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 = '234' AND p.product_id IN (18033,18034,18043,18052,18053,18056,18058,18064,18065,18066,18067,18074,18077,18079,18092,18095,18098,18105,18106,18111,18133,18138,18139,18148,18155,18160,18161,18165,18166,18169,18170,18176,18181,18185,18188,18189,18226,18227,18231,18234,18244,18247,18249,18252,18254,18262,18263,18273,18275,18276,18282,18283,18286,18290,18300,18302,18303,18304,18327,18336,18337,18344,18345,18367,18391,18429,18469,18474,20374,20375,20376,20377,20378,20379,20380,20381,20382,20383,20384,20385,20386,20387,20388,20389,20390,20391,20392,20393,20394,20395,20396,20397,20398,20399,20400,20401,20402,20403,20404,20405,20406,20407,20408,20409,20410,20411,20412,20413,20414,20415,20416,20417,20418,20419,20420,20421,20422,20423,20424,20425,20426,20427,20428,20429,20430,20431,20432,20433,20434,20435,20436,20437,20438,20439,20440,20441,20442,20443,20444,20445,20446,20447,20448,20449,20450,20451,20452,20453,20454,20455,20456,20457,20458,20459,20460,20461,20462,20463,20464,20465,20466,20467,20468,20469,20470,20471,20472,20473,20474,20475,20476,20478,20479,20480,20481,20482,20483,20484,20485,20486,20487,20488,20489,20490,20491,20492,20493,20494,20495,20496,20497,20498,20499,20500,20501,20502,20503,20504,20505,20507,20508,20509,20510,20511,20512,20513,20514,20515,20516,20517,20518,20519,20520,20521,20522,20523,20524,20525,20526,20527,20528,20529,20530,20531,20532,20533,20534,20535,20536,20537,20539,20540,20541,20542,20543,20544,20545,20546,20547,20548,20549,20550,20551,20552,20553,20554,20555,20556,20557,20558,20559,20560,20561,20562,20563,20564,20565,20566,20567,20568,20569,20570,20571,20572,20573,20574,20575,20576,20577,20578,20579,20580,20581,20582,20583,20584,20585,20586,20587,20588,20589,20590,20591,20592,20593,20594,20595,20596,20597,20598,20599,20600,20601,20602,20603,20604,20605,20606,20607,20608,20609,20610,20611,20612,20613,20614,20615,20616,20617,20618,20619,20620,20621,20622,20623,20624,20625,20626,20627,20628,20629,20630,20631,20632,20633,20634,20635,20636,20637,20638,20639,20640,20641,20642,20643,20644,20645,20646,20647,20648,20649,20650,20651,20652,20653,20654,20655,20656,20657,20658,20659,20660,20661,20662,20664,20665,20666,20667,20668,20669,20670,20671,20672,20673,20674,20675,20676,20677,20678,20679,20680,20681,20682,20683,20684,20685,20686,20687,20688,20689,20690,20691,20692,20693,20694,20695,20696,20697,20698,20699,20700,20701,20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20716,20717,20718,20719,20720,20721,20722,20723,20724,20725,20726,20727,20728,20729,20730,20731,20732,20733,20734,20735,20736,20737,20738,20739,20740,20741,20742,20743,20744,20745,20746,20747,20748,20749,20750,20751,20752,20753,20754,20755,20756,20757,20758,20759,20760,20761,20762,20763,20764,20765,20766,20767,20768,20769,20770,20771,20772,20773,20774,20775,20776,20777,20778,20779,20780,20781,20782,20783,20784,20785,20786,20787,20788,20789,20790,20791,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20804,20805,20806,20807,20808,20809,20810,20811,20812,20813,20814,20815,20816,20817,20819,20820,20821,20822,20823,20824,20825,20827,20828,20829,20830,20832,20833,20834,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20866,20867,20868,20869,20870,20871,20872,20873,20874,20876,20877,20878,20879,22928,22929,22930,22931,22932,22933,22934,22935,22936,22937,22938,22939,22940,22941,22942,22943,22944,22945,22946,22947,22948,22949,22950,22951,22952,22953,22954,22955,22956,22957,22958,22959,22960,22961,22962,18030,18031,18032,18035,18036,18037,18038,18040,18041,18042,18044,18045,18046,18047,18048,18049,18050,18051,18054,18055,18057,18059,18060,18061,18062,18063,18068,18069,18070,18071,18072,18073,18075,18078,18080,18081,18082,18083,18084,18085,18086,18087,18088,18089,18090,18091,18093,18094,18096,18097,18099,18100,18101,18102,18103,18104,18107,18108,18109,18110,18112,18113,18114,18115,18116,18117,18118,18119,18120,18121,18122,18124,18125,18126,18127,18128,18129,18130,18131,18132,18134,18136,18140,18141,18142,18143,18144,18145,18146,18147,18149,18150,18151,18152,18153,18154,18156,18157,18158,18159,18162,18163,18164,18167,18168,18171,18172,18173,18174,18175,18177,18178,18179,18180,18182,18183,18184,18187,18190,18191,18192,18193,18194,18195,18196,18197,18198,18199,18200,18201,18202,18203,18204,18205,18206,18207,18208,18209,18210,18212,18213,18214,18215,18216,18217,18218,18219,18220,18221,18222,18223,18224,18225,18229,18230,18232,18233,18235,18236,18237,18239,18240,18241,18245,18246,18248,18250,18251,18255,18257,18258,18260,18261,18265,18266,18267,18269,18270,18271,18272,18277,18278,18279,18280,18281,18284,18285,18287,18288,18289,18291,18292,18293,18294,18295,18296,18297,18298,18299,18301,18305,18306,18307,18308,18309,18312,18314,18315,18316,18317,18318,18319,18320,18321,18322,18324,18325,18326,18328,18330,18331,18332,18333,18334,18335,18339,18340,18347,18349,18350,18351,18352,18354,18355,18363,18366,18370,18372,18373,18374,18375,18377,18378,18380,18381,18385,18387,18389,18392,18393,18394,18397,18398,18403,18404,18405,18406,18410,18414,18415,18417,18418,18420,18423,18424,18425,18426,18428,18430,18431,18432,18433,18434,18435,18436,18437,18438,18442,18443,18445,18446,18447,18448,18449,18450,18451,18453,18454,18455,18456,18457,18459,18460,18461,18463,18464,18466,18468,18470,18471,18472,18473,18475,18476,18477,18478,18479,18480,18481,18482,18483,18484,18485,18487,18488,18489,18490,18491,18492,18493,18494,18495,18496,18401,18361,18256,18343,18388,18399,18395,18311,18416,18310,18408,18341,18348,18274,18427,18440,18462,18268,18243,18407,18411,18259,18376,18358,18444,18365,18211,18412,18452,18386,18486,18409,18382,18360,18465,18390,18356,18359,18346,18135,18369,18379,18400,18342,18353,18383,18402,18396,18039,18253,18467,18362,18364,18422,18441,18413,18439,18458,18076,18313,18329,18357,18368,18419,18238,18323,18371,18264,20865,18228,20831,20477,20826,18338,18384,20875,20818,18421,20538,18137,20663,18242,20506) 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,10000SELECT 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 = '234' AND p.product_id IN (0) 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 žieminės padangos internetu pigiau | Autorolis.lt