selectcount(*) as aggregate from `products` whereexists (select*from `categories` innerjoin `category_product` on `categories`.`id` = `category_product`.`category_id` where `products`.`id` = `category_product`.`product_id` and `categories`.`categorySlug` like'saree-collection')