product_query SELECT SQL_CALC_FOUND_ROWS * FROM NTZ_Ur1stop_Product WHERE HighPic != '' AND Quantity > 0  ORDER BY CASE MainCategory WHEN 'gaming' THEN 1 WHEN 'notebook' THEN 2 WHEN 'desktop' THEN 3 WHEN 'aio' THEN 4 WHEN 'tv' THEN 5 WHEN 'monitor' THEN 6 WHEN 'tablet' THEN 7 WHEN 'graphicCard' THEN 8 WHEN 'accessory' THEN 9 ELSE 10 END, CASE WHEN HighPic NOT LIKE '%Manufacturer%' THEN 1 ELSE 2 END, NTDZ_Ur1stop_Product_Id DESC LIMIT 16 OFFSET -16<br>