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(8068855,10939588,8068856,10939596,10939655,10939656,10939657,10939658,10939659,10939660,10939871,10939872,10939882,10939921,10939922,10939923,10939924,10939925,10939926,10939927,10939928,10939929,10939930,10939931,10939932,10939933,10939934,10939935,4970678,4970679,4970680,4970706,4971024,4971025,4971026,4971027,4971028,4971084,4971085,4971086,4971087,4971088,4971089,4971090,4971091,4971092,4971093,4971094,8066992,8067169,8067170,8067171,8067193,8067194,8067366,10437410,8067756,8067757,8067814,8067815,10437745,8067910,4969364,4969365,4969366,4969367,4969368,4969369,4969370,10939116,10939117,10939118,10939119,10939120,10939121,10939122,10939123,10939124,10939125,10939429,10939468,10939469,10939470,10939471,10939472,10939473,10939474,10939475,8068814,8068815,8068816,8068817,8068818,8068819,8068821,8068822,8065123,10931659,10931660,10931767,10931826,10931827,10931828,10931829,10931830,10931831,10931834,10931835,10931836,10931837,10931838,10931839,10931840,10931841,10931842,10932095,8065771,10932151,4967027,4967028,4967029,8065879,8065919,8065920,8065921,8066065,8066066,8066122,8066123,8066124,8066125,8066126,8066127,8066128,8066129,8066130,8066131,8066132,8066133,8066134,8066135,8066136,4967992,4967993,4967994,4967995,11049799,11049800,10942754,10942762,10942763,10943148,10943186,10943187,10943188,10943189,10943190,10943191,10943329,3655525,3655526,10940660,10940942,10940943,10940944,10940945,10940946,10940947,10940948,10940949,10940950,10940951,10940952,10940953,10940954,10940955,10940956,10940957,3656286,3656287,3656288,3656289,3656290,3656291,3656292,3656293,3656294,3656295,3656296,3656739,10942016,10942057,10942058,10942096,10942097,10942098,10942297,10942403,10942404,10622962,10622963,10622964,10622965,10622966,10622967,10622968,10622969,10622970,10622971,10622972,10622973,10622974,10622975,10622976,10622977,10622978,10622979,10622980,10622981,10622982,10622983,10622984,10622985,10622986,10622987,10622988,10622989,10622990,10622991,10622992,10622993,10622994,10622995,10622996,10622997,10622998,10622999,10623000,10623001,10623002,10623003,10623004,10623005,10623006,10623007,10623008,10623009,10623010,10623011,10623012,10623013,10623014,10623015,10623016,10623017,10623018,10623019,10623020,10623021,10623022,10623023,10623024,10623025,10623026,10623027,10623028,10623029,10623030,10623031,10623032,10623033,10623034,10623035,10623036,10623037,10623038,10623039,10623040,10623041,10623042,10623043,10623044,10623045,10623046,10623047,10623048,10623049,10623050,10623051,10623052,10623053,10623054,10623055,10623059,10623064,10623065,10623658,10624539,10622187,10622197,10622217,10622224,10622225,10622235,10622772,10622872,10622873,10622877,10622878,10622879,10622880,10622881,10622882,10622883,10622884,10622885,10622886,10622887,10622888,10622889,10622890,10622891,10622892,10622893,10622894,10622895,10622896,10622897,10622898,10622899,10622900,10622901,10622902,10622903,10622904,10622905,10622906,10622907,10622908,10622909,10622910,10622911,10622912,10622913,10622914,10622915,10622916,10622917,10622918,10622919,10622920,10622921,10622922,10622923,10622924,10622925,10622926,10622927,10622928,10622929,10622930,10622931,10622932,10622933,10622934,10622935,10622936,10622937,10622938,10622939,10622940,10622941,10622942,10622943,10622944,10622945,10622946,10622947,10622948,10622949,10622950,10622951,10622952,10622953,10622954,10622955,10622956,10622957,10622958,10622959,10622960,10622961,10620107,10620123,10620124,10620125,10620126,10620127,10620129,10620132,10620133,10620134,10620139,10620143,10620144,10620145,10620146,10620147,10620148,10620149,10620150,10620151,10620152,10620153,10620154,10620155,10620156,10620157,10620158,10620159,10620160,10620161,10620162,10620163,10620164,10620165,10620166,10620167,10620168,10620169,10620170,10620171,10620172,10620173,10620174,10620175,10620176,10620177,10620178,10620179,10620180,10620181,10620182,10620183,10620184,10620185,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620207,10620208,10620209,10620210,10620211,10620212,10620213,10620214,10620215,10620216,10620217,10620218,10620219,10620220,10620221,10620222,10620223,10620224,10620225,10620226,10620227,10620228,10620229,10620230,10620231,10620232,10620233,10620234,10620235,10620236,10620237,10620238,10620239,10620240,10620241,10620242,10620243,10620244,10620245,10620246,10620247,10620248,10620249,10620250,10620251,10620252,10620253,10620254,10620255,10620256,10620257,10620258,10620259,10620260,10620261,10620262,10620263,10620264,10620265,10620266,10620267,10620268,10620269,10620270,10620271,10620272,10620273,10620274,10620275,10620276,10620277,10620278,10620279,10620280,10620281,10620282,10620300,10620306,10921970,10922073,10922074,10922075,10922076,10922077,10922078,10922079,10565152,10565153,10614072,10611286,10611287,10611360,10611362,10614403,10614404,10614405,10614406,10614538,10614595,10611758,10611761,10614849,10611984,10612005,10612006,10612009,10612161,10612166,10612167,10612223,10612224,10612233,10612264,10612270,10609348,10609350,10609351,10609352,10609356,10609357,10609358,10609359,10609362,10609363,10609367,10609376,10609377,10609378,10609379,10609385,10609386,10609400,10609707,10609724,10613034,10613077,10610086,10610093,10613164,10613165,10613173,10613292,10613326,10613351,10610351,10613356,10613357,10613455,10613519,10613589,10613610,10613613,10613630,10610694,10564864,10564881,10610791,10610840,10517329,10517330,10517331,10517332,10517398,10517399,10517400,10517401,10517699,10517700,10517701,10517702,10517703,10517704,10517705,10517706,10517707,10517708,10517709,10517710,10517711,10517712,10517713,10517758,10517759,10517760,10517761,10517762,10517763,10517764,10517765,10517766,10517767,10517768,10517769,10517770,10517771,10517772,10517773,10517774,10517775,10517776,10517777,10517778,10420083,10471357,10471358,10471359,10471360,10471361,10471362,10471363,10471364,10471568,10471569,10471570,10471571,10471572,10471573,10471574,10471575,10471576,10471577,10471578,10471579,10471580,10471581,10471582,10471583,10463583,10471584,10463584,10471585,10463585,10471586,10463586,10471587,10471588,10471589,10471590,10471591,10471592,10471593,10471594,10471595,10471596,10471597,10471598,10471599,10471600,10471601,10471602,10471603,10471604,10471605,10471606,10471607,10471608,10471609,10471610,10471611,10471612,10471613,10471614,10471615,10471616,10471617,10471618,10471619,10471620,10471621,10471622,10471623,10471624,10471625,10471626,10471627,10471628,10471629,10471630,10471631,10471632,10471633,10471634,10471635,10471636,10471637,10471638,10471639,10471640,10471641,10471642,10471643,10471644,10471645,10471646,10471647,10471648,10471649,10471650,10471651,10471652,10471653,10471654,10471655,10471656,10471657,10471658,10471659,10471660,10471661,10471662,10471663,10471664,10471665,10471666,10471667,10471668,10471669,10471670,10471671,10471672,10471673,10471674,10471675,10471676,10471677,10471678,10471679,10471680,10471681,10471682,10471683,10471684,10471685,10471686,10471687,10471688,10471689,10471690,10471691,10471692,10471693,10471694,10471695,10471696,10471697,10471698,10471699,10471700,10471701,10471702,10471703,10471704,10471705,10471706,10471707,10471708,10471709,10471710,10471711,10471712,10471713,10471714,10471715,10471716,10471717,10471718,10471719,10471720,10471721,10471722,10471723,10471724,10471725,10471726,10471727,10471728,10471729,10471730,10471731,10471732,10471733,10471734,10471735,10471736,10471737,10471738,10471739,10471740,10471741,10471742,10471743,10471744,10471745,10471746,10471747,10471748,10471749,10471750,10471751,10471752,10471753,10471754,10471755,10471756,10471757,10471758,10471759,10471760,10471761,10471762,10471763,10471764,10471765,10471766,10471767,10471768,10471769,10471770,10471771,10471772,10471773,10471774,10471775,10471776,10471777,10471778,10471779,10471780,10471781,10471782,10471783,10471784,10471785,10471786,10471787,10471788,10471789,10471790,10471791,10471792,10471793,10471794,10471795,10471796,10471797,10471798,10471799,10471800,10471801,10471802,10471803,10471804,10471805,10471806,10471807,10471808,10471809,10471810,10471811,10471812,10471813,10471814,10471815,10471816,10471817,10471818,10471819,10471820,10471821,10471822,10471823,10471824,10471825,10471826,10471827,10471828,10471829,10471830,10471831,10471832,10471833,10471834,10471835,10471836,10471837,10471838,10471839,10471840,10471841,10471842,10471843,10471844,10471845,10471846,10471847,10471848,10471849,10471850,10471851,10471852,10471853,10471854,10471855,10471856,10471857,10471858,10471859,10471860,10471861,10471862,10471863,10471864,10471865,10471866,10471867,10471868,10471869,10471870,10471871,10471872,10471873,10471874,10471875,8563476,8563477,8563478,8563479,10470212,10470213,10470214,10470215,10470216,8563549) 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'