select `products`.*, `products_categories`.`category_id` as `pivot_category_id`, `products_categories`.`product_id` as `pivot_product_id` from `products` innerjoin `products_categories` on `products`.`id` = `products_categories`.`product_id` where `products_categories`.`category_id` =3and `status` =1andexists (select*from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products`.`id` = `products_categories`.`product_id` and `categories`.`deleted_at` isnull) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `brands`.`deleted_at` isnull) and `products`.`deleted_at` isnull
select `categories`.*, `products_categories`.`product_id` as `pivot_product_id`, `products_categories`.`category_id` as `pivot_category_id` from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products_categories`.`product_id` in (16, 17, 18) and `categories`.`deleted_at` isnull
select `products`.*, `products_categories`.`category_id` as `pivot_category_id`, `products_categories`.`product_id` as `pivot_product_id` from `products` innerjoin `products_categories` on `products`.`id` = `products_categories`.`product_id` where `products_categories`.`category_id` =13and `status` =1andexists (select*from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products`.`id` = `products_categories`.`product_id` and `categories`.`deleted_at` isnull) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `brands`.`deleted_at` isnull) and `products`.`deleted_at` isnull
select `categories`.*, `products_categories`.`product_id` as `pivot_product_id`, `products_categories`.`category_id` as `pivot_category_id` from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products_categories`.`product_id` in (8, 9, 10, 11, 12, 22, 23, 24, 25, 26, 27, 28) and `categories`.`deleted_at` isnull
select `products`.*, `products_categories`.`category_id` as `pivot_category_id`, `products_categories`.`product_id` as `pivot_product_id` from `products` innerjoin `products_categories` on `products`.`id` = `products_categories`.`product_id` where `products_categories`.`category_id` =20and `status` =1andexists (select*from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products`.`id` = `products_categories`.`product_id` and `categories`.`deleted_at` isnull) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `brands`.`deleted_at` isnull) and `products`.`deleted_at` isnull
select `categories`.*, `products_categories`.`product_id` as `pivot_product_id`, `products_categories`.`category_id` as `pivot_category_id` from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products_categories`.`product_id` in (1, 2, 3, 4, 5, 14) and `categories`.`deleted_at` isnull
select `products`.*, `products_categories`.`category_id` as `pivot_category_id`, `products_categories`.`product_id` as `pivot_product_id` from `products` innerjoin `products_categories` on `products`.`id` = `products_categories`.`product_id` where `products_categories`.`category_id` =44and `status` =1andexists (select*from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products`.`id` = `products_categories`.`product_id` and `categories`.`deleted_at` isnull) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `brands`.`deleted_at` isnull) and `products`.`deleted_at` isnull
select `products`.*, `products_categories`.`category_id` as `pivot_category_id`, `products_categories`.`product_id` as `pivot_product_id` from `products` innerjoin `products_categories` on `products`.`id` = `products_categories`.`product_id` where `products_categories`.`category_id` =55and `status` =1andexists (select*from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products`.`id` = `products_categories`.`product_id` and `categories`.`deleted_at` isnull) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `brands`.`deleted_at` isnull) and `products`.`deleted_at` isnull
select `products`.*, `products_categories`.`category_id` as `pivot_category_id`, `products_categories`.`product_id` as `pivot_product_id` from `products` innerjoin `products_categories` on `products`.`id` = `products_categories`.`product_id` where `products_categories`.`category_id` =78and `status` =1andexists (select*from `categories` innerjoin `products_categories` on `categories`.`id` = `products_categories`.`category_id` where `products`.`id` = `products_categories`.`product_id` and `categories`.`deleted_at` isnull) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `brands`.`deleted_at` isnull) and `products`.`deleted_at` isnull
