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(8068827,8068829,8068831,8068836,8068837,8068842,8068851,8068854,8068874,8068885,8068886,7076011,11001726,7076042,7076057,11001941,11001942,11001943,11001944,7076311,7076324,7076325,11002026,11002027,11002028,11002029,11002030,11002031,11002032,11002033,11002034,7068447,7068448,7068449,11002202,11002203,11002204,11002205,11002206,11002207,11002208,11002209,11002210,11002211,11002212,11002213,11002214,4970752,7068604,4970866,4970867,4970868,4970869,4970870,4970871,4970882,4970883,4970884,4970885,7068677,4970893,4970894,4970902,4970919,4970938,4970944,4970945,8569725,8569726,4970969,4970972,4970974,4970977,4970986,4970987,11002461,11002462,11002463,8569766,8569767,8569768,10963518,11002598,11002599,11002600,11002601,11002602,11002603,11002604,7073989,10933374,7074035,7074065,7074066,7074067,7074068,11002763,11002764,11002765,11002766,11002767,11002768,11002769,11002770,11002771,11002772,11002773,11002774,11002775,7074114,7074156,7074190,8067206,11002917,11003016,7066341,7066342,8067330,10437257,10437258,11003129,7074561,7066570,7066571,7074573,7074599,7066609,7066610,7074617,8067603,8067604,7066634,7074643,7074651,7074663,11003349,11003350,11003351,11003352,11003353,11003354,7074677,8067661,7066689,7066690,8067671,8067672,7066700,7074705,7074706,8067699,7066729,8067720,10437604,10437605,10437624,7074783,7074784,7074785,11003485,11003486,7074806,7074807,7074810,7074813,7074814,7074820,7074838,7074852,7074873,7074900,7074911,7066918,7074942,10961627,7074943,10961628,7074944,10961629,7074945,10961630,7074946,7074947,7074948,7074975,7074991,7074992,7074993,10961752,10961753,10961754,7075131,10961817,7075144,10961855,10961856,10961867,10961884,10961885,10961886,10961887,7067565,7067615,7067913,8068816,7067930,8068823,8065085,7072290,7072291,7072314,7072317,7072327,7072353,7072354,7072355,7072376,7072385,7064387,7064388,7064389,7064390,7072391,7064391,7064392,7064393,7072417,7072418,7072419,7072438,7072439,7072501,7072528,7072546,7072572,7072573,8075332,7072607,10932012,7072668,10932048,7072709,7072758,7072807,4967030,8065817,7072858,7072859,7072902,7072966,10932342,7073033,7073098,7073109,7073125,7073338,10961214,10961296,10961297,10961298,10961299,10961300,10961301,10961302,10961303,10961304,10961305,10961394,10961395,10961396,10961422,10961423,10961424,10961487,10961488,10961489,10961490,10961491,10961492,10961493,10961494,10961495,10961496,10961602,7071156,11049059,7071174,7071196,7071197,7071218,11049137,10942910,10942911,10942916,10942918,10942919,10942920,10942939,11049264,10942992,10942993,10942994,7071412,7071424,7071440,11049344,7071445,7071454,10943086,11049375,10959211,7071530,7071562,7071563,10943303,7071751,7071880,7071881,8071711,3655575,8071776,8071841,10940762,8071906,8071971,8072036,7069331,7069337,10940973,8072101,3655956,8072166,8072231,3656213,3656263,3656264,7069695,7069717,3656337,8072593,8072603,8072613,8072619,8072626,8072636,3656478,3656481,3656593,10941687,10941688,10941689,3656970,10942064,10942067,10942131,10942154,11048519,7070621,10942250,10942253,10942254,10942320,10942321,7070729,8073512,10942419,10942426,7070810,10942435,7070818,10623003,10623016,10623022,10618039,10618065,10923576,10618067,10618070,10618071,10618080,10928595,10618093,10618094,10618095,10928609,10618113,10618130,10918728,10918730,10918746,10923864,10923865,10923866,10923867,10923868,10923869,10923870,10923871,10923872,10618389,10618390,10923941,10923942,10923943,10924028,10924029,10924030,10924109,10924110,10924111,10924112,10924113,10924114,10924115,10924116,10924117,10919184,10919185,10919186,10924221,10924222,10924223,10924250,10924312,10924313,10924314,10924325,10924326,10924327,10924328,10924329,10924330,10924331,10924332,10924333,10924334,10924335,10924336,10924337,10924338,10924339,10924575,10924576,10919818,10919819,10919820,10919821,10919822,8071021,8071022,10924851,10619362,8071078,8071103,8071104,10919946,10919947,10919948,10919949,8071286,8071298,10624614,10624615,8071367,10925170,10925171,8071372,10925177,8071378,10925204,10925205,10925206,10925207,8071406,10925208,10925209,10925210,10925211,10925212,10925213,10925214,8071435,8071456,8071483,8071498,8071503,8071510,10619845,10619846,10619847,10619848,10925372,10925373,10925376,10925377,8071581,8071646,10925456,10953634,10953635,10953636,10953637,10953638,10953639,10953640,10953641,10953642,10953643,10953644,10953645,10953646,10953647,10953648,10953649,10953650,10953651,10953652,10953653,10953654,10953655,10953656,10953657,10953658,10953659,10953660,10953661,10953662,10953663,10953664,10953665,10953666,10953667,10953668,10953669,10953670,10953671,10953672,10953673,10953674,10953675,10953707,10922629,10922685,10922700,10922701,10622192,10922702,10922703,10922704,10922714,10922716,10922753,10922759,10922860,10922889,10922914,10922915,10922916,10922966,10922984,10923023,10923024,10923061,10923080,10923083,10923113,10923114,10928233,10923269,10617794,10923393,10923395,10923470,10925484,10920561,8570045,10615141,10920740,10920741,10921034,10921035,10921036,10930696,10930704,10921331,10620859,10620860,10620861,10615874,10930847,10921470,10616002,10930964,10921556,10921672,7059743,7059788,8864232,7059883,6665779,6665780,8864455,10562899,10562900,6666131,6666132,8864729,8864810,7057496,10612076,7057625,7057626,10557292,7057645,10557293,10557294,10557295,10612177,7057691,8862101,8862102,7057770,10557444,10557445,10609332,10609344,10609345,7057888,10609543,7058194,7058216,7058219,7058220,7058221,7058222,7058231,7058291,10561004,10561005,10561006,7058388,7058684,7058745,10610327,7058859,7058890,7058913,7058914,7058915,7058951,7058952,7059113,7059114,7059127,7059159,7059190,7059286,7059287,7059308,7059309,7059310,7059311,7059364,7059380,7059381,7059382,7059408,7059415,8863775,7059430,7059431,7059432,7059445,7059446,10515112,4974184,4974185,4974186,4974187,4974188,4974189,4974190,9161365,9161366,9161367,9161368,9161369,9161370,9161371,10517226,10517227,10517228,10517229,10513233,10513237,10513241,10555262,10555263,10555264,10555265,10555266,10555267,10555268,10555269,10555270,10555271,10555272,10555273,10555274,10555275,10555276,7055657,10515338,4974457,7055785,9161631,7055901,10517657,10517658,10517659,10517671,10517680,4974772,4974785,4974790,4974798,10555788,10555789,10555790,10555791,10555792,10555793,10555794,10555795,4974839,4974840,4974866,4974888,10555937,10555938,10555939,10555940,10555941,10555942,7057167,10512815,10512832,10512833,10512838,10556990,10517035,10517036,9160312,9160323,4973298,4973299,4973335,4973336,4973337,4973338,4973493,4973582,4973599,7054913,7054914,7054915,7054916,7054917,7054918,7054919,10420063,10420067,10420071,8864829,10471176,10471178,10471179,10471181,10471182,10471183,10471185,10471186,10471188,10471189,10471193,10471196,10471198,10471199,10471201,10471203,10471204,10471207,10471208,10471223,10471226,10471229,10471235,10471237,10471239,10471241,10471243,8865205,8916410,10469483,10469491,10471495,10471504,8916767,6667205,10467927,10467936,10467938,6667437,8563386,8563387,8563392,10470092,10470119,10470122,10470126,10470127,10470130,10470131,10470132,10470134,10470135,8917342,10470283,10470319,6667801,10470383,10470488,8917915,10628042,10628066,10629693,10629703,10629704,10629706,10629707,10629708,10629748,10629892,10629893,10629894,10629895,10629896,10629897,10629918,10626986,10153839,10153840,10627568,10627788,10627836,10627837,10627846,10627847,10627925,10627932,10627933,10627949,10629998,10630146,10630297,10630315,10630316,10630328,10630329,10630330,10630331,10630332,10630333,10630334,10630335,10630336,10630337,10630338,10630339,10630372,10630462,10630463,10630490,10630491,10630492,10630493,10630494,10630495,10630506,10630507,10630508,10630509,10630510,10630595,10630664,10630676,10630677,10630678,10630679,10630680,10630681,10630860,10630945,10630960,10630962,10631019,10631020,10631047,10631048,10631049,10626120,10626295,10626517,10626518,10626519,10626520,10626521,10626522,10626523,10626529,10626535,10626549,10571278,10571279,10571280,10571281,10571282,10574426,10574427,10574428,10574585,10574586,10574587,10574588,10568886,10568887,10568888,10568889,10568993,10568994,10568995,10568996,10572404,10572405,10572406,10572407,10572408,10572409,10572410,10572411,10572412,10569484,10569485,10569486,10570238,10570411,10570412,10570413,10570414,10570415,10570416,10570417,10570418,10570419,10570420,10570421,10570422,10570423,10570424,10570425,10570426,10521195,10521413,10521414,10521415,10521416,10521417,10522514,10522659,10524726,10524727,10524728,10524729,10422279,10421582,10422601,10422627,10422781,10422889,10422898,10422934,10422942,10422006,10422010,10422029,10422069,10422123,10477109,10477802,10476425) 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'