Products >HOTSUIT

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` = 'HOTSUIT' AND `p`.`category` = '1' AND `p`.`sub_category` = '1' AND `p`.`status` = 1 ORDER BY `p`.`title` ASC LIMIT 12

Wearables

Personal Care

Medical Supplies

Exercise

Cycling

Tech Accessories

Audio & Video

Batteries and Charging

Camera

Computers

Networking

Printers & Scanners

Phone Deals

Kids

Pets

Festival

Ocassion

Special Days

Personal

Household

Best Deals from HOTSUIT

Categories

Merchants

Best Deals from HOTSUIT

Featured Products

Puchoji