SELECT r.product_id id, r.code product_code,r.th_name product_name, format(r.sell_price,2) sell_price , format(r.promotion_price,2) promotion_price,th_detail product_detail , ifnull((select file_name from product_images where image_group = 'main' and product_id =r.product_id limit 0,1), 'noimage-popular.png') as Picture from product r where r.is_deleted = 'N' order by sell_price asc limit 0, 12