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` = '21'
AND `p`.`status` = 1
ORDER BY `p`.`title` ASC
LIMIT 12
Whether you favor Android or iPhone, we've spent hundreds of hours on research and testing to find the best smartphones around. For Android phones, we've looked for the best combinations of features and price. For iOS, we've compared the current selection of iPhones to help you choose the best phone for you.