        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 (23864,23863,23862,23513,23512,23511,39220,39221,38203,39222,39240,31622,15078,15077,15076,15075,15074,15073,15072,15071,15070,15069,15068,15067,15066,15065,15064,15063,15061,15060,15059,15058,15057,15056,15055,15054,15053,15052,15051,15021,14975,14974,14973,14972,14971,14970,14969,14968,14967,14966,14965,14964,14963,14962,14961,14960,14959,14958,14957,14956,14955,14954,14953,14952,14951,14950,14882,14881,14880,14879,14878,14877,14876,14875,14874,14873,14872,14871,14870,14869,14868,14867,14866,14865,14864,14863,14862,14861,14860,14859,14858,14857,14856,14855,14854,14642,14641,14640,14639,14638,14637,14636,14635,14634,24014,24015,24016,24017,24491,24492,24514,24515,24888,24889,25132,25133,25135,25136,25137,25139,25386,25387,25890,25891,25892,25894,25895,25896,25897,25912,26073,26074,26075,26076,26102,26103,26104,26105,26107,26108,26178,26179,26181,26182,26183,26184,26185,26186,26188,26189,26190,26191,26199,26200,26201,26382,26443,26452,26453,26454,26456,26449,26451,26458,26459,26460,26457,26485,26486,26487,26488,26489,26490,26491,26492,26493,26494,26495,26496,26497,26543,26544,26545,26546,26605,26608,26609,26610,26611,26612,26613,26655,26735,26736,26782,26783,26882,26932,26960,26961,26962,26963,26964,27004,27005,27006,27007,27596,27661,27662,27678,27679,27680,27706,27888,27928,26455,25893,26450,27260,27261,15062,26180,26187,28721,28722,28723,28797,28825,28984,28985,29038,29039,29040,29101,29102,29204,29205,29206,29207,29208,29209,29210,29211,29212,29214,29215,29218,29219,29521,29522,29523,29524,29550,29551,29552,29553,29554,29555,29557,29558,29744,29755,29756,29860,29861,30017,30018,30347,30348,30349,30350,30356,30357,30382,30383,30386,30387,30391,30392,31146,31147,31150,31151,31568,31623,31659,31660,32359,32360,32361,32421,32422,32844,32845,32846,32847,32848,32949,32950,33498,33499,33587,33898,33899,33900,33901,33902,34066,34067,34068,34069,34226,34227,34375,34376,34377,34378,34379,34380,34381,34382,34383,34539,34540,34541,34542,34543,34544,34545,34548,34549,34726,34727,34728,34869,34870,34871,34872,34873,34874,34875,34876,34877,34878,34879,34880,34881,34883,35143,35144,35145,35146,35147,35148,35149,35150,35151,35152,35166,35443,35444,35530,35531,35710,35711,35712,35713,35714,35715,35716,35717,35718,35719,35720,35986,36048,36294,36295,36296,36309,36310,36311,36312,36318,36511,36515,36516,36517,36518,36670,36671,36694,36695,36707,36727,36742,37013,37014,37173,37174,37175,37628,37629,37630,37633,37634,37778,37779,37780,37990,37991,38003,38004,38005,38179,38180,38181,38182,38183,38184,38479,38480,38488,38489,38490,38496,39036,39037,39648,39649,39650,39651,39652,39653,39654,39655,39896,39897,39898,40248,40249,40250,40251,40502,40503,40504,40505,40676,40677,40679,40680,40707,40736,40737,40759,40760,40771,40772,41035,41036,41043,41086,41087,41591,41757,41758,41769,41772,41773,41774,41775,41819,41938,41939,41940,41941,42101,42102,42208,42209,42210,42250,42251,42347,42348,42672,42673,42674,43307,43308,43463,43465,43663,43664,43665,43666,43671,43678,43679,43680,44501,44502,44503,44504,44595,44664,45222,45223,45435,45436,45544,45545,45683,45780,46392,46393,46394,46395,46396,46397,46398,46399,46400,46680,46681,46854,46855,47037,47048)
          AND pd.language_id = '1'
          AND p.status = '1'
          AND p.quantity > 0
        ORDER BY p.sort_order ASC
        LIMIT 120, 0