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` = '9' AND `p`.`sub_sub_category` = '27' AND `p`.`status` = 1 ORDER BY `p`.`title` ASC LIMIT 12