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(7075993,7068724,7068759,7068769,7068770,8569769,8569770,8569776,7068807,7068812,7068830,8569809,8569810,7068836,7068838,10940465,7068843,7068850,10940474,10940475,10940479,7068858,7068865,7068875,7068897,8066941,8066942,8066943,8066944,8066945,8066946,8066954,8066955,8066956,8066957,8066958,8066959,7074104,10977285,10977321,10977322,10977323,10977324,10977325,10977326,10977327,10977328,10977329,10977443,10977444,10977445,10977468,10977469,10977470,10977471,10977472,10977473,10977474,10977475,10977476,10977477,10977478,10977479,10977480,10977481,10977482,10977483,10977484,10977485,10977486,10977487,10977488,10977489,10977490,10977491,8067952,8067953,8067954,8067955,8067956,8067957,8067958,8067959,8067960,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068067,8068068,8068069,8068070,8068071,8068072,8068073,8068074,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068140,8068141,8068142,10961941,10961942,10961946,8068253,8068254,8068255,8068306,8068307,8068308,8068309,8068398,8068449,8068450,8068451,8068493,8068494,8068495,8068496,8068497,8068498,8068499,8068500,8068501,8068502,8068503,8068504,8068505,8068506,8068507,8068508,10988308,10988309,10988343,10988344,10988345,10972977,10972978,10972979,10972980,10972981,10972982,10972983,10972984,10972985,10972986,10972987,10972988,10972989,10972990,10972991,10972992,10972993,10972994,10972995,10972996,10972997,10972998,10972999,10973000,10973001,10973002,10973003,10973004,10973005,10973006,10973007,10973008,10973009,10973010,10973011,10973012,10973013,10973014,10973015,10973016,10973017,10973018,10973019,10973020,10973021,10973022,10973023,10973024,10973025,10973026,10973027,10973028,10973029,10973030,10973031,10973032,10973033,10973034,10973035,10973036,10973037,10973038,10973107,10973108,10973109,10973188,8066198,8066199,8066200,8066202,8066209,8066210,8066218,8066219,8066220,8066221,8066222,8066223,8066268,8066269,8066270,8066271,8066286,8066287,8066288,8066289,8066290,8066306,8066307,8066468,8066498,8066499,8066500,8066501,8066502,8066503,8066504,8066505,8066506,10984620,10984621,10984622,10984623,10984624,10984625,10984626,10984627,10984628,10984629,8063947,10971721,10971722,10971723,10971724,10971728,10971729,10971730,10971736,10971737,10971738,10971739,10971740,10971741,10971742,10971743,10971744,10984745,10971745,10984746,10971746,10984747,10971747,10984748,10971748,10971749,10971750,10971751,10971752,10971753,10971754,10971755,10971756,10971757,10971758,10942746,10971816,10971817,10971818,10971819,10971820,10971821,10971822,10971823,10971824,10971825,10971826,10971827,10971828,10971829,10971830,10971831,10971832,10971833,10971865,10971866,10971867,10971868,10971869,10971870,10971871,10971872,10971873,10971874,10971875,10971876,10971877,10971878,10971879,10971880,10971881,10971882,10971883,10971884,10971885,10971886,10971887,10971888,10971889,10971890,10971891,10971892,10971893,10971894,10971895,10971896,10971897,10971898,10971899,10971900,10971901,10971902,10971903,10971904,10971905,10971906,10971907,10971908,10971909,10971910,10971911,10971993,10971999,10972000,10972001,10972002,10972003,10972004,10972005,10972006,10972007,10972008,10972036,10972037,10972038,10972068,10972069,10972070,10972071,10972072,10972073,10972074,10972075,10972076,10972077,10972099,7071644,10972606,10972607,10972608,3655568,3655569,3655570,3655571,3655572,3655573,3655574,10940719,10940720,7069237,10970211,10970212,10970213,10970214,10970215,10970216,10970217,10970218,10970219,10970220,10970221,10970222,10970223,10970224,10970225,7069597,3656206,3656207,3656208,3656265,3656266,3656279,10983732,10983734,10983735,10983736,10983737,10983738,10983740,10983741,10983742,10983757,10983758,10983766,10983811,10983812,10983813,10983814,10983815,10983816,10983817,10983818,10983819,10983820,10983821,10983822,10983823,10983824,10983825,10983826,10983827,10983828,10983829,10983830,10983831,10983832,10983833,10983834,10983835,10983836,10983837,10983838,10983839,10983840,10983841,10983842,10983843,10983844,10983845,10983846,10983847,10983848,10983849,10983850,10983851,10983852,10983853,10983854,10983855,10983856,10983857,10983858,10983859,10983860,10983861,10983862,10983863,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,10971459,10971460,10971461,10971462,10971463,10971464,10971465,10971466,8073517,10971467,10971468,8073518,8073519,10971469,8073520,10971470,10971471,10971472,10971473,10971474,10971475,10971476,10971477,10971478,10971479,10971480,10971481,10971482,10971483,10971484,10971485,10971486,10971487,10971488,10971489,10971490,10971491,10971492,10971493,10971494,10971495,10971496,10971497,10971498,10971499,10971500,10971501,10971502,10971503,10971504,10971505,10971506,10971507,10971508,10971509,10971510,10971511,10971512,10971513,10971514,10971515,10971516,10971517,10971518,10971519,10971520,10971521,10971522,10971523,10971524,10971525,10971526,10971527,10971528,10971529,10971530,10971531,10971532,10971533,10971534,10971535,10971536,11048752,10971537,10971538,10971539,10971540,10971541,10971542,10971543,10971544,10971545,10971546,10971547,10971548,10971549,10984617,10984618,10984619,10623087,10623088,10623089,10982106,10982107,10982108,10982109,10982288,10982289,10982290,10982291,10982292,10982293,10982294,10982295,10982296,10982297,10982298,10982299,10982300,10982301,10982302,10982303,10982304,10982483,10982484,10982485,10982486,10982487,10982488,10982489,10982490,10982491,10982492,10982493,10982494,10982495,10982496,10982497,10982498,10982499,10982500,10982501,10982502,10982503,10982504,10982505,10982506,10982507,10982508,10982509,10982510,10982511,10982512,10982513,10982514,10982515,10982516,10982517,10982518,10982519,10982520,10982521,10982522,10982523,10982524,10982525,10982526,10982527,10982528,10982529,10982530,10982531,10982532,10982533,10982534,10982535,10982536,10982537,10982538,10982539,10982540,10982541,10982542,10982543,10982544,10982545,10982546,10982547,10982548,10982549,10982550,10982551,10982552,10982553,10982554,10982555,10982556,10982557,10982558,10982559,10982560,10982561,10982562,10982563,10982564,10982565,10982566,10982567,10982568,10982569,10982570,10982571,10982572,10982573,10982574,10982575,10982576,10982577,10982578,10982579,10982580,10982581,10982582,10982583,10982584,10982585,10982586,10982587,10982588,10982589,10982590,10982591,10982592,10982593,10982594,10982595,10982596,10982597,10982598,10982599,10982600,10982601,10621990,10621991,10621992,10622012,10980613,10977723,10977724,10977725,10977726,10977727,10977728,10977729,10977730,10977731,10977732,10977733,10977734,10977735,10977736,10977737,10977879,10977906,10977907,10977908,10977909,10977910,10977911,10977912,10977913,10977914,10977915,10977916,10977917,10977918,10977919,10977920,10977921,10977922,10620300,10620303,10615313,10620321,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620408,10620409,10620410,10620426,10930733,10930737,10930757,10930758,10621116,10621119,10621120,10621132,10621146,10621150,10621162,10621265,10621266,10621273,10621274,10621284,10621288,10621289,10621290,10621291,10621323,10621324,10621375,10621376,10621377,10621378,10621379,10621380,10926923,10926924,7058755,8863174,8863308,8863334,8863335,8863336,8863337,8863338,8863339,8863375,8863376,8863422,8863423,8863424,8863522,8863523,8863524,8863525,8863526,8863527,8863715,7056350,7056367,7056384,7056385,7056398,7056411,7056422,7056454,7056455,7056473,7057017,7057018,7057019,7057057,7057096,7057110,7057311,7057312,10418108,10463023,10467125,10467146,4971646,10469527,10469587,10463587,10463588,10469602,10463648,10463649,10463650,10463651,10463652,4971953,10465682,10465683,4971959,10465684,4971960,10465685,4971975,4971993,4972006,10463730,4972007,10463741,10463742,10463743,10463744,10465759,10465760,4972043,4972044,10463768,4972045,10463769,10465770,10463770,10463771,10465796,10465797,10465798,10465799,10465800,4972093,4972125,4972126,10465857,10465858,10465859,10465860,10463876,10463877,10465913,10469967,10469968,10469969,10469972,10469973,10469974,8917181,8917192,4972429,10468180,10468185,10468186,10468197,10468199,10466206,10466207,10466208,10466209,10468210,10466210,10468215,10468217,10468218,10466303,10466304,10466310,10466311,10462312,10466312,10462313,10462340,10462342,10462343,10466343,10466344,10466345,10466346,10462347,10462392,10462393,10462394,10466402,10466403,10466404,10466405,10462406,10462407,10462408,10462426,10462427,10462428,10462472,10462473,10462581,10462582,10462583,8917793,10466850,10629686,10629687,10629688,10627328,10522404,10522459,10522460,10522461,10522466,10522467,10522468,10421394,10421071,10421096,10421097,10421099,10421202,10421203) 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'