        SELECT p.*,
               pd.name,
               pd.description,
               (SELECT AVG(rating) 
                FROM oc_review r 
                WHERE r.product_id = p.product_id AND r.status = '1') AS rating,
               (SELECT price FROM oc_product_discount pd2
                WHERE pd2.product_id = p.product_id 
                  AND pd2.customer_group_id = '1'
                  AND pd2.quantity = '1'
                  AND ((pd2.date_start = '2001-01-01' OR pd2.date_start < NOW()) 
                  AND (pd2.date_end = '2001-01-01' OR pd2.date_end > NOW()))
                ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
               (SELECT price FROM oc_product_special ps
                WHERE ps.product_id = p.product_id 
                  AND ps.customer_group_id = '1'
                  AND ((ps.date_start = '2001-01-01' OR ps.date_start < NOW()) 
                  AND (ps.date_end = '2001-01-01' OR ps.date_end > NOW()))
                ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
        FROM oc_product p
        LEFT JOIN oc_product_description pd ON p.product_id = pd.product_id
        WHERE p.product_id IN (22733,22732,22731,22730,22729,22728,22727,22726,22725,22724,22723,22722,35506,39205,39206,26523,25909,25910,25985,26132,26176,26177,26205,26352,26448,26524,26547,26548,26606,26798,26965,26966,26987,27000,27721,28356,28357,28358,28349,28350,27571,27716,27717,27718,27719,27720,27722,27723,27412,29203,29213,29401,29402,29608,29609,29614,29615,29617,29649,29840,29862,29868,29869,29870,29871,30019,30022,30098,30100,30146,31145,31148,31149,31809,32010,32016,32878,32879,33300,33301,33897,34882,35169,35516,35972,35973,36320,36476,36478,36737,37631,37993,37994,37997,37998,37999,38000,39038,39643,39644,39645,39646,39750,39751,40265,41770,41771,42461,42811,42812,44478,44479,44481,44482,44484,44485,44486,44491,44492,44493,44494,44495,46138,46139,47049,47061)
          AND pd.language_id = '3'
          AND p.status = '1'
          AND p.quantity > 0
        ORDER BY p.sort_order ASC
        LIMIT 30, 0