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 (23859,23858,23857,23856,23855,23854,23853,23499,23497,23498,23495,23496,23494,23493,23492,23491,23489,23490,23488,23486,23483,23482,23481,23480,23479,23478,23477,23476,23475,18527,18526,18525,18524,18523,18522,18521,18520,18519,18518,18517,18516,18515,18514,39219,38204,39065,39066,39067,39106,39186,39187,15422,14847,14846,14845,14844,14843,14842,14841,14840,14839,14838,14837,14836,14835,14834,14833,14832,14831,14830,14829,14828,14827,14826,14825,14824,14823,14822,14821,14820,14819,14818,14817,14816,14815,14814,14813,14812,14811,14810,14809,14808,14807,14806,14805,14804,14803,14802,14801,14800,14799,14798,14797,14796,14795,14794,14793,14792,14791,14790,14789,14788,14787,14786,14785,14784,14783,14782,14781,14780,14779,14778,14777,14776,14775,14774,14773,14772,14771,14770,14769,14768,14767,14766,14765,14764,14763,14762,14761,14760,14759,14758,14757,14756,14755,14754,14753,14752,14751,14750,14749,14748,14747,14746,14745,14744,14743,14742,14741,14740,14739,14738,14737,14736,14735,14734,14733,14732,14731,14730,14729,14728,14727,14726,14725,14724,14723,14722,14721,14720,14719,14718,14717,14716,14715,14714,14713,14712,14711,14710,14709,14708,14707,14706,14705,14704,14703,14702,14701,14700,14699,14698,14697,14696,14695,14694,14693,14692,14691,14690,14689,14688,14687,14686,14685,14684,14683,14682,14681,14680,14679,14678,14677,14676,14675,14674,14673,14672,14671,14670,14669,14668,14667,14666,14665,14664,14663,14662,14661,14660,14659,14658,14657,14656,14655,14654,14653,14652,14651,14650,14649,14633,14632,14631,14630,14629,14628,14627,14626,14625,14624,14623,14622,14621,14620,14619,14618,14617,14616,14615,14614,14611,14610,14609,14608,14607,14606,14605,14604,14603,14602,14601,14600,14599,14598,14597,14596,14595,14594,14593,14592,14591,14590,14589,14588,14587,14586,14585,14584,14583,14582,14581,14580,14579,14578,14577,14576,14575,14574,14573,14572,14571,14570,14568,14569,14567,14566,14565,14564,14563,14562,14561,14560,14559,14558,14557,14556,14555,14554,14553,14552,14551,14550,14549,14548,14547,14546,14545,14544,14543,14542,14541,14540,14539,14538,14537,14536,14535,14534,14533,14532,14531,14529,14528,14527,14526,14525,14524,14523,14522,14521,14520,14519,14518,14517,14516,14515,14514,14513,14512,14511,14510,14509,14508,14507,14506,14505,14504,14503,14502,14501,14500,14499,14498,14497,14496,14495,14494,14493,14492,14491,14490,14489,14488,14487,14486,14485,14484,14483,14482,14481,14480,14479,14478,14477,14468,24008,24009,24010,24011,24299,24300,24302,24445,24446,24447,24448,24513,24512,24913,24914,24915,24916,25029,25032,25033,25034,25122,25123,25204,25205,25206,25207,25221,25222,25229,25230,25231,25296,25297,25298,25299,25300,25301,25302,25303,25304,25351,25352,25432,25433,25434,25435,25436,25437,25494,25614,25841,25842,25843,25872,25932,25933,25934,25935,25936,25937,25938,25939,25940,25941,25942,25943,25944,25945,26043,26044,26045,26042,24301,26100,26109,26110,26111,26155,26166,26170,26171,26353,26354,26444,26506,26507,26509,26510,26164,26165,26591,26592,26614,26615,26616,26617,26638,26663,26664,24444,14613,26762,26763,26764,26855,26856,26857,26858,26859,26860,26861,26924,27002,27003,27026,27073,27074,27254,27255,27256,27257,27367,27705,28280,28281,28282,28283,28284,28285,28346,28347,28348,28372,28373,28374,28375,28486,28519,28520,28521,28545,28546,28547,28555,28556,28557,28577,28578,28579,28580,28581,28582,28583,28584,28585,28586,28587,28665,28666,28667,28668,28698,23860,28287,28699,28700,28702,28703,28704,28705,28801,28802,28803,28804,28805,28806,28807,28871,28907,28908,28909,29049,29050,29150,29151,28559,26588,29268,29269,29270,29271,29285,29286,29287,29288,29289,29396,29397,29437,29438,29439,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29465,29466,29467,29468,29665,29748,29811,29820,29857,29858,29859,30020,30021,30093,30094,30101,30116,30142,30143,30144,30145,30352,30353,30354,30355,30373,30374,30375,30376,30377,30378,30379,30337,30381,30571,30572,30618,30619,30620,30621,30630,30631,30763,30825,30826,30849,30883,30931,30939,30940,30941,30942,30943,31155,31227,31228,31229,31230,31231,31310,31480,31485,31486,31536,36847,31586,31587,31588,31684,31685,31686,31753,31754,31765,31819,31848,31849,31870,31921,31957,31958,31964,31965,31983,31984,31985,32043,32044,32049,32210,32252,32364,32365,32366,32722,32723,32724,32725,32726,32727,32728,32867,32868,32904,32905,32906,32937,32953,32954,32955,32978,32979,33163,33332,33333,33334,33335,33343,33344,33366,33410,33411,33449,33450,33487,33488,33524,33525,33526,33527,33528,33529,33530,33531,33532,33533,33534,33730,33731,33732,34128,34158,34159,34160,34161,34162,34216,34243,34244,34245,34246,34247,34447,34448,34449,34450,34451,34452,34453,34454,34501,34502,34503,34648,34649,34650,34651,34652,34931,34930,34985,34986,34987,34988,34989,35134,35182,35183,35187,35188,35333,35335,35537,35566,35609,35610,35611,35635,35651,36003,36004,36005,36006,36007,36008,36009,36027,36028,36029,36036,36072,36192,36193,36194,36220,36221,36268,36269,36284,36285,36286,36301,36317,36195,36427,36453,36454,36455,36456,36463,36464,36465,36477,36493,36494,36498,36507,36508,36509,36510,36514,36534,36535,36647,36700,36701,36702,36703,36704,36705,36706,36848,36959,36960,36961,37002,37003,37004,37005,37006,36259,36260,32319,30380,31739,28286,37085,36536,36537,37450,36300,37632,37638,37639,37775,37776,37777,37957,37958,38002,38055,38398,38399,38494,38497,38498,38548,38614,38615,38690,38691,38692,38736,38737,38738,38739,38740,38957,38958,39043,39361,39435,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) AND pd.language_id = '1' AND p.status = '1' AND p.quantity > 0 ORDER BY p.sort_order ASC LIMIT 0, 30