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(8595056,8595113,8595116,8595191,7201808,7068113,7076128,8836216,7076288,7076291,10103986,8911926,10843797,8628724,8628725,5654537,5654577,5654578,5654579,5654581,7202510,4971081,5654657,8629093,8629095,8629096,8629098,8629099,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629282,8629283,8629284,8629304,8629305,8629306,8629307,8629308,8629309,8629533,8629553,10199825,10199826,8629784,8573336,8629976,7200600,8627122,8627195,8627196,8627197,8627198,4430177,8627199,8627200,8627201,8627202,4430182,8627203,8627204,8627205,4430184,8627206,8627207,8627211,8627213,8627215,8627218,7200847,7200906,7200907,7200908,8627316,8627317,8627358,8627530,7201153,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8627619,8627623,8627629,8627630,8627631,8627632,8627633,8627640,8627641,8627642,8627643,8627644,8627647,8627648,8627649,8627655,8627656,8627663,8627664,8627665,8627666,8627667,8627673,7201274,8627674,8627675,8627676,8627677,8627681,8627687,8627688,8627689,8627690,8627691,8627692,10249769,7201413,7201427,8627828,10842953,8627895,8627897,8627899,8627901,8627905,8627913,8627914,8627915,8627918,8627921,8627928,8627932,10843048,10843049,8908494,7198709,7198710,7198711,7198724,7198781,8625215,8625487,10247571,8625525,10931963,10931964,10208915,10208916,10208917,10208918,10208919,8625907,8625908,8625940,8625941,10209107,8626229,8626230,8626232,8626233,8626318,8626338,8626339,8626345,8626449,8626450,8626451,8626452,8626453,10209555,10209556,10209558,10235628,10235631,10235632,10248675,10248676,10102114,10102115,8626679,4968076,4968077,4968078,8626920,8626921,8626922,8907491,8614349,3234944,3234945,3234946,3234947,3234948,3234949,3234950,3234956,8624423,8624426,10285525,10285526,10285531,10285532,10285533,10246544,8624573,8624575,8624693,8624694,8624699,10205078,10205079,10205080,10205081,8635057,8635058,10231130,7156033,10231202,10231203,3232914,8612408,8905665,8542254,3233426,3233428,3923468,8613073,8613074,7196899,3234107,3234108,3234109,7196952,10838501,10838538,8906887,10284584,10284585,10284586,10284587,10284588,10284589,3234373,10838967,10838971,10838980,3234730,3234732,3234737,3234744,8633017,8633018,8633021,8633022,8633023,8633058,8633067,10229137,10229142,10229143,10229156,3581897,3581901,3581903,8633186,8633190,8633195,8633199,8633203,8633210,10425942,8633224,10425943,8633237,8633250,10426015,10426018,10426019,10848431,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,8633391,10623363,10623364,10623365,8633402,8633409,3582191,10229548,8540353,8540354,8540358,8540359,10229565,10229566,8540398,10229641,8540544,8540564,8540568,8540572,8540573,8540588,8540590,8540592,8540631,8904273,8904285,8633881,8633886,8633892,10229963,8904405,8611260,8634108,8634111,8541004,8611353,3232026,8611455,3232066,3232074,3232075,3232144,3232149,3232176,8634444,8634450,8634451,8634452,8634455,8634460,8634468,3232248,3232250,3232260,3232261,3232263,8634498,8634499,8634511,3232284,8634512,8634513,8634514,8634515,8634516,8634517,8634518,8634519,8634520,8634524,8634525,8634526,8634527,8634528,8634529,8634530,3232303,8634531,8634532,3232305,8634533,10282597,8634534,8634535,8634536,3232312,3232328,3232329,3232330,3232380,8634689,8634690,8634691,8634692,8541578,8541579,8541580,3232553,8634787,3232564,8634851,8634852,8634858,8634859,8634864,8634865,8634871,8634872,10619865,8634912,8575733,8632294,8632295,8632296,8632297,10617343,10617344,10617345,10617346,10617347,10617353,10617354,10617426,10622430,10617452,10617457,10617458,10280605,10280606,10280607,10280608,10280609,10280610,10432519,10425348,10425349,8632642,8632643,10425388,8632744,8632752,8632757,8632762,8632764,10425483,10425518,10425551,10425556,10425567,10425575,10848004,10848005,10848006,8632911,8632912,8632913,8632914,8632915,8632916,8632917,8632918,8632919,8632924,8632925,8632926,8632927,8632928,8632929,8632930,8632931,8632932,8632933,8632934,8632935,8632940,8632941,8632942,8632943,8630015,8630134,10615222,8630309,8630310,8630398,8630403,8630858,8630859,8631031,10616019,10616044,8631073,10616045,8631075,10616060,8631175,3229012,8631271,8631272,8631273,8631274,8631279,8631281,8631283,8631285,8631291,8631292,8631296,8631297,10188377,10616295,10616298,8631340,8631341,8631342,8631343,8631344,8631345,8631400,8631401,8631402,8631403,8631404,8631411,8631436,8631437,8631438,8631439,8631440,8631445,8631449,10616475,8583474,10431606,8631721,8631727,8631728,8631729,8631876,8631879,8631880,8631881,8631884,8631885,8631887,8631888,10616888,10616907,10431899,8853175,8853178,8853179,8853214,10562230,10562231,10565296,10614203,10559498,7059859,9173723,9173724,10614495,10614496,10559706,10559722,10559723,10559724,10559725,10559726,10559744,9173986,6665998,9214037,9214038,9214179,10612136,9187551,9211565,9211566,8862099,9211919,8851764,9196014,8566586,9212322,9196459,9196460,10613157,10613175,10613176,8852344,8852345,8852346,8852347,10613191,10613192,8852356,8852357,8852358,8852359,8852360,8852361,8852362,8567055,8567056,8567057,8567058,8567059,8567060,8567061,10613369,8852542,8852607,10613475,8852772,8852773,8852774,6677258,6677275,6677279,9173112,9173113,9173114,8567682,10613871,10613881,8853057,10513118,10513119,10117525,9161492,8849324,8849325,8849329,8849330,8849331,10515327,10515328,10515329,7055690,6673803,9185613,9185627,9161669,9161670,9161671,9161672,9169748,9185790,9185835,10517670,9185900,9169935,9169939,9169940,10118247,10118248,6674313,6674328,6674329,10118371,10118372,10118373,10118374,10118375,9170191,9170192,6674454,6674455,6674457,6674458,10516142,10118674,8850507,8850508,8850547,9186813,8552226,10512782,10119183,6672521,8848157,10419271,10419307,9176428,9176429,6672658,6672662,6672669,6672673,6672675,6672716,10419438,10419439,6672727,10417445,10419477,10419478,10419479,6672770,6672774,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,6672808,10418562,10418564,10418566,6672867,6672869,6672883,6672893,7054871,9168728,10419671,10419672,10418736,10418737,8848717,8848728,8848734,8848746,8848756,6673145,8848775,6673162,8848782,8848797,8848821,8848828,8848829,8848830,8848831,8848875,6673267,9177085,6673310,9193119,10417061,10417062,10417063,10417064,10417065,10417066,10417097,10417099,10420104,10420105,10417107,10420108,10420109,10420110,10417111,10420117,10417119,10417121,10420125,10420127,10417129,10417150,10417152,10417154,10417156,10417160,9209268,9169275,10420217,10420219,10420220,9190616,6666650,8549957,10469573,9207257,9191268,10467918,10467919,10467920,10467921,10467922,10467923,10467924,10467925,10467926,10463948,10463949,10469949,8847267,8847269,8550662,10470084,9167874,9167879,9167895,9167953,6668125,9168148,9168290,10883569,10883570,10883571,10883629,10883665,10946563,10893759,10893984,10893985,10893986,10893987,10893988,10894115,10884173,10884174,10889451,10155598,10889756,10889757,10894757,10894758,10894759,10894760,10889774,10899909,10890048,10890117,10632163,10632164,10632165,10632310,10883043,10627581,10627775,10888382,10888463,10166756,10166781,10885856,10166875,10166878,10167029,10167030,10167043,10172082,10167111,10167114,10167125,10167126,10167143,10167166,10167167,10167190,10167191,10167192,10886203,10886231,10162249,10886243,10886244,10886268,10886273,10167352,10891365,10626105,10626143,10626144,10626241,10626247,10891789,10891790,10172901,10887096,10887097,10882134,10892167,10892168,10892169,10892170,10892171,10887192,10887193,10887194,10877211,10626725,10887460,10887461,10887462,10626957,10601359,10601360,10643469,10586453,10586454,10586455,10643545,10643546,10643547,10643551,10598631,10598632,10598633,10598719,10590269,10590270,10590272,10590273,10590274,10590275,10590279,10590280,10590297,10644404,10599386,10647543,10647545,10651692,10651693,10651694,10651695,10651696,10579809,10591923,10541443,10539850,10539851,10539852,10539853,10528193,10522414,10522415,10522416,10522420,10522469,10522470,10522471,10522473,10522474,10522475,10538563,10536860,10547077,10547078,10547079,10420221,10420443,10420444,10422597,10421981,10421998,10425036,10425042,10425051,10425056,10507957,10485913,10409437,10409439,10486128,10486129,10486130,10409619,10409620,10407825,10407828,10486567,10407926,10407927,10407928,10407929,10407930,10407931,10407932,10408187,10408188,10410267,10497036,10497064,10410701,10410717,10410718,10410764,10478492,10487516,10406948,10406949) 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'