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 (23863,23862,23535,23534,23533,23513,23510,23509,23508,23507,23506,39220,39221,38203,39222,39240,39290,39291,39292,39293,39294,39295,31622,39470,39207,39208,39209,39210,39211,39212,39213,39214,39215,39216,39217,47194,47195,39218,47196,47251,47249,15074,15073,15072,15071,15070,15069,15068,15067,15066,15065,15064,15063,15061,15060,15059,15058,15057,15056,15055,15054,15053,15052,15051,15050,15049,15048,15047,15046,15045,15044,15043,15042,15041,15040,15039,15038,15037,15036,15035,15034,15033,15032,15031,15030,15029,15028,15027,15026,15025,15024,15021,15020,15019,15018,14975,14974,14973,14972,14971,14970,14969,14968,14967,14966,14965,14964,14962,14961,14960,14959,14958,14957,14956,14955,14954,14953,14952,14951,14950,14948,14947,14946,14945,14944,14943,14942,14937,14936,14935,14934,14931,14930,14929,14925,14924,14923,14922,14921,14920,14893,14892,14889,14888,14887,14886,14885,14884,14883,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,24018,24145,24146,24147,24148,24149,24150,24491,24492,24514,24515,24888,24889,25132,25133,25134,25135,25136,25137,25139,25211,39289,25386,25387,25388,25890,25891,25892,25894,25895,25896,25897,25912,25971,25972,25973,25974,26022,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,26540,26541,26542,26543,26544,26545,26546,26594,26605,26609,26610,26611,26612,26613,26655,26667,26668,26671,26672,26673,26674,26675,26676,26677,26678,26679,26680,26682,26683,26684,26685,26783,26879,26880,26881,26882,26932,26933,26934,26935,26937,26957,26958,26959,26961,26962,26988,26989,27006,27007,47193,27516,27517,27518,27596,27597,27598,27661,27662,27679,27680,27706,27715,27797,27847,27888,27928,27937,27938,27940,27945,27947,26455,28019,28018,25893,23504,23505,27899,26450,27798,27260,27261,15062,28079,28086,28360,28361,26180,26187,28427,28428,28489,28503,28536,28537,28669,28722,28797,28798,28799,28825,28984,28985,29012,29014,29015,29016,29017,29018,29037,29038,29039,29040,29102,29204,29205,29206,29207,29208,29209,29210,29214,29215,29216,29217,29218,29219,29220,29221,29333,29500,29501,29503,29521,29522,29523,29524,29550,29551,29552,29553,29554,29555,29557,29558,29741,29742,29743,29744,29745,29746,29747,29755,29756,29758,29759,29860,29861,30017,30350,30356,30357,30382,30383,30386,30387,30388,30389,30390,30391,30392,31139,31140,31141,31142,31143,31144,31146,31147,31150,31151,31469,31470,31471,31475,31568,31623,31659,31660,47192,31916,31917,31918,32048,32050,32051,32356,32357,32358,32359,32360,32361,32399,32421,32422,32495,32564,32572,32573,32844,32845,32846,32847,32848,32849,32875,32876,32877,32949,32950,32951,32952,33362,33363,33412,33426,33427,33428,33498,33499,33587,33715,33733,33898,33899,33900,33901,33902,34066,34067,34068,34069,34088,34226,34227,34375,34376,34377,34378,34379,34380,34381,34382,34383,34387,34523,34524,34539,34540,34541,34542,34543,34544,34545,34546,34547,34548,34549,34552,34553,34726,34727,34728,34869,34870,34871,34872,34875,34876,34877,34878,34879,34880,34881,34883,34884,47191,35143,35144,35145,35146,35147,35148,35149,35150,35151,35152,35167,35168,35190,35530,35531,35711,35712,35713,35714,35715,35716,35717,35718,35719,35720,35986,36287,36288,36294,36295,36296,36297,36309,36310,36318,36482,36483,36484,36497,36511,36512,36513,36515,36516,36517,36518,36670,36671,36674,36675,36676,36677,36678,36679,36694,36695,36707,36715,36716,36717,36727,36736,36742,36743,37010,37011,37012,37013,37014,47190,47189,47188,47187,37173,37174,37175,37628,37629,37630,37633,37634,37738,37740,37741,37742,37743,37744,37745,37746,37747,37748,37749,37750,37751,37752,37753,37754,37755,37756,47186,37778,37779,37780,37787,37788,37789,37790,37791,37792,37793,37990,37991,38001,38003,38004,38005,38179,38180,38181,38182,38183,38184,38242,38243,38252,38253,38254,38255,38256,38289,38290,38291,38292,38293,38294,38295,38296,38297,38298,38474,38479,38480,38481,38482,38483,38484,38485,38486,38487,38488,38489,38490,38496,38656,38657,38658,38659,38660,38666,38667,38671,38672,38673,38674,38683,38684,38685,38686,38687,38688,38689,38714,38715,38716,38732,38733,38734,38735,38774,38775,38776,38777,38778,38956,39014,39015,39016,39017,39018,39019,39027,39028,39029,39030,39031,39032,39033,39034,39036,39037,39039,39040,39041,39042,39046,39424,39473,39477,39648,39649,39650,39651,39652,39653,39654,39655,39659,39765,39766,39767,39768,39896,39897,39898,39924,39925,39943,39944,39945,39946,40248,40249,40250,40251,40337,40382,40502,40503,40504,40505,47185,40676,40677,40679,40680,40707,40736,40737,40738,40739,40740,40741,40742,40743,40744,40745,40759,40760,40771,40772,41017,41018,41019,41020,41021,41022,41035,41036,41043,41086,41087,41117,41245,41591,41753,41754,41755,41757,41758,41762,41763,41764,41769,41772,41773,41774,41775,41777,41778,41779,47183,41819,41938,41939,41940,41941,42101,42102,42208,42209,42210,42250,42251,42347,42348,42349,42350,42351,42672,42673,42674,42759,42760,42761,42813,42814,42815,42816,42817,42818,42830,42831,42832,43307,43308,43330,43331,43332,43458,43462,43463,43464,43465,43663,43664,43665,43666,43668,43669,43670,43671,43672,43673,43674,43675,43676,43677,43678,43679,43680,43874,43875,43876,43877,43878,43881,44301,44302,44303,44428,44429,44430,44476,44477,44501,44502,44503,44504,44508,44509,44510,44595,44663,44664,44747,44862,44863,44931,44932,44934,45172,45216,45217,45218,45219,45221,45222,45223,45369,45383,45384,45435,45436,45442,45443,45444,45445,45446,45454,45461,45462,45544,45545,45683,45684,45692,45775,45780,45781,45818,45819,45820,45821,45822,45934,45955,45956,45957,45958,45959,45960,45961,45962,45963,45964,45965,45966,45967,45968,45969,45970,46119,46120,46121,46136,46137,46173,46174,46175,46176,46177,46178,46179,46180,46181,46182,46183,46190,46191,46192,46193,46194,46195,46196,46197,46198,46199,46200,46201,46202,46203,46204,46205,46206,46207,46208,46209,46210,46211,46212,46213,46217,46239,46287,46363,46365,46366,46367,46368,46369,46391,46392,46393,46394,46395,46396,46397,46398,46399,46400,46401,46403,46404,46405,46406,46407,46531,46532,46533,46565,46680,46681,46682,46683,46762,46854,46855,46973,46974,47037,47048,47095,47096,47150,47151,47161,47163,47166,47172,47173,47174,47175) AND pd.language_id = '1' AND p.status = '1' AND p.quantity > 0 ORDER BY p.sort_order ASC LIMIT 0, 30