SELECT a.*,IFNULL(pi_file,'nopic.jpg') AS pi_file ,cg_name_zh AS cg_name, pcolorbox,psize,IFNULL(pro_name_zh,pro_name_en) AS pro_name,IFNULL(pro_desc_zh,pro_desc_en) AS pro_desc,(IFNULL(total_sell,0)+IFNULL(pro_sell,0)) AS total_sell FROM product_list_view a WHERE 1 WHERE 1=1 AND pro_show = 1 AND pro_special = 'Y' GROUP BY p.pro_id ORDER BY pro_sort ASC, pro_id DESC LIMIT ?, ?