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(11001836,11001837,10845998,11001957,11001958,11001959,11001960,11001961,11002000,10448313,11002141,11002142,11002432,11015508,11002567,11002568,11002569,8621764,8066953,7074010,11002723,11002724,11002725,7074085,7074148,11002886,11002887,11002888,11002889,11002890,11003001,11016023,11016056,11016057,11016058,11016059,11016060,11016061,11016062,11016063,11016064,11003089,8583879,8067509,11003283,8584082,11003324,11003325,11029371,11029372,11029373,11029374,11029375,11029376,11029377,11029378,11029379,11029380,11029381,11029382,11029383,11029384,11029385,11029386,11029387,11003440,11003441,11003442,11003443,11003444,11003575,11003576,11003577,11003578,8619851,8619883,10961736,10961737,8619956,11026850,11026852,11026853,11026854,11026855,11026856,11026857,11026858,11026859,11026860,11026861,11026862,11026863,11026864,11026865,11026866,11026867,11026868,11026869,11026870,11013882,11013883,11013884,8620047,10929597,8837835,11040150,11014187,8838024,8838025,8838026,8838027,8838028,7067541,7067542,8838112,11001410,11001411,11001412,8627707,8627710,8627712,7072186,8835829,8911465,10973186,7072593,7201844,8595296,7072701,7072793,7202167,7202189,7072958,7202221,7202222,7202233,7202247,7202256,7202280,7202283,7202291,7202294,11012860,11012861,11012862,11012863,8836676,8836679,8595846,8595853,8595854,5654618,8596048,10961278,10961279,8837095,8837096,8837097,8619488,8619489,8619559,11013446,10961455,8619623,8619658,8837353,10997781,10997874,8617056,8834744,8617118,8617189,8617190,8627010,8617250,8627089,8627090,8910509,8627107,8627120,8617346,11024214,11024216,11024217,11024218,11024219,11024220,11024221,11024222,11024223,11024224,11024225,11024226,11024227,11024228,11024229,11024230,11024231,11024232,11024233,11024234,11024235,11024236,11024237,11024238,11024239,11024240,8617437,10985316,10985317,10985318,10985319,7071693,8617534,4430389,7071803,4430429,11034650,11034651,11034652,8624700,8624701,7198352,3925545,3925546,3925657,3925734,3925774,3925865,11035207,8615377,11022442,11022443,11022444,11035464,8625520,8625521,8625522,8625523,8625524,8615740,8625628,8625629,8625630,11035705,10996762,3926474,8909163,8909164,8909235,8909236,8909237,11022869,11022870,11022871,11022872,11022873,11022874,11022875,8625932,8625933,8625934,8625935,10997172,10997173,10971186,10971187,10971195,11023238,7070624,8909730,8909731,10997365,10997415,10997416,10997417,8909890,8626522,8626532,8626533,8626534,11023613,11023614,10918488,10918489,8906045,7156573,7156574,10618086,8906148,8906149,8906150,11019852,7156719,7156720,7156721,3923582,10918737,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,8906319,7156858,11033065,11033066,11033067,11033068,11020144,10919214,10919215,10919216,10919217,10919218,10919219,10919220,11033426,11033427,10994532,10994539,11033562,11020577,11020578,11020579,11020580,11020581,11020582,11020583,11020584,11033584,11020585,11020586,11020587,11020588,11020589,10919511,10919512,7157531,7157532,7197239,11033691,11033692,11033693,11033694,11033695,11033696,11033697,10994756,10994757,10994805,7157695,7157696,7157697,10994952,7157902,7157903,11008048,10919909,11034137,11034138,11034139,11034140,11034141,11034142,11034143,11034144,11034145,11034146,11034147,10920000,10920001,10920002,7158080,11034373,11034374,11021477,11021478,11021479,11021480,11021481,11021482,11021483,11021484,8541457,8541459,8541470,8541471,11005674,11018694,11018695,11005714,8634731,8634775,8634776,8634777,8634779,8634781,8634783,8634786,8634787,8634790,8634791,8634792,10917710,10917711,8634845,11031945,11031946,11031947,11031948,11031949,11031950,11031951,11031952,11005989,8541923,10918001,10918002,11006160,11006161,10918125,10918126,10918127,10918128,10918129,10918130,8905664,8542155,8905712,11019403,11019404,10918286,10918287,10918288,8632586,8632587,8632637,8632638,8632639,8570280,10920856,10920857,10920858,10920859,11004039,11004040,8576551,8576552,8576553,10920966,10920967,10620488,11004161,10921044,10921045,10921046,10921047,10921048,10921049,10921050,10921051,10921052,10921053,8633189,11004265,8576758,8576759,10921241,10921242,10921243,10921244,10921245,10921246,10921247,8577008,10921397,10921568,11004733,8577226,11004734,11004735,11004736,10921621,10426466,8577291,11030839,11030840,11030841,11030842,11030843,11030844,10921698,8577358,8577359,8577360,10921736,11005156,11005157,11005158,11005159,11005160,11005161,10917032,8577674,10917033,11031187,8577708,11031417,11031419,11031420,11031421,11031422,11031423,11005513,11005514,11005515,8611706,8634572,6677541,6677812,6677813,10559471,10559472,10559473,10559474,10559475,9189687,8853617,8864457,10614634,10614636,9189990,6678235,9190048,10611714,10562872,8853888,8853889,9190077,10562910,10562911,10562912,10562913,10562914,10562915,9190150,9190183,9190185,10614862,8854073,8854074,8854075,9171321,9171338,8542599,9203447,9203448,9203449,9203450,9203451,9203452,9187597,9187777,9203778,9187778,9187779,9187972,10612677,9196024,9188083,9204102,10609816,8566791,8566803,10609976,9204452,7058691,9204529,9204655,9204656,9204657,10613384,10613386,10613488,10613551,10613569,8852736,10613613,10613665,10613669,10613671,10613674,4974152,9185330,9169435,9201522,9201523,9201524,10555356,10555357,10555358,8849446,9193661,9193699,8849559,8849560,9201815,9201816,9193867,9193868,7023567,9201970,10555808,10555809,10555810,10118213,9202048,9202049,9194056,9194057,9194058,9202113,10555954,9202215,9194315,9202399,9202400,9194458,9202540,9202541,9202542,9194569,9202720,9186780,9194806,9194807,9194808,9194809,9194810,9194811,9202826,10512789,10512790,10512791,10512802,10512822,10512823,10512824,10512825,10512826,10512827,10512828,10512829,9195051,9195077,9195078,9171145,9171224,9195242,9195243,9195244,9171283,6675491,6675492,10419272,10419274,10419275,10419276,10419278,10419279,10419280,10419281,10419282,10419284,10419293,10419294,10419299,10418316,10415320,10415322,10415326,10418330,10418331,10419339,10419340,10419341,9200433,10419370,10415381,6680672,10417394,10417396,10417398,10417402,10417406,10417410,10417413,10417415,10417417,10417420,10417422,6680722,6680756,9200599,9200600,10419539,6680824,10419540,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419555,10419557,9200695,9200822,9200894,9168924,9168925,6673209,10420064,4974151,6678693,10122743,6678786,10469163,9182618,9206719,10471490,10471493,10471494,10467607,10123432,10123433,6679537,6680013,10462400,6680116,6680149,6680150,6680151,9175955,9175956,10124206,10124237,10470667,10124302,10124387,8593548,10174738,10174739,10179805,10179806,10179807,10174813,10174854,10174855,10883846,10883847,10883862,10174876,10179879,10883915,10179927,10180045,10180046,10180047,8594121,10180455,10180456,10180457,10884715,10894790,10180877,10180878,10166160,10166161,10166162,10181167,10181168,10181428,10181429,10183494,10882624,10882912,10882985,10888163,7001395,7001396,7001397,10179419,10885558,10630053,10630101,10181662,10181663,10181664,10885872,10182002,10182171,10182172,10162190,10182342,10177416,10177440,10182460,10182567,10182568,10182569,10162597,10177614,10177615,10177616,10177617,10177618,10177619,10177620,10177621,10177622,10177623,10177624,10177625,10177626,10187745,10182769,10182770,10187780,10183300,10183413,10183452,10183467,10577366,10577367,10577368,10571383,10643564,10568574,10568575,10568576,10568577,10568578,10568579,10568580,10568581,10574589,10574590,10574591,10574592,10571651,10580683,10571729,10571730,10571731,10574734,10574735,10574736,10574737,10577822,10577823,10577824,10577825,10574832,10574856,10574857,10574858,10574859,10574860,10568892,10649971,10649972,10649973,10653067,10575114,10575115,10575116,10575117,10575118,10575119,10578242,10578243,10572362,10572363,10575399,10575400,10647534,10578965,10578966,10578967,10579012,10573216,10573217,10579420,10570466,10570467,10573497,10573498,10573499,10573500,10573501,10573502,10573503,10573504,10573505,10573506,10573507,10576615,10576616,10576617,10576618,10576619,10576620,10576621,10576622,10576623,10576624,10576625,10576626,10576627,10576628,10576629,10576630,10576631,10576632,10576633,10576634,10576635,10576636,10576637,10648833,10648834,10535279,10535280,10535281,10535282,10535283,10535862,10535863,10536388,10536389,10536390,10522398,10534610,10534611,10536627,10536628,10536641,10540791,10540792,10534833,10534834,10534835,10534836,10534837,10548895,10423597,10423606,10422686,10422687,10422688,10422689,10422692,10422695,10422698,10422699,10423084,10425090,10425091,10425093,10423105,10421206,10487911,10493922,10487990,10494105,10409455,10409478,10409483,10409492,10483189,10481200,10481432,10481433,10409958,10410059,10496914,10481991,10497212,10497231,10497314,10493403,10493713,10493831) 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'