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(4970679,4970743,10989389,7066050,10950679,10950727,10950732,10950747,10950748,7066144,7066145,7066269,10847513,8067931,10939409,10939410,10939411,10939412,8911955,8911963,10843685,8910239,8910240,8910241,8910652,8910668,8910669,8910670,8907923,8615630,10101296,8860369,8860370,8860372,8860373,8860374,8860375,8860376,8860377,8860378,8905969,10623502,8906764,8906812,8906883,8906884,10838792,10838837,10838891,10838910,10838943,10838944,10838946,10838947,10838949,10838950,10838952,10838958,8905039,10617135,10617145,10617146,10617158,10617168,8905115,8905116,8905221,10617322,10622409,10622446,8905372,8905373,11045038,8905548,8905549,8905550,8905551,8905557,8905560,8905563,8905566,8905567,8905569,8905570,8905729,8905837,8905838,8905839,10614973,10614974,10614975,10615102,10615106,10615107,10615108,10615109,10615113,10615114,10615115,10615116,10615129,10615133,10615551,10615556,11043201,11043202,11043203,10930848,10930849,10616074,10616089,10616548,10616572,10616576,8611282,10616610,10616611,8611308,8611319,8611356,8611358,8611359,10616684,8611374,10616913,10616919,10616920,10613982,10611041,10611063,10614068,10611086,10611100,10611102,10611132,10614327,10614328,10614329,10714144,10714145,10611338,10611339,10614339,10614354,10614632,10611684,6666256,10612053,10609157,10609213,10612348,10609395,8862527,8862528,10612723,10612725,10612735,10612736,10612738,10612754,10612755,10612759,10612760,10612761,10612762,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612805,10612809,10612811,10612812,10612813,10612815,10612816,10612817,10612869,10612963,10612973,10612977,10612978,10609979,10612982,10612998,10612999,10613000,10613001,10613002,10613003,10613004,10613005,10613006,10613007,10613008,10610014,10613019,10613020,10613023,10613027,10613029,10613031,10613034,10613036,10613055,10613056,10613057,10613058,10613059,10613060,10613061,10613062,10613063,10613064,10613065,10613066,10613067,10613068,10613069,10613070,10613071,10613072,10613073,10613074,10613075,10613076,10613077,10613078,10613079,10613080,10613081,10613082,10613083,10613084,10613090,10613092,10613119,10613187,10610346,10613350,10613352,10613371,10610696,10613798,10610834,10610908,10610942,7014953,7014954,7014955,7014956,7014957,7014958,7014959,7014960,7014961,7014962,7014963,7014964,7014965,7014966,7014967,7014968,7014969,7014970,7014971,7014972,7014973,7014974,7014975,7014976,7014977,7014978,7014979,7014980,7014981,7014982,7014983,7014984,7014985,7014986,7014987,7014988,7014989,7014990,7014991,7014992,7014993,7014994,7014995,7014996,7014997,7014998,7014999,9169345,7015000,7015001,7015002,7015003,7015004,7015005,7015006,7015007,7015008,7015009,7015010,7015011,7015012,7015013,7015014,7015015,7015016,7015017,7015018,7015019,7015020,7015021,7015022,7015023,7015024,7015025,7015026,7015027,7015028,7015029,7015030,7015031,7015032,7015033,7015034,7015035,7015036,7015037,7015038,7015039,7015040,7015041,7015042,7015043,7015044,7015045,7015046,7015047,7015048,7015049,7015050,7015051,7015052,7015053,7015054,7015055,7015056,7015057,7015058,7015059,7015060,7015061,7015062,7015063,7015064,7015065,7015066,7015067,7015068,7015069,7015070,7015071,7015072,7015073,7015074,7015075,7015076,7015077,7015078,7015079,7015080,7015081,7015082,7015083,7015084,7015085,7015086,7015087,7015088,7015089,7015090,7015091,7015092,7015093,7015094,7015095,7015096,7015097,7015098,7015099,7015100,7015101,7015102,7015103,7015104,7015105,7015106,7015107,7015108,7015109,7015110,7015111,7015112,7015113,7015114,7015115,7015116,7015117,7015118,7015119,7015120,7015121,7015122,7015123,7015124,7015125,7015126,7015127,7015128,7015129,7015130,7015131,7015132,7015133,7015134,7015135,7015136,7015137,7015138,7015139,7015140,7015141,7015142,7015143,7015144,7015145,7015146,7015147,7015148,7015149,7015150,7015151,7015152,7015153,7015154,7015155,7015156,7015157,7015158,7015159,7015160,7015161,7015162,7015163,7015164,7015165,7015166,7015167,7015168,7015169,7015170,7015171,7015172,7015173,7015174,9169848,9169850,9169877,10416231,10416232,10416233,10416234,10416235,10416236,10416237,10416238,10416239,10416240,10416241,10416242,10416243,10416244,9168322,10416245,10416246,10416247,10416248,10416249,10416250,10416251,10416252,10416259,10415333,10419475,10419478,10419479,10419482,10419484,10416536,10416546,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10419635,10419636,10419641,10419642,10419643,10419644,10419645,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,9168745,9168746,9168747,9168752,9168756,9168766,9168767,9168785,9168792,9168793,9168794,9168797,9168798,9168817,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10419851,9168933,10418888,10418914,10418915,10418916,10418917,10418918,10418919,7014658,7014659,7014660,7014661,7014662,7014663,7014664,7014665,7014666,7014667,7014668,7014669,7014670,7014671,7014672,7014673,7014674,10418942,7014675,10418943,7014676,7014677,7014678,10418946,7014679,7014680,7014681,7014682,7014683,7014684,7014685,7014686,7014687,7014688,7014689,7014690,7014691,7014692,7014693,7014694,7014695,7014696,7014697,7014698,7014699,7014700,7014701,7014702,7014703,7014704,7014705,7014706,7014707,7014708,7014709,7014710,7014711,7014712,7014713,7014714,7014715,7014716,7014717,7014718,7014719,7014720,7014721,7014722,7014723,7014724,7014725,7014726,7014727,7014728,7014729,7014730,7014731,7014732,7014733,7014734,7014735,7014736,7014737,7014738,7014739,7014740,7014741,7014742,7014743,7014744,7014745,7014746,7014747,7014748,7014749,7014750,7014751,7014752,7014753,7014754,7014755,7014756,7014757,7014758,7014759,7014760,7014761,7014762,7014763,7014764,7014765,7014766,7014767,7014768,7014769,7014770,7014771,7014772,7014773,7014774,7014775,7014776,7014777,7014778,7014779,7014780,7014781,7014782,7014783,7014784,7014785,7014786,7014787,7014788,7014789,7014790,7014791,7014792,7014793,7014794,7014795,7014796,7014797,7014798,7014799,7014800,7014801,7014802,7014803,7014804,7014805,7014806,7014807,7014808,7014809,7014810,7014811,7014812,7014813,7014814,7014815,7014816,7014817,7014818,7014819,7014820,7014821,7014822,7014823,7014824,7014825,7014826,7014827,7014828,7014829,7014830,7014831,7014832,7014833,7014834,7014835,7014836,7014837,7014838,7014839,7014840,7014841,7014842,7014843,7014844,7014845,7014846,7014847,7014848,7014849,7014850,7014851,7014852,7014853,7014854,7014855,7014856,7014857,7014858,7014859,7014860,7014861,7014862,7014863,7014864,7014865,7014866,7014867,7014868,7014869,7014870,7014871,7014872,7014873,7014874,7014875,7014876,7014877,7014878,7014879,7014880,7014881,7014882,7014883,7014884,7014885,7014886,7014887,7014888,7014889,7014890,7014891,7014892,7014893,7014894,7014895,7014896,7014897,7014898,7014899,7014900,7014901,7014902,7014903,7014904,7014905,7014906,7014907,7014908,7014909,7014910,7014911,7014912,7014913,7014914,7014915,7014916,7014917,7014918,7014919,7014920,7014921,7014922,7014923,7014924,7014925,7014926,7014927,7014928,7014929,7014930,7014931,7014932,7014933,7014934,7014935,7014936,7014937,7014938,7014939,7014940,7014941,7014942,7014943,7014944,7014945,7014946,7014947,7014948,7014949,7014950,7014951,7014952,10468877,10468882,10468883,10468886,10468901,8549545,8549546,10471173,10471175,8549811,8549928,8549981,8550054,8550055,8550060,10469526,10469528,10469529,10469530,10469531,10469532,10469533,10469534,10469535,10469536,10469537,10469538,9167556,9168127,10468838,10468839,10468840,10468841,10468842,10468845,10468846,10468847,10468848,10468849,10468850,10468851,9168291,10170922,10877489,10877491,10877579,7000835,10625364,10162148,10626441,10877228,10533117,10537572,10537573,10537574,10421549,10486267,10486268,10486269,10486270,10486271,10486272,10486273,10486274,10486275,10488276,10486276,10488277,10486277,10488278,10486278,10486279,10486280,10486281,10486282,10486283,10486284,10486285,10486286,10486287,10486288,10486289,10486290,10486291,10486292,10486537,10476338,10476339) 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'