        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 (23915,23916,18189,18179,18180,18177,18178,18170,18168,18169,18162,18160,18161,18159,18156,18157,18154,18155,18152,18153,18150,18151,18148,18149,18146,18147,18144,18145,18139,18140,18137,18138,18135,18136,18133,18130,18128,18129,18126,18127,18124,18125,18122,18123,18120,18121,18118,18119,18116,18117,18114,18115,18112,18113,18110,18111,18108,18109,18107,18104,18105,18102,18103,18100,18101,18098,18099,18096,18097,18094,18095,18092,18093,18091,18088,18089,18086,18085,18081,18078,18079,18076,18077,18074,18075,18072,18073,18070,18071,18068,18069,18066,18067,18064,18065,18062,18063,18060,18061,18058,18059,18056,18057,18055,18048,18049,18046,18047,18044,18045,18043,18038,18039,18036,18037,18030,18031,18028,18029,18026,18024,18025,18023,18017,18016,18013,18011,18012,18005,18006,18003,18004,18001,18002,17997,17998,17995,17996,17993,17994,17991,17992,17989,17990,17987,17988,17986,17983,17981,17979,17980,17978,17976,25517,25520,25521,25522,17974,26251,26252,26349,26388,26389,26390,26442,18020,18141,18171,18188,18018,27265,27269,27740,27741,27742,27804,28610,28611,28612,29445,30590,30932,35044,36282,36283,18175,39391,39688,42352,42502,43241,44047,44048,44533,44534,44671,45230,45317,45638,45973,46294,46295,46347)
          AND pd.language_id = '3'
          AND p.status = '1'
          AND p.quantity > 0
        ORDER BY p.sort_order ASC
        LIMIT 60, 0