SELECT  *  FROM `mg_product` WHERE   ( price BETWEEN '1' AND '100001')  AND cat_id IN ('null','1','3','4','5','6','2','107','7','114','8','10','11','9','12','16','18','20','13','17','19','14','15','106','25','27','28','26','29','31','32','35','36','30','33','34','37','39','40','41','43','45','46','48','49','50','38','42','44','47','63','65','66','67','69','70','74','76','77','78','75','71','68','64','72','79','73','80','108','109','110','81','83','86','89','82','84','87','85','88','113','115','116','103','104','21','23','24','22','51','53','54','56','58','55','57','52','111','112','59','61','62','60','90','92','94','93','95','91','96','117','118','119','120','121','97','98','99','100','101','102') ORDER BY `sort` DESC