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(8630912,8630913,8630914,8630917,8630919,8839038,8631476,8631477,8631478,8631479,8631712,8067368,8067369,10459914,10459915,10459917,10459918,10459919,10459921,10459922,10459926,10459927,10459928,10459956,10459957,10459959,10459960,10459961,10459963,10459964,10459968,10459969,10459970,10459996,10459997,10459999,10460000,10460001,10460003,10460004,10460008,10460009,10460010,10460036,10460037,10460039,10460040,10460041,10460043,10460044,10460048,10460049,10460050,10460076,10460077,10460079,10460080,10460081,10460082,10460084,10460088,10460089,10460090,8632190,10460116,8632191,10460117,8632192,8632193,10460119,10460120,10460121,10460123,10460124,10460128,10460129,10460130,10849868,10849869,10460156,10460157,10460159,10460160,10460161,10460163,10460164,10460168,10460169,10460170,10460196,10460197,10460199,10460200,10460201,10460203,10460204,10460208,10460209,10460210,10460236,10460237,10460239,10460240,10460241,10460243,10460244,10460248,10460249,10460250,10460276,10460277,10460279,10460280,10460281,10460283,10460284,10460288,10460289,10460290,10460316,10460317,10460319,10460320,10460321,10460323,10460324,10460328,10460329,10460330,10460356,10460357,10460359,10460360,10460361,10460363,10460364,10460368,10460369,10460370,8629472,8629523,8629525,8629559,8629585,8067931,8067943,8629617,8629618,8629619,8629620,8629621,8629622,8629741,8629742,10860386,10860390,8629754,8629755,8629756,8629841,8629843,10860490,8630406,7201080,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8627581,8627582,8627583,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,8627707,8627708,8627709,8627710,8627711,8627712,8627713,7201319,8627793,8627798,8627799,8627800,7201432,10866565,10866566,10866569,10866570,10866571,10866572,10866573,10866574,10866575,10866576,10866577,10866578,8628622,8628623,8628634,7202683,7202684,7202695,8629095,8629096,8629099,8629166,8629188,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629227,8629228,8629229,8629230,8629231,8629232,8629303,8629393,8629396,8626932,10958987,10958988,10958989,8627050,8627052,8627055,8627056,8627057,8627058,8627059,8627060,8627061,8627064,8627065,8627066,8627068,8627072,8627074,8627075,8627083,8627084,8627089,8627090,8627093,8627094,8627099,8627106,8627107,8627108,8627109,8627110,8627112,8627117,8627119,8627120,8627121,7200903,7200904,7200911,7200913,8627315,8627317,8627318,8627320,8627321,8627322,8071683,8071684,8071686,8071687,8071692,8071694,8071695,8071704,8071705,8071707,8624502,8624508,8624512,8624524,8624525,8071748,8071749,8071751,8071752,8071757,8071759,8071760,8071769,8071770,8071772,8071813,8071814,8071816,8071817,8071822,8071823,8071825,8071834,8071835,8071837,8071878,8071879,8071881,8071882,8071887,8071889,8071890,8071899,8071900,8071902,8071943,8071944,8071946,8071947,8071952,8071954,8071955,8071964,8071965,8071967,8072008,8072009,8072011,8072012,8072017,8072019,8072020,8072029,8072030,8072032,8072073,8072074,8072076,8072077,8072082,8072084,8072085,8072094,8072095,8072097,8072138,8072139,8072141,8072142,8072147,8072149,8072150,8072159,8072160,8072162,8072203,8072204,8072206,8072207,8072212,8072214,8072215,8072224,8072225,8072227,8072268,8072269,8072271,8072272,8072277,8072279,8072280,8072289,8072290,8072292,7198696,7198714,7198716,7198719,7198730,7198743,7198762,7198772,10100764,3236570,10853141,11045725,10853335,4937288,4937289,4937291,4937292,4937297,4937299,4937300,4937310,4937311,4937313,4937357,4937358,4937360,4937361,4937366,7196890,4937368,4937369,7196891,7196892,4937378,4937379,4937381,4937422,4937423,4937425,4937426,4937431,4937433,4937434,4937443,4937444,4937446,4937487,4937488,4937490,4937491,4937496,4937498,4937499,4937508,4937509,4937511,4937552,4937553,4937555,4937556,4937561,4937562,4937564,4937573,4937574,4937576,4937617,4937618,4937620,4937621,4937626,4937628,4937629,4937638,4937639,4937641,4937682,4937683,4937685,4937686,4937691,4937693,4937694,4937703,4937704,4937706,4937747,4937748,4937750,4937751,4937756,4937758,4937759,4937768,4937769,4937771,4937812,4937813,4937815,4937816,4937821,4937823,4937824,4937833,4937834,4937836,4937877,4937878,4937880,4937881,4937886,4937888,4937889,4937898,4937899,4937901,4937942,4937943,4937945,4937946,4937951,4937953,4937954,4937963,4937964,4937966,4938007,4938008,4938010,4938011,4938016,4938018,4938019,4938028,4938029,4938031,8071550,8071551,8071553,8071554,8071559,8071561,8071562,8071572,8071573,8071575,8624400,8071618,8071619,8071621,8071622,8071627,8071629,8071630,8071639,8071640,8071642,8624449,8634615,8634616,8634617,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,8634769,8634770,8634811,10617322,10617324,10852524,10617426,10852571,10852572,10617456,8542204,8632538,8632627,10620195,10620196,10620197,10620198,10620199,10620208,8632808,10425553,10615341,8632884,8633186,8633187,8633188,8633189,8633190,8633191,8633192,8633193,8633194,8633195,8633196,8633197,8633198,8633199,8633200,8633201,10615711,8633219,8633220,8633221,8633222,8633223,8633224,8633225,8633226,8633227,8633228,8633229,8633230,8633231,8633232,8633233,8633234,10848408,10848409,10615896,10616005,8540543,8540564,8540565,8540566,8540567,8540590,8634150,3232023,3232024,3232025,3232047,8611468,8634412,8634453,10610995,10610996,10614857,8565891,8565947,10613369,10613736,10117517,4974543,9912966,10119183,8848726,8848747,8848760,9193119,9193120,9193121,8563358,8563359,8563360,8563361,8563362,8563363,9168100,8848006,10883568,10883627,10893984,10893985,10893986,10893987,10893988,10894377,10883415,10883416,10891654,10891655,10626724,10626725,10602179,10602182,10602185,10602191,10602197,10583441,10602700,10590310,10590311,10603696,10579772,10579773,10579774,10579775,10579776,10579777,10579778,10579779,10579780,10579781,10601687,10601702,10601704,10529398,10529399,10549588,10549589,10550384,10550385,10550386,10550445,10543042,10425325,10409350,10407369,10407370,10409501,10414686,10414688,10414690,10414693,10414766,10414770,10408988,10409024,10409025) 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'