SELECT p.product_id, p.price AS sprice, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) 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 = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' 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 = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ps.date_end FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special_price_valid_until, pd.url FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '233' AND p.product_id IN (20169,20170,20171,20172,20173,20174,20175,20176,20177,20178,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21051,21455,21456,21457,21458,21459,21463,21464,21466,21488,21489,21490,21492,21493,21495,21496,21498,21500,21501,21504,21506,21507,21509,21510,21512,21513,21514,21515,21516,21517,21519,21520,21521,21522,21523,21524,21525,21526,21527,21528,21529,21530,21531,21532,21533,21534,21535,21536,21537,21538,21539,21540,21541,21542,21543,21544,21545,21546,21547,21548,21549,21550,21551,21552,21553,21554,21555,21556,21557,21558,21559,21560,21561,21562,21563,21564,21565,21566,21573,21574,21575,21576,21577,21578,21580,21581,21582,21583,21584,21585,21586,21587,21593,21594,21598,21599,21600,21601,21602,21603,21604,21605,21606,21607,21608,21609,21610,21611,21612,21613,21614,21615,21616,21617,21618,21619,21620,21621,21623,21624,21627,21628,21629,21630,21631,21632,21633,21634,21635,21636,21637,21638,21639,21640,21642,21643,21644,21645,21646,21647,21648,21649,21650,21651,21652,21653,21654,21655,21656,21657,21658,21659,21660,21661,21662,21667,21669,21670,21671,21672,21673,21674,21675,21676,21677,21678,21679,21680,21681,21682,21683,21684,21685,21686,21687,21688,21689,21690,21691,21692,21693,21694,21695,21696,21697,21698,21699,21700,21702,21703,21704,21705,21706,21707,21708,21710,21712,21713,21714,22435,22436,22437,22438,22439,22440,22441,22442,22443,22444,22445,22446,22448,22449,22450,22451,22452,22453,22454,22455,22456,22457,22458,22459,22460,22461,22462,22463,22464,22465,22466,22467,22468,22469,22470,22471,22472,22473,22474,22475,22476,22477,22478,22479,22480,22481,22482,22483,22484,22559,22564,22567,22568,22577,22579,22594,22597,22611,22612,22613,22614,22616,22617,22619,22620,22621,22622,22623,22625,22627,22631,22633,22635,22637,22638,22639,22640,22641,22642,22643,22644,22645,22649,22651,22652,22658,22662,22668,22672,22673,22688,22689,22692,22693,22699,22700,22705,22708,22709,22710,22711,22712,22713,22715,22716,22720,22723,22724,22725,22727,22728,22889,22890,22891,22892,22893,22894,22895,22896,22897,22898,22899,22900,22901,22902,22903,23352,23353,23354,23355,23356,23357,23358,23359,23360,23361,23362,23365,23366,23367,23368,23369,23370,23409,23715,23716,23717,23718,28530,28531,28532,28533,28534,28535,28536,28537,28538,28539,28540,28541,28542,28543,28544,28545,28546,28547,28548,28549,28550,28551,28552,29383,29386,29392,29393,29394,29396,29403,29404,29409,29427,29466,29470,29472,29474,29476,29478,29480,29483,29484,29486,29488,29489,29490,29492,29494,29497,29498,29499,29500,29501,29502,29508,29511,29512,29513,29514,29515,29517,29518,29519,29520,29521,29522,29524,29525,29526,29527,29528,29529,29530,29531,29532,29533,29534,29535,29536,29537,29538,29539,29540,29541,29542,29543,29544,29545,29546,29547,29548,29549,29550,29551,29552,29554,29558,29559,29565,29566,29567,29568,29569,29570,29572,29574,29575,29576,29577,29579,29588,29589,29590,29591,29592,29593,29594,29595,29596,29597,29600,29601,29603,29604,29605,29606,29607,29608,29611,29613,29615,29617,29618,29619,29620,29621,29624,29625,29626,29627,29628,29629,29630,29631,29632,29633,29634,29635,29636,29637,29638,29639,29640,29641,29642,29643,29644,29645,29646,29648,29649,29650,29651,29652,29654,29655,29656,29658,29659,29660,29661,29662,29663,29664,29665,29666,29668,29669,29670,29671,29672,29673,29674,29675,29677,29678,29679,29680,29681,29682,29683,29684,29685,29687,29688,29692,29693,29694,29695,29697,29699,29700,29701,29703,29704,29705,29711,29712,29713,29714,29719,29720,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29737,29738,29739,29740,29741,29742,29743,29744,29745,29746,29747,29748,29749,29750,29751,29752,29753,29754,29755,29756,29757,29758,29759,29761,29763,29764,29765,29766,29768,29769,29770,29771,29772,29773,29774,29775,29776,29824,29829,29830,29831,29833,29834,29835,29836,29837,29838,29839,29849,29852,29853,29856,29857,29858,29859,29860,29861,29862,29863,29864,29865,29867,29868,29869,29872,29873,29874,29879,29881,29882,29883,29885,29886,29887,29888,29889,29890,29891,29892,29893,29894,29895,29896,29897,29898,29899,29900,29901,29902,29903,29904,29905,29906,29909,29910,29911,29912,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,31219,31220,31221,31222,31223,31224,31225,31226,31227,31229,31230,31231,31232,31233,31234,31235,31236,31237,31238,31239,31240,31241,31242,31243,31244,31245,31246,31247,31248,31249,31250,31251,32312,32313,32314,32315,32316,32317,32318,32319,32320,32321,32322,32323,32324,32325,32326,32327,32328,32329,32330,32331,32332,32333,32334,32335,32336,32337,32338,32339,32340,32341,32342,32343,32344,32346,32347,32348,32349,32350,32351,32352,32353,32354,32355,32356,32357,32358,32359,32360,32361,32362,32363,32364,32365,32366,32367,32368,32369,32370,32371,32372,32373,32374,32375,32376,32377,32378,32379,32380,32381,32382,32383,32384,32385,32386,32387,32388,32389,32390,32391,32392,32393,32394,32395,32396,32397,32398,32399,32400,32401,32402,32403,32404) GROUP BY p.product_id ORDER BY CASE WHEN p.quantity <= 0 THEN 1 ELSE 0 END, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,10000
Naujos vasarinės padangos internetu pigiau | Autorolis.lt