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(8630625,8630626,8630629,8630630,8630631,8630632,8630633,8630634,8630636,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,4970670,4970671,3229024,10944265,7065947,8583441,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8067927,8067941,8067942,8067943,8629617,8629618,8629619,8629620,8629621,8629622,8573243,7067586,8630437,8630438,8630439,8630440,8630441,10842809,10842810,7201426,7201427,7201676,7201728,7201729,7201901,8595306,7201959,7202037,8595719,7202367,7202369,7202371,7202373,7202375,7202378,7202381,7202383,7202384,7202385,7202386,7202388,7202390,7202392,7202394,7202396,7202398,7202400,7202402,7202404,7202406,7202408,7202410,7202413,7202415,7202417,7202419,7202421,7202423,7202425,7202427,7202430,7202432,7202445,7202446,7202447,7202448,7202449,7202450,7202451,7202452,7202453,7202454,7202455,7202456,7202457,7202458,7202459,7202460,7202461,7202462,7202463,7202464,7202465,7202466,7202467,7202468,7202469,7202470,7202471,7202472,7202473,7202474,7202475,7202476,7202477,7202478,7202479,7202480,7202481,7202482,7202483,7202484,7202485,7202486,7202487,7202488,7202489,7202490,7202491,7202492,7202493,7202494,7202495,7202496,7202497,7202498,7202499,7202500,7202501,7202502,7202503,7202504,7202505,7202506,7202507,7202508,7202509,7202510,7202511,7202512,7202513,7202514,7202515,7202516,7202517,7202518,7202519,7202520,7202521,7202522,7202523,5654676,5654677,9794589,8629430,7200469,7200470,10958953,10958954,7200527,7200528,7200529,8910453,8910454,8910455,8910456,8910457,8910458,8910459,8910460,8910461,8910462,8910463,8910464,8910465,8627238,8627239,8627240,8627241,8627249,8627250,8627253,8627284,8627285,8627286,8627287,8627291,8627292,8627310,8627312,8627313,10839695,8624611,7198381,8625022,10941262,8625243,8625244,8625245,8625246,8625247,8908708,8908709,8908710,8908711,8908713,8908714,8908715,8908716,8908717,8908718,8908722,8908723,8908730,8908738,8908739,8908741,8908746,8908747,8908750,8908751,8908752,8908753,8908754,8908755,8908758,8908759,8908760,8908761,8908762,8625385,3926474,7199508,3923420,8906900,8906901,10838793,10838999,8624261,8624262,8624263,8624264,8624265,8624266,8624267,8624268,8624269,8624270,8624271,8624272,8624273,8624274,8624275,8624276,8624277,8624278,8624279,8624297,8624298,8624299,8624300,8624301,8624302,8624303,8624304,8624305,8624306,8624307,8624308,8624309,8624318,8624319,8624320,8624321,8624322,8624323,8624324,8624325,10619844,10619875,8634580,8634738,8634739,8634740,8634741,8634742,8634743,8634744,8634745,8634746,8634747,8634754,8634755,8634756,8634757,10622258,8634758,10622264,10622265,10622266,10622267,10622268,8905183,8905184,8905185,8905186,8905187,8905188,8905189,8905190,8905191,8905192,8905193,8905194,8905195,8905196,8905197,8905198,8905199,10622360,8634890,8634891,8634892,10622402,10622405,10622408,10622431,10622447,10622460,10617509,10617510,10617511,10617512,10622514,10622516,10622523,3232914,10426340,10426474,8611460,8611461,8611462,8611463,8611464,8611465,7155257,7155258,7155259,10616907,10616910,8634445,10610969,10610971,10610980,10610982,10610999,8863986,10611778,10609844,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,9220274,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613369,8852542,10613527,10613531,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,9172924,10610588,9172925,10610589,9172926,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10610633,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10613722,10613732,10613733,10117592,10117593,10117594,10117595,10117596,10117597,10117598,10117599,10117600,10117601,10117602,10117603,6673685,10117682,10117683,10117684,9169998,9169999,10118374,10118375,8850280,8850281,8850282,8850283,8850284,8850285,8850286,8850287,8850288,8850289,8850290,8850291,8850292,8850293,8850294,8850295,8850296,8850297,8850298,8850299,8850300,8850301,8850302,8850303,8850304,8850305,8850306,8850307,8850308,8850309,8850310,8850311,8850312,8850313,8850314,8850315,8850316,8850317,8850318,8850319,8850320,8850321,8850322,8850323,8850324,8850325,8850326,8850327,8850328,8850329,8850330,8850331,8850332,8850333,8850334,8850335,8850336,8850337,8850338,8850339,8850340,8850341,8850342,8850343,8850344,8850345,8850346,8850347,8850348,8850349,8850350,6672724,6672725,6672726,6672727,6672728,6672729,6672730,6672731,6672732,6672733,6672734,10416481,10418559,10418560,10418561,10418562,10418563,10418564,10418565,10418566,10419668,10419669,10419670,10419671,10419672,10419673,10419674,10419675,10419676,10419677,10419678,10419679,10419680,10419681,10419682,10419683,10419684,10419685,10419686,10419687,10419688,10419689,10419690,10419693,10419694,10419695,10419703,10419704,10419705,10419706,10419707,10419708,10419709,10419710,10419711,10419712,10419713,10419714,10419715,10419716,10419717,10419718,10419719,10419720,10419721,10419722,10419723,10419724,10419725,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,10419734,10419735,10419736,10419737,10419738,10419739,10419740,10419741,10419742,10419743,10419744,10419745,10419746,10419747,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419755,10419756,6673064,10419793,6673082,10419802,10419803,10419804,10419805,10419806,10419807,10419808,10419809,10419810,10419813,10419814,10419815,10419816,6673100,10419817,10419818,10419819,10419820,10419821,6673105,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10117478,8549880,8549881,8549902,8549972,8550015,3963318,3963319,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,10467909,10467910,10467911,10467912,10467913,10467914,10467915,10468239,9168000,9168001,9168002,9168003,9168004,10883518,10883519,10883520,10883521,10883522,10883523,10883524,10883525,10883526,10883527,10883528,10883529,10883530,10883531,10883532,10883533,10883534,10883535,10883536,10883537,10883538,10883539,10883540,10883541,10883542,10883543,10883544,10883545,10883546,10883547,10883548,10883549,10883550,10883551,10883552,10890246,10890247,10890250,10890251,10890252,10890253,10890254,10890255,10890256,10890257,10890258,10890259,10632011,10887724,10161853,10161854,10161855,10161856,10161857,10161858,10161859,10161860,10886878,10647401,10647402,10647403,10647404,10647405,10647406,10647407,10647408,10647409,10647410,10647411,10647412,10647413,10647414,10647415,10647416,10647417,10647418,10647714,10650733,10650741,10650819,10650820,10527957,10508171,10508256,10508603,10507625,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10507944,10507958,10507959,10411981,10411982,10411983,10411984,10411985,10411986,10411987,10411988,10411989,10411990,10411991,10411992,10487112,10410952,10410960,10410962,10410965,10410970,10410971,10410972,10410973,10410974,10410975,10410976,10410977,10410978,10410979,10410980,10410981,10410982,10410983,10410984,10410985,10410986,10410987,10410988,10410989,10410990,10410991,10410992,10410993,10410994,10410995,10410996,10410997,10410998,10410999,10411000,10411001,10411002,10411003,10411004,10411005,10411006,10411007,10411008,10411009,10411010,10411011,10411012,10411013,10411014) 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'