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(8574021,10447841,11014791,10448031,10870466,10870467,11015152,4970948,4970961,10950381,8631482,8631498,8631499,8631500,8631501,8631502,8621818,10976768,10976769,8067211,7074280,8575565,8575595,10871720,10862878,10862879,10862880,10862881,10844583,8619830,8619999,10872543,8620121,10872588,10872643,8573735,8838055,8573807,8838134,8838135,8838136,8838137,8617722,10999340,7072673,7072674,7072716,8628371,7072815,10867241,7072972,7073055,7073073,7073124,8836716,8628997,8628999,8629000,8629001,8629002,8629003,8629004,8629007,5654712,8629029,8629041,8629056,8629057,8837164,8837165,8619586,8619648,8619649,8909946,10942758,8617011,7071182,7071206,10972156,10972157,8910538,8617378,7071665,7071667,7071668,7071670,7071672,7071674,4430302,8617538,7071781,8617630,8624481,8624482,8614773,7068992,7068993,7068994,7068995,3925493,3925582,8615110,8615111,8615112,8615113,8615114,8615115,7069284,7069285,7069286,7069287,7069288,8615124,7069289,7069290,7069291,7069292,7069293,7069294,10863608,10863609,10944862,10970164,10970182,3925984,10970328,11035400,10970403,10970404,11035529,11035530,11035531,10970746,3926500,8909177,3926512,3926513,8909326,8909327,10942070,8626050,8909581,8909582,8909583,8909584,8909783,8909784,3927134,10918529,10918530,10618044,10618107,10618134,10618135,8906075,10918721,10993764,10993765,10993766,10993767,11045768,10993768,10993769,10993770,11045791,11045792,7156768,10918926,10918927,8906381,3923722,10919633,10919634,10919635,10919636,10919637,10919638,10919639,10919640,10919641,7157769,7157770,10919916,10919917,10982011,7157966,10839276,10969230,10839298,10969231,10839326,8907644,8907645,11044874,11044875,11044877,11044879,11044880,11044881,11044882,11044888,11044889,11044890,11044891,11044901,11044902,11044903,11044904,11018971,8542156,10918358,10918359,10918360,8569860,10920699,10920700,10920701,10920775,10920776,10920777,10920778,10915902,10915903,8576635,8576636,8633198,10921272,10921273,10921351,10921352,10921353,10921354,8576917,9217413,10921425,10848582,8577051,8577052,8577053,8577054,10921629,8577250,10921902,10921903,8577434,8577435,8577752,8577785,3232188,6677555,6677595,6677655,9189490,9915722,3654803,3654808,6677942,6677943,9916112,9190019,9190102,9190103,8853941,6678335,10562951,10562952,9916374,9916375,10122430,10557121,10557122,9171315,9171352,9171353,9203386,9203387,9203388,9187457,10557352,9195564,9195565,9187630,9187631,10557457,9195647,9203682,9203683,9913911,9913912,9195722,9195795,9195796,6676012,6676013,9187815,9187816,9187818,9203844,9195865,9187918,7058130,9188001,9188002,9196080,9204136,9172189,9172190,9172191,9204195,9204196,9204239,9204240,9204241,10120448,10120449,10120450,10120451,9204504,7058698,9196554,7058746,9204599,9204600,9196623,9189088,9189141,7055511,9193403,9193404,9185434,9177546,9193648,8849474,9161681,9193714,9193715,10555551,10555552,10555553,10555554,10555555,10555556,10555557,10555558,10555559,10555560,10555561,10555562,10555563,10555564,8849609,6674084,6674122,9193922,9193923,9193924,9193925,9193926,9193927,9193928,10555841,9194129,9194130,9194131,9194132,9202141,10556029,10556030,10556031,10556032,10556033,10556034,10556035,10556036,10556037,10556038,10556039,10556040,10556041,10556042,10556043,10556044,10556045,10556046,10556047,10556048,10556049,10556050,10556051,10556052,10556053,10556054,10556055,10556056,10556057,9202288,10512143,10514260,10514261,10514262,10514263,10514264,10514265,10514266,10514267,10514268,10514269,10514270,10514271,10514272,10514273,10514274,10514275,10514276,10514277,10514278,9194500,9194501,9202616,9202617,9194640,9194641,9194642,9194733,9202754,9202755,9202756,10556569,9202870,9194894,9194895,9194896,9194897,6675157,6675158,10512794,10512795,10512796,10512808,10512820,10556928,10556929,9195139,9195140,10516966,9171257,9913473,9913474,9195294,8848124,10427699,9200347,9200377,9200480,9200481,9200482,9200483,10416444,10416445,10416446,10416447,8848388,8848389,9176606,9200616,9176651,6680895,6680926,10428105,9200742,9200844,9208997,9208998,8849085,8849087,9201284,8854133,9916568,6678579,8854306,6678726,6666579,6666593,8854485,4971615,10471489,8854838,8550423,10115676,8847392,6679777,6679963,6680081,10124096,10470501,8847776,10124181,10124182,10124183,6680298,6680299,6680300,6680301,10124314,10124356,10124416,10124450,10174488,10174489,10174490,10174506,10164555,10164556,10164557,10164558,10164559,10628068,10174712,10913725,10913726,10913727,10164786,10164787,10174831,10174872,10174874,10179890,10903883,10903884,10908941,10179967,10908972,10909034,10165068,10165069,10165070,10165071,10914077,10914078,10909166,10180197,10180198,10904219,10165232,10904220,10165233,10909235,10909236,10909237,10894319,10909411,10914478,10914479,10914480,10904502,10904503,10904504,10904505,10909542,10165567,10165568,10180606,10180607,10180608,10909637,10909638,10165717,10904735,10899759,10899760,10899761,10899762,10899763,10899764,10899765,10909831,10165894,10180970,10180971,10180972,10914974,10914975,10629542,10181241,10629727,10629728,10629729,10629730,10629731,10629763,10629804,10629814,10629860,10183654,10183655,10183721,10912954,10888027,10888105,10164250,10164251,10164252,10164253,10164254,10164255,10174430,10174436,10174453,10181505,10181506,10181507,10181508,10890783,10890820,10890829,10890830,10890874,10890992,10890993,10890994,10182059,10182060,10906109,10906110,10906111,10906112,10906158,10172211,10172212,10182226,10182227,10167229,10167248,10906248,10182320,10906364,10182387,10896375,10182487,10182640,10182641,10182642,10182750,10182751,10182817,10906818,10626320,10626321,10626322,10626323,10626339,10182999,10183082,10887118,10178194,10178195,10178196,10178197,10178198,10183255,10183333,10907425,10577122,10649196,10649197,10577225,10577226,10577227,10571307,10602189,10602220,10571469,10571470,10577534,10577535,10577536,10577537,10577538,10577539,10577540,10577541,10577542,10577543,10577544,10577545,10577546,10602571,10602572,10602573,10602574,10652947,10652948,10571917,10577920,10577921,10577922,10577923,10574949,10578092,10578093,10575199,10578382,10578383,10578384,10575459,10575460,10575461,10575462,10590463,10590464,10590465,10590477,10590479,10575572,10566615,10566616,10566617,10572624,10572625,10572626,10572627,10572628,10572629,10572630,10572631,10572632,10572633,10578931,10578932,10600067,10579103,10579104,10576200,10576201,10651524,10651525,10651526,10651527,10651528,10570649,10570650,10570651,10601897,10571098,10553247,10553248,10553249,10551304,10521341,10533352,10533353,10535445,10535446,10535447,10535448,10535449,10535450,10535451,10535452,10535453,10535454,10539522,10553601,10553602,10553603,10553604,10553605,10553606,10553607,10553608,10553609,10553610,10539636,10551640,10551641,10551642,10551643,10551644,10527801,10554010,10554011,10554012,10536064,10536065,10536066,10536067,10536068,10536069,10536070,10536071,10536072,10536073,10536074,10536075,10536076,10554272,10534668,10528828,10554839,10554840,10554841,10554842,10554843,10554844,10554845,10540856,10550963,10550964,10550965,10550966,10422176,10493897,10487937,10493939,10488020,10494029,10494141,10494243,10494318,10494344,10494345,8563178,10477913,10478015,10493757,10482781,10482782,10482783,10487860) 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'