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(10943596,10943597,10943598,10943599,10943600,10943601,10943602,10943603,10943604,4970651,10940161,10940180,10944264,10944272,4968168,10933274,10933334,10933335,8067222,10938674,10938675,10939381,8065781,8065782,8065978,8066004,4967873,4967874,4967875,4967876,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,10943116,10943132,10943155,8064557,8064558,8064559,8064560,8064561,8064562,8064563,8064564,8064565,8064566,8064567,8064568,10943318,10943321,10943322,10943323,8064710,8064711,10943375,8970193,10940749,10940750,10940751,10940752,10940753,3656574,10941823,10941825,10941832,10941833,10941841,10941871,10941939,10941950,10941952,10941969,10942006,10942137,10942423,10942432,10942433,10942453,10942472,10918581,10918582,10918583,10918584,10918585,10918688,10918689,10623381,10919130,10919133,10919134,10919135,10919136,10919137,10919138,10919139,10919140,10623788,10919434,10919435,10919436,10919783,10919784,10919785,10920433,10920434,10920435,10920436,10622113,10622114,10622115,10622116,10622117,10622118,10622119,10622120,10622121,10622122,10622123,10917644,10917645,10917646,10917647,10917648,10917649,10917877,10917878,10917879,10917887,10917888,10622729,10918249,10918250,10918251,10920739,10620342,10921172,10921173,10921174,10921316,10921317,10921331,10921332,10921333,10921334,10921335,10921336,10921337,10921338,10921339,10921340,10921341,10921342,10921343,10921344,10921345,10921346,10921347,10921348,10921349,10921350,10921351,10921352,10921353,10921354,10921355,10921356,10921357,10921358,10921359,10921360,10921361,10921362,10921363,10921364,10921365,10921366,10921367,10921368,10921369,10921370,10921371,10921372,10921373,10921374,10921375,10921376,10921377,10921378,10921379,10921380,10921381,10921382,10921383,10921384,10921385,10921386,10921387,10921452,10921453,10921454,10921545,10921546,10921925,10921926,10921967,10922106,10922107,10917353,10917354,10917355,10917356,10917357,10917359,10917360,10565233,10611160,10614237,10614330,10614859,10614862,10611879,10612053,10609106,10609107,10609108,10609109,10609110,10609111,10609112,10609113,10609114,10609115,10609116,10609117,10612179,10612181,10612187,10612188,10612284,10612285,10612286,10612490,10612493,10612499,10612527,10612583,10612592,10612660,10612697,10612698,10612700,10612705,10612907,10612912,10612913,10612914,10612951,10610070,10613093,10613094,10610306,10610307,10610359,10610390,10610480,10610481,10613562,10610567,10610750,10610954,10555209,10555210,10555211,10555212,10555213,10555262,10555263,10555264,10555265,10555266,10555267,10555268,10555269,10555270,10555271,10555272,10555273,10555274,10555275,10555276,10555277,10555278,10555279,10555280,10555281,10555282,10555283,10555284,10555285,10555286,10555287,10555288,10555289,10555290,10555291,10555292,10555293,10555294,10555295,10555296,10555297,10555298,10555299,10555300,10555301,10555302,10555303,10555304,10555305,10555306,10555307,10555308,10555309,10555310,10555311,10555312,10555313,10555314,10555315,10555316,10555317,10555318,10555319,10555320,10555321,10555322,10555323,10555324,10555325,10555326,10555327,10555328,10555329,10555330,10555331,10555332,10555333,10555334,10555335,10555336,10555337,10555338,10555339,10555340,10555341,10555342,10555343,10555344,10555345,10555346,10555347,10555348,10555349,10555350,10555351,10555352,10555353,10555354,10555355,10555356,10555357,10555358,10555359,10555360,10555361,10555362,10555363,10555364,10555365,10555366,10555367,10555368,10555369,10555370,10555371,10555372,10555373,10555374,10555375,10555376,10555377,10555378,10555379,10555380,10555381,10555382,10555383,10555384,10555385,10555386,10555387,10555388,10555389,10555390,10555391,10555392,10555393,10555394,10555395,10555396,10555397,10555398,10555399,10555400,10555401,10555402,10555403,10555404,10555405,10555406,10555407,10555408,10555409,10555410,10555411,10555412,10555413,10555414,10555415,10555416,10555417,10555418,10555419,10555420,10555421,10555422,10555423,10555424,10555425,10555426,10555427,10555428,10555429,10555430,10555431,10555432,10555433,10555434,10555435,10555436,10555437,10555438,10555439,10555440,10555441,10555442,10555443,10555444,10555445,10555446,10555447,10555448,10555449,10555450,10555451,10555452,10555453,10555454,10555455,10555456,10555457,10555458,10555459,10555460,10555461,10555462,10555463,10555464,10555465,10555466,10555467,10555468,10555469,10555470,10555471,10555472,10555473,10555474,10555475,10555476,10555477,10555478,10555479,10555480,10555481,10555482,10555483,10555484,10555485,10555486,10555487,10555488,10555489,10555490,10555491,10555492,10555493,10555494,10555495,10555496,10555497,10555498,10555499,10555500,10555501,10555502,10555503,10555504,10555505,10555506,10555507,10555508,10555509,10555510,10555511,10555512,10555513,10555514,10555515,10555516,10555517,10555518,10555519,10555520,10555521,10555522,10555523,10555524,10555525,10555526,10555527,10555528,10555529,10555530,10555531,10555532,10555533,10555534,10555535,10555536,10555537,10555538,10555539,10555540,10555541,10555542,10555543,10555544,10555545,10555546,10555547,10555548,10555549,10555550,10555551,10555552,10555553,10517553,10555554,10517554,10555555,10555556,10555557,10555558,10555559,10555560,10555561,10555562,10555563,10555564,10555565,10555566,10555567,10555568,10555569,10555570,10555571,10555572,10555573,10555574,10555575,10555576,10555577,10555578,10555579,10555580,10555581,10555582,10555583,10555584,10555585,10555586,10555587,10555588,10555589,10555590,10555591,10555592,10555593,10555594,10555595,10555596,10555597,10555598,10555599,10555600,10555601,10555602,10555603,10555604,10555605,10555606,10555607,10555608,10555609,10555610,10555611,10555612,10555613,10555614,10555615,10555616,10555617,10555618,10555619,10555620,10555621,10555622,10555623,10555624,10555625,10555626,10555627,10555628,10555629,10555630,10555631,10555632,10555633,10555634,10555635,10555636,10555637,10555638,10555639,10555640,10555641,10555642,10555643,10555644,10555645,10555646,10555647,10555648,10555649,10555650,10555651,10555652,10555653,10555654,10555655,10555656,10555657,10555658,10555659,10555660,10555661,10555662,10555663,10555664,10555665,10555666,10555667,10555668,10555669,10555670,10555671,10555672,10555673,10555674,10555675,10555676,10555677,10555678,10555679,10555680,10555681,10555682,10555683,10555684,10555685,10555686,10555687,10555688,10555689,10555690,10555691,10555692,10555693,10555694,10555695,10555696,10555697,10555698,10555699,10555700,10555701,10555702,10555703,10555704,10555705,10555706,10555707,10555708,10555709,10555710,10555711,10555712,10555713,10555714,10555715,10555716,10555717,10555718,10555719,10555720,10555721,10555722,10555723,10555724,10555725,10555726,10555727,10555728,10555729,10555730,10555731,10555732,10555733,10555734,10555735,10555736,10555737,10555738,10555739,10555740,10555741,10555742,10555743,10555744,10555745,10555746,10555747,10555748,10555749,10555750,10555751,10555752,10555753,10555754,10555755,10555756,10555757,10555758,10555759,10555760,10555761,10555762,10555763,10555764,10555765,10555766,10555767,10555768,10555769,10555770,10555771,10555772,10555773,10555774,10555775,10555776,10555777,10555778,10555779,10555780,10555781,10555782,10555783,10555784,10555785,10555786,10555787,10555788,10555789,10555790,10555791,10555792,10555793,10555794,10555795,10555796,10555797,10555798,10555799,10555800,10555801,10555802,10555803,10555804,10555805,10555806,10555807,10555808,10555809,10555810,10555811,10555812,10555813,10555814,10555815,10555816,10555817,10555818,10555819,10555820,10555821,10555822,10555823,10555824,10555825,10555826,10555827,10555828,10555829,10555830,10555831,10555832,10555833,10555834,10555835,10555836,10555837,10555838,10555839,10555840,10555841,10555842,10555843,10555844,10555845,10555846,10555847,10555848,10555849,10555850,10555851,10555852,10555853,10555854,10555855,10555856,10555857,10555858,10555859,10555860,10555861,10555862,10555863,10555864,10555865,10555866,10555867,10555868,10555869,10555870,10555871,10555872,10555873,10555874,10555875,10555876,10555877,10555878,10555879,10555880,10555881,10555882,10555883,10555884,10555885,10555886,10555887,10555888,10555889,10555890,10555891,10555892,10555893,10555894,10555895,10555896,10555897,10555898,10555899,10555900,10555901,10555902,10555903,10555904,10555905,10555906,10555907,10555908,10555909,10555910,10555911,10555912,10555913,10555914,10555915,10555916,10555917,10555918,10555919,10555920,10555921,10555922,10555923,10555924,10555925,10555926,10555927,10555928,10555929,10555930,10555931,10555932,10555933,10555934,10555935,10555936,10512116,10512117,10512161,10512162,10512163,10512164,10512165,10512166,10415466,10416636,10420012,10420046,10417058,10417076,10417077,10417188,10417196,10417204,10463381,10463382,10463383,10463384,10463385,10463386,10463387,10463388,10463389,10464067,10464068,10464069,10464070,10464071,10464072,10464073,10464074,10464075,8563428,10470300,10470431,10470433,10470557,10470558,10470560) 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'