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 (16697,16717,16718,16723,16724,16728,16729,16735,16740,16741,16742,16743,16744,16745,16746,16747,16748,16749,16750,16751,16752,16753,16755,16756,16757,16758,16759,16760,16761,16762,16763,16764,16765,16766,16767,16768,16769,16770,16771,16772,16773,16775,16780,18030,18031,18032,18033,18034,18035,18037,18038,18041,18043,18045,18046,18047,18049,18050,18052,18053,18056,18059,18061,18062,18077,18078,18079,18080,18081,18082,18083,18084,18085,18086,18087,18088,18089,18090,18091,18092,18093,18094,18095,18096,18097,18098,18099,18100,18101,18102,18103,18104,18105,18106,18107,18108,18109,18110,18111,18112,18113,18114,18116,18119,18120,18121,18122,18123,18125,18126,18127,18128,18129,18130,18131,18132,18133,18134,18135,18136,18138,18139,18140,18141,18142,18143,18144,18145,18146,18147,18148,18149,18150,18151,18152,18153,18154,18157,18162,18165,18186,18187,18188,18189,18190,18200,18201,18203,18206,18208,18211,18212,18213,18214,18215,18216,18217,18218,18219,18220,18221,18222,18225,18226,18232,18233,18238,18239,18244,18246,18271,18272,18273,18274,18275,18276,18277,18278,18279,18280,18281,18282,18283,18284,18287,18289,18291,18293,18295,18296,18297,18299,18301,18304,18305,18326,18342,18360,18366,18429,18439,18444,18445,18446,18447,18448,18449,18450,18453,18454,18455,18456,18457,18458,18459,18460,18461,18462,18463,18464,18465,18466,18467,18468,18469,18470,18472,18473,18474,18475,18476,18477,18478,18479,18481,18482,18483,18484,18485,18487,18488,18489,18490,18491,18492,18493,18494,18495,18496,18498,18499,18503,18506,18510,18511,18512,18514,18519,18521,18522,18524,18525,18526,18527,18528,18529,18530,18532,18534,18536,18537,18538,18540,18543,18544,18545,18546,18549,18550,18551,18552,18553,18554,18555,18556,18557,18564,18565,18683,18684,18689,18691,18692,18693,18694,18696,18697,18715,18725,18727,18729,18732,18733,18736,18737,18738,18742,18747,18749,18750,18754,18757,18759,18765,18766,18771,18773,18774,18775,18779,18780,18781,18783,18788,18789,18790,18792,18795,18797,18801,18804,18810,18811,18812,18813,18815,18820,18821,18824,18827,18828,18829,18832,18834,18835,18837,18838,18839,18845,18848,18849,18850,18853,18854,18855,18856,18858,18860,18866,18868,18870,18873,19317,19368,19370,19394,19405,19412,19416,19448,20211,20223,20224,20227,20231,20232,20235,20238,20243,20244,20245,20247,20248,20249,20250,20252,20254,20257,20258,20261,20262,20263,20264,20267,20271,20272,20273,20276,20277,20282,20283,20284,20285,20286,20289,20290,20291,20292,20293,20294,20296,20307,20310,20315,20316,20320,20329,20332,20334,20335,20336,20337,20338,20339,20340,20345,20346,20348,20349,20350,20351,20354,20359,20360,20364,20365,20366,20367,20368,20369,20370,20371,20372,20373,20376,20378,20381,20382,20383,20384,20385,20427,20429,20430,20438,20439,20441,20443,20445,20447,20449,20450,20455,20456,20457,20464,20466,20467,20469,20471,20472,20474,20475,20481,20482,20485,20487,20488,20489,20492,20509,20521,20524,20526,20527,20528,20529,20534,20535,20538,20541,20542,20543,20544,20546,20548,20551,20552,20555,20556,20557,20558,20559,20560,20565,20566,20567,20568,20569,20570,20571,20572,20573,20574,20575,20580,20581,20584,20586,20590,20591,20592,20593,20596,20597,20598,20599,20600,20601,20603,20604,20605,20608,20612,20621,20631,20632,20633,20634,20637,20644,20645,20646,20648,20655,20656,20657,20658,20659,20661,20662,20663,20669,20670,20672,20677,20681,20684,20686,20700,20701,20703,20706,20710,20715,20727,20744,20757,20758,20760,20761,20762,20763,20764,20766,20769,20772,20773,20774,20777,20778,20786,20789,20792,20794,20797,20801,20803,20811,20812,20813,20816,20817,20818,20821,20822,20824,20826,20831,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20866,20867,20868,20870,20871,20872,20905,20907,20917,20929,20930,20937,20939,20940,20942,20944,20947,20950,20959,20963,20965,20970,20974,20979,20983,20989,21124,21125,21131,21132,21133,21168,21169,21171,21200,21203,21210,21215,21218,21219,21221,21223,21226,21227,21229,21246,21247,21251,21256,21258,21266,21310,21313,21314,21315,21318,21355,21358,21359,21360,21362,21363,21367,21409,21414,21434,21896,21897,21898,21899,21900,21901,21902,21903,21904,21905,21906,21907,21908,21909,21960,21965,21969,21970,21975,21991,22024,22026,22030,22077,22083,22181,22185,22187,22188,22189,22192,22193,22194,22195,22196,22197,22199,22200,22201,22202,22204,22205,22206,22207,22208,22210,22211,22213,22214,22215,22217,22218,22219,22221,22222,22226,22231,22249,22250,22251,22252,22253,22254,22255,22256,22257,22258,22259,22260,22261,22262,22263,22264,22265,22266,22267,22269,22270,22271,22272,22273,22274,22275,22276,22277,22278,22279,22280,22281,22908,22912,22915,22928,22930,22931,22933,22934,22935,22936,22937,22941,22942,22943,22944,22945,22946,22947,22948,22949,22950,22951,22952,22953,22954,22955,22956,22957,22958,22959,22960,22961,22962,22963,22964,22980,22981,22982,22983,22984,22985,22988,22994,22999,23001,23002,23006,23007,23008,23010,23011,23012,23013,23014,23015,23016,23017,23134,23138,23139,23140,23142,23154,23155,23156,23157,23158,23287,23609,23611,23616,23617,23618,23619,23621,23622,23623,23624,23625,23626,23643,23644,23645,23647,23648,23654,23655,23674,23675,23677,23678,23740,23741,23742,23743,23744,23745,23746,23747,23748,23749,23750,23751,23752,23753,23754,23755,25008,25010,25011,25013,25014,25016,25017,25018,25019,25022,25023,25024,25025,25026,25058,25059,28296,28297,28298,28299,28300,28302,28303,28305,28307,28311,28315,28317,28319,28328,28331,28334,28335,28336,28337,28340,28342,28343,28346,28347,28352,28368,28556,28561,28570,28571,28575,28576,28577,28594,28596,28598,28609,28615,28618,28619,28621,28623,28659,28661,28662,28667,28668,28697,28702,28780,28781,28784,28786,28789,28791,28792,28793,28795,28796,28797,28799,28801,28806,28847,28848,28849,28852,28853,28855,28858,28886,28888,28889,28890,28895,28896,28897,28898,28901,28902,28904,28906,28907,28909,28913,28914,28917,28920,28921,28923,28924,28925,28926,28927,28928,28933,28935,28936,28939,28940,30352,30353,30354,30355,30356,30357,30358,30359,30360,30361,30362,30363,30364,30365,30366,30367,30368,30369,30370,30371,30372,30373,30374,30375,30376,30441,30444,30445,30446,30447,30448,30449,30450,30460,30462,30487,30489,30495,30500,30506,30507,30532,30533,30536,30538,30557,30575,30587,30630,30631,30649,30667,30668,30669,30673,30674,30675,30680,30682,30685,30686,30687,30691,30694,30697,30701,30702,30705,30708,30719,30748,30759,30767,30775,30794,30861,30863,30866,30867,30868,30870,30872,30875,30878,30879,30880,30881,30883,30884,30885,30888,30889,30890,30891,30892,30894,30895,30896,30897,30898,30899,30900,30901,30902,30904,30905,30906,30907,30908,30910,30911,30912,30913,30914,30915,30916,30917,30918,30919,30920,30921,30923,30924,30926,30927,30928,30929,30930,30953,30954,30955,30956,30957,30958,30959,30960,30961,30962,30963,30964,30965,30966,30967,30968,30969,30970,30971,30972,30973,30974,30975,30976,30977,30978,30979,30980,30981,30982,30983,30984,30985,30986,30987,30988,30989,30990,30991,30992,30993,30994,30995,30996,30997,30999,31000,31001,31003,31004,31005,31007,31008,31009,31010,31011,31012,31013,31014,31040,31148,31151,31182,31353,31355,31387,31388,31391,31403,31408,31456,31460,31461,31463,31467,31468,31469,31470,31472,31473,31474,31477,31479,31482,31483,31484,31485,31487,31504,31505,31508,31509,31511,31512,31515,31524,31535,31536,31538,31539,31545,31546,31616,31630,31653,31657,31665,31673,31674,31684,31685,31716,31720,31726,31742,31752,31766,31767,31788,31790,31792,31795,31806,31810,31811,31820,31832,31853,31869,31871,31876,31879,31880,31881,31882,31884,31886,31887,31888,31899,31900,31905,31910,31911,31912,31913,31918,31964,31965,31967,31968,31969,31970,32000,32001,32002,32004,32025,32029,32031,32035,32043,32044,32045) 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