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(4970152,4970153,4970154,4970155,4970156,4970157,4970158,4970159,4970160,4970161,4970162,4970163,4970164,4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970175,4970176,4970178,4970179,4970180,4970181,4970182,4970183,4970184,4970185,4970186,4970187,4970188,4970189,4970190,4970191,4970192,4970198,4970199,4970201,4970202,4970203,4970204,4970205,4970206,4970208,4970209,4970210,4970211,4970213,4970214,4970215,4970216,4970217,4970219,4970220,4970221,4970225,4970226,4970294,4970295,4970296,4970321,4970348,4970389,4970391,4970483,4970484,4970486,4970528,4970530,4970579,4970582,4970583,4970610,4970611,4970636,4970637,4970638,4970670,4970681,4970691,4970694,4970713,4970720,4970725,4970728,4970737,4970781,4970806,4970810,4970823,4970836,4970837,4970838,4970839,4970840,4970874,4970879,4970894,4970898,4970901,4970903,4970907,4970909,4970910,4970913,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,4971099,4971100,4971106,4971115,4971116,4971117,4971118,4971127,4971136,4971144,4971148,4971149,4971150,4971151,4968154,4968155,4968197,4968199,4968200,4968224,4968232,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,4968638,4968639,4968671,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,4969253,4969254,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969267,4969268,4969270,4969271,4969273,4969275,4969278,4969279,4969282,4969283,4969284,4969287,4969288,4969289,4969292,4969295,4969300,4969301,4969302,4969304,4969307,4969308,4969309,4969310,4969311,4969313,4969314,4969315,4969316,4969317,4969318,4969319,4969323,4969327,4969328,4969329,4969332,4969333,4969334,4969335,4969336,4969337,4969338,4969339,4969342,4969343,4969347,4969348,4969349,4969350,4969351,4969352,4969353,4969355,4969356,4969358,4969359,4969360,4969361,4969365,4969366,4969367,4969376,4969377,4969379,4969381,4969384,4969385,4969386,4969387,4969388,4969389,4969390,4969391,4969392,4969393,4969394,4969395,4969396,4969397,4969398,4969399,4969401,4969403,4969405,4969406,4969407,4969408,4969409,4969411,4969412,4969413,4969414,4969415,4969416,4969417,4969419,4969420,4969423,4969425,4969429,4969430,4969432,4969433,4969434,4969436,4969439,4969441,4969443,4969445,4969447,4969448,4969450,4969451,4969452,4969455,4969459,4969460,4969464,4969471,4969473,4969476,4969478,4969480,4969481,4969482,4969483,4969485,4969486,4969488,4969490,4969492,4969494,4969495,4969496,4969497,4969498,4969504,4969505,4969506,4969507,4969508,4969510,4969511,4969513,4969514,4969515,4969516,4969517,4969520,4969521,4969523,4969527,4969528,4969529,4969531,4969532,4969533,4969534,4969536,4969537,4969538,4969539,4969540,4969541,4969542,4969543,4969544,4969545,4969546,4969547,4969550,4969553,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,4969569,4969607,4969613,4969624,4969628,4969629,4969630,4969631,4969634,4969635,4969636,4969637,4969639,4969640,4969641,4969643,4969644,4969647,4969649,4969650,4969651,4969652,4969653,4969663,4969664,4969665,4969667,4969668,4969669,4969670,4969671,4969672,4969674,4969677,4969678,4969680,4969684,4969685,4969687,4969688,4969689,4969692,4969693,4969694,4969695,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969704,4969705,4969707,4969708,4969709,4969716,4969718,4969719,4969728,4969729,4969730,4969735,4969737,4969738,4969740,4969743,4969748,4969749,4969750,4969751,4969752,4969753,4969754,4969755,4969756,4969762,4969763,4969764,4969765,4969768,4969771,4969775,4969777,4969778,4969781,4969782,4969783,4969786,4969787,4969788,4969789,4969791,4969792,4969795,4969798,4969799,4969801,4969802,4969805,4969806,4969808,4969809,4969810,4969811,4969812,4969813,4969814,4969815,4969817,4969820,4969821,4969823,4969826,4969829,4969833,4969834,4969835,4969836,4969837,4969838,4969839,4969840,4969841,4969842,4969843,4969844,4969845,4969848,4969850,4969852,4969853,4969854,4969855,4969856,4969857,4969858,4969859,4969860,4969861,4969864,4969865,4969866,4969867,4969868,4969869,4969870,4969871,4969872,4969873,4969875,4969876,4969877,4969878,4969880,4969882,4969883,4969884,4969885,4969887,4969890,4969891,4969892,4969893,4969895,4969896,4969898,4969899,4969900,4969901,4969903,4969904,4969906,4969907,4969908,4969909,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969919,4969920,4969921,4969925,4969927,4969928,4969932,4969933,4969934,4969939,4969940,4969941,4969942,4969943,4969944,4969946,4969947,4969948,4969949,4969950,4969952,4969956,4969959,4969961,4969962,4969963,4969964,4969967,4969969,4969973,4969975,4969976,4969977,4969978,4969979,4969980,4969982,4969983,4969984,4969986,4969987,4969988,4969989,4969991,4969993,4969995,4969997,4969998,4970000,4970001,4970002,4970003,4970004,4970005,4970006,4970007,4970008,4970009,4970010,4970011,4970012,4970013,4970014,4970017,4970019,4970022,4970024,4970025,4970031,4970033,4970037,4970039,4970040,4970042,4970043,4970046,4970047,4970048,4970049,4970050,4970051,4970053,4970054,4970055,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970067,4970068,4970071,4970072,4970073,4970074,4970075,4970076,4970077,4970078,4970079,4970081,4970082,4970083,4970084,4970087,4970088,4970089,4970090,4970092,4970093,4970095,4970096,4970097,4970098,4970100,4970101,4970102,4970103,4970104,4970105,4970106,4970107,4970109,4970110,4970111,4970113,4970114,4970115,4970116,4970117,4970118,4970120,4970123,4970124,4970126,4970128,4970129,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970137,4970139,4970140,4970141,4970142,4970143,4970145,4970149,4970150,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,4967149,4967150,4967151,4967152,4967153,4967156,4967158,4967159,4967160,4967162,4967163,4967164,4967165,4967166,4967167,4967168,4967171,4967173,4967174,4967177,4967178,4967180,4967181,4967186,4967187,4967189,4967190,4967191,4967193,4967194,4967195,4967196,4967197,4967198,4967199,4967200,4967201,4967203,4967205,4967208,4967209,4967215,4967217,4967219,4967220,4967221,4967224,4967225,4967226,4967227,4967229,4967233,4967235,4967236,4967237,4967238,4967241,4967243,4967244,4967248,4967253,4967254,4967257,4967259,4967261,4967263,4967264) 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'