QUERY = SELECT DISTINCT CubeCart_inventory.cat_id, CubeCart_cats_idx.productId, productCode, image, image1, price_mefpa AS price, sale_price_mefpa AS sale_price, ekptwtiki_price, shortDesc, productCode, timestamp_ekptwsi_start, timestamp_ekptwsi_end, final_price, dia, name, available, tampelaki, blackfriday, useStockLevel, stock_level FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE CubeCart_cats_idx.cat_id IN () AND active='1' AND isPhotos='0' AND isNews='0' AND char_length(productCode)<8 AND char_length(productCode)<8 GROUP BY productCodeGroup ORDER BY CubeCart_inventory.list_no DESC, productId DESC