SELECT `sh_product`.* FROM `sh_product` WHERE (mode<>-1 AND (allow_minus_stock<>0 OR stock>0)) AND ((sh_product.web_id='342') OR (sh_product.root_web_id='342')) AND (is_special=1) GROUP BY `template_id` ORDER BY `id` DESC