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(10447728,7067874,7067875,7067876,7067877,7067878,7067879,7067880,7067881,7067882,7067883,7067884,7067885,10447774,10447785,10962691,11001778,10939888,4970736,4970738,8569453,10448384,10963260,8569609,8569638,10950485,7066011,10963726,10963857,11041857,11041858,7066177,10963862,11042092,8622308,8622309,7074527,8575733,8575734,8575735,8575736,8575737,10951186,8575738,8575739,8575740,8575741,8575742,8575743,8575744,8575745,8575746,8575747,8575748,8575749,8575750,10964435,8609601,7074905,10962048,10962049,7075388,7075389,7075390,7075391,10962081,11001141,7075489,7075519,7075522,7075525,7075534,7075552,7075568,7075571,7075579,7067583,7075590,7075609,7075610,7075611,7075612,7075613,7075614,7075615,7075618,7075619,7075623,7075626,7075627,7075628,7075635,7075645,7075719,7075720,7067789,7067793,8835323,8835324,8835345,10103007,10103014,10103016,10103265,10103351,10103445,10960010,10960011,10999093,8836307,8618687,10104019,10104020,10104021,10104043,10104044,10104045,8836416,8618846,10960964,8572478,8572479,11000012,7073419,8572971,11036539,11036540,10102017,10102018,10102036,10102042,11036618,11036619,11010657,10102102,11010658,10102103,11010659,11010660,11010661,11010662,11010663,11010695,11010696,8910081,10942754,8910130,8910131,8910132,8910133,10997779,7071538,10943255,10943256,7071544,7071545,7071546,7071550,7071551,7071556,10998387,10102862,8615174,8615190,7069493,7069593,11009280,8615675,8615676,8615680,10996686,10996687,10996688,10996689,10996690,10996701,8564730,8564731,8564732,8909090,8909091,8564865,11035977,11035978,10101479,11010035,10101516,8565097,8565098,7070394,7070395,10101554,10958283,8969921,10101774,10101775,10101776,10101777,10101778,10101779,10101780,10101782,10101783,10623065,8579129,8579130,8612807,8612808,8612851,10967779,10967780,11045905,8070117,10968010,10968011,10968014,10968015,10968016,10968017,10968018,10623490,8613365,10968298,10994302,11046525,8070808,8070809,8070810,8070886,10619239,8071198,11008233,10624729,10624730,10624802,10624804,11047372,10619835,10619836,10619864,10619865,10619866,10619872,10619873,10619875,10619879,10619922,8614613,10966674,10966675,10966676,10622188,8611885,10617329,10953951,10617448,10954177,10622692,10954312,10954390,10619980,10619981,10951557,10615090,10925635,10925636,10620183,10620207,8570038,8570134,10951817,10951818,8570168,10951819,10620444,10620465,10952049,8570399,10620595,10615597,10615598,10620603,10620604,10965470,8610665,10965542,11004634,10952605,10616573,10616575,10621774,10621783,10616794,10616795,10559332,10559333,10559334,10611193,10611194,9189537,9189538,9165539,9189539,9189540,9189541,9189542,9189543,9189544,9189545,9189546,9189547,9189548,9189549,9189550,9189551,9189552,9189553,9189554,9189555,9189556,9189557,9189558,9189559,9189560,10611226,10614238,10611242,10611245,10611251,9189615,9189616,9189617,9189664,9173757,10614532,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10559709,10559710,10559711,10559712,6665931,6665932,10559748,10559749,10562767,10611696,10562858,10562867,6666064,6666069,6666070,6666071,6666077,10614744,6666082,6666097,6666098,6666099,6666100,10611821,9190230,9190231,9187306,7057713,7057714,7057715,7057767,7057789,10609309,10612322,10612323,10612325,10609330,10609360,9171799,9211923,9211948,10609714,10609717,9196182,10609988,10558141,10610005,10610012,10613036,10558302,10610333,9196741,10613475,10613547,10613548,10610564,9173110,9197129,9169355,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10515316,10513400,10513401,10513404,7055921,7055961,10517651,10517652,10517653,7056009,9161898,7056097,9169959,7056200,10513970,10513971,10513972,10513973,10512180,10512181,10512182,10512183,10512184,10512185,10512186,10512187,10512188,10512189,10512190,10516568,10516569,10516570,10516571,10516572,10516573,10516574,10516575,9170866,9170892,10514830,10514831,9171038,9171064,10516928,10516930,10516931,10516932,10516934,10516935,10516936,10516937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516946,10516947,10516948,10516949,10516950,10516951,10516952,10516953,10516954,10516955,10513047,10513048,10513049,10513050,10513051,10513052,10513053,4973244,10416534,10416535,10416537,10416538,10416539,10416543,10416544,7054979,9168847,9168872,9193176,9193195,10418156,10418157,10418158,10418159,10418160,10418161,9169279,9182422,6666859,6666861,6667035,6667038,9191104,8550404,8916934,8916935,6667288,6667289,6667299,9207304,9207331,9175497,9175498,9175499,8550655,9207564,8550786,8550797,8550812,9207826,9176087,9176090,6668090,9176092,9176093,9176098,9176102,9176103,9176104,9176105,9176106,9176107,9176108,10628152,10174822,10174938,10174940,10628430,10628826,10628827,10628828,10629119,10629149,10880208,10627002,7000887,7000888,7000890,7000891,10627332,10627410,10627411,10627412,10627413,10627414,10627415,7001145,10174093,10627590,10627663,7001366,10630022,10630100,10630101,10630102,10630103,10630104,10630105,10875924,10172067,10630672,10630673,10630674,10162218,10172288,10625800,10626111,10631312,10626445,10188062,10163106,10188106,10163107,10163108,10163109,10163110,10163111,10626731,10163320,10163321,10163322,10631885,10626951,10626952,10626953,10626954,10626955,10626956,10626957,10626958,10626959,10586133,10598534,10598565,10598566,10598567,10598568,10598569,10598570,10598571,10598574,10598575,10598576,10598577,10598578,10598579,10598580,10598581,10598582,10598583,10598584,10598586,10598587,10598588,10598590,10598591,10598592,10598593,10598594,10598595,10598596,10598597,10598598,10598599,10598600,10598601,10598602,10598604,10598605,10598606,10598607,10598608,10598609,10598610,10598611,10598613,10598614,10598620,10598623,10598626,10598627,10598628,10598629,10598630,10598631,10598632,10598633,10598634,10598635,10598636,10598637,10598638,10598639,10598640,10598641,10598642,10598643,10598644,10598645,10598646,10598647,10598648,10598649,10598650,10598651,10598652,10598653,10598654,10598655,10598656,10598657,10598658,10598659,10598660,10598661,10598662,10598664,10598667,10598668,10598670,10598671,10598673,10598674,10598675,10598676,10598677,10598678,10598679,10598680,10598681,10598682,10598683,10598684,10598685,10598686,10598687,10598688,10598689,10598690,10598691,10598692,10598693,10598694,10598695,10598696,10598697,10598698,10598699,10598700,10598701,10598702,10598703,10598704,10598705,10598707,10598708,10598710,10598711,10598712,10598713,10598715,10598716,10598717,10598718,10598719,10598720,10598721,10598722,10598723,10598724,10598725,10598726,10598727,10598728,10598729,10598731,10598732,10598733,10598734,10598735,10598736,10598738,10598739,10598740,10598741,10598742,10598743,10598744,10598745,10598746,10598747,10598748,10598749,10598751,10598752,10598753,10598754,10598756,10598757,10598758,10598759,10598760,10598761,10598762,10598763,10598764,10598767,10568936,10568937,10566125,10566126,10566127,10566128,10566129,10566131,10566153,10590278,10590679,10591108,10591109,10591110,10591111,10591112,10591113,10591114,10591115,10591116,10591117,10591118,10591119,10591120,10582890,10582891,10577085,10529327,10529328,10529329,10529330,10529331,10529332,10529333,10527388,10527389,10527534,10527535,10527536,10527537,10527538,10527539,10527540,10527541,10527542,10527543,10525567,10521596,10521597,10529728,10521871,10521872,10521873,10528103,10528218,10528262,10528263,10528264,10528265,10528266,10534364,10522404,10528527,10528528,10528529,10528530,10528531,10528578,10528579,10528580,10528581,10528582,10528583,10528584,10528585,10528586,10528587,10538759,10538760,10538761,10538762,10538763,10538764,10538765,10538766,10538767,10538768,10538769,10538770,10538771,10538772,10538773,10538774,10538775,10538776,10538777,10538778,10538779,10538780,10538781,10538782,10538783,10538784,10538785,10538786,10538787,10538788,10538789,10538790,10538791,10538792,10538793,10538794,10538796,10538797,10538798,10538799,10538800,10538801,10538802,10538803,10538804,10538805,10538806,10538807,10538808,10538809,10538810,10538811,10538812,10538813,10538814,10538815,10538819,10524870,10524872,10524873,10527030,10527031,10527032,10425235,10425236,10425237,10422354,10422355,10422356,10422357,10422358,10422359,10422360,10422361,10422362,10422363,10422364,10422365,10422366,10422367,10422368,10422369,10422370,10422371,10422372,10422373,10422374,10422375,10422376,10422377,10422378,10422379,10422380,10422381,10422382,10422383,10422403,10423922,10424968,10486535,10486536,10486537,10486538,10486539,10486540,10486541,10486542,10486543,10486544,10486545,10486546,10486547,10486548,10486549,10486550,10486551,10486552,10486553,10486554,10486555,10486556,10486557,10486558,10486559,10486560) 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'