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(7201597,7201728,7201729,8628262,8628264,8836127,7202211,8628667,10859479,10859483,10859498,10859500,10859524,10859525,5654620,10859607,10859621,5654670,10872655,10872656,10872657,10872658,10872659,10872660,8629244,8629282,8629317,8629318,8629429,8629430,10929083,8629485,8629504,8629509,8629518,8629568,10860402,10860584,10860585,10860593,7066883,4430138,8910601,4430185,8627221,10857864,10857865,8627223,10857866,8627224,10857867,10857868,8627227,10857869,10857870,8627228,10857871,8627230,10857872,8627231,10857873,10857874,8627232,8627233,10857875,10857876,8627234,8627235,10857877,8627236,10857878,10857879,10842344,8627237,10857880,8627238,10857881,8627239,8627240,8627241,8627242,8627243,8627244,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627266,8627267,8627269,8627270,8627272,8627273,10857917,8627279,8627280,10857924,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627290,8627291,8627292,8627293,8627310,8627312,8627313,8627318,8627319,8627320,8627359,10871050,8627460,8627462,8627465,8627479,10858122,8627489,8627490,8627494,8627495,8627497,8627525,8627526,8627527,7201154,7201155,7201156,10236681,10236682,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,7201272,7201325,10103344,10871527,10871528,10871529,10871530,10871531,10871532,10871533,10871534,10840153,7198685,7198696,7198699,7198710,7198711,7198714,7198724,7198728,7198733,7198769,7198772,8625212,8625341,10100878,10856184,3926353,10869283,8909077,8909078,8909079,10840912,8626128,10856907,8626347,8626348,8626349,10870113,10870114,10857123,10196570,10196571,10196572,10196573,10196574,10196575,10196576,10196577,10196578,10196579,10196580,10196581,10196582,10196583,10196584,10196585,7200121,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,8626960,8626961,8626962,10867709,10867712,3234951,3234952,3234957,3234958,7197804,7197814,7197815,7197846,8624439,8624594,8624595,10839702,8624596,8624597,8624598,8624599,8624600,8624601,8624602,8624603,8624604,8624605,8624606,8624607,8624608,8624699,8624750,8624754,7198386,10233980,10233981,10233982,10855557,10855558,8635060,8635061,8612412,8612413,8612414,8905720,3233409,10853298,10853299,10853300,10853301,7196260,10866484,10866485,10866486,10866487,3923593,10866655,10866656,10866657,10866658,10866659,8554358,10941716,10838539,10942027,10867209,3234364,3234365,10867265,10867266,10867267,10867268,10838965,3234738,3234743,8633059,10863753,10850823,8633210,8633212,8633226,8633410,8633411,8610664,10623493,8540377,10851163,10851164,8540569,10229917,3231703,8633990,3231908,3231909,3231910,3231911,3231912,3231913,3231914,3231915,3231916,3231917,3231918,3231919,3231920,3231921,3231922,3231923,3231924,3231925,3231926,3231927,3231928,3231929,3231930,3231931,3231932,3231933,3231934,3231935,3231936,3231937,3231938,3231939,3231940,3231941,3231942,3231943,3231944,3232014,3232015,3232016,3232017,3232018,3232168,10852049,8634463,3232245,10282563,10852254,10852370,8905258,8905263,10865562,8631975,8631976,8631977,8631978,8631979,8631980,8631981,8631982,8631983,8631984,8631985,8631986,8631987,8631988,8631989,8631990,8631991,8631992,8631993,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632014,8632015,8632016,8632017,8632018,8632019,10847216,8632121,8632122,8632123,8632124,8632148,8632149,8632150,8632151,8632152,8632153,8632154,8632155,8632156,8632157,8632308,8632309,8632310,8632311,10617373,10617374,10617378,10617456,10617512,8629987,8629993,8630007,10615125,10860786,10860787,10860788,10860828,10860829,8630211,8630215,8630437,8630438,8630439,8630440,8630441,10861216,8630847,8630853,8630896,8630897,8631037,8631047,8631050,10861924,10861928,10616341,10616342,10616417,8583488,8583489,10849376,10849377,10849378,10849379,10849380,10849381,10849382,10849383,10849384,10849385,10849386,10849387,8631786,10616872,8631901,8631902,8631903,8631904,8631905,8631906,8631907,8631908,8631909,8631910,8631911,8631912,8631913,8631914,8631924,8631925,8631926,8631927,8631928,8631929,8631930,8631931,8631932,8631933,8631934,8631935,8631936,8631937,8631938,8631939,8631940,8631941,8631942,8631943,8631944,8631945,8631946,8631947,8631948,8631957,8631958,8631959,8631960,8631961,8631962,8631963,8631964,8631965,8631966,8631967,8631968,8631969,8631970,8631971,8631974,10614048,9173737,10614500,6666259,10611969,9211467,9211468,9211470,9211471,9211472,9211475,9913860,9172542,10613372,8852632,8852771,10613696,10613902,10613918,6673700,10513373,9185725,9185726,9185727,9185791,9185809,10118151,10517796,10517797,6674281,6674329,8849970,9912437,9912438,8850116,8850117,9912654,9912888,10518675,10518676,10518677,10518678,10518679,10518680,8552194,9171080,10516953,10516954,9913358,4973253,4973254,4973255,10419527,10419528,10419529,10419530,10419531,10418560,9192639,10418798,6673277,10117317,10420043,10420091,10420092,10420093,10420094,9169275,7055456,10417217,8550036,10123239,9199042,9199043,9175512,976476,9167878,10908683,10903836,10903841,10903842,10894088,10894377,10884483,10879888,10890113,10890118,10890137,10890138,10887476,10887557,10632161,10632162,10632311,10632313,10627319,10630148,10885959,10886290,10886350,10886359,10886370,10886374,10626136,10626204,10631909,10631911,10631912,10631915,10631917,10631918,10631919,10631922,10887461,10626955,10626956,10626957,10610966,10568128,10568129,10568130,10611665,10610015,10604388,10582562,10610418,10582570,10591756,10591800,10601700,10528164,10548444,10522617,10420434,10420438,10421488,10422597,10423614,10423615,10423616,10423617,10423618,10423619,10423620,10415728,10506825,10422993,10422994,10422995,10422996,10422997,10422998,10422999,10423000,10422001,10507956,10507957,10411281,10411814,10413935,10413939,10413955,10413957,10411957,10413980,10413981,10410019,10414044,10414054,10408189,10408190,10412447,10412448,10412449,10412450,10412451,10412452,10412453,10412454,10412455,10412456,10412457,10412458,10412459,10412460,10412461,10412462,10412463,10412464,10412465,10412466,10412502,10412508,10462301,10412694,10408707,10410721,10410722,10414830,10414840,10414975,10414976,10414977,10406982,10406983,10406984,10406985,10406986,10406987,10406988,10406989,10406990,10406991,10406992,10406993,10415184) 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'