select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_date_added, p.products_price, p.products_type, p.master_categories_id from zen_products p left join zen_products_description pd on p.`products_id` = pd.`products_id` left join zen_products_to_categories p2c on p.`products_id` = p2c.`products_id` where (0 or p.products_model in('A10001','A10002','A10003','A10004','A10005','A10006','A10007','A10008','A10009','A10010','A10011','A10012','A10013','A10014','A10015','A10016','A10017','A10018includes/templates/bagsjp/images/includes/templates/bagsjp/images/')) and pd.language_id = '1' and p.products_status = 1 GROUP BY p.`products_id` ORDER BY `products_sort_order` ASC LIMIT 12