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(7201611,7201613,8595074,8595075,8595106,8595139,8595192,8628214,8628265,7202120,7202145,7202160,7202194,7202195,7202222,7202233,7202247,7202256,7202270,7202283,7202294,8569568,8569569,5654684,7202638,7202640,7065921,7065944,7065945,7065946,7065980,7066063,7066064,7066065,7066066,7066067,7066068,7066069,7066139,7066177,7066210,7066211,7066212,8573313,8573314,8573315,7200626,7200638,7200647,7200650,7200659,7200665,7200676,7200683,7200685,8067910,8067911,8067912,7200691,7200700,8067937,7200881,7200890,7201081,7201335,3238541,7198715,7198738,7198758,7198764,7198897,7199145,7199182,10101554,7199775,7199776,7199777,7199778,7200014,7200071,8910077,7200406,7200510,7200511,7200512,10839143,8907594,8907597,8907598,8907599,8907600,8907603,8907604,8907605,8907606,8907607,8907608,8907609,8907610,8907631,8907633,8907634,8907635,8907669,8907675,7197905,10100077,10100078,7198427,3922812,8905722,8905723,8905724,3923414,3923415,3923416,7196274,7196275,3923444,3923445,7196301,7196302,7196342,3923492,3923493,7196353,7196354,7196461,7196469,7196584,7196671,8906891,8906892,8906893,8906894,8906895,8906896,8860393,8907070,10838811,10838843,10838895,10838940,3581872,3581873,8633398,8540638,8540639,8540640,8540641,8540642,8904200,8904211,8904212,8904213,8904214,8904215,8904216,8904217,8904218,8904221,8904268,8904270,8904274,8904275,8904276,8904286,8904331,8904335,8904336,8904338,8904340,8904342,8904343,8904345,8904360,8904379,8904380,8611317,8611438,8611439,8611440,10427114,8905165,8905166,8905264,10619898,10619899,10619900,10619901,10619902,10619903,10619904,10619905,10619906,8905353,8905354,8905355,8905356,8905357,8905358,8905359,8905360,8905361,8905362,8905363,8905364,8905365,10927512,10927515,8575738,10617219,10617220,10617222,10622365,8609594,10617457,10617458,10617459,10617460,10617461,10617462,10617463,10617464,10617465,10617513,10617514,10617515,10617516,10617517,10615168,10615169,10615170,10615171,10615172,10615345,10615346,10615347,10615348,10615349,10615350,10925882,10925883,8573997,8573998,8573999,8574000,8574001,10616005,10616007,10616008,10616009,10616010,10616011,10616012,10616013,3229057,3229058,3229059,3229060,3229061,3229062,3229063,3229064,3229065,3229066,3229067,3229068,3229069,3229070,3229071,3229170,3229175,8575134,8575135,8575136,8575137,8575138,8575155,8575156,8575157,8575158,8575159,8575160,8631635,10616655,10616656,10616657,10950692,10950739,8583658,8583659,8583703,8583704,8853181,8853182,8853183,8853184,8853185,8853186,8853187,8853188,8853189,8853190,8853191,8853192,8853193,8853194,8853195,8853196,8853197,8853198,8853199,8853200,8853201,8853202,8853203,8853204,8853205,8853206,8853243,10714154,10714203,10614506,10614507,10614508,10614509,10614510,10614511,10614635,10614636,10611971,10611972,10611973,10611974,10611975,10611976,10611977,10611978,10611979,10611980,10611981,10611982,10611983,10611984,10611985,10611986,10611987,10611988,10611989,10611990,10611991,10611992,10611993,10611994,10611995,10611996,10611997,10611998,10611999,10612000,10612001,10612002,10612003,10612004,10612005,10612006,10612007,10612008,10612009,10612010,10119815,10612296,8862510,8566589,8566609,7017914,7017915,9220282,9220283,9220285,8567067,8567075,8863121,8863122,10613700,10613741,10613742,8863717,8863718,6673507,6673508,6673570,6673571,6673572,7055533,6673573,6673574,10117682,10117683,10117684,10117861,10117862,10117863,9169842,9169843,10118083,10118084,10118085,10118086,10118087,6674145,9169966,9169967,9169968,9169969,9169970,9169971,9169972,9169973,9169974,9169975,9169976,9169977,9169978,9169979,9169980,9169981,9169982,9169983,9169984,9169985,9169986,6674199,7015700,7015701,6674264,6674265,6674301,10118317,6674333,6674334,6674335,10118611,10118612,10118613,10118668,10118669,10118670,10118671,10118672,10118673,10118679,10118680,10118950,10118951,9168368,10416331,10416332,10416377,10416380,9168492,9168493,9168494,6672720,10418498,10419499,10418499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,6672803,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10419538,10419539,10419540,10419541,10419542,10418543,10419543,10419544,10418544,10419545,10419546,10419547,10418547,10419548,10418548,10419549,10418549,10419550,10418550,10419551,10418551,10419552,10419553,10419554,10419555,10419556,10419557,10419558,10419559,10419560,10419561,10419562,10419563,10419564,10419565,10419566,10419567,10419568,10419569,10419570,10419571,10419572,10419573,10419574,10419575,10419576,10419577,10419578,10419579,10419580,10419581,10419582,10419583,10419584,10419585,10419586,10419587,10419588,10419589,10419590,10419591,10419592,10419593,10419594,10419595,10419596,10419597,10419598,10419599,10419600,10419601,10419606,6672891,10419609,10416611,10419613,10419617,10416619,10419626,10419628,10419631,10419636,10419640,10419645,10416650,10419650,10419655,10419658,10416660,10419665,10419667,9168819,10416775,6673064,6673065,6673066,6673067,6673106,10418891,10417036,10417037,10417038,10417039,10417040,10417045,10417051,10417052,6673338,10419178,10419179,10419180,10419181,10419182,10419183,10419184,10419185,10419186,9169276,9169277,9169278,10471176,10471177,10471178,10471179,10471180,10471181,10471182,10471183,10471184,10471185,10471186,10471187,10471188,10471189,10471190,10471191,10471192,10471193,10471194,10471195,10471196,10471197,10471198,10471199,10471200,10471201,10471202,10471203,10471204,10471205,10471206,10471207,10471208,10471209,10471210,10471211,10471212,10471213,10471214,10471215,10471216,10471217,10471218,10471219,10471266,10471267,10471268,10471269,10471270,10471271,10471272,10471273,10471274,10471275,10471276,10469279,10469280,8549927,8549971,10467471,8550071,8550072,10469518,8550105,10469574,8550152,10469575,10469576,10469577,10469578,10469579,10469580,10469581,10469582,10469583,10469584,10469585,10469586,10469587,10469588,10469589,10469590,10469591,10469592,10469593,10469594,10469595,10469596,10469597,10469598,10469599,10469600,10469601,10469602,10469603,10469604,10469605,10469606,10469607,10469608,10469609,10469610,10469611,10469612,10469613,10469614,8550261,8550268,10467709,10467891,10467892,10467893,10467894,10467895,10468238,10468239,10468240,10468241,10468242,10468436,9167989,9167990,9167991,9167992,9167993,9168102,9168103,9168104,9168105,10470723,10468766,10468779,10468780,10468841,10468848,10883493,10883494,10883495,10883496,10883599,10883600,10883601,10883602,10883603,10883632,10883633,10883634,10883635,10883636,10883637,10883638,10883639,10883640,10883641,10883642,10883643,10883644,10883645,10883646,10883647,10883648,10883649,10883650,10883651,10883652,10883653,10883654,10883655,10883790,10883791,10883792,10884003,10884004,10884005,10884006,10884007,10884008,10884020,10884047,10884052,10889053,10884053,10889054,10884054,10889055,10889056,10889057,10884062,10884064,10884066,10884069,10884070,10884071,10884072,10884090,10884091,10884092,10884093,10884094,10884095,10884096,10884097,10884098,10884099,10884100,10884101,10884699,10884700,10884701,10884702,10884703,10889717,10884724,10889778,10889779,10889780,10889781,10885061,10885062,10885063,10885064,10885065,10885066,10890176,10890177,10890178,10885312,10887487,10887488,10887489,10887490,10887491,10887492,10887493,7000865,7000866,7000867,10882943,10887987,10887988,10887989,10887990,10883046,10883047,10883048,10164079,10888320,10885555,10885556,10885557,10161868,10161957,10161958,10885960,10885961,10162030,10949013,10162236,10162250,10162251,10162252,10162253,10162254,10162255,10162256,10162257,10162258,10162259,10162260,10162261,10162262,10162263,10162264,10162265,10167445,10167447,10887233,10887234,10887235,10887236,10887237,10882432,10882433,10643549,10643550,10647395,10647396,10647438,10647439,10647512,10647536,10647705,10647706,10647707,10647708,10647709,10424255,10424273,10424281,10424393,10424412,10424429,10421544,10421545,10421546,10421547,10421548,10421549,10424112,10508038,10508039,10424204,10409496,10477209,10477210,10409646,10409658,10496948,10496949,10496950,10496951,10496952,10496953,10496954,10496994,10496995,10496996,10496997,10496998,10496999,10497000,10497001,10478034,10478035,10478036,10478037,10478038,10478039,10478040,10478041,10478042,10478043,10478044,10478045,10478046,10478047,10497047,10478048,10497048,10478049,10497049,10478050,10497050,10478051,10497051,10478052,10497052,10478053,10497053,10497054,10478054,10478055,10410487,10408657,10410915,10410916,10410917,10410918,10406961,10407100,10407126,10407131,10407136) 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'