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(4970156,4970157,4970158,4970159,4970160,4970161,4970162,4970163,4970164,4970176,4970183,4970184,4970185,4970186,4970187,4970192,4970199,4970201,4970202,4970205,4970206,4970210,4970294,4970295,4970296,4970321,4970348,4970389,4970391,4970483,4970484,4970486,4970528,4970530,4970579,4970580,4970581,4970582,4970583,4970584,4970610,4970611,4970624,4970636,4970637,4970638,4970668,4970669,4970670,4970681,4970691,4970694,4970713,4970720,4970725,4970728,4970737,4970781,4970806,4970810,4970823,4970836,4970837,4970838,4970839,4970840,4970879,4970907,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970999,4971000,4971013,4971014,4971042,4971054,4971059,4971115,4971116,4971117,4971118,4971127,4971136,4971144,4971148,4971149,4971150,4971151,4968154,4968155,4968197,4968199,4968200,4968224,4968254,4968296,4968297,4968299,4968301,4968305,4968312,4968313,4968320,4968328,4968334,4968352,4968354,4968355,4968378,4968379,4968416,4968419,4968420,4968421,4968422,4968434,4968435,4968447,4968472,4968473,4968477,4968479,4968480,4968482,4968486,4968487,4968500,4968504,4968506,4968507,4968509,4968511,4968513,4968515,4968556,4968572,4968573,4968574,4968600,4968634,4968676,4968686,4968687,4968688,4968689,4968690,4968723,4968781,4968783,4968786,4968794,4968795,4968796,4968797,4968798,4968799,4968800,4968802,4968821,4968842,4968849,4968868,4968870,4968871,4968872,4968873,4968874,4968876,4968887,4968899,4968920,4968922,4968940,4968941,4968947,4968963,4968970,4968971,4968973,4968974,4968975,4968976,4968977,4968992,4969013,4969014,4969015,4969029,4969079,4969082,4969085,4969086,4969100,4969101,4969114,4969152,4969153,4969154,4969155,4969156,4969157,4969158,4969159,4969160,4969161,4969180,4969181,4969182,4969183,4969184,4969187,4969188,4969189,4969207,4969220,4969237,4969238,4969259,4969273,4969295,4969313,4969314,4969315,4969338,4969339,4969349,4969350,4969351,4969358,4969359,4969381,4969391,4969392,4969393,4969394,4969395,4969396,4969397,4969415,4969417,4969450,4969492,4969513,4969514,4969515,4969516,4969532,4969539,4969540,4969541,4969542,4969543,4969544,4969545,4969546,4969547,4969550,4969559,4969569,4969607,4969613,4969624,4969700,4969701,4969735,4969738,4969740,4969756,4969768,4969771,4969799,4969802,4969815,4969854,4969864,4969865,4969883,4969887,4969908,4969911,4969912,4969932,4969933,4969948,4969949,4969950,4969952,4969982,4969983,4969984,4969986,4969987,4969988,4969989,4970007,4970009,4970010,4970011,4970012,4970031,4970033,4970043,4970056,4970058,4970064,4970065,4970071,4970073,4970074,4970075,4970076,4970077,4970088,4970089,4970090,4970093,4970097,4970101,4970104,4970105,4970106,4970107,4970111,4970116,4970126,4970129,4970140,4970141,4970143,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074792,8074793,8074794,8074795,8074796,8074797,8074798,8074799,8074800,8074801,8074802,8074803,8074804,8074805,8074806,8074807,8074808,8074809,8074810,8074811,8074812,8074813,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8074834,8074835,8074836,8074837,8074838,8074839,8074840,8074841,8074842,8074843,8074844,8074845,8074846,8074847,8074848,8074849,8074850,8074851,8074852,8074853,8074854,8074855,4967052,4967078,4967079,4967081,4967144,4967148,4967171,4967174,4967180,4967190,4967194,4967196,4967205,4967208,4967209,4967217,4967219,4967220,4967244,4967253,4967254,4967273,4967280,4967288,4967293,4967294,4967295,4967299,4967300,4967301,4967316,4967330,4967331,4967350,4967358,4967386,4967426,4967433,4967434,4967439,4967440,4967467,4967475,4967498,4967530,4967531,4967537,4967538,4967554,4967555,4967556,4967581,4967583,4967585,4967587,4967605,4967607,4967609,4967617,4967630,4967633,4967671,4967672,4967673,4967684,4967697,4967725,4967730,4967731,4967732,4967733,4967734,4967750,4967762,4967777,4967778,4967779,4967796,4967801,4967802,4967803,4967804,4967850,4967853,4967856,4967860,4967899,4967906,4967907,4967908,4967913,4967914,4967936,4967944,4967945,4967946,4967947,4967948,4967949,4967954,4967955,4967956,4967957,4968016,4968017,4968018,4968021,4968022,4968023,4968025,4968026,4968027,4968069,4968070,4968129,8072788,8072789,8072790,8072791,8072792,8072972,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,8072982,8072983,8073139,8073151,8073158,8073168,8073360,8073363,8073366,8073371,8073499,8073509,8073513,8073532,10622986,10623005,10623010,10623027,10623031,10623053,10623054,10623074,10623076,10623084,10623085,10623086,10623093,10623105,10623107,10623114,10623117,10623118,10623122,10623123,10623124,10623148,10623178,10623179,10623223,10623266,10623267,10623269,10623304,10623315,10623326,10623333,10623337,10623343,10623348,10623359,10623370,10623380,10623398,10623406,10623409,10623420,10623427,10623431,10623437,10623442,10623461,10623481,10623482,10623483,10623484,10623503,10623504,10623512,10623514,10623515,10623520,10623522,10623528,10623530,10623531,10623532,10623533,10623534,10623535,10623536,10623537,10623538,10623539,10623540,10623541,10623542,10623543,10623549,10623552,10623554,10623566,10623595,10623636,10623637,10623638,10623639,10623644,10623647,10623649,10623655,10623663,10623672,10623674,10623681,10623685,10623690,10623692,10623707,10623708,10623710,10623711,10623712,10623719,10623720,10623721,10623722,10623725,10623726,10623727,10623730,10623732,10623738,10623743,10623750,10623765,10623766,10623768,10623774,10623777,10623786,10623792,10623828,10623830,10623890,10623898,10623979,10623980,10623989,10623990,10624001,10624015,10624017,10624022,10624023,10624084,10624124,10624134,10624135,10624143,10624144,10624145,10624146,10624147,10624152,10624186,10624192,10624194,10624196,10624201,10624202,10624204,10624205,10624206,10624208,10624226,10624231,10624232,10624233,10624234,10624235,10624236,10624237,10624238,10624239,10624240,10624241,10624242,10624243,10624244,10624245,10624246,10624247,10624248,10624249,10624250,10624251,10624252,10624253,10624254,10624255,10624256,10624257,10624258,10624259,10624260,10624261,10624262,10624263,10624264,10624265,10624266,10624267,10624268,10624269,10624270,10624271,10624272,10624273,10624274,10624275,10624276,10624277,10624278,10624279,10624280,10624281,10624282,10624283,10624284,10624285,10624286,10624287,10624288,10624289,10624290,10624291,10624292,10624293,10624294,10624295,10624296,10624297,10624298,10624299,10624300,10624301,10624302,10624303,10624304,10624305,10624306,10624307,10624308,10624309,10624310,10624311,10624312,10624313,10624314,10624315,10624316,10624317,10624318,10624319,10624320,10624321,10624322,10624323,10624324,10624325,10624326,10624327,10624328,10624329,10624330,10624331,10624332,10624333,10624334,10624340,10624358,10624366,10624367,10624369,10624370,10624371,10624374,10624375,10624387,10624389,10624390,10624391,10624392,10624428,10624437,10624445,10624452,10624454,10624472,10624490,10624492,10624500,10624552,10624553,10624557,10624567,10624568,10624569,10624570,10624579,10624580,10624583,10624594,10624598,10624651,10624652,10624653,10624654,10624655,10624656,10624664,10624666,10624672,10624708,10624712,10624726,10624728,10624734,10624738,10624741,10624742,10624745,10624746,10624747,10624750,10624751,10624752,10624753,10624754,10624755,10624756,10624757,10624758,10624759,10624760,10624761,10624765,10624770,10624787,10624798,10624811,10624819,10624827,10624841,10624843,10624866,10624868,10624875,10624884,10624891,10624902,10624903,10624945,10624946,10621963,10621965,10622064,10622094,10622103,10622104,10622105,10622159,10622178,10622209,10622211,10622215,10622227,10622232,10622239,10622242,10622279,10622288,10622305,10622319,10622342,10622366,10622376,10622391,10622400,10622412,10622421,10622434,10622438,10622441,10622446,10622457,10622521,10622530,10622533,10622535,10622544,10622545,10622552,10622590,10622591,10622592,10622615,10622627,10622631,10622638,10622642,10622647,10622673,10622675,10622676,10622682,10622685,10622694,10622695,10622699,10622722,10622751,10622766) 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'