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(10861382,10861383,10861384,10861385,10861386,10848645,10848646,3228942,3229019,10862001,10862013,3229177,3229178,3229182,7065968,10950703,7066129,10849624,10862793,10862794,10849966,10850034,8609600,10844713,10860499,10860509,10939174,7201259,8628008,8628009,8628010,10858811,7201774,7201779,8595187,7201796,7201800,7201801,8595199,7201829,7201830,7202049,7202445,7202447,7202448,7202450,7202451,7202454,7202456,7202459,7202461,7202464,7202466,7202469,7202472,7202473,7202475,7202477,7202479,7202482,7202485,7202487,7202489,7202491,7202494,7202496,7202498,7202500,7202502,7202504,7202506,7202508,7202510,7202511,7202513,7202515,7202516,7202519,7202521,7202523,7202532,7202534,7202536,7202538,7202540,7202541,7202543,7202545,7202546,7202548,7202549,7202550,7202551,7202554,7202555,7202557,7202558,7202560,7202561,7202563,7202564,7202565,7202567,7202569,7202570,7202572,7202573,7202576,10859667,10859668,10859670,10859672,10859922,10859923,10859924,10859925,10859926,10859927,10859928,10859929,10859930,10859931,10859932,10859933,10859934,10859935,10859936,10859938,10859940,10859941,10859942,10859943,10859945,10859947,10859948,10859949,10859950,10859951,10859952,10859953,10859954,10859955,10859956,10859957,10859958,10859959,10859960,10859961,10859962,10859963,10859964,10859965,10859966,10859967,10859968,10867999,10865305,8626729,8626730,10865393,10865394,10865395,10865396,10865397,10865398,10865399,10865440,3927606,7071260,7071261,7071262,10865574,10865576,10865579,10865584,10865588,10865593,10865596,10865602,10865605,10865607,10865609,10865611,10865613,10865615,10865617,10865619,10865620,10865622,10865629,7200625,7200627,7200628,7200629,7200690,4430162,7200985,10863114,10863115,10855515,10863714,10863722,10863730,10863748,10863758,10863759,10863761,8556480,10864087,10856309,10856567,8860267,8860268,8557335,10856745,8860423,8834123,10864935,10864936,10864937,10864938,10864957,10864958,7196239,10623311,10623400,8554336,8906594,8906595,10854088,7197840,7197851,10854940,8614498,10854964,10854980,10854981,10854986,10619854,10619872,10619874,10617027,8611750,8611751,10617108,10852315,10852316,10852317,10852318,10852337,10852338,10852339,10852530,10852531,10852532,10852533,10852536,10852537,10852540,10617472,3232882,3232883,8905837,10615001,8569932,10615477,10615483,10615949,10615960,10616025,10426298,10426450,8904326,10614444,6669998,10614566,10614647,10614648,3655289,6666257,10612207,10612208,10612209,10612210,10612211,10612212,10612213,10612259,7017447,7017448,7017449,7017450,7017451,7017452,7017483,7017484,7017485,7017486,7017487,7017488,10612529,10612604,8851923,8851935,8851936,10612833,10612867,10613009,10613010,10613092,10613093,10613094,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,9172535,8852546,8852835,8852836,8852853,8852876,7055495,9169352,9169401,9169468,10117723,9911836,9911837,10117889,9169698,10118027,10118038,10118052,10118088,10118092,9912111,10118190,9912330,10118357,10118358,10118374,10118375,10118494,10118500,10118501,10118502,10118638,10118639,10118951,10118952,10417222,10417223,10417225,10418229,10418230,10418231,10418250,10418251,10415333,10416356,10416357,10418613,10416663,10416664,10418693,10418694,10418695,10418696,10418697,10418698,10418699,10418732,10415782,8848708,10418807,10418809,10418812,10418824,10418830,10418833,10418835,10418837,10418839,10418841,10418843,10418845,10418847,10418849,10418851,10418853,10418859,9168985,9168986,10117418,10417181,10417189,10417197,10417212,10462907,10462908,10462909,8916865,8916866,10115644,10466249,10466250,10466251,9167818,10468501,10468515,10470645,10470646,9168119,10470726,10470727,10470728,10470731,10470732,7013885,7013886,7013887,7013888,7013889,7013890,7013927,7013928,7013929,7013930,7013931,7013932,10628312,10628313,10628314,10628316,10628320,10884300,10889782,10889783,10889784,10889785,10889786,10889787,10885371,10883005,10631412,10631414,10631416,10631419,10631420,10631423,10631425,10631428,10631431,10631433,10631435,10631438,10631439,10631441,10631443,10631444,10631446,10631448,10626450,10631451,10631794,10173359,10602351,10602352,10602775,10604396,10607410,10604549,10604555,10604560,10604561,10604579,10604658,10528382,10528383,10550644,10550645,10550646,10550647,10550663,10550664,10550665,10550666,10550667,10550668,10550685,10420647,10413360,10411385,10407437,10407469,10411586,10409648,10411662,10409887,10414097,10414098,10414100,10414101,10414102,10414318,10414319,10414320,10414321,10414322,10414323,10414324,10414325,10414326,10414327,10414328,10414329,10414330,10414331,10414333,10414335,10414336,10414337,10414338,10414339,10414340,10414341,10414342,10414343,10414344,10414345,10414346,10414348,10414349,10414350,10414351,10414352,10414353,10414354,10414355,10414356,10414357,10414358,10414359,10414360,10414361,10414362,10414363,10414364,10410681,10414780,10414790,10408868,10408869,10408870,10408871,10406906,10406907,10408994,10408995,10408996,10408997,10409000,10409001,10409003,10407183,10407184,10407185) 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'