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,4970174,4970175,4970176,4970177,4970178,4970179,4970180,4970181,4970182,4970183,4970184,4970185,4970186,4970187,4970188,4970189,4970190,4970191,4970192,4970198,4970199,4970200,4970201,4970202,4970204,4970205,4970206,4970210,4970218,4970228,4970229,4970486,4970672,4970712,4970795,4970796,4970797,4970810,4970811,4970812,4970813,4970814,4970815,4970852,4970896,4970897,4970898,4970899,4970900,4970905,4970906,4970907,4970908,4970909,4970915,4970921,4970943,4970949,4970950,4970951,4970958,4970963,4970966,4970969,4970995,4970996,4970997,4970998,4970999,4971000,4971001,4971002,4971003,4971004,4971005,4971006,4971007,4971008,4971009,4971010,4971011,4971012,4971013,4971014,4971066,4971067,4971068,4971069,4971144,4968232,4968304,4968305,4968481,4968555,4968556,4968633,4968638,4968639,4968640,4968641,4968682,4968683,4968684,4968685,4968791,4968792,4968793,4968794,4968795,4968841,4969158,4969159,4969177,4969259,4969271,4969272,4969273,4969276,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969289,4969290,4969291,4969292,4969293,4969294,4969295,4969296,4969297,4969298,4969299,4969313,4969314,4969315,4969316,4969321,4969322,4969323,4969324,4969325,4969326,4969331,4969332,4969333,4969334,4969335,4969336,4969337,4969338,4969339,4969349,4969350,4969351,4969357,4969358,4969359,4969365,4969366,4969367,4969368,4969369,4969370,4969375,4969381,4969391,4969392,4969393,4969394,4969395,4969396,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969415,4969416,4969417,4969418,4969419,4969420,4969421,4969422,4969423,4969424,4969425,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969434,4969435,4969436,4969437,4969438,4969439,4969440,4969441,4969442,4969443,4969444,4969445,4969446,4969447,4969448,4969449,4969450,4969451,4969452,4969453,4969454,4969455,4969456,4969457,4969458,4969459,4969460,4969461,4969462,4969463,4969464,4969465,4969466,4969467,4969468,4969469,4969470,4969471,4969472,4969473,4969474,4969475,4969476,4969477,4969478,4969479,4969480,4969481,4969482,4969483,4969484,4969485,4969486,4969487,4969488,4969489,4969490,4969491,4969492,4969502,4969513,4969514,4969515,4969516,4969519,4969520,4969521,4969522,4969523,4969524,4969525,4969526,4969527,4969528,4969529,4969530,4969531,4969532,4969533,4969541,4969550,4969559,4969629,4969646,4969655,4969662,4969682,4969690,4969700,4969701,4969702,4969703,4969710,4969726,4969731,4969732,4969733,4969734,4969735,4969736,4969737,4969738,4969739,4969740,4969756,4969761,4969766,4969767,4969768,4969769,4969770,4969771,4969772,4969773,4969774,4969797,4969799,4969802,4969813,4969815,4969825,4969840,4969854,4969860,4969861,4969862,4969863,4969864,4969865,4969866,4969867,4969868,4969869,4969870,4969871,4969872,4969873,4969874,4969875,4969876,4969877,4969878,4969879,4969880,4969881,4969882,4969883,4969884,4969885,4969886,4969887,4969888,4969889,4969890,4969891,4969892,4969893,4969894,4969895,4969896,4969897,4969898,4969899,4969900,4969901,4969902,4969903,4969904,4969905,4969906,4969907,4969908,4969909,4969910,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969918,4969919,4969920,4969921,4969922,4969923,4969924,4969925,4969926,4969927,4969928,4969929,4969930,4969931,4969932,4969933,4969934,4969935,4969936,4969937,4969938,4969939,4969940,4969941,4969942,4969943,4969944,4969945,4969946,4969947,4969948,4969949,4969950,4969951,4969952,4969953,4969954,4969955,4969956,4969957,4969958,4969959,4969960,4969961,4969962,4969963,4969964,4969965,4969966,4969967,4969968,4969969,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4969979,4969980,4969981,4969982,4969983,4969984,4969985,4969986,4969987,4969988,4969989,4969990,4969991,4969992,4969993,4969994,4969995,4969996,4969997,4969998,4969999,4970000,4970001,4970002,4970003,4970004,4970005,4970006,4970007,4970008,4970009,4970010,4970011,4970012,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970029,4970030,4970031,4970032,4970033,4970034,4970035,4970036,4970037,4970038,4970039,4970040,4970041,4970042,4970043,4970044,4970045,4970046,4970047,4970048,4970049,4970050,4970051,4970052,4970053,4970054,4970055,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970066,4970067,4970068,4970069,4970070,4970071,4970072,4970073,4970074,4970075,4970076,4970077,4970078,4970079,4970080,4970081,4970082,4970083,4970084,4970085,4970086,4970087,4970088,4970089,4970090,4970091,4970092,4970093,4970094,4970095,4970096,4970097,4970098,4970099,4970100,4970101,4970102,4970103,4970104,4970105,4970106,4970107,4970108,4970109,4970110,4970111,4970112,4970113,4970114,4970115,4970116,4970117,4970118,4970119,4970120,4970121,4970122,4970123,4970124,4970125,4970126,4970127,4970128,4970129,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970137,4970138,4970139,4970140,4970141,4970142,4970143,4970144,4970145,4970146,4970147,4970148,4970149,4970150,4970151,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074706,8074707,8074708,8074709,8074710,8074711,8074712,8074713,8074714,8074715,8074716,8074717,8074718,8074719,8074720,8074721,8074722,8074723,8074724,8074725,8074726,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074748,8074749,8074750,8074751,8074752,8074753,8074754,8074755,8074756,8074757,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074767,8074768,8074769,8074770,8074771,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074877,8074878,8074879,8074880,8074881,8074882,8074883,8074884,8074885,8074886,8074887,8074888,8074889,8074890,8074891,8074892,8074893,8074894,8074895,8074896,8074897,8074898,8074899,8074900,8074901,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,8074922,8074923,8074924,8074925,8074926,8074927,8074928,8074929,8074930,8074931,8074932,8074933,8074934,8074935,8074936,8074937,8074938,8074939,8074940,8074941,8074942,8074943,8074944,8074945,8075247,8075248,4967030,4967031,4967050,4967051,4967052,4967106,4967148,4967153,4967154,4967155,4967161,4967167,4967168,4967169,4967170,4967171,4967172,4967173,4967174,4967175,4967176,4967177,4967178,4967179,4967180,4967181,4967182,4967183,4967184,4967185,4967186,4967187,4967188,4967189,4967190,4967191,4967192,4967193,4967194,4967195,4967196,4967197,4967198,4967199,4967200,4967201,4967202,4967203,4967204,4967205,4967206,4967207,4967208,4967209,4967210,4967211,4967212,4967213,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967225,4967226,4967227,4967228,4967229,4967230,4967231,4967232,4967233,4967234,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967248,4967249,4967250,4967251,4967252,4967253,4967254,4967255,4967256,4967257,4967258,4967259,4967260,4967261,4967262,4967263,4967264,4967265,4967266,4967267,4967268,4967269,4967270,4967271,4967272,4967273,4967274,4967275,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967283,4967284,4967285,4967286,4967287,4967288,4967289,4967290,4967291,4967292,4967293,4967294,4967295,4967296,4967297,4967298,4967299,4967300,4967301,4967302,4967303,4967304,4967305,4967306,4967307,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967317,4967318,4967319,4967320,4967321,4967322,4967323,4967324,4967325,4967326) 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'