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(7068074,4970700,4970743,3228986,8583110,10940264,8583142,8583166,8583171,8583189,10950501,8583377,8583381,7065989,7066005,7066101,7066102,7066179,7066220,8575440,8583973,11042276,11042277,8609634,8609639,3230230,8609666,10951513,10844688,10844689,8573149,8573154,3227397,3227400,3227407,8573182,8067904,8067906,8573231,8573235,3227474,8573237,3227475,3227477,3227478,3227480,3227481,3227505,3227506,8573269,8573270,3227526,10938815,10938951,3227773,8573639,10939168,10939380,10939381,10939382,10939384,10939552,7201202,7201203,7201205,7201224,7201262,7201383,7201430,7201431,10842944,7201455,7064235,7201533,7201535,7201536,7201544,7201546,7201547,7201560,7201746,7064606,10843631,10843633,8572096,8572112,8572124,8572125,8572126,8572127,8572128,8572130,8572131,8572149,8572185,8572189,8572208,7065156,10844097,7202601,7202635,7202735,7065561,8572857,3227198,8573004,8573031,8573061,7065916,7065920,7200182,7200221,7200468,8834732,8834764,7200522,7200523,7200524,7200526,7200625,8910465,7200753,7200792,8910657,10102763,10100156,10100222,7198433,7198437,7198453,7198564,7198566,7198598,10941019,7198678,7198690,7198694,7198702,7198703,7198713,7198720,7198727,7198733,7198759,7198814,7069731,10100923,7199053,7199059,10941440,10941441,10941442,10941444,10100980,10101067,8564671,10101158,7199297,7199298,10101206,7199378,10101291,7199460,7199507,7199510,10101449,10101453,10101454,10101465,7199647,10101563,7199892,7200134,7200149,10623061,10837850,10618300,10618301,10623524,10623587,10623588,10623589,10623590,10623632,10623633,8906828,8906892,7197146,7197207,7197210,7197214,7197219,7197227,7197228,7197249,10838762,10838763,10838764,10838765,10838766,10838767,10838768,10838774,10838775,10838776,7197269,10838777,10838778,10838937,8614445,7197859,7197896,7197920,7197921,7197936,7197937,7197948,7197958,7198083,7198084,7198085,7198143,7198144,8904996,10617035,10617037,10617038,10617040,10836988,10837006,8905388,10617379,8905537,10617506,8905542,8905544,10617520,8905625,10837354,10837355,8905856,8905928,8905973,8905974,8905975,8905977,10614967,8569944,8569945,10615059,10615060,10615095,10615098,10615099,10615100,10615101,10615117,10615143,10615185,10615190,10620201,10620202,10615202,10615232,10615233,10615337,10615390,10615409,10615432,10615433,10615553,10620585,10425934,10930633,10615859,10615860,10426205,10426210,10426211,10426212,8610795,10952604,10616016,10426441,8610928,8610930,8540627,10616156,10616198,10616199,10616200,10616211,10616217,10616218,10616225,10616227,10616289,8904321,10616302,10616335,10616336,10616375,10616377,10616378,10616381,8611279,8611288,8611382,10616653,10616747,8577902,10427112,8577970,8611647,8578002,8578003,8578004,8904911,8904917,8904947,10616923,8904961,8904988,8904989,10613965,10613975,10614009,10614013,10611049,10611052,10614210,6669783,6669820,10614279,10614282,10714109,6669874,6669875,6669876,6669877,6669878,6669879,6669880,6669881,6669882,10614340,6669883,10611344,10614357,10714188,10611378,10614443,10614497,10614593,9166229,9166230,9166231,9166236,10609008,10612060,10612084,10612086,10612168,10612169,10612273,10612344,10609348,10609349,10609350,10609351,10609352,10609356,10609357,10609358,10609359,10609362,10609363,10609374,10609375,10609376,10609378,10612381,10609382,10609385,10609387,10609388,10609389,10609393,10609404,10609408,10609443,10609444,10609447,10609457,10609471,10609475,10609481,10609489,10609496,10609497,10609498,10609499,10609502,10609503,10609504,10609523,10609540,10609553,10609554,10609595,10609606,10609614,10609618,10609633,10609660,10609674,10609697,10609703,10612706,10609710,10609717,10609730,10609732,10609733,10609734,10609735,10609740,10609741,10609749,10609784,10609835,10609836,10609838,10609851,10609852,10609854,10609855,10609856,10609877,10609878,10609881,10609896,10609897,10612907,10609907,10612910,10612911,10612913,10612914,10609944,10609953,10612973,10612981,10612982,10610013,10610184,10610272,10610274,10613278,10613356,10613357,10610361,10610395,10610415,9164777,9164779,10613502,10610694,10613779,10613780,10613801,10613802,10613808,10613809,10613827,10613887,10613920,10613935,10613952,10613958,10117500,10117501,10117502,10117503,10117512,10117528,10117531,7055509,9169496,7055669,7055725,10117804,10117805,10117814,10117994,10118027,9169926,9169927,10118146,10118266,10118267,10118268,8551404,10118302,8551410,8551436,8551502,8551503,8551506,8551507,8551508,8551509,8551510,8551511,10118615,10118640,10118660,8551925,8552043,8552159,8552161,8552164,8552168,8552200,8552201,9210939,9210940,8861641,8552430,9160336,10417285,10416285,10417286,10416286,10417287,10417288,10417289,10417290,10417291,9168369,10417292,10416302,9168402,10415328,10415403,10415404,10415406,10415417,10415425,10416444,10416445,10416446,10419446,10419447,10416448,10419448,10419449,9184530,10416453,10416457,10416466,10416467,10416468,9168560,10416485,10415490,10419524,10419525,10419526,10419527,10116815,10418543,9184624,10419592,10415604,9160694,10416649,10416650,9160740,10416709,10416710,9160789,9160808,9160825,9160826,9160828,9160832,9160833,9160843,9160873,10417798,9160887,10415842,10418915,9169015,9169020,9161056,10117320,9161157,10419095,10117397,10117398,10117399,10420131,10117430,10117455,10117462,7055441,7055442,10117477,10117483,7055452,10117484,10117486,10117491,8549480,9166328,8549486,9166333,9166393,9166417,10468994,10471010,9166442,9166444,10469043,10469057,10469058,10471066,10471067,10471087,10471136,9166610,8549765,8549829,10469326,8549934,8549956,8550009,10467488,8550073,9182936,10469516,10469517,10469518,10467579,8550177,10467616,8550209,8550224,8550225,8550226,10467734,10469903,9207331,10467936,10467945,10467946,10469960,10469967,10469968,10469969,10463979,9183413,10469990,10469991,10469992,10469993,10470007,10470008,10115665,10470087,9167659,9167662,9167670,9167707,9167738,9167768,9167782,9167783,9167784,9167785,9167786,9167788,9167796,9167797,9167798,9167799,10116203,9168020,10468662,10470664,10470793,10468825,9168282,10888487,10946300,10946315,10946338,10946340,10946343,10946344,10946346,10946351,10946355,10883554,10883558,10883559,10883560,10883565,10946405,10946406,10946407,10946412,10883603,10888680,10888814,10888826,10888840,10946779,10946817,10946818,10946819,10946820,10889134,10889135,10889136,10889140,10889141,10889148,10889167,10884167,10889172,10889180,10889185,10889191,10889201,10889202,10889204,10884212,10889226,10889227,10947054,10947055,10947056,10947058,10884291,10884292,10884296,10947108,10947110,10947111,10947112,10947113,10947114,10947116,10884406,10884462,10884513,10884603,10889618,10884793,10947625,10889815,10884824,10884836,10879870,10889894,10884897,10879912,10879913,10879919,10879920,10889970,10875018,10875019,10875020,10875021,10875026,10875028,10890044,10875064,10875065,10947878,10947879,10947882,10885097,10947910,10947911,10947913,10947931,10947932,10947940,10947950,10890164,10947977,10947978,10890169,10947988,10890198,10948047,10948112,10948114,10890307,10948133,10885398,10885412,10885415,10890431,10948278,10882475,10882488,10945308,10887503,10887508,10882533,10882534,10882547,10882551,10882558,10882579,10882591,10882592,10882594,10882598,10882605,10882606,10945444,7000834,10945460,10945469,10945471,10887665,10887666,10882666,10882668,10882673,10882681,10882686,10945499,10945504,10945521,10945523,10945543,10882733,10882736,10882746,10945573,10945581,10945583,10945588,10945589,10882779,10882785,10882794,10882808,10945623,10882818,10945634,10945635,10882880,10882884,10882905,10882906,10882916,10882921,10887922,10882928,10882932,10882935,10882936,10882941,10887942,10882946,10882947,10882948,10882962,10882970,10882976,10882977,10887980,10882994,10882997,10883000,10883029,10945851,10883042,10883064,10888107,10883123,10883124,10883125,10883145,10946003,10883195,10946007,10883212,10883230,10883238,10888257,10627776,10946103,10946146,10946177,10946178,10946179,10946180,10883419,10946232,10875603,10948433,10948436,10161790,10161794,10161813,10161814,10161817,10161822,10161823,10161838,10162024,10948873,10948874,10162089,10162109,10948949,10948986,10625672,10949005,10625734,10625736,10881488,10881502,10881503,10881504,10881562,10881569,10881573,10876593,10626209,10876798,10876809,10626470,10626471,10626472,10626473,10626484,10626485,10626492,10877048,10877053,10877059,10877062,10877063,10877069,10882239,10882244,10877279,10945115,10877331,10945143,10945151,10877342,10877345,10877354,10877367,10945185,10882400,10882401,10882402,10882403,10882422,10882431,10945252,10945255,10945257,10945259,10945260,10945261,10882451,10882452,10945263,10945264,10882454,10945265,10945267,10882467,10882469,10882470,10420861,10420862,10420863,10420873,10420877,10420878,10420879,10420880,10420881,10420882,10420883) 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'