SELECT `p`.`url_title`, `p`.`title`, `img_url`, `c`.`url_title` as `category`, `sc`.`url_title` as `sub_category`, `sc`.`name` as `subCategoryName`, `ssc`.`url_title` as `sub_sub_category`, (select name from _com_shop_merchants where id = merchant) as merchant
FROM `_com_shop_products` as `p`
JOIN `_com_shop_post_categories` as `c` ON `c`.`category_id` = `p`.`category`
JOIN `_com_shop_sub_categories` as `sc` ON `sc`.`id` = `p`.`sub_category`
LEFT JOIN `_com_shop_sub_sub_categories` as `ssc` ON `ssc`.`id` = `p`.`sub_sub_category`
WHERE `p`.`brand` = 'Optimum Nutrition'
AND `p`.`status` = 1
ORDER BY `p`.`title` ASC
LIMIT 12
https://www.puchoji.com/shop/brand/optimum-nutrition?sortBy=1
Best Deals from Optimum Nutrition
Showing 1 - 0 out of 0 results.