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,10939550,10939551,10939553,10939594,10939595,10943448,10943453,10943467,10939675,10943498,10943524,10943639,10940030,10940033,10940042,4970687,10940066,4970688,10940075,10943898,10943902,4970739,4970747,10940229,10944041,10944046,10944051,10944076,10940293,10944090,10944095,10940303,10944104,10944105,10944106,10944111,10944112,10944113,10944129,10944139,10944140,10944141,10944142,10944143,10944148,10944186,10940432,10940434,10944249,10944322,10944326,4968187,8066924,8066925,8066929,8066930,8066934,8066997,8067074,4968342,8067081,8067082,8067097,8067106,10437392,8067777,10938527,10938596,10938599,10938604,10938605,10938640,8067922,10938655,8067923,10938687,10938688,10938689,10938690,10938691,10938692,10938693,10938694,10938695,10938696,10938697,10938698,10938722,10938731,10938732,10938940,10938941,10938942,10938943,4969569,10938949,10938957,10938959,10938960,10938966,10938967,10938974,10938975,10938976,10938977,10938979,10938983,10938986,10939084,10939101,10939126,10939146,10939147,10939148,10939149,10939150,10939154,10939159,10939163,10939164,10939167,10939186,10939187,10939218,10939220,10939228,10939240,10939250,10939253,10939261,10939277,10939278,10939297,10939300,10939306,10939309,10939314,10939322,10939324,10939328,10939330,10939336,10939385,10939416,10939421,10939422,10939476,10939496,10939500,10939506,10939507,10939510,10939511,10939524,10939527,10939528,10939530,8064926,8064957,8064959,8064967,8064992,8065147,8065159,10931546,10931547,8065184,8065185,8065300,8065352,8065399,8065413,8065459,8065536,8065537,8065538,8065548,8065549,8065556,8065567,8065568,8065580,8065609,8065619,8065620,8065621,8065624,8065628,8065638,8065639,8065640,8065653,8065665,8065676,8065684,8065690,8065744,8065804,8065838,8065839,8065840,8065895,8065897,8065912,10933037,10933038,10933041,10933043,10933044,10933048,10933049,10933050,10933056,10933059,10933060,10933061,10933062,10933063,10933064,10933066,10933067,10933073,10933074,4967980,4967981,8970177,8063998,8064007,8064023,8064099,8064105,8064106,10942777,8064171,8064202,8064267,8064268,8064275,8064278,8064279,8064356,8064364,8064482,8064483,8064493,8064494,8064495,8064500,8064504,8064510,8064520,8064522,8064537,8064605,8064608,8064609,8064615,8064616,8064622,8064628,8064629,8064632,8064729,8064730,8064731,8064732,8064833,8064834,10940654,10940661,10940662,10940664,3656942,8073549,10623052,10623053,10623067,10623070,10623079,10623080,10623081,10623099,10623100,10623112,10623115,10623168,10623169,10623171,10623172,10623173,10623174,10623175,10623176,10623177,10623215,10623216,10623481,10623482,10623483,10623484,10623508,10623530,10623531,10623532,10623533,10623534,10623535,10623536,10623537,10623538,10623539,10623540,10623541,10623542,10623543,10623547,10623548,10623549,10623552,10623605,10623606,10624899,10624900,10624903,10624908,10624909,10624916,10621964,10621965,10621967,10621968,10621969,10621970,10621973,10621974,10622188,10622196,10620112,10620113,10620114,10620115,10620116,10620117,10620118,10620147,10620165,10620168,10620169,10620229,10620230,10620231,10620233,10620299,10620305,10620316,10620426,10620428,10620437,10620460,10620461,10620463,10620464,10620466,10620496,10620497,10620498,10620499,10620500,10620501,10620502,10620584,10620586,10620587,10620588,10620589,10620590,10620636,10620652,10620654,10620699,10620700,10620701,10620702,10620703,10620704,10620705,10620706,10620707,10620709,10620710,10620719,10620720,10620798,10620799,10620800,10620852,10620853,10620854,10620857,10620867,10620868,10620872,10620873,10620898,10620899,10620900,10620901,10620902,10620903,10620904,10620909,10620910,10620911,10620912,10620913,10620914,10620926,10620927,10620928,10620929,10620930,10620931,10620932,10620939,10620940,10620942,10620943,10620944,10620945,10620946,10620947,10620948,10620950,10620951,10620952,10620953,10620954,10620955,10620956,10620957,10620958,10620959,10620960,10620961,10620962,10620965,10620966,10620967,10620968,10620969,10620970,10620971,10620972,10620973,10620974,10620975,10620976,10620977,10620978,10620979,10620980,10621056,10621057,10621058,10621061,10621062,10621079,10621080,10621081,10621083,10621084,10621104,10621105,10621106,10621107,10621359,10621816,10621938,10621939,10621940,10621941,10621942,10621943,10621944,10621945,10621946,10621947,10621948,10621949,10621950,10621951,10621952,10621953,10621954,10621955,10621956,10611162,10611232,10611234,10611235,10611267,10611293,10611319,10611352,10611353,10611696,10611714,10611722,10611723,10611724,10611725,10611726,10611784,10611788,10611801,10611802,10611808,10611823,10611825,10611850,10611851,10611852,10611853,10611857,10611859,10611860,10611863,10611864,10611865,10611866,10611867,10611868,10611869,10611870,10611871,10611872,10611879,10609265,10609279,10609288,10609304,10609306,10609375,10609767,10609771,10609772,10609773,10609774,10609775,10609776,10609777,10609778,10609779,10609780,10609781,10609782,10609783,10609784,10609785,10609786,10609787,10609788,10609789,10609790,10609791,10609792,10609793,10609794,10609795,10609796,10609797,10609798,10609799,10609800,10609801,10609802,10609803,10609804,10609805,10609806,10609807,10609808,10609809,10609810,10609811,10609812,10609813,10609814,10609815,10609818,10609819,10609826,10609828,10609834,10609975,10609976,10609978,10609979,10609981,10610006,10610018,10610023,10610035,10610037,10610039,10610040,10610042,10610061,10610094,10610095,10610096,10610173,10610175,10610176,10610177,10610190,10610197,10610237,10610261,10610262,10610269,10610270,10610271,10610272,10610273,10610280,10610282,10610283,10610289,10610293,10610295,10610296,10610298,10610318,10610319,10610334,10610339,10610340,10610341,10610342,10610343,10610344,10610346,10610359,10610362,10610364,10610371,10610373,10610374,10610376,10610429,10610437,10610440,10610441,10610461,10610463,10610466,10610468,10610469,10610471,10610474,10610476,10610481,10610723,10610725,10610728,10610729,10610730,10610740,10610742,10610747,10610748,10610750,10610751,10610793,10610836,10610846,10610876,10610877,10610878,10610879,10610880,10610881,10610882,10610883,10610884,10610885,10610886,10610887,10610888,10610889,10610890,10610891,10610892,10610893,10610894,10610895,10610896,10610897,10610898,10610899,10610900,10610902,10610937,10610939,10610940,10610954,10419254,10419262,10419269,10419273,10419274,10419275,10419276,10419286,10415324,10415325,10415326,10419342,10419377,10419391,10419393,10419396,10419445,10415539,10415540,10415541,10415542,10415543,10415544,10415545,10415546,10415547,10415548,10415549,10415550,10415551,10415552,10415553,10415554,10415555,10415556,10415557,10415558,10415559,10415560,10415561,10415562,10415563,10415564,10415565,10415566,10415567,10415568,10415569,10415570,10415571,10415572,10415573,10415574,10415575,10415576,10415577,10415578,10415579,10415580,10415581,10415582,10415583,10415584,10415585,10415586,10415587,10415588,10415589,10415590,10415591,10415592,10415593,10415594,10415595,10415596,10415597,10415598,10415599,10415600,10415601,10415602,10415603,10415604,10415605,10415606,10415607,10415608,10415609,10415610,10415611,10415612,10415613,10415614,10415615,10415616,10415617,10415618,10415619,10415620,10415621,10415622,10415623,10415624,10415625,10415626,10415627,10415628,10415629,10415630,10415631,10415632,10415633,10415634,10415635,10415636,10415637,10415638,10415639,10415640,10415641,10415642,10415643,10415644,10415645,10415646,10415647,10415648,10415649,10415650,10415651,10415652,10415653,10415654,10415655,10415656,10415657,10415658,10415659,10415660,10415661,10415662,10415663,10415664,10415665,10415666,10415667,10415668,10415669,10415670,10415671,10415672,10415673,10415674,10415675,10415676,10415677,10415678,10415679,10415680,10415681,10415682,10415683,10415684,10415685,10415726,10415727,10415728,10415729,10415730,10415731,10415732,10415733,10415734,10415735,10415736,10415737,10420025,10420026,10420029,10471085,10471086,10463499,10463500,10463501,10463502,10463503,10463504,10463505,10463506,10463507,10463508,10463509,10463510,10463511,10463512,10463513,10463514,10463515,10463516,10463517,10463518,10463519,10463520,10463521,10463522,10463523,10463524,10463525,10463526,10463527,10463528,10463529,10463530,10463531,10463532,10463533,10463534,10463535,10463536,10463537,10463538,10463539,10463540,10463541,10463542,10463543,10463544,10463545,10463546,10463547,10463548,10463549,10463550,10463551,10469893,10470150,10470151,10470152,10470153,10470154,10470155,10470156,10470157,10470158,10470159,10470160,10470161,10470162,10470163,10470164,10470165,10470166,10470167,10470168,10470169,10470170,10470171,10470172,10470173,10470174,10470175,10470176,10470177,10470178,10470179,10470180,10470181,10470182,10470183,10470184,10470185,10470186,10470187,10470188,10470189,10470190,10470191,10470192,10470193,10470194,10470195,10470196,10470197,10470198,10470199,10470200,10470201,10470202,10470203,10470204,10470205,8563583) 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'