        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 (23891,23887,23886,23884,38217,23838,23649,23648,23647,23603,23593,23531,23530,26330,22678,22677,22676,22675,22674,35475,18477,18476,18475,18472,33608,18470,18469,18468,18467,18466,18465,18464,18463,18462,18461,18460,18459,18458,18457,18456,18455,18454,18453,18452,18451,18450,18449,18448,18447,18446,18445,18444,18443,18442,18441,18440,18439,18438,18437,18436,18435,18434,18433,18432,18431,18430,18429,18428,18427,18426,18425,18424,18423,18422,18421,18420,18419,18418,18417,17005,17004,17003,17002,17001,17000,16999,16998,16997,16996,16964,16963,16962,16961,16960,16959,16958,16957,16956,16955,16954,16953,16952,16951,16950,16949,16948,16947,16946,16945,16944,16895,16743,16744,16742,16741,16740,16739,16738,39051,39062,39063,38206,39087,39114,39115,39147,39170,39171,39175,39176,39177,39188,39197,39198,39199,39200,39201,39202,14999,14998,14997,14996,14995,14994,14993,14992,14991,14990,14989,14988,14987,14986,14985,14984,14983,14982,14981,14980,14979,14978,14977,14476,14469,24102,24292,24443,24464,24518,24594,24908,25030,25040,25121,25389,25415,25478,26123,26124,26125,26126,26227,26328,26331,16747,31210,26593,26329,23532,26602,26603,25117,26604,26607,26742,26743,26744,26761,26767,26768,26796,26840,26862,26910,26905,26906,26907,27325,27894,27965,28130,25695,28376,28377,28378,28379,28380,28381,28382,28383,28508,28510,28513,28514,28515,28516,28600,28601,28602,28614,28615,28720,28791,28792,28989,28990,29187,29222,29225,29385,29440,29448,29480,29487,29515,29516,29517,29518,29519,29513,29851,29863,29864,29865,29866,29867,30115,29520,30125,30336,30343,30624,30702,30703,30762,18474,30792,30793,30794,30950,30982,30985,30986,30987,30988,31031,31418,31619,31620,31810,31868,31876,31945,31946,31948,31949,31950,31951,31952,31982,32045,32046,32047,32080,32501,32565,32566,32567,32568,32569,32570,32571,32576,32577,32578,32579,32580,32581,32582,32583,32584,32585,32586,32653,32738,32755,32758,32760,32805,32806,32807,32885,32886,32887,32888,32958,32959,32981,33050,32499,33201,33336,33361,33425,33950,33685,33686,33687,33688,33714,33916,33917,33918,33946,33947,33948,33949,30288,34221,34654,34744,34932,35173,35174,35175,35176,35184,35185,35186,35189,35209,35351,35352,35432,35451,35518,35541,35621,35622,35628,35629,35630,35633,35641,35642,35643,35691,35706,35902,36032,36096,36197,36199,36200,36226,36302,36303,36304,36305,36306,36307,36308,36319,36429,36430,36431,36459,36466,36503,36641,36642,36643,36644,36645,36762,36849,36852,36853,36871,36872,36873,37029,37030,37031,37032,37035,37036,37037,37038,37042,37043,37044,37045,37046,38216,35517,34729,37247,37305,35576,36663,36664,36222,36640,37641,37739,37761,37762,37763,37764,37765,37766,37767,37782,37835,38011,38013,18471,30788,38174,38175,38176,38177,38259,38402,38404,38405,38406,38499,38616,38703,38756,38757,38818,38948,39360,39482,39483,39484,39488,39596,39597,39602,39603,39604,39626,39627,39628,39629,39630,39631,39686,39706,39736,39759,39761,39824,39921,39825,39823,39922,39923,40119,40124,40125,40126,40127,40128,40129,40130,40131,40132,40133,40134,40135,40136,40137,40138,40139,40143,40268,40344,40345,40402,40483,40646,40675,40732,40718,40729,40730,40731,40733,40693,40513,40781,40782,40788,40789,40806,40807,40808,40809,40810,40811,40812,40813,40814,40829,40830,40831,40832,40833,40911,40919,40920,40921,40925,40926,40927,40928,40942,40943,41039,41047,41302,41303,41349,41377,41467,41539,41540,41541,41542,41543,41544,41545,41546,41638,41677,41748,41791,41820,42077,42135,42147,42148,42181,42182,42213,42214,38078,42431,42432,42433,42551,42678,42679,42746,42916,42917,42921,43067,43074,43075,43076,43086,43087,43139,43149,43152,43239,43240,43267,43346,43411,43425,43426,43600,43601,43602,43603,43604,43605,43606,43607,43608,43713,43739,43756,43850,43880,44039,44040,44046,44049,44050,44344,44349,44350,44351,44461,44462,44470,44499,44500,44529,44530,44531,44532,38077,44575,44662,44666,44682,44683,44748,44749,44979,45171,45225,45231,45263,45299,45311,45381,45382,45518,45522,45621,45687,45706,45709,45710,45754,45830,45831,45865,45866,45905,45927,45972,45974,45985,46111,46124,46271,46272,46273,46274,46275,46277,46278,46279,46348,42664,46534,46535,46536,46537,46538,46856,46857,46877,46966,46967,40270,46968,46969,46970,46971,25126,46430,41322,46431,25870,28597,28598,45708,46972,28599,30148,46990,47038,47039)
          AND pd.language_id = '3'
          AND p.status = '1'
          AND p.quantity > 0
        ORDER BY p.sort_order ASC
        LIMIT 30, 0