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(10939584,10939585,10939586,10939647,10939648,10939649,10939764,10939765,10939810,10943628,7068144,7068152,10939946,10939957,7068255,7068256,7068351,7068352,7068353,7068354,7068357,7068370,10940106,10940107,10940169,10940192,7068598,10940407,10940408,10940409,7068762,7065951,7065995,7066000,8067138,8067209,7066184,10437307,8067605,8067606,8067607,8067608,8067637,8067649,10437620,8067779,8067780,8067781,8067782,8067783,8067784,8067793,8067794,8067795,8067796,8067797,8067798,8067799,8067800,7066736,7066737,7066738,7066739,7066784,7066821,7066825,7066841,8067909,8068000,8068031,8068077,8068078,8068079,8068102,8068103,8068104,8068105,8068148,8068149,8068150,8068151,8068152,8068153,8068202,8068203,8068256,8068257,8068258,8068274,8068275,8068276,7067314,7067315,7067316,8068321,8068322,8068323,8068324,8068375,8068376,8068377,8068378,8068402,8068403,7067446,8068440,8068441,8068528,8068618,8068626,8068669,8068670,10939425,10939435,10939456,7067757,10931637,10931772,4967030,4967031,7064726,10932195,10932196,10932197,10932198,10932199,8065998,8066017,8066018,8066019,8066192,8066205,8066217,8066257,8066258,8066259,8066305,8066316,8066331,8066332,8066333,8066354,8066355,8066356,8066407,8066408,8066424,8066425,8066613,8066614,8066672,8066730,4968060,8860926,10942769,10942795,10942796,10942797,8861084,8861327,8861335,10943165,10943167,10943168,10943170,10943224,10943225,10943233,10943234,10943236,10943240,10943241,10943242,10943244,10943245,8861474,8861477,10943289,5999947,5999968,8970235,6000040,6000048,6000095,3655566,10944446,3655781,10940832,10940845,8072368,8072369,8072370,8072371,8072372,8072373,8072374,3656272,3656287,3656288,3656289,3656457,3656468,3656484,3656723,3656724,3656870,3656871,3656872,3656875,3656876,3656877,3656880,3656882,3656990,3656991,3656992,3656993,3656994,10942065,10942149,10942181,10942182,10942183,10942184,10942187,10942190,10942191,10942192,10942194,8860394,8860396,10942328,10942421,10942427,8860632,8860643,10923494,10918525,10918526,10923594,10923595,10923596,10923660,10923661,10923662,10923663,10923664,10923665,10918666,10623190,10918733,10923755,10923756,10923757,10923758,10923837,10923838,10923839,10923896,10923897,10923898,10918911,10918912,10918913,10918914,10918915,10918916,10918917,10918918,10918919,10918920,10923981,10923982,10924068,10924069,10924288,10919290,10919614,10919615,10919616,10919617,10919618,10919619,10919620,10924668,10919852,10924893,10924894,10924895,10924896,10924897,10924898,10924899,10925010,10925011,10925271,10925272,10925273,10925274,10925275,10925276,10925451,10927534,10927535,10927536,10927537,10927538,10927539,10927540,10927541,10927542,10927543,10927544,10927545,10927579,10927580,10927583,10927584,10927585,10927586,10927587,10927588,10927589,10927590,10927591,10927592,10927593,10927594,10927595,10927597,10927598,10927599,10927600,10927601,10927602,10927603,10927604,10927605,10927607,10927608,10927612,10927613,10927615,10927616,10927617,10927618,10927619,10927620,10927621,10927624,10927625,10927626,10927627,10927628,10927629,10927630,10927631,10927639,10927655,10927656,10927657,10927659,10927662,10927663,10927664,10927665,10927666,10927667,10927668,10927669,10927670,10927671,10927672,10927673,10927675,10927676,10927677,10927678,10927679,10927681,10927682,10927683,10927684,10927685,10927687,10927688,10927689,10927690,10927691,10927692,10927693,10927695,10922695,10922697,10922698,10927699,10927700,10927702,10927712,10927713,10927714,10927715,10922715,10927716,10927717,10927718,10927719,10927721,10927722,10927726,10927727,10927729,10927730,10927731,10927732,10927733,10927734,10927736,10927737,10927738,10922738,10927739,10927740,10927741,10927742,10927743,10927744,10927745,10927746,10927747,10927749,10927750,10927751,10927752,10927753,10927754,10927755,10927756,10927757,10927758,10927759,10927760,10927765,10927766,10927769,10927770,10927771,10927772,10927775,10927776,10927779,10927780,10927781,10927782,10927783,10927784,10927785,10927790,10922790,10927791,10927792,10927793,10927794,10927795,10927796,10927797,10927798,10927799,10927800,10927801,10927802,10927807,10927808,10927809,10927810,10927811,10927812,10927817,10927818,10927819,10927820,10927821,10927822,10927823,10927824,10927825,10927827,10927828,10922828,10927831,10927832,10927833,10927834,10927838,10927839,10927841,10927842,10927843,10927844,10927845,10927846,10927847,10927848,10927849,10927850,10927851,10927852,10927853,10927854,10927855,10927856,10922903,10922908,10922909,10922910,10922932,10927938,10922950,10922951,10922952,10922953,10922967,10922968,10927982,10927986,10927987,10923037,10923067,10923093,10923094,10923110,10923128,10923129,10923151,10923152,10923153,10923154,10923155,10923156,10918157,10918164,10918165,10918166,10918167,10923185,10923186,10923193,10923198,10923199,10923205,10923214,10923215,10923238,10923239,10923240,10923241,10622750,10923288,10923289,10923335,10923344,10923345,10923364,10923365,10923366,10923367,10622888,10622900,10923427,10923428,10923429,10925490,10925510,10920566,10620071,10620083,10920617,10920618,10920656,10920687,10920688,10920689,10920771,10920772,10920921,10920922,10920923,10920924,10620420,10920992,10920993,10920994,10921085,10921087,10921088,10921089,10921090,10921091,10620665,10921264,10926359,10926360,10926361,10926362,10926363,10926364,10926365,10926366,10926367,10926368,10926369,10926370,10620875,10620876,10621074,10621075,10621118,10921640,10921762,10621268,10621278,10621297,10621336,10621362,10621411,10621449,10621455,10922095,10922096,10922097,10922098,10922099,10922122,10621656,10621657,10621690,10565125,10565126,10565192,10565193,10565194,10565195,10565196,10611373,10614401,10614440,10611479,10611480,10611481,10611482,10611483,10611484,10611485,10611486,10611487,10611488,10611489,10611490,10611491,10611492,10611493,10611494,10611495,10611496,10611497,10611498,10611499,10611500,10611501,10611502,10611503,10611504,10611505,10611506,10611507,10611508,10611509,10611510,10614517,10611674,10611675,10611676,10611677,10611726,10614765,10611830,10611831,10611832,10611833,10611834,10609361,10612529,10563698,10563700,10563797,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563926,10612781,10563956,10564124,10564143,10564144,10564145,10564152,10564153,10564154,10564201,10564202,10564203,10613070,10564415,10564427,10564433,10564442,10564443,10564447,10610310,10610311,10613315,10613351,10610468,10613619,10613622,10610675,10610733,10610824,10511170,10511172,10511173,10517238,10517239,10517240,10517241,10517244,10517245,10517247,10517248,10517249,10517250,10517251,10517254,10517256,10517258,10517259,10517264,10517265,10517266,10517271,10517272,10517273,10517274,10517275,10517276,10517279,10517282,10517283,10517284,10517286,10517290,10517291,10517292,10517293,10517296,10517297,10555476,10555477,10555478,10555479,10555480,10555481,10555482,10555483,10555484,10555485,10555526,10555527,10555528,10555529,10555530,10555531,10555532,10555533,10555534,10517620,10517683,10517684,10512161,10512162,10512163,10512164,10512165,10512166,10512167,10512168,10512169,10512170,10512171,10512172,10512173,10512174,10512175,10556322,10556460,10556461,10512557,10512558,10512562,10556562,10512563,10556563,10512564,10512565,10512577,10556741,10556742,10556743,10512750,10512859,10512962,10513042,10557073,10557074,10557075,10557076,10557077,10557078,10557079,10557080,10557081,10557082,10557083,10557084,10557085,10557086,10557087,10557088,10557089,10557090,10557091,10557092,10557093,10557094,10557095,10557096,10416232,10416246,10416300,10416301,10415543,10415544,10415557,10415558,10415559,10415560,10415561,10415562,10415563,10415564,10415565,10415566,10415567,10415568,10415569,10415570,10415571,10415572,10415573,10415574,10415577,10415578,10415579,10415580,10415581,10415582,10416800,10416801,10416802,10416803,10416804,10416805,10416806,10416808,10416809,10416810,10416811,10416812,10416813,10416814,10416815,10416816,10416817,10416818,10416819,10416820,10416821,10417116,10417124,10420136,10420148,10417191,10420202,10471120,10471183,10471184,10471532,10471533,10471534,10471535,10471536,10463768,10463769,10463770,10463771,10463772,10463773,10463774,10463775,10463776,10463777,10463778,10463779,10463780,10463781,10463782,10463783,10463784,10463785,10463786,10463787,10463788,10463789,10463790,10463791,10463792,10463793,10463794,10463795,10463796,10463797,10463798,10463799,10463800,10463801,10463802,10463803,10463804,10463805,10463806,10463807,10463808,10463809,10463810,10463811,10463812,10463813,10463814,10463815,10463816,10463817,10463818,10463819,10463820,10463821,10463822,10463823,10463824,10463825,10463826,10463827,10463828,10463829,10463830,10463831,10463832,10463833,10469994,10469995,10469996,10464285,10470286,10470349,10470387,10470390,10470394,10470496,10470499,10470500,10470510,10470511,10470597,10470600,10470601,10470679) 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'