        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,23914,18183,18189,18181,18182,18179,18180,18177,18178,18170,18168,18169,18162,18160,18161,18158,18159,18156,18157,18154,18155,18152,18153,18150,18151,18148,18149,18146,18147,18144,18145,18139,18140,18137,18138,18135,18136,18132,18133,18130,18131,18128,18129,18126,18127,18124,18125,18122,18123,18120,18121,18118,18119,18116,18117,18114,18115,18112,18113,18110,18111,18108,18109,18106,18107,18104,18105,18102,18103,18100,18101,18098,18099,18096,18097,18094,18095,18092,18093,18090,18091,18088,18089,18086,18087,18084,18085,18082,18083,18080,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,18054,18055,18052,18053,18050,18051,18049,18046,18047,18044,18045,18042,18043,18040,18041,18038,18039,18036,18037,18030,18031,18028,18029,18026,18027,18024,18025,18023,18017,18021,18015,18016,18013,18011,18012,18005,18006,18003,18004,18001,18002,17999,18000,17997,17998,17995,17996,17993,17994,17991,17992,17989,17990,17987,17988,17985,17986,17983,17984,17981,17982,17979,17980,17977,17978,17976,25516,25517,25518,25519,25520,25521,25522,17974,26173,26251,26252,26253,26348,26349,26350,26351,26388,26389,26390,26442,18020,18141,18171,18188,18007,18010,18014,18018,18167,27264,27265,27268,27269,27271,27272,27273,27274,27740,27741,27742,28152,28610,28611,28612,29441,29442,29445,30590,30597,30932,31237,31238,31239,33135,33136,33200,33489,33490,33491,33492,33493,33546,33547,33548,33549,33550,34461,35044,35234,35235,35236,35237,35238,35302,35619,36282,36283,18175,38944,38947,39391,39688,39789,42215,42352,42501,42502,43241,44047,44048,44533,44534,44671,45230,45317,45638,45973,46294,46295,46347)
          AND pd.language_id = '1'
          AND p.status = '1'
          AND p.quantity > 0
        ORDER BY p.sort_order ASC
        LIMIT 60, 0