        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 (39219,39064,39065,39067,39066,39106,39186,39187,14602,14601,14600,14599,14598,14597,14596,14595,14571,14570,14487,14486,14483,14482,14481,14480,14479,14478,14477,14468,25204,25351,25352,26506,26507,26663,27002,28907,29811,29820,30939,33524,36003,36284,36301,36300,38957,38958,39043,39361,39435,39478,39479,39559,39588,39600,39660,39737,39753,25612,25613,39754,39755,39756,39926,39942,39948,39949,40007,40008,40120,40121,40263,40264,40660,40661,40662,39185,34430,34431,39107,33906,36246,39108,39109,39078,39079,39080,33471,33572,40671,40672,40673,40674,36648,18473,40755,40756,40757,40762,40763,40764,40805,40916,41038,41046,41085,41088,41089,41112,41116,41160,41209,41317,41337,41350,41351,41610,41647,41756,41792,41825,41826,42025,42026,42097,42098,42099,42113,42114,42115,42116,42117,42118,42119,42178,42179,42180,42459,42508,42546,42547,42548,42676,42742,42743,42553,42554,42555,42556,42557,42558,42559,42857,42858,43037,43052,43053,43068,43069,43070,43071,43072,43073,43084,43143,43144,43145,43146,43235,43236,43266,43303,43312,43334,43410,43413,43466,43467,43468,43484,43562,43790,43791,43796,43885,44021,44037,44038,44041,44115,44173,44458,44459,44466,44467,44468,44506,44507,44511,44512,44513,44518,44591,44592,44593,44594,44665,44668,44669,44670,44766,44767,44782,44981,45139,45173,45182,45261,45262,45379,45438,45439,45440,45441,45475,45623,45624,45625,45823,45824,45925,45926,45935,45936,46123,46125,46126,46140,46218,46219,46343,46419,46512,46513,46514,46515,46516,46517,46564,46678,46679,46873,46874,46875,46876,46677,46980,46981,46982,46983,46984,46988,47043,47100,47111,47113,47137,47138,47139,47140,47141,47142)
          AND pd.language_id = '3'
          AND p.status = '1'
          AND p.quantity > 0
        ORDER BY p.sort_order ASC
        LIMIT 780, 0