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(4970409,4970453,4970454,4970455,4970456,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970508,4970509,4970510,4970511,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970639,4970651,4970654,4970655,4970656,4970666,4970667,4970668,4970669,4970675,4970687,4970688,4970699,4970700,4970706,4970713,4970714,4970718,4970724,4970725,4970726,4970743,4970745,4970746,4970748,4970749,4970750,4970751,4970752,4970757,4970758,4970759,4970777,4970778,4970779,4970785,4970792,4970859,4970862,4970864,4970865,4970868,4970869,4970870,4970871,4970872,4970873,4970877,4970878,4970879,4970880,4970881,4970882,4970884,4970885,4970886,4970889,4970890,4970891,4970892,4970895,4970896,4970899,4970900,4970901,4970903,4970904,4970905,4970906,4970907,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970975,4970976,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971022,4971023,4971026,4971027,4971028,4971030,4971031,4971032,4971033,4971034,4971035,4971036,4971054,4971055,4971056,4971057,4971058,4971060,4971061,4971062,4971128,4971143,4968165,4968166,4968167,4968208,4968209,4968210,4968211,4968212,4968213,4968214,4968215,4968216,4968217,4968218,4968219,4968220,4968320,4968321,4968322,4968323,4968330,4968331,4968332,4968333,4968334,4968340,4968405,4968406,4968407,4968408,4968442,4968443,4968565,4968602,4968603,4968609,4968637,4968644,4968646,4968647,4968648,4968649,4968650,4968651,4968681,4968698,4968699,4968700,4968723,4968784,4968808,4968809,4968810,4968811,4968812,4968813,4968827,4968828,4968829,4968830,4968831,4968843,4968859,4969252,4969261,4969262,4969263,4969264,4969266,4969285,4969286,4969287,4969288,4969328,4969329,4969340,4969341,4969342,4969382,4969383,4969544,4969545,4969546,4969562,4969589,4969590,4969591,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,4969619,4969620,4969621,4969622,4969686,4969687,4969688,4969689,4969914,4969915,4969916,4969917,4969968,4969969,4970038,4970039,4970040,4970041,4970042,8075231,8075232,8075233,8075234,8075240,8075241,8075259,8075261,8075262,8075263,8075264,8075265,8075266,8075288,8075400,8075401,8075404,8075405,8075407,8075408,8075409,8075410,8075413,8075414,8075415,8075432,8075433,8075435,8075436,8075448,8075449,8075450,8075453,8075455,8075488,8075489,4967027,4967028,4967030,4967031,4967032,4967045,4967046,4967047,4967064,4967086,4967094,4967095,4967107,4967108,4967109,4967110,4967111,4967113,4967130,4967134,4967140,4967194,4967195,4967212,4967216,4967228,4967229,4967230,4967231,4967232,4967239,4967245,4967246,4967247,4967251,4967253,4967264,4967270,4967271,4967272,4967275,4967276,4967283,4967284,4967285,4967286,4967287,4967288,4967295,4967306,4967310,4967312,4967323,4967324,4967325,4967326,4967339,4967340,4967341,4967344,4967351,4967352,4967383,4967391,4967403,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967514,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967535,4967536,4967537,4967538,4967539,4967540,4967541,4967542,4967543,4967544,4967545,4967546,4967547,4967548,4967549,4967550,4967551,4967552,4967553,4967554,4967555,4967556,4967557,4967558,4967559,4967560,4967561,4967562,4967563,4967564,4967565,4967566,4967567,4967568,4967569,4967570,4967571,4967572,4967573,4967574,4967575,4967576,4967577,4967578,4967579,4967580,4967581,4967582,4967583,4967584,4967585,4967586,4967587,4967588,4967589,4967590,4967591,4967592,4967593,4967594,4967595,4967596,4967597,4967598,4967599,4967600,4967601,4967602,4967603,4967604,4967605,4967606,4967607,4967608,4967609,4967610,4967611,4967612,4967613,4967614,4967615,4967616,4967617,4967618,4967619,4967620,4967621,4967622,4967623,4967624,4967625,4967626,4967627,4967628,4967629,4967630,4967631,4967632,4967633,4967634,4967635,4967636,4967637,4967638,4967639,4967640,4967641,4967642,4967643,4967644,4967645,4967646,4967647,4967648,4967649,4967650,4967651,4967652,4967653,4967654,4967655,4967656,4967657,4967658,4967659,4967660,4967661,4967662,4967663,4967664,4967665,4967666,4967667,4967668,4967669,4967670,4967671,4967672,4967673,4967674,4967675,4967676,4967677,4967678,4967679,4967680,4967681,4967682,4967683,4967684,4967685,4967686,4967687,4967688,4967689,4967690,4967691,4967692,4967693,4967694,4967695,4967696,4967697,4967698,4967699,4967700,4967701,4967702,4967703,4967704,4967705,4967706,4967707,4967708,4967709,4967710,4967711,4967712,4967713,4967714,4967715,4967716,4967717,4967718,4967719,4967720,4967721,4967722,4967723,4967724,4967725,4967726,4967727,4967728,4967729,4967730,4967731,4967732,4967733,4967734,4967735,4967736,4967737,4967738,4967739,4967740,4967741,4967742,4967743,4967744,4967745,4967746,4967747,4967748,4967749,4967750,4967751,4967752,4967753,4967754,4967755,4967756,4967757,4967758,4967759,4967760,4967761,4967762,4967763,4967764,4967765,4967766,4967767,4967768,4967769,4967770,4967771,4967772,4967773,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967819,4967820,4967821,4967822,4967823,4967824,4967825,4967826,4967827,4967828,4967829,4967830,4967831,4967832,4967833,4967834,4967835,4967836,4967837,4967838,4967839,4967859,4967873,4967874,4967875,4967876,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,4967896,4967897,4967919,4967920,4967921,4967931,4967932,4967933,4967934,4967935,4967936,4967937,4967938,4967939,4967946,4967948,4967949,4967958,4967959,4967960,4967961,4967962,4967963,4967964,4967965,4967966,4967981,4967983,4967984,4967985,4967986,4967987,4967988,4967989,4967990,4967991,4967997,4967998,4967999,4968000,4968001,4968002,4968003,4968009,4968015,4968029,4968049,4968058,4968060,4968074,4968121,4968144,4968145,4968146,4968148,4968149,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072383,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072407,8072408,8072409,8072410,8072411,8072412,8072413,8072414,8072415,8072416,8072417,8072418,8072419,8072420,8072421,8072422,8072423,8072424,8072425,8072426,8072427,8072429,8072430,8072431,8072432,8072433,8072434,8072435,8072436,8072437,8072438,8072439,8072440,8072441,8072442,8072443,8072444,8072445,8072446,8072447,8072448,8072449,8072450,8072451,8072452,8072453,8072454,8072455,8072456,8072457,8072458,8072459,8072460,8072461,8072462,8072470,8072471,8072535,8072536,8072537,8072562,8072563,8072564,8072633,8072634,8072635,8072636,8072637,8072638,8072639,8072640,8072641,8072642,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072796,8072797,8072798,8072799,8072800,8072804,8072805,8072806,8072807,8072808,8072812,8072813,8072814,8072815,8072816) 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'