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(8631143,3228944,3228945,7065918,7065919,7065920,8583435,8583436,7201635,8595044,8595045,8595046,8595047,8595048,8595049,8595050,8595051,8595052,8595053,8595054,8595059,5654563,5654564,5654565,5654566,5654567,5654568,5654569,5654570,5654572,9794571,9794572,8627447,10855103,10855104,10855105,10855106,10855107,10855108,10855109,10855110,10855111,10855112,10855113,10855114,10855115,10855116,10855117,10855118,10855119,10855120,10855121,10855122,10855123,10855124,10855125,10855126,7198698,7198702,7198704,7198710,10855898,10101457,10101458,10101459,10101460,10101461,10101462,10101463,10101464,10101465,10101466,8860324,3923398,3923399,3923400,3923401,3923402,3923423,7197246,7197247,7197248,7197249,7197250,7197251,7197252,7197253,7197254,7197255,7197256,7197257,7197258,7197259,7197260,7197261,7197262,7197263,7197264,7197265,7197266,7197267,7197268,7197269,7197270,7197271,7197272,7197273,7197274,7197275,7197276,7197277,7197278,7197279,7197280,7197281,7197282,7197283,7197284,7197285,7197286,7197287,10854362,10854363,10854366,10854409,10854410,10854411,10854412,10854413,10854414,10854415,10854416,10854417,10854418,10854419,10854420,10854421,10854422,10854423,10854424,10854425,10854426,10854427,10854428,10854429,10854430,10854431,10854432,10854433,10854434,10854435,10854436,10854437,10854438,10854439,10854440,10854441,10854442,10854443,10854444,10854445,10854446,10854447,10854448,10854449,10854450,10854451,10854452,10854453,10854454,10854455,10854456,10854457,10854458,10854459,10854460,10854461,10854462,10854463,10854464,10854465,10854466,10854467,10854468,10854469,10854470,10854471,10854472,10854473,10854474,10854475,10854476,7197434,10854477,10854478,10854479,7197437,10854480,10854481,10854482,10854483,10854484,10854485,10854486,10854487,10854488,10854489,10854490,10854491,10854492,10854493,10854494,10854495,10854496,10854497,10854498,10854499,10854500,10854501,10854502,10854503,10854504,10854505,10854506,10854507,10854508,10854509,10854510,10854511,10854512,10854513,10854514,10854515,10854516,10854517,10854518,10854519,10854520,10854521,10854522,10854523,10854524,10854525,10854526,10854527,10854528,10854529,10854530,10854531,10854532,10854533,10854534,10854535,10854536,10854537,10854538,10854539,10854540,10854541,10854542,10854543,10854544,10854545,10854546,10854547,10854548,10854549,10854550,10854551,10854552,10854553,10854554,10854555,10854556,10854557,10854558,10854559,10854560,10854561,10854562,10854563,10854564,10854565,10854566,10854567,10854568,10854569,10854570,10854571,10854572,10854573,10854574,10854575,10854576,10854577,10854578,10854579,10854580,10854581,10854582,10854583,10854584,10854585,10854586,10854587,10854588,10854589,10854590,10854591,10854592,10854593,10854594,10854595,10854596,10854597,10854598,10854599,10854600,10854601,10854602,10854603,10854604,10854605,10854606,10854607,10854608,10854609,10854610,8904984,8904985,8904986,8904987,8904988,8904989,8904990,8904991,8904992,8904993,8904994,8904995,8904996,8904997,8904998,8904999,8905000,8905001,8905002,8905003,8905004,8905005,8905006,8905007,8905008,8905009,8905010,8905011,8905012,8905013,8905066,8905201,8905202,8905203,10622363,10615049,10615050,10615051,10615571,8633275,8540594,8611289,8611290,8611291,7155242,10714111,10714112,10714113,10714137,10614730,10614731,10609407,10609846,10609847,10609848,10609849,10609850,10609851,10609852,10609853,10609854,10609855,10609856,10609857,10609858,10609859,10609860,10609861,10609862,10609863,10609864,10609865,10609866,10609867,10609868,10609869,10609870,10609871,10609872,10609873,10609874,10609875,10609876,10609877,10609878,10609879,10609880,10609881,10609882,10609883,10609884,10609885,10609886,10609887,10609888,10609889,10609890,10609891,10609892,10609893,10609894,10609895,10609896,10609897,10609898,10609899,10609900,10609901,10609902,10609903,10609904,10609905,10609906,10609907,10609908,10609909,10609910,10609911,10609912,10609913,10609914,10609915,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,10609944,10609945,10609946,10609947,10609948,10609949,10609950,10609951,10609952,10609953,10609954,10609955,10609956,10609957,10609958,10609959,10609960,10609961,10609962,10609963,10609964,10609965,10609966,10609967,10609968,10609969,10609970,10609971,10612973,10610127,10610128,10610129,10610130,10610131,10610132,10610133,10610274,10610691,10610692,10610693,10610694,10117496,10117497,10117498,10117499,10117500,10117501,10117502,10117503,10117504,10117505,10117506,10117507,10117508,10117509,10117510,10117511,10117512,10117513,10117514,10117541,9169351,9169352,6673559,6673560,10117610,9911808,9911809,9911810,9911811,9911812,9911813,9911814,9911815,9911816,9911817,9911818,9911819,9911820,9911821,9911822,9911823,9911824,9911825,9911826,9911827,9911828,9911829,9911830,9911831,9911832,9911833,9911834,9911835,9911836,9911837,9911838,9911839,9911840,9911841,9911842,9911843,9911844,9911885,9911886,9911887,9911888,9911889,9911890,9911891,9911892,9912012,9912013,9912014,9912015,9912016,9912017,9912018,9912019,9912020,8850105,8850106,8850107,8850108,8850109,8850110,8850111,8850122,8850123,8850124,8552174,10417293,10417294,10417295,6672601,6672602,6672603,6672604,6672605,6672606,6672607,6672608,6672609,6672610,6672659,6672660,10419407,10419408,9169287,10117494,10117495,8549936,8549937,8549938,8549939,8549940,8549941,8549942,8549943,8549944,8549945,8549946,8549947,8549948,8549949,8549950,8549951,8549952,8550123,8550124,10467604,10467605,10467606,10467607,10467608,10467609,10467610,10467611,10467612,10467613,10467614,10467615,10467616,10467617,10467618,10467619,10467620,10467621,10467622,10467623,10467624,10467625,10467626,10467627,10467628,10467629,10467630,10467631,10467772,10467773,10469900,10467951,976431,976432,976433,976434,976436,9167831,9167832,9167833,9167834,9167835,9167836,9167837,9167838,9167839,9167840,9167841,9167842,9167843,9167844,9167845,9167846,9167847,9167848,9167849,9167850,9167851,9167852,9167853,9167854,9167855,9167856,9167857,9167905,9168019,9168020,10883677,10883678,10883679,10884529,10889983,10885018,10887662,10887663,10887664,10887665,10887666,10882901,10882902,10882903,10882904,10882905,10882906,10882907,10882908,10882909,10882910,10882911,10882912,10882913,10882914,10882915,10882916,10882917,10882918,10882919,10882920,10882921,10882922,10882923,10882924,10882925,10882926,10882927,10882928,10882929,10882930,10882931,10882932,10882933,10882934,10882935,10882936,10882937,10882938,10882939,10882940,10882941,10882942,10882943,10882944,10882945,10882946,10882947,10882948,10882949,10882950,10882951,10882952,10882953,10882954,10882955,10882956,10882957,10882958,10882959,10882960,10882961,10882962,10882963,10882964,10882965,10882966,10882967,10882968,10882969,10882970,10882971,10882972,10882973,10882974,10882975,10882976,10882977,10882978,10882979,10882980,10882981,10882982,10882983,10882984,10882985,10882986,10882987,10882988,10882989,10882990,10882991,10882992,10882993,10882994,10882995,10882996,10882997,10882998,10882999,10883000,10883001,10883002,10883003,10883004,10883005,10883006,10883007,10883008,10883009,10883010,10883011,10883012,10883013,10883014,10883015,10883016,10883017,10883018,10883019,10883020,10883021,10883022,10883023,10883024,10883025,10883026,10883027,10883028,10883222,10883223,10883224,10883225,10883226,10883227,10883228,10883229,10888446,10161820,10161821,10161822,10161823,10161824,10161825,10161826,10161827,10161828,10161829,10161830,10161831,10161832,10161833,10161836,10877068,10647349,10647350,10647351,10647352,10647353,10647354,10647366,10507663,10507664,10507665,10410097,10410134,10410135,10410136,10410137,10410138,10410139,10410140,10410141,10410142,10410143,10410144,10410145,10410146,10410147,10410148,10410149,10410150,10410151,10410152,10410153,10410154,10410155,10410156,10410157,10410158,10410159,10410160,10410161,10410162,10410163,10410164,10410165,10410166,10410167,10410168,10410169,10410170,10410171,10410172,10410173,10410174,10410175,10410176,10410177,10410178,10410179,10410180,10410181,10410182,10410183,10410184,10410185,10410186,10410187,10410188,10410189,10410190,10410191,10410192,10410193,10410194,10410195,10410196,10410197,10410198,10410199,10410200,10410201,10410202,10410203,10410204,10410205,10410206,10410207,10410208,10410209,10410210,10410211,10410212,10410213,10410214,10410215,10410216,10410217,10410218,10410219,10410305,10410306,10410307,10410308,10410309,10410310,10410311,10410312,10410313,10410314,10410315,10410316,10410317,10410318,10410319,10410320,10410321,10410322,10410323,10410324,10410325,10410326,10410327,10410328) 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'