product-manager.php#2297vestidokw_co2.76msselect `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count` from `products` where (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`added_by` ='seller'and `user_id` =1)
product-manager.php#1956vestidokw_co3.06msselect `publishing_houses`.*, (selectcount(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical'))) as `publishing_house_products_count` from `publishing_houses` whereexists (select*from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical')))
product-manager.php#1965vestidokw_co400μsselect `id` from `products` where (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`product_type` ='digital') and1=1
product-manager.php#1971vestidokw_co1.21msselect `authors`.*, (selectcount(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` andexists (select*from `products` where `digital_product_authors`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical'))) as `digital_product_author_count` from `authors`
product-manager.php#1979vestidokw_co1.3msselect `id` from `products` where (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`product_type` ='digital') and1=1
product-manager.php#1735vestidokw_co5.12msselect `products`.*, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectsum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` where (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`added_by` ='seller'and `user_id` =1) orderby `id` desc, `id` desc
ShopViewController.php#504vestidokw_co1.88msselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` =0and0=1
ShopViewController.php#537vestidokw_co1.45msselect `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`added_by` ='seller'and `user_id` =1) and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` =1and0=1
product-manager.php#1796vestidokw_co1.69msselect `publishing_houses`.*, (selectcount(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `product_type` ='digital'and (`user_id` =1and `added_by` ='seller'))) as `publishing_house_products_count` from `publishing_houses`
product-manager.php#1827vestidokw_co960μsselectcount(*) as aggregate from `products` where (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`product_type` ='digital') and1=1and (`user_id` =1and `added_by` ='seller')
product-manager.php#1872vestidokw_co1.23msselect `authors`.*, (selectcount(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` andexists (select*from `products` where `digital_product_authors`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `product_type` ='digital'and (`user_id` =1and `added_by` ='seller'))) as `digital_product_author_count` from `authors` orderby `name` asc
product-manager.php#1902vestidokw_co1.24msselectcount(*) as aggregate from `products` where (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and (`product_type` ='digital') and1=1and (`user_id` =1and `added_by` ='seller')
ShopViewController.php#38vestidokw_co300μsselectcount(*) as aggregate from `orders` where (`seller_is` ='seller'and `seller_id` =1) and `order_type` ='default_type'
ShopViewController.php#112vestidokw_co710μsselectcount(*) as aggregate from `stock_clearance_products` where (`is_active` =1) and `added_by` in ('admin', 'vendor') andexists (select*from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` =1anddate(`duration_start_date`) <='2025-03-15'anddate(`duration_end_date`) >='2025-03-15'and ((`offer_active_time` ='specific_time'andtime(`offer_active_range_start`) <='00:26:38'andtime(`offer_active_range_end`) >='00:26:38') or (`offer_active_time` ='always'and `offer_active_range_start` isnulland `offer_active_range_end` isnull))) and (`shop_id` ='86')
product-manager.php#2389vestidokw_co410μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `status` =1) and (`customer_id` =2568and `is_guest` =1)
cart-manager.php#130vestidokw_co310μsselect `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `status` =1) and (`customer_id` =2568and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#69vestidokw_co200μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `status` =1) and0=1
product-manager.php#2389vestidokw_co350μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `status` =1) and (`customer_id` =2568and `is_guest` =1)
cart-manager.php#130vestidokw_co340μsselect `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `status` =1) and (`customer_id` =2568and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#69vestidokw_co220μsselect*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`status` =1) and (`request_status` =1) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('digital', 'physical') and `status` =1) and0=1and (`is_checked` =1)
english
