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(8573994,8574031,8574032,10939603,8574088,8574107,8574127,8574150,8574151,8574152,8574153,8574157,8574169,7076030,7076031,7076032,7076033,7076034,7068176,10940001,10940100,4970738,10940289,10940290,7068615,7068616,7068628,7068629,7068630,7068641,7068642,7068678,7068683,4971029,7068696,7068699,8574974,8574975,8575012,7065866,10963634,8575147,10976762,10976763,10976764,10976765,10976766,8583696,8067356,8067357,8067358,10951141,7066649,7066710,10962158,10962159,10962160,10962166,8573697,8573698,11040251,8573924,10962431,10962438,8573935,8573971,8573972,6000126,11011556,11011557,11011558,11011559,11011560,11011561,11011562,11011563,11011564,11011565,11011566,11011567,11011568,11011569,11011570,11011571,11011572,11011573,11011574,11011575,10103021,8617796,8617797,8617800,8617803,8617810,8617812,8617813,10972687,10972688,10972697,10972698,10972699,10972768,10972797,8617952,10972905,10972920,7072248,10972936,10972937,10972938,7072255,10985960,10985997,10985998,10985999,8835809,10986021,10986022,10986023,8835846,8835854,10986052,8835900,10973146,10973147,10986176,10986177,10986178,10986179,10973179,10986180,8836027,8836029,8618409,10986268,10986269,10986270,10986271,10986272,10986273,10986274,10986275,10986276,10986277,10986278,10986279,10986280,10986281,10986282,10986283,10986284,10986285,10986286,10986287,10986288,10103835,10103836,10960472,8066138,8618924,8618932,8618933,7073137,7073138,7073139,7073140,7073141,7073142,7073196,7073197,7073198,7073425,7073628,7073688,7073716,7065800,8970190,10942642,10942662,11010645,11010698,11010699,7071016,7071017,7071018,7071049,10102190,10102203,10102209,10102215,10102307,10985071,10102517,10985072,10102518,7071392,10972102,10972103,10972139,10972140,10972141,10972142,10972143,10972144,10959182,7071546,11011263,11011264,11011265,11011266,11011267,11011268,11011269,10102756,5999975,11011381,11011382,10972446,8908064,10969704,8908078,10969705,8908079,8908080,8908081,8908082,10969727,10969728,10969743,10969744,10969745,10969746,10969747,10969748,10969749,10969783,10969784,10969785,10969786,10969787,10969788,10969789,10969790,10969791,10969792,10969793,10969794,10969795,10969796,10969797,10969798,10969799,10969800,10969909,7069226,10969910,10969911,10969912,10969913,10969914,7069233,7069239,7069241,10969959,10969960,10969961,10969962,10969963,10969964,7069319,8615195,10970088,10970089,10970090,10970113,10970114,10970115,10970116,10970117,10970118,10970155,10970156,10970210,10970230,10970231,10970284,10970285,10970365,10970366,10970367,10970368,10970503,10970542,10970543,10970544,10970545,10970546,10970547,10970612,10970613,10970614,10970615,10970616,10970617,10970653,10970654,10970655,7070070,10983759,7070102,10101302,10970871,10970872,10970873,10970874,10970901,10970902,10970925,10970947,10970948,10970949,8616119,8616121,10970985,10971021,10971022,10971070,10971071,10971072,10101539,11036160,11036161,11036162,11036163,11036164,11036165,11036166,10971236,10971237,10971238,8073464,10971348,10971349,10971376,11006551,11006552,11006553,11006554,8612858,8612859,10967881,11006881,11006882,8613093,8613097,8613099,8613109,8613110,8613121,8613144,10968145,10968146,8613336,8613341,8613348,8613363,11007225,11007226,11007227,8613379,11007228,11007229,11007241,8613393,11007242,8613394,11007243,11007244,11007245,10968606,10968630,10968641,10968668,11007689,11007690,10968716,10968717,10968718,10968719,10968720,10968721,10968722,10968723,10968724,10968725,10968726,10968727,10968728,8613938,8613939,8613940,8613942,8613943,8613953,10981804,10981805,10981806,10981807,10981808,10981809,10981810,10981811,10981812,8613963,10981813,10981814,10981815,8613984,8613988,8614009,8614036,10968909,10968910,10968911,10968912,10968913,10968914,10968915,10968916,10968917,10968918,8907592,10622039,11045197,11045198,11045199,10928227,11045342,8905742,8569898,10615202,8570164,10620352,10620372,10620390,10620391,10620392,8570223,8570224,10620411,10620415,10620424,10615553,10615554,10991322,10930731,10930918,8904210,8904211,8904266,8904330,8904331,11044049,9189551,9165554,9197671,9197672,9197673,9197674,9197675,9189710,9189711,9197756,9197773,9181881,9181904,8864497,10614643,10614644,9166007,8864592,9214088,9166112,10611821,10566098,10566099,10609118,9187493,7057681,10612269,10609443,10609444,9212103,9196219,9196220,9188255,9212312,7058538,7058539,8863111,8863121,8863125,8863168,8863174,8863175,8863239,9180866,9204930,10561747,10561748,10561749,10561750,10561751,10561752,10561753,10561754,10610944,10610948,9161353,9161363,9161365,10513435,10513436,10513437,10513438,10513439,10513440,10513441,9185660,9161749,9177769,10515732,10515733,10515734,7056228,7056235,9162421,9162422,2809331,10512846,10512847,9160362,10419306,10415311,10419350,9176430,9176431,9176432,9176481,9176482,9176483,10415409,10419539,10419540,10419541,10419542,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,9176668,4973679,4973680,4973681,9176954,9176972,9176977,4973894,4973993,9177172,9177173,9177174,9177175,9177176,9177177,9209254,4971347,4971348,4971349,4971351,4971353,4971357,4971358,4971359,4971477,4971478,4971503,4971529,4971530,9190694,4971573,4971574,4971575,4971581,4971582,4971583,4971584,4971600,4971601,4971602,4971633,4971634,10469487,10471524,10471525,9199068,8550414,8550415,9199276,9183333,9183334,8550500,9167407,8917167,8917168,10468113,4972429,4972436,4972442,4972443,4972454,10468179,9167625,4972478,9167626,9167788,8917694,8917695,4973150,8593571,10628215,10164809,10164810,10628295,10628311,10164891,10164892,10164893,10164894,10164895,10164896,10164897,10164898,10164899,10174952,10174953,10174954,10174955,10174956,10174957,10165013,10165017,10165018,10165019,10628510,10628511,10628512,10628513,8594119,8594120,10165138,10165139,10165140,10165141,10175142,10170273,10170328,10170329,10165343,10165353,10170354,10170355,10170356,10170387,10170388,10165402,10165403,10165404,10628890,10628891,10628926,10628927,10628928,10170451,10170452,10170453,10170454,10628944,10628952,10628953,10628954,10628955,10628956,10628957,10628958,10628959,10165489,10165490,10165491,10165492,10165493,10165494,10165495,10165496,10165497,10165498,10170550,10170573,10170574,10170616,10165655,10165656,10170680,10170703,10170704,10165844,10165845,10165846,10165847,10165848,10165899,10165923,10165924,10165925,10165926,10165927,10165928,10165972,10165973,10165974,10165975,10165976,10165977,10165978,10165979,10165980,10165981,10165982,10165983,10165984,10165985,10165986,10171004,10171021,10171056,10171079,10166236,10166237,10166393,10153848,10164114,10164115,10164116,10164117,10164118,10164119,10164120,10164121,10164122,10164123,10164124,10184193,10164361,10164362,10164363,10164364,10164365,10164366,10164367,10164368,10164369,10164370,10164371,10164372,10164373,10164374,10164375,10166535,10166536,10166537,10166555,10166556,10166557,10176578,10166593,10166594,10166629,10166630,10166631,10166649,10166650,10166651,10176679,10176680,10176681,10176682,10176683,10176684,10176685,10176686,10176687,10176688,10176689,10176690,10176691,10176692,10176693,10630189,10176736,10166784,10166795,10161865,10166875,10166876,10166884,10166885,10166907,10166910,10172022,10167031,10167056,10167057,10167058,10167122,10167133,10167153,10167158,10167159,10167160,10167203,10167216,10167217,10167218,10162254,10167270,10949096,10949102,10167305,10167355,10167470,10949986,10583441,10586600,10566114,10590265,10579012,10579013,10579450,10579451,10579452,10579453,10523116,10525130,10525133,10523481,10523482,10523527,10523528,10523529,10523530,10523531,10523532,10523533,10523534,10523535,10523536,10537564,10523594,10523595,10523596,10523597,10523598,10523599,10523600,10523601,10523602,10523603,10533955,10533956,10533957,10533958,10533959,10533960,10533961,10533962,10533963,10527968,10527969,10527970,10533973,10533974,10533975,10534166,10534167,10534168,10534169,10534170,10534171,10534172,10534173,10538276,10524290,10524399,10524721,10524722,10524723,10524724,10524725,10524733,10524734,10524735,10524736,10524737,10524738,10524739,10524740,10524741,10524742,10524753,10524754,10528795,10523031,10523053,10525106,10525107,10525108,10525109,10525110,10525111,10424313,10424314,10424315,10424316,10424317,10424318,10424319,10424320,10424321,10423403,10423404,10423470,10498372,10498378,10423205,10423206,10423207,10423208,10481012,10481025,10484039,10481047,10481048,10481049,10486050,10481050,10486051,10486052,10486053,10486054,10479108,10479109,10477214,10481268,10481269,10481270,10481271,10481272,10481273,10481274,10481494,10481495,10481549,10481641,10481756,10481757,10481758,10481759,10481891,10477893,10481947,10478003,10478162,10478202,10478259,10478260,10478267,10478560,10478561,10478562,10478710,10478711,10482804) 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'