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` = '8'
AND `p`.`status` = 1
ORDER BY `p`.`title` ASC
LIMIT 12
https://www.puchoji.com/shop-products/electronics/batteries-and-charging?sortBy=1
Best Deals from Batteries and Charging
Need to power multiple devices in any situation, or to keep your gear charged on the go? We've rounded up the best batteries and power accessories to keep your gadgets up and running whether you're traveling, working, or just hanging out at home. These cables, battery packs, hubs, surge protectors, and more will help keep all of your devices humming along.
Showing 1 - 2 out of 2 results.