select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"9\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"12\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"15\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"16\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"19\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"20\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"21\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"22\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"23\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"55\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"56\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"57\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"58\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"59\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"24\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"25\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"26\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"27\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"28\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"29\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"30\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"31\"%'orderby RAND() limit 12
select*from `translations` where `translations`.`translationable_id` in (54) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"33\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"34\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"38\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"39\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"43\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"44\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"45\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"46\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"47\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"48\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"50\"%'orderby RAND() limit 12
select*from `translations` where `translations`.`translationable_id` in (2267, 2268, 2269, 2270, 2271) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"51\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"52\"%'orderby RAND() limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `category_ids` like'%\"53\"%'orderby RAND() limit 12
select `sellers`.*, (selectcount(*) from `orders` where `sellers`.`id` = `orders`.`seller_id`) as `orders_count`, (selectcount(*) from `products` where (`sellers`.`id` = `products`.`user_id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and (`added_by` ='seller')) as `product_count` from `sellers` where (`status` ='approved') andexists (select*from `orders` where `sellers`.`id` = `orders`.`seller_id` and `seller_is` ='seller') orderby `orders_count` desc limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (`added_by` ='seller') and `products`.`user_id` in (4, 5, 6, 7, 10)
select `products`.*, (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 `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `featured` =1orderby `order_details_count` desc limit 12
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') orderby `id` desc limit 8
select `product_id`, COUNT(product_id) as count from `order_details` whereexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (`order_details`.`product_id` = `products`.`id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `status` =1) groupby `product_id` orderby `count` desc limit 6
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `status` =1and `products`.`id` in (122, 409, 483, 2590, 2647, 2662)
select `product_id`, AVG(rating) as count from `reviews` whereexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (`reviews`.`product_id` = `products`.`id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical')) and `status` =1groupby `product_id` orderby `count` desc limit 6
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') orderby RAND() limit 1
select*from `translations` where `translations`.`translationable_id` in (2316) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` and (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical')) as `brand_products_count` from `brands` where `status` =1orderby `created_at` desc
selectcount(*) as aggregate from `products` where (exists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `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 ('physical') and `discount` !=0
select*from `translations` where `translations`.`translationable_id` in (2) and `translations`.`translationable_type` ='App\Models\FlashDeal'and `locale` ='en'