SELECT `p`.*, `c`.`url_title` as `curl`, `sc`.`url_title` as `scurl`, `sc`.`name` as `sub_category_name`, `ssc`.`url_title` as `sscurl`, `m`.`name` as `merchant`, `cr`.`currencySymbol` as `currency`
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`
JOIN `_com_shop_merchants` as `m` ON `m`.`id` = `p`.`merchant`
JOIN `_com_currency` as `cr` ON `cr`.`currencyId` = `p`.`currency`
WHERE `p`.`category` = '2'
AND `p`.`sub_category` = '7'
AND `p`.`sub_sub_category` = '8'
AND `p`.`status` = 1
ORDER BY `p`.`title` ASC
LIMIT 12
https://www.puchoji.com/shop-products/electronics/audio-video/receivers?sortBy=1
Best Deals from Receivers
Receivers
No produts found. please try with other filters or categories.
No Products Found
Please Modify filters or try a different category.