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(10939537,10962575,7067893,7067894,7067895,7067896,7067897,7067898,7067899,7067900,7067901,10939617,7067902,10939618,7067903,7075912,10939628,7067929,7067937,7067938,10939677,10939694,10939700,10939703,10939772,10939792,10943591,10943592,10939796,10943593,10943594,10943595,10939822,7076127,7076128,7076129,10939848,10939868,10939907,10939908,10939914,10939915,10939916,7068220,7068221,10939940,10940061,7068397,7068398,7068399,7068400,7068401,7068402,4970738,7068403,7068404,10940145,8569453,7068494,7068495,7068496,7068497,10940220,10940221,10940222,10940223,10940224,10940225,10940226,10940227,10940228,7068519,7068520,7068521,7068522,7068523,10940283,10940284,10940285,10940293,10940297,10940298,10940299,10940300,10940301,8569625,8569647,8569731,8569732,8569757,10940507,10940524,7065832,7065837,7065873,8066998,8066999,10963637,8067028,10963674,10963750,10963878,10963879,7066265,7066276,7066348,10437503,7066584,7074632,10964441,10964442,10964443,10964444,10964445,10964446,10964447,10964448,10964449,10964450,8067931,10938673,8067942,8067943,10938787,10938791,10938792,10938794,10938795,10938797,10938832,10938854,7067196,10961933,7067408,10939126,7075414,7075460,7075484,7075485,7075498,10939383,10962360,10962361,7067697,10939439,10939467,10939492,7075778,7075779,10939495,7075783,10939503,10939511,7071829,7064043,7072073,7072074,7072249,7072259,7072263,10960062,7072467,10960404,8065791,10960411,10960412,10960413,10960417,7064733,7064735,7064760,7064761,7064771,7064856,7064863,7064878,10960568,10960569,7064911,7064912,10960604,10960605,10960606,7064926,7064977,7064983,7064984,7064985,7064986,7065004,8066170,8066171,8066177,4967460,7073161,10960851,10960948,4967870,4967871,4967872,10961233,4968076,4968077,4968078,10942534,10942535,10942666,10942671,10942672,10942692,10942693,10942696,10942710,10942712,10942714,10942715,10942734,10942735,10942737,10942743,10942745,10942793,10942799,10942804,10942812,10942817,10942861,10942913,10942992,10942994,7071297,10943018,10958987,10943019,10958988,10958989,10943026,10943044,10943045,10943048,8861260,10943113,10943122,8064554,8064555,8064556,10943248,7071537,10943256,10943257,10943270,10943280,10943290,10943304,10943306,10943308,10943309,8064672,8064673,10943419,10940578,10940580,10944411,10944412,3655602,3655603,3655604,10940633,10944478,10940741,10940742,10940783,10940883,10944725,10944726,10944727,10944728,10944729,10944730,10944731,10944732,10944733,10944734,10944735,10944736,10940969,10940993,10940998,10941002,10941045,10941046,10941047,10941055,10941056,10941057,10941058,10941060,10941061,10941103,10941128,10941161,10941163,10941195,10941226,10941251,10941262,10941278,10941285,10945086,10941296,10945101,7069592,10941383,10941389,10941391,10941400,10941477,7069788,10941512,10941589,10941636,7069926,10941651,10941682,7069986,10941745,10941749,10941791,10941913,10941920,10941926,10941929,10941948,10941961,10941969,10941979,10941984,10942106,10942205,10942210,10942213,10942218,10942219,10942222,10942228,10942229,7070567,10942286,10942304,10942325,10942332,10942335,10942343,10942344,10942346,10942347,10942348,10942350,10942356,10942357,10942358,10942361,10942366,10942367,10942385,10942386,10942390,10942395,10942401,10942410,10942435,8860633,8860634,8860635,10942448,10942477,10942483,10942484,10942489,10623169,10623177,10618183,10928700,10928701,10928703,10928704,10618274,10623490,10623665,10623707,10623708,10623709,10623710,10623711,10623712,10623713,10623714,10623715,10623719,10623720,10623721,10623722,10623724,10623725,10623726,10623727,10623728,10623729,10623730,10623731,10623732,10623733,10623734,10623735,10623736,10623805,10623810,10624548,10624552,10624553,10624554,10624627,10624628,10624632,10624633,10619864,10619865,10619866,10619872,10619873,10619874,10619875,10619887,10619891,10619892,10619895,10619896,10619901,10619902,10619928,10953500,10617209,10622217,10622224,10622225,10622235,10617322,10617327,10617329,10927872,10617426,10617427,10922949,10617448,10617450,10617455,10617456,10953995,10927985,10927986,10927987,10927988,10617511,10622548,10622549,10617573,10954173,10954297,10954298,10954310,10954313,10928303,10620117,10620118,8570011,10620183,10620186,10620187,10620188,10620189,8570020,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620208,10615222,8570093,8570094,8570095,8570096,8570097,8570098,8570099,8570100,8570101,8570102,8570103,8570104,8570105,8570106,8570108,8570109,8570110,8570111,8570112,8570113,8570114,8570115,8570116,8570117,8570118,8570119,10620289,8570120,8570121,8570122,8570123,8570124,8570125,10620309,10620310,10620311,10620312,10620313,10620330,10620331,10615334,10615339,10615340,10615341,10615342,10615343,10615356,10620528,10926086,10926087,8570413,10615598,10926113,10926176,10615674,10615710,10620717,10620718,10620764,10620765,10620766,10620767,10620768,10620769,10620770,10620771,10620772,10620773,10620774,10620775,10926285,10620776,10620777,10620778,10620779,10620780,10620781,10620782,10620783,10620784,10620785,10620786,10620787,10620788,10620789,10620790,10620791,10620792,10620793,10620794,10620795,10620796,10620797,10615889,10615890,10615891,10615892,10620893,10615893,10615894,10620894,10615895,10620895,10615896,10620920,10620921,10620922,10620923,10930742,10616005,10616033,10621034,10621036,10621037,10621038,10621041,10616059,10616075,10616076,10616077,10616118,10616119,10616123,10616124,10616126,10616127,10616131,10616132,10616134,10616147,10616181,10616182,10616542,10616543,10616544,10616553,10616648,10616649,10927259,10927260,10927261,10927262,10927263,10927264,10927265,10927266,10927267,10927268,10616898,10616955,10953498,10953499,10565150,10565259,10565285,10565286,10565287,10565288,10565289,10565296,10559332,10559334,10614186,10559384,10559385,10559386,10614243,10614246,10614257,10614267,10614268,10614269,10614270,10559426,10559630,10614548,10614552,10614553,10614554,10559705,10559706,10559709,10559715,10559716,10559717,10559718,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10559744,10559745,10562767,10611821,8861845,10612104,10612105,10612106,10612107,10612131,10612135,10612136,10612137,8862099,8862146,10609287,10612291,10612319,10609355,10609369,8862394,8862558,10609986,10609988,10610030,10613144,10558303,10558304,10558317,10558318,10558319,10558320,10613220,10613221,10613306,10610351,10613362,10613369,10561523,10561524,8863271,8863272,10613475,10564664,10564666,10610697,10613736,10613750,10610913,10610914,10610947,10517143,10517144,10515309,10515310,10515327,10515328,10515329,10515377,10515422,10515423,10517614,10517615,10517616,10517617,10517618,10517670,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10513728,10513729,10513952,10513961,10513974,10513975,10513994,10517994,10517995,10513997,10513998,10513999,10514015,10514028,10514029,10514030,10514031,10514032,10514033,10514037,10514038,10514090,10514091,10514092,10514093,10516171,10516172,10516173,10516174,10516175,10516176,10514364,10512530,10512562,10512563,10512564,10512565,10516703,10512780,10512782,10516810,10516865,10516866,10516867,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516917,10516918,10516928,10516930,10516931,10516934,10516935,10516953,10516954,10516955,10514964,10514965,10514976,10514980,10514983,10514986,10514987,10514988,10514989,10514992,10514993,10514994,10514995,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515010,10515013,10515019,10515020,10515021,10515022,10515028,10515029,10515030,10515031,10515032,10515039,10515040,10515041,10515042,10515043,10515044,10515047,10515048,10515049,10515050,10515051,10515052,10515053,10515054,10515059,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,4973162,4973244,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10462939,10462940,10463376,10463377,10463378,10463379,10463380,10467449,8563250,8563251,8563252,10463948,10463949,10469949,10469950,8563299,10464079,10464080,10466273,10466501,10466502,10466503,10466504) 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'