QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(9214655,7076017,10939642,8838589,8621124,10870636,8839015,8839016,8839017,8583102,8621484,10874047,8569752,8569753,10459404,4971072,11041546,11041547,11041548,11041549,11041550,3229297,11041601,8583569,10847097,10847103,8622294,10849777,10849806,4968846,10862924,8576005,8560950,8560951,8561051,7075185,7075188,7075199,8561151,8561152,8561153,8561154,7067220,7075234,8837737,10845006,7075263,7075264,10938930,10845413,10962600,3238457,8065080,8065082,8065093,10866443,8595114,8595117,7064528,8618397,7201858,8595298,8595360,10867021,8836235,10999468,10999469,10999470,10999471,10859088,8065798,4967068,8572087,8618807,8618808,7065155,8066141,8628824,8628825,8628826,7202525,8560311,7202633,8560432,10867874,10932976,10932977,11039350,11039351,11039352,11013433,11013434,4967992,11013496,11013497,11013498,11013499,11013500,11013501,11013502,11013503,11013504,11013505,11013506,11013507,8560768,11013508,11013509,11013510,11013511,11013512,11013513,11013514,11013515,11013516,11013517,8063985,8910100,3927480,3927487,8626943,8834833,10998101,11049384,7200738,7200739,10943150,10943151,11037226,11037227,10865893,10858021,10858022,8558772,7071828,6000124,4430546,10100111,7068988,10839877,10944623,10944624,10863747,11009346,11009347,8072437,7198949,11009475,11009476,7069796,10996568,8072652,8072657,8072672,8072677,8072697,3236381,3236382,3656624,10840903,8616166,8557315,8557316,8626055,8626056,8626058,8626059,8626061,8626062,8626063,11036166,8565227,10958365,10958366,11048594,8834189,3927100,3927104,10954667,11045730,11045746,11045747,11032751,4936814,10837897,11032853,11006880,11032897,3233632,3233633,3233634,3233635,3233636,3233637,11033010,11033011,11033012,11033013,11033014,11033015,8613166,11033016,11033017,3233910,3924130,10968423,10968424,10968425,10968426,10968427,7157288,7197038,7157421,11046693,11046694,3234436,3234437,10838839,3234552,10838911,8071015,8071016,8555383,4938175,3234918,7158077,7197828,7197829,4938356,4938361,4938376,4938381,4938401,8905018,8905019,10922515,11005667,10622027,10622053,10427408,10836876,8905221,10917713,10917714,10622294,10622328,10927907,8905469,10954259,10993428,11006456,11006466,8905840,11006467,11006468,11006469,11006492,8579054,10850232,10850239,10850256,10460541,10460542,10850291,10615036,10425391,10425392,10425393,10850326,3230459,10850338,10850352,10850353,10920628,10847856,10620237,10850600,10620437,10926015,8570488,9217222,9217223,9217224,9217225,9217226,9217227,10620750,10952362,10615905,10952624,10952625,10851353,8540595,9217801,10952845,9217848,3231760,8540960,8540961,8540962,8577691,7155065,8541145,8552602,10927198,10852002,10852063,8634456,8578002,9189340,8853174,8853175,8853190,8853191,10611066,9189445,9189449,10611122,10611179,9213599,10565444,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565565,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,10565632,10565633,10565634,10565635,10565636,10565637,10565638,10565639,10565640,10565641,10565642,10565643,10565644,10565645,10614530,10565772,10565773,10565774,10565775,10565776,10565777,10565778,10565779,10565780,10565781,10565782,10565783,10565784,8853797,10565785,8853798,10565786,10565787,10565788,8568477,10565789,10565790,10565791,10565792,10565793,10565794,10565795,10562803,10562804,10562805,10562806,10562807,10562808,10562809,10562810,10562811,10562812,10562813,10562814,10562815,10562816,10562817,10562818,10562819,10562820,10562821,10562822,10562823,10562824,10562825,10562826,10562827,10562828,10562829,10562830,10562831,10562832,10562833,10562834,10562835,10562836,10562837,10562838,10562839,10562840,10562841,10562842,10562843,10562844,10562845,10562846,10562847,10562848,10562849,10562850,9166112,10565943,3962453,8864665,10611836,9211337,10612178,10119830,10612381,10612419,10612420,10612421,9211785,10612710,10612824,10612960,10612961,9188333,10610037,10610072,10610075,10610076,10613085,10613088,8862951,8567091,9172751,9172752,9164756,9164817,7018504,8852736,9173012,8863535,9173013,9173014,9173015,6677425,7018950,9209486,9209487,8849317,8849318,8849332,8849333,8849378,8592719,10517499,10517500,10517501,10517502,10517503,10517504,10517505,9169756,4974663,7023546,10513714,10126152,7023615,7023622,8849795,7023658,8849838,8849877,7056248,7056249,7023747,7023797,9912366,9912367,9210168,10118387,4975072,8850044,3285966,3286048,3286049,9186532,8850596,8850597,10516606,10516607,10516608,10516609,10516610,10516611,10516612,10516613,9913184,9913221,8565563,8552466,8552476,8917983,9160350,9176362,9160416,10419423,10116721,10416495,6672783,6672786,6672796,6672797,6672801,6672802,9208604,9208605,9208606,9208607,6672893,6672911,9208739,9208748,7054938,6672994,6672995,8848755,8848756,8848757,8848758,8848759,10419905,10419906,6673190,6673191,6673255,6673261,10419063,10125365,10125366,10125367,10125403,9161280,6678540,8864862,8864930,8864943,9198460,6678857,9206657,6670917,6670918,9190734,8549954,9190846,9917063,8854698,8854699,10465457,6665231,6665232,10463584,8854895,6667166,10465756,9191246,3963621,8550554,6665651,8847273,8847274,8847275,6667494,6667495,9207580,9207589,9207654,8847487,8847488,9207673,9207732,9207733,9207734,9199755,9207796,9191854,9191855,9167893,9167896,10462640,10462641,9168130,8848024,8848025,8848026,8848027,8848028,8848029,8848031,9168241,10116489,10116490,10116491,10883561,10883602,10946591,10946593,10883826,10888892,10888893,10884060,10899499,10899515,10889591,10889635,10947495,10889717,10155738,10894733,10889782,10155808,10629294,10629295,10155834,10155835,10879893,10879902,10909933,10889970,10889972,10890090,10166286,10890289,10945642,10168846,10173886,10168917,10168918,10168919,10883098,10883099,10883100,10883108,10908140,10908141,10908189,10885592,10885593,10630152,10181742,10905775,10181807,10181808,10181809,10181810,10910915,10910925,10885962,10896334,10187607,10891773,10631278,10631279,10631280,10631281,10631282,10631283,10631284,10631285,10631286,10631287,10631288,10631289,10876860,10876861,10876862,10876863,10187982,10187988,10949802,10950152,10950153,10945170,10631881,10602172,10602181,10602234,10602236,10643513,10602366,10602367,10602368,10602369,10602370,10602401,10602402,10589607,10589608,10589609,10589610,10589611,10589612,10589613,10589614,10608517,10602517,10602691,10602701,10602712,10602720,10602733,10589894,10589895,10653271,10603070,10603071,10644342,10644619,10569689,10603571,10584728,10584729,10584730,10584731,10647884,10603703,10590867,10590975,10654035,10590976,10606888,10606900,10606941,10606951,10606976,10654326,10654327,10654328,10654329,10604201,10588370,10588371,10591388,10591424,10585483,10585484,10585485,10585486,10604417,10601436,10651654,10651655,10651656,10651657,10601510,10607536,10607547,10607607,10607609,10579831,10579832,10579833,10579834,10579835,10601687,10601698,10601699,10601706,10601711,10601717,10601786,10529149,10545329,10545330,10529434,10545567,10545601,10545602,10545603,10545604,10545605,10547833,10547834,10547835,10547836,10547837,10547838,10547839,10547840,10547841,10547842,10547843,10547844,10547845,10547846,10547847,10547848,10547849,10547850,10547851,10547852,10547853,10547854,10547855,10547856,10547857,10547858,10547859,10547860,10547861,10547862,10547863,10547864,10547865,10547866,10547867,10547868,10547869,10547870,10547871,10547910,10547911,10547912,10529972,10532136,10530174,10542277,10542295,10546452,10546531,10546532,10546533,10546534,10546535,10546564,10546565,10546577,10520757,10536837,10536838,10538859,10522864,10522865,10538901,10538914,10538927,10541037,10543044,10543045,10543046,10543047,10543048,10543049,10543050,10543051,10543052,10422286,10424640,10505583,10510780,10508817,10508818,10424018,10507974,10480943,10407308,10480985,10486108,8562514,10413588,10407593,10407600,10407619,10407647,10407658,10407671,10407694,10407705,10407709,10407719,10407720,10477439,10407895,10496675,10714569,10495111,10495112,10495252,10412605,10412606,10493276,10408676,10408720,10715318,10487783) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'