SELECT * FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'SELECT COUNT(`id`) AS count FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'
SELECT * FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'SELECT COUNT(`id`) AS count FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'
SELECT * FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'SELECT COUNT(`id`) AS count FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'
SELECT * FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'SELECT COUNT(`id`) AS count FROM `product` WHERE `brand_id` = :brand_id AND `status` = 'published'