QUERY = SELECT DISTINCT CubeCart_cats_idx.productId, price_mefpa AS price, sale_price_mefpa AS sale_price, ekptwtiki_price, shortDesc, productCode, timestamp_ekptwsi_start, timestamp_ekptwsi_end, final_price FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE CubeCart_cats_idx.cat_id IN (blocks-construction-tiles-toy-75-pcs-p_5013) AND active='1' AND isPhotos='0' AND isNews='0'