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,10989242,7068605,7068606,7068724,7068759,7068765,7068769,7068770,8569769,8569770,8569776,7068807,7068812,8066941,8066942,8066943,8066944,8066945,8066946,8066954,8066955,8066956,8066957,8066958,8066959,10963638,10963639,7074103,7074104,10437402,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,10961928,10961929,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,10972606,10972607,10972608,10972609,10972610,10931538,10931539,7072264,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,7064725,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,10961223,10961224,10961225,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,10971537,10971538,10971539,10971540,10971541,10971542,10971543,10971544,10971545,10971546,10971547,10971548,10971549,8063947,10984617,10984618,10984619,10984620,10984621,10984622,10984623,10984624,10984625,10984626,10984627,10984628,10984629,10971721,10971722,10971723,10971724,10971728,10971729,10971730,10971736,10971737,10971738,10971739,10971740,10971741,10971742,10971743,10971744,10971745,10971746,10971747,10971748,10971749,10971750,10971751,10971752,10971753,10971754,10971755,10971756,10971757,10971758,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,8861278,10972068,10972069,10972070,10972071,10972072,10972073,10972074,10972075,10972076,10972077,10972099,10972192,10972193,10972194,10972195,10972196,10972197,10972198,10972199,10972200,10972201,10972202,10972203,10972204,10972205,10972206,10972207,10972208,10972209,10972210,10972211,10972212,10972213,10972214,10972215,10972216,10972217,10972218,10972219,10972220,10972221,10972222,10972223,10972224,10972225,10972226,10972227,10972228,10972229,10972230,10972231,10972232,10972233,10972234,10972235,10972236,10972237,10972238,10972239,10972240,10972241,10972242,10972243,10972244,10972245,10972246,10972247,10972248,10972249,10972250,10972251,10972252,10972253,10972254,10972255,10972256,10972257,10972258,10972259,10972260,10972261,10972262,10972263,10972264,10972265,10972266,10972267,10972268,10972269,10972270,8861545,7071644,10943380,8970215,10972457,10972458,10972459,10972460,10972461,10972462,10972463,10972464,10972465,10972466,10972467,10972468,10972469,10972470,10972471,10972472,10972473,10972474,10972475,10972476,10972477,10982500,10982501,10982502,10982503,10982504,10982505,10982506,10982507,10982508,10982509,10982510,10982511,7068828,10982512,10982513,10982514,7068830,10982515,10982516,10982517,10982518,10982519,10982520,7068836,10982521,10982522,7068838,10982523,10982524,10982525,10982526,10982527,7068843,10982528,10982529,10982530,10982531,10982532,10982533,10982534,7068850,10982535,10982536,10982537,10982538,10982539,10982540,10982541,10982542,7068858,10982543,10982544,10982545,10982546,10982547,10982548,10982549,7068865,10982550,10982551,10982552,10982553,10982554,10982555,10982556,10982557,10982558,10982559,7068875,10982560,10982561,10982562,10982563,10982564,10982565,10982566,10982567,10982568,10982569,10982570,10982571,10982572,10982573,10982574,10982575,10982576,10982577,10982578,10982579,10982580,7068897,10982581,10982582,10982583,10982584,10982585,10982586,10982587,10982588,10982589,10982590,10982591,10982592,10982593,10982594,10982595,10982596,10982597,10982598,10982599,10982600,10982601,7068968,10940719,10940720,7069183,7069184,7069185,7069233,7069237,7069238,7069269,7069270,7069271,7069272,7069273,7069274,7069275,7069276,7069278,10944862,10970211,10970212,10970213,10970214,10970215,10970216,10970217,10970218,10970219,10970220,10970221,10970222,10970223,10970224,10970225,10983732,10983757,10983758,10983766,10983811,10983812,10983813,10983814,10983815,10983816,10983817,10983818,10983819,10983820,10983821,10983822,10983823,10983824,10983825,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073517,8073518,8073519,8073520,10971459,10971460,10971461,10971462,10971463,10971464,10971465,10971466,10971467,10971468,10971469,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,10928558,10928599,10928615,10618213,10621990,10621991,10621992,10622012,10622013,10622104,10617104,10622105,10617105,10622656,10622662,8569798,8569804,8569809,8569810,10620300,10620301,10620303,10615313,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620408,10620409,10620410,10964949,10964950,10620426,10930757,10930758,10930778,10621116,10621119,10621120,10621132,10621146,10621150,10621162,10621265,10621266,10621273,10621274,10621284,10621288,10621289,10621290,10621291,10621323,10621324,10621375,10621376,10621377,10621378,10621379,10621380,10559701,6666292,7058822,8863308,8863334,8863335,8863336,8863337,8863338,8863339,8863375,8863376,8863422,8863423,8863424,8863521,8863522,8863523,8863524,8863525,8863526,8863527,8863715,10513400,7056350,7056367,7056384,7056385,7056398,7056411,7056422,7056454,7056455,7056473,7057006,7057017,7057018,7057019,7057099,7057107,10512903,10418108,10419187,10463023,10467125,10471128,10471129,10467146,4971646,10469527,10463587,10463588,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,8917181,8917192,4972429,10468180,10468185,10468186,10468197,10468199,10466206,10466207,10466208,10466209,10468210,10466210,10468215,10468217,10468218,10466303,10466304,10466310,10466311,10462312,10466312,10462313,10466343,10466344,10466345,10466346,10466402,10466403,10466404,10466405,10462406,10462407,10462408,10462426,10462427,10462428,10462472,10462473,10468480,10462581,10462582,10462583,8917793,10466850,10627328,10630229,10626096,10631395,10522459,10522460,10522461,10522466,10522467,10522468,10421394,10422049,10422063,10421071,10421096,10421097,10421099,10422115,10422118,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'