sq 1 SELECT * FROM `products` where MainCat = 'Tables' AND SubCat = 'Occasional' AND Sale = 1 AND (Active = 1) ORDER BY SortOrdersq 2