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(8569568,8569569,3229057,3229058,3229059,3229060,3229061,3229062,3229063,3229064,3229065,3229066,3229067,3229068,3229069,3229070,3229071,3229170,3229175,7065944,7065945,7065946,8575134,8575135,8575136,8575137,8575138,8575155,8575156,8575157,7065980,8575158,8575159,8575160,7066063,7066064,7066065,10950692,7066066,7066067,7066068,7066069,10950739,7066139,7066177,8583658,8583659,7066210,7066211,7066212,8583703,8583704,8575738,8609594,8067910,8067911,8067912,8067937,8573313,8573314,8573315,10939391,10939392,10939421,10939422,8573997,8573998,8573999,8574000,8574001,7201335,3238541,7201611,7201613,8065808,8065809,8065810,8065811,8065812,8065813,8065814,7202120,7202145,7202160,7202194,7202195,7202222,7202233,7202247,7202256,7202270,7202283,7202294,5654684,7202638,7202640,7065921,8910077,7200406,7200510,7200511,7200512,7200626,7200638,7200647,7200650,7200659,7200665,7200676,7200683,7200685,7200691,7200700,7200881,7200890,7201081,10100077,10100078,7198427,7198715,7198738,7198758,7198764,7198897,7199145,7199182,10101554,7199775,7199776,7199777,7199778,11048435,7200014,7200071,7196274,7196275,7196301,7196302,7196342,7196353,7196354,7196461,7196469,7196584,7196671,8906891,8906892,8906893,8906894,8906895,8906896,8907070,10838811,10838843,10838895,10838940,10839143,8907594,8907597,8907598,8907599,8907600,8907603,8907604,8907605,8907606,8907607,8907608,8907609,8907610,8907631,8907633,8907634,8907635,8907669,8907675,7197905,10619898,10619899,10619900,10619901,10619902,10619903,10619904,10619905,10619906,10927512,10927515,8905165,8905166,10617219,10617220,10617222,8905264,8905353,8905354,8905355,8905356,8905357,8905358,8905359,8905360,8905361,8905362,8905363,8905364,8905365,10622365,10617457,10617458,10617459,10617460,10617461,10617462,10617463,10617464,10617465,10617513,10617514,10617515,10617516,10617517,8905722,8905723,8905724,10615168,10615169,10615170,10615171,10615172,10615345,10615346,10615347,10615348,10615349,10615350,10925882,10925883,10616005,10616007,10616008,10616009,10616010,10616011,10616012,10616013,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,10616655,10616656,10616657,10427114,10610966,10610967,10610968,10610969,10610970,10610971,10610972,10610973,10610974,10610975,10610976,10610977,10610978,10610979,10610980,10610981,10610982,10610983,10610984,10610985,10610986,10610987,10610988,10610989,10610990,10610991,10610992,10610993,10610994,10610995,10610996,10610997,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,10609352,10609357,10609359,10609388,10609389,10609393,8862510,7017914,7017915,10609965,10609966,9220282,9220283,9220285,8863121,8863122,10610483,10610484,10610485,10610486,10610487,10610488,10610489,10610490,10610491,10610492,10610493,10610494,10610495,10610496,10610497,10610498,10610499,10613700,10610719,10610721,10610722,10610729,10610730,10610733,10610734,10610736,10610737,10610738,10610739,10613741,10613742,10610745,10610752,8863717,8863718,10610954,7055533,10117682,10117683,10117684,10117861,10117862,10117863,9169842,9169843,10118083,10118084,10118085,10118086,10118087,9169966,9169967,9169968,9169969,9169970,9169971,9169972,9169973,9169974,9169975,9169976,9169977,9169978,9169979,9169980,9169981,9169982,9169983,9169984,9169985,9169986,7015700,7015701,10118317,10118611,10118612,10118613,10118668,10118669,10118670,10118671,10118672,10118673,10118679,10118680,10118950,10118951,9168368,10416331,10416332,10416377,10416380,9168492,9168493,9168494,10418498,10418499,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10415533,10419534,10415534,10419535,10415535,10419536,10415536,10419537,10415537,10419538,10415538,10419539,10419540,10419541,10419542,10418543,10419543,10418544,10419544,10415544,10419545,10419546,10419547,10418547,10419548,10418548,10418549,10419549,10418550,10419550,10419551,10418551,10419552,10419553,10419554,10419555,10419556,10419557,10419558,10419559,10415559,10419560,10419561,10419562,10419563,10419564,10415564,10419565,10419566,10419567,10415567,10419568,10419569,10419570,10415570,10419571,10419572,10419573,10415574,10419574,10419575,10419576,10419577,10419578,10415578,10419579,10419580,10419581,10419582,10415582,10419583,10419584,10419585,10419586,10419587,10419588,10419589,10419590,10419591,10419592,10419593,10419594,10419595,10419596,10419597,10419598,10419599,10419600,10419601,10419606,10419609,10416611,10419613,10419617,10416619,10419626,10419628,10419631,10419636,10419640,10419645,10419650,10416650,10419655,10419658,10416660,10419665,10419667,9168819,10416775,10418891,10417036,10417037,10417038,10417039,10417040,10417045,10417051,10417052,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,10424255,10424273,10424281,10424393,10424412,10424429,10421544,10421545,10421546,10421547,10421548,10421549,10424112,10424204,10477209,10477210,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,10497047,10478047,10497048,10478048,10497049,10478049,10497050,10478050,10497051,10478051,10497052,10478052,10497053,10478053,10497054,10478054,10478055,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'