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(4968608,10437315,10437316,4968622,4968623,4968624,10437329,4968625,10437330,10437342,4968644,4968647,4968654,4968662,4968663,10437497,7066557,7066558,10437599,10437600,10437601,7066656,10437602,10437603,7066663,7066712,7066749,7066750,7066752,7066753,7066754,7066755,7066756,7066757,7066759,7066760,7066761,7066762,7066763,7066764,7066860,7066889,7066925,8067952,8067953,8067954,8067955,8067961,8067962,8067963,8067968,8067969,8067970,8067971,8067983,8067984,4969252,8067999,8068001,8068002,8068003,8068004,8068005,4969266,4969267,4969268,4969269,8068013,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068026,8068027,8068028,8068029,8068030,8068031,8068032,8068033,8068034,8068035,8068040,8068042,8068043,8068044,8068050,8068057,8068075,8068076,8068086,8068087,8068088,8068089,8068097,8068098,8068099,8068100,8068101,8068109,8068110,8068111,8068112,8068113,8068123,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068140,8068141,8068142,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068153,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068161,8068162,8068163,8068164,8068165,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068173,8068174,8068175,8068176,8068190,8068191,8068192,8068193,8068194,8068195,8068196,8068197,8068198,8068199,8068200,8068201,8068211,8068212,8068213,8068214,8068215,8068216,8068222,8068223,8075214,8075215,8075216,8075217,10074125,10074138,10074139,8075309,8075310,8075312,10074195,10074201,10074207,10074208,10074210,10074220,10074222,10074224,7064732,7064733,7064736,7064746,7064747,7064748,7064751,7064754,7064756,7064757,7064758,7064763,7064764,7064768,7064769,7064770,7064771,4967031,4967069,4967070,4967071,4967072,4967086,4967087,4967088,4967089,4967100,4967156,4967157,4967158,7064966,7064975,7064976,7064977,7064979,7064983,7064990,7064991,7064993,7064994,7064996,7064999,7065001,7065012,4967309,4967435,10074869,10074872,7065351,4967713,7065472,10075151,10075156,4967866,10075252,4967885,4967886,4967887,4967888,4967889,10075311,10075312,10075323,10075365,10075368,4967996,10075394,10075395,10075396,7065950,7065962,4968259,4968262,4968271,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968294,10437044,10437045,10437054,10437057,10437066,10437069,10437074,10437077,10437081,10437082,7066208,10437178,10437179,8860267,8968508,8860450,8860451,8860452,8968628,8968631,8968848,8073546,8968863,8073569,8073570,8073571,8073572,8073573,8073574,8968895,8968896,8968897,8073668,8073669,8073670,8073671,8073672,8073673,8073674,8969058,8969228,8969229,8074037,8074038,8074039,8074040,8074041,8969412,8969413,8969414,8969485,8969558,8969560,8074596,8074597,8074598,8074599,8074600,10073533,10073535,10073542,10073543,10073612,10073625,10073632,10073633,10073634,10073643,10073645,8967414,8072405,8072431,8070082,8070083,8070085,8070086,8070090,8070091,8070095,8070096,8070097,8070102,8070103,8070108,8070109,8070112,8070113,8070160,8070162,8070165,8070169,8965546,8070336,8070342,8965659,8070510,8070514,8070546,8070549,8070557,8070561,8070564,8070569,8070572,8070573,8070574,8070575,8070576,8070577,8070578,8070585,8070586,8070591,8070595,8070596,8070597,8070598,8070599,8070609,8070610,8070612,8070616,8070617,8070618,8070619,8070620,8070623,8070624,8070625,8070626,8070627,8070628,8966004,8966005,8966081,8070858,8070947,8070960,8070962,8070964,8070965,8070966,8070967,8070971,8070972,8070975,8070977,8070979,8070981,8070983,8070989,8070995,8070996,8070997,8070998,8070999,8071000,8071001,8071002,8071003,8071004,8071005,8071006,8071007,8071008,8071009,8071010,8966462,8966472,8966473,8966570,8966571,8966615,8966616,8966618,8966619,8966631,8966640,8966644,8966645,8966646,8966647,8966651,8966657,8966782,8966784,8966785,8966802,8966804,8966805,8966806,8966808,8966859,8966879,8966880,8966888,8966920,8966921,8966922,8966923,8966926,8966927,8966932,8966936,8966937,8966938,8966939,8966940,8966941,8966942,8966945,8966947,8966970,8966976,8966981,8966984,8966985,8966988,8966989,8966990,8966992,8966995,8966997,8967009,8967011,8967019,8967020,8967026,8967151,8967171,8967172,8967178,8967191,8967192,8967193,8967195,8967202,8967212,8967244,8967283,8967284,8967285,8967289,8967292,8967300,8967301,8967303,10623006,10623007,10623026,10707329,10707330,10707331,10707332,10707333,10707334,10707417,10707418,10707421,10707423,10707425,10707426,10707490,10707518,10707689,10707690,10707691,10707692,10707693,10707710,10707770,10707808,10707809,10707810,10707811,10707814,10707839,10708091,10708092,10708093,10708094,10708095,10708096,10708097,10624730,10624852,10621981,10621986,10621987,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10622012,10622014,10622032,10622033,10622034,10622049,10622050,10622053,10622055,10622060,10622071,10622104,10622105,10622113,10622114,10622115,10622126,10622128,10622204,10622215,10622216,10622220,10622224,10622225,10622226,10622227,10622238,10622239,10622240,10620303,10620307,10620322,10620326,10620338,10620353,10620354,10620355,10620356,10620370,10620373,10620374,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620401,10620402,10620403,10620408,10620414,10620427,10620441,10620465,10620528,10620663,10620664,10620669,10620670,10621110,10621111,10621112,10621113,10621114,10621115,10621119,10621120,10621124,10621144,10621146,10621147,10621148,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621265,10621266,10621267,10621268,10621269,10621270,10621271,10621273,10621274,10621276,10621277,10621280,10621281,10621292,10621293,10621294,10621296,10621300,10621301,10621303,10621304,10621305,10621306,10621307,10621308,10621309,10621310,10621311,10621316,10621317,10621318,10621319,10621320,10621321,10621323,10621324,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621341,10621343,10621345,10621346,10621347,10621348,10621352,10621353,10621354,10621355,10621375,10621381,10621382,10621383,10621422,10621423,10621424,10621428,10621429,10621430,10621431,10621432,10621433,10621434,10621436,10621438,10621439,10621440,10621441,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621456,10621460,10621461,10621464,10621465,10621480,10621481,10621482,10621483,10621484,10621491,10621492,10621496,10621497,10621498,10621500,10621501,10621502,10621503,10621504,10621511,10621513,10621514,10621521,10621522,10621523,10621529,10621530,10621531,10621532,10621533,10621537,10621538,10621539,10621540,10621541,10621542,10621543,10621544,10621545,10621565,10621572,10621573,10621581,10621582,10621587,10621631,10621632,10621646,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621658,10621689,10621692,10621693,10621694,10621705,10621706,10705784,10705785,10705786,10705787,10705788,10705789,10705790,10705791,10621742,10705792,10621743,10705793,10705794,10621745,10705795,10705796,10705797,10705798,10705799,10705800,10705801,10705802,10705803,10705804,10705805,10705806,10705807,10705808,10705809,10705810,10705820,10705821,10705822,10705823,10705824,10705825,10705826,10705827,10705828,10705829,10705830,10705831,10705832,10705833,10705834,10705835,10705836,10614060,10614064,10614067,10614068,10614069,10614087,10614088,10614732,10614733,10614734,10612381,10613068,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613303,10613304,10613307,10564471,10564472,10564473,10564482,10564483,10564488,10564489,10564496,10564560,10564561,10564562,10564563,10564564,10564565,10564566,10564567,10564568,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564594,10564595,10564596,10564597,10564610,10564611,10564612,10564613,10564624,10564625,10613520,10613521,10517634,10517635,10517679,10517681,10512760,10512761,10419423,10419424,10416657,10419698,10419699,10419700,10419701,10419702,10419724,10419725,10419905,10419906,10419917,10420138,10420139,10420140,10471176,10471177,10471178,10471180,10471181,10471183,10471185,10471186,10471188,10471189,10471190,10471191,10471193,10471194,10471196,10471198,10471199,10471201,10471203,10471204,10471207,10471208,10471421,10471433,10471434,10471435,10465772,10465773,10465804,10471835,10465865,10465866,10463881,10463882,10464040,10470117,10470126,10470129,10470131,10470132,10470134,10470135,10464560,10464561,10464562,10464563,10464739) 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'