TestTSELECT 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, 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 = '232' AND p.product_id IN (16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579,16580,16581,16582,16583,16584,16585,16586,16587,16588,16589,16590,16591,16592,16593,16594,16595,16596,16597,16598,16599,16600,16601,16602,16603,16604,16605,16606,16607,16608,16609,16610,16611,16612,16613,16614,16615,16616,16617,16618,16619,16620,16621,16622,16623,18635,18636,18637,18638,18639,18640,18641,18642,18643,18644,18645,18646,18647,18648,18649,18650,18651,18652,18653,18654,18655,18656,18657,18658,18659,18660,18661,18662,18663,18664,18665,18666,18667,18668,18669,18670,18671,18672,18673,18674,18675,18676,18677,18678,18679,18883,18884,18886,18887,18888,18889,18890,18891,18893,18895,18896,18898,18899,18900,18901,18903,18904,18905,18906,18907,18909,18910,18911,18912,18913,18914,18915,18917,18918,18920,18921,18922,18923,18924,18925,18926,18927,18928,18929,18931,18932,18933,18934,18936,18937,18938,18939,18940,18941,18942,18943,18944,18945,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19130,19131,19585,19586,19588,19589,19590,19591,19592,19593,19594,19595,19596,19597,19598,19599,19600,19601,19602,19603,19604,19605,19606,19607,19608,19609,19610,19611,19612,19613,19614,19616,19617,19619,19621,19622,19623,19628,19632,19633,19634,19635,19636,19637,19638,19639,19640,19641,19642,19643,19644,19645,19646,19647,19648,19649,19650,19651,19653,19654,19656,19657,19658,19659,19660,19661,19662,19663,19664,19665,19666,19667,19668,19676,19677,19719,19720,19721,19722,19723,19724,19725,19726,19727,19728,19729,19731,19732,19733,19734,19737,19739,19740,19741,19742,19743,19744,19745,19746,19747,19748,19749,19750,19751,19752,19754,19755,19756,19757,19758,19759,19760,19761,19762,19763,19764,19765,19766,19767,19768,19769,19770,19771,19774,19775,19777,19778,19779,19780,19782,19783,19784,19786,19790,19791,19792,19793,19794,19795,19796,19797,19798,19801,19803,19804,19806,19809,19810,19811,19818,19820,19821,19822,19825,19826,19827,19832,19833,19835,19838,19840,19843,19844,19845,19846,19847,19848,19850,19852,19853,19854,19857,19859,19860,19861,19862,19863,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19896,19897,19898,19899,19900,19901,19902,19920,19922,19923,19926,19927,20146,20147,20148,20149,20150,20151,20152,20153,20154,20155,20156,20157,20158,20159,20160,20161,20162,20163,20164,20165,20166,20167,20168,21060,21061,21062,21063,21064,21065,21475,21476,21480,21481,21483,21484,21485,21486,21579,21588,21589,21592,21595,21597,21641,21701,21715,22485,22490,22491,22492,22493,22494,22495,22497,22498,22558,22560,22563,22565,22566,22574,22581,22584,22608,22628,22630,22659,22660,22666,22691,22733,22734,22736,22737,22739,22856,22857,22858,22859,22860,22861,22862,22863,22864,22865,22866,22867,22868,22869,22870,22871,22872,22873,22874,22875,22876,22877,22878,22879,22880,22881,22882,22883,22884,22885,22886,22887,22888,23019,23349,23351,23363,23364,23392,23394,23396,23397,23398,23399,23401,23402,23404,23405,23406,23407,23410,23411,23412,23413,23414,23415,23416,23417,23418,23501,23508,23509,23510,23511,23512,23513,23514,23515,23516,23517,23518,23519,23520,23521,23522,23527,23528,23702,23703,23704,23705,23706,23707,23708,23709,23710,23711,23712,23713,23714,24922,24923,24924,24925,24926,24927,24928,24929,24930,24931,24932,24933,24934,24935,24936,24937,24938,24939,24940,24941,24942,24943,24944,24945,24946,24947,24948,24949,24950,24951,24952,24953,24954,24955,24956,24957,24958,24959,24960,24961,24962,24963,24964,24965,24966,24967,24968,24969,24970,24971,24972,24973,24974,28391,29228,29229,29232,29241,29249,29251,29263,29264,29269,29273,29372,29385,29400,29410,29412,29418,29420,29421,29425,29429,29431,29437,29438,29440,29441,29444,29446,29447,29448,29449,29450,29451,29452,29453,29454,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29581,29582,29583,29584,29587,29622,29623,29653,29760,29804,29805,29808,29809,29811,29812,29813,29814,29815,29816,29817,29819,29820,29821,29822,29825,29842,29843,29844,29847,29848,29851,29854,31252,31253,31254,31255,31256,31257,31258,31278,31299,31300,31301,31302,31303,31304,31305,31306,31307,31308,31309,31310,31311,31312,31313,31314,31315,31316,31317,31318,31319,31320,31321,31322,31323,31324,32197,32198,32199,32200,32201,32202,32203,32204,32205,32225,32226,32227,32228,32229,32230,32231,32232,32233,32234,32235,32236,32237,32238,32239,32247,32248,32289,32290,32291,32292,32293) AND p.quantity > 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 padangos internetu pigiau | Autorolis.lt