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(8583105,8583106,10459226,10459227,10459254,10459267,10459318,10459319,10459335,10940403,10459355,10459373,10459415,10459416,10459442,8631571,9215612,7074303,7074338,11042200,11042347,11042348,10460416,11013684,11013685,11039966,11039967,11039968,7067292,11040126,11014401,8594669,8594670,8594671,8594672,8594673,8594674,8594675,8594676,8594677,8594678,8594679,8594680,8594681,8594682,11038168,11038196,11038216,11038221,11038222,11038278,7072781,11038473,11038474,8066011,8066012,8066013,11038748,11039071,3927728,3927729,8617334,10959259,7071875,10840266,7198899,8072469,3236401,11023049,11023202,11023203,11023204,11023205,11023206,11023207,11023208,11023209,11023210,11048606,10841610,10968134,10968135,10968136,8613510,8613511,8613512,8613513,8613514,8613515,8613516,8613517,10838708,3924381,11007745,11007746,11007747,4938207,10617204,8634978,8634979,10622429,10977697,10977698,10977699,10977700,10977701,10977702,10977703,10425384,10977704,10977705,10977706,10977707,10977708,10977709,10977710,10977711,10977712,10977713,10977714,10977715,10977716,10977717,10977718,10977719,10977720,10977721,10977722,10615209,3230614,10925879,7154429,7154430,7154431,7154432,10930883,8904329,8904330,8904331,8904332,8904333,8904334,8904335,8904336,8904337,8904338,8904339,8904340,8904341,8904342,8904343,8904344,8904345,8904346,8904347,8904348,8904349,8904350,8904351,8904352,8904353,8904354,8904355,8904356,8904357,8904358,8904359,8904360,8904361,8904362,8904363,8904364,8904365,8904366,8904367,8904368,8904369,8904370,8904371,8904372,8904373,8904374,8904375,8904376,8904377,8904378,8904379,8904380,8904381,8904382,8904383,8904384,8904385,8904386,8904387,8904388,8904389,8904390,8904391,8904392,8904393,8904394,8904395,8904396,8904397,8904398,8904399,8904400,8904401,8904402,8904403,8904404,10926913,10621570,10714022,10714023,6670037,6670038,6670039,3962375,3962376,9174158,9174159,9174160,7025088,9179562,8566572,8566574,9172359,7026557,8853028,8849124,8849125,8849126,8849127,8849128,8849129,8849130,8849131,8849132,8849133,8849134,8849135,8849136,8849137,8849138,8849139,8849140,8849141,8849142,8849143,8849144,8849145,8849146,8849147,8849148,8849149,8849150,8849151,8849152,8849153,8849154,8849155,8849156,8849157,8849158,8849159,8849160,8849161,8849162,8849163,8849164,8849165,8849166,8849167,8849168,8849169,8849170,8849171,8849172,8849173,8849174,8849175,8849176,8849177,8849178,8849179,8849180,8849181,8849182,8849183,8849184,8849185,8849186,8849187,8849188,8849189,8849190,8849191,8849192,8849193,8849194,8849195,8849196,8849197,8849198,8849199,8849200,8849201,8849202,8849203,8849204,8849205,8849206,8849207,8849208,8849209,8849210,8849211,8849212,8849213,8849214,8849215,8849216,8849217,8849218,8849219,8849220,8849221,8849222,8849223,8849224,8849225,8849226,8849227,8849228,8849229,8849230,8849231,8849232,8849233,8849234,8849235,8849236,8849237,8849238,8849239,8849240,8849241,8849242,8849243,8849244,8849245,8849246,8849247,8849248,8849249,8849250,8849251,8849252,8849253,8849254,8849255,8849256,8849257,8849258,8849259,8849260,8849261,8849262,8849263,8849264,8849265,8849266,8849267,8849268,8849269,8849270,8849271,8849272,8849273,8849274,8849275,8849276,8849277,8849278,8849279,8849280,8849281,8849282,8849283,8849284,8849285,8849286,8849287,8849288,8849289,8849290,8849291,8849292,8849293,8849294,8849295,8849296,8849297,8849298,8849299,8849300,8849301,8849302,8849303,8849304,8849305,8849306,8849307,8849308,8849309,8849310,8849311,8849312,8849313,7055969,9186033,7023699,7023825,9178188,9178189,9178190,9178191,9192460,8848715,8848716,8848717,8848718,8848719,8848720,8848721,8848722,8848723,8848724,8848725,8848726,8848727,8848728,8848729,8848730,8848731,8848732,8848733,8848734,8848735,8848736,8848737,8848738,8848739,8848740,8848741,8848742,8848743,8848744,8848745,8848746,8848747,8848748,8848749,8848750,8848751,8848752,8848753,8848754,8848755,8848756,8848757,8848758,8848759,8848760,8848761,8848762,8848763,8848764,8848765,8848766,8848767,8848768,8848769,8848770,8848771,8848772,8848773,8848774,8848775,8848776,8848777,8848778,8848779,8848780,8848781,8848782,8848783,8848784,8848785,8848786,8848787,8848788,8848789,8848790,8848791,8848792,8848793,8848794,8848795,8848796,8848797,8848798,8848799,8848800,8848801,8848802,8848803,8848804,8848805,8848806,8848807,8848808,8848809,8848810,8848811,8848812,8848813,8848814,8848815,8848816,8848817,8848818,8848819,8848820,8848821,8848822,8848823,8848824,8848825,8848826,8848827,8848828,8848829,8848830,8848831,8848832,8848833,8848834,8848835,8848836,8848837,8848838,8848839,8848840,8848841,8848842,8848843,8848844,8848845,8848846,8848847,8848848,8848849,8848850,8848851,8848852,8848853,8848854,8848855,8848856,8848857,8848858,8848859,8848860,8848861,8848862,8848863,8848864,8848865,8848866,8848867,8848868,8848869,8848870,8848871,8848872,8848873,8848874,8848875,8848876,8848877,8848878,8848879,8848880,8848881,8848882,8848883,8848884,8848885,8848886,8848887,8848888,8848889,8848890,8848891,8848892,8848893,8848894,8848895,8848896,8848897,8848898,8848899,8848900,8848901,8848902,8848903,8848904,8848905,8848906,8848907,8848908,8848909,8848910,8848911,8848912,8848913,8848914,8848915,8848916,8848917,8848918,8848919,8848920,8848921,8848922,8848923,8848924,8848925,8848926,8848927,8848928,8848929,8848930,8848931,8848932,8848933,8848934,8848935,8848936,8848937,8848938,8848939,8848940,8848941,8848942,8848943,8848944,8848945,8848946,8848947,8848948,8848949,8848950,8848951,8848952,8848953,8848954,8848955,8848956,8848957,8848958,8848959,8848960,8848961,8848962,8848963,8848964,8848965,8848966,8848967,8848968,8848969,8848970,8848971,8848972,8848973,8848974,8848975,8848976,8848977,8848978,8848979,8848980,8848981,8848982,8848983,8848984,8848985,8848986,8848987,8848988,8848989,8848990,8848991,8848992,8848993,8848994,8848995,8848996,8848997,8848998,8848999,8849000,8849001,8849002,8849003,8849004,8849005,8849006,8849007,8849008,8849009,8849010,8849011,8849012,8849013,8849014,8849015,8849016,8849017,8849018,8849019,8849020,8849021,8849022,8849023,8849024,8849025,8849026,8849027,8849028,8849029,8849030,8849031,8849032,8849033,8849034,8849035,8849036,8849037,8849038,8849039,8849040,8849041,8849042,8849043,8849044,8849045,8849046,8849047,8849048,8849049,8849050,8849051,8849052,8849053,8849054,8849055,8849056,8849057,8849058,8849059,8849060,8849061,8849062,8849063,8849064,8849065,8849066,8849067,8849068,8849069,8849070,8849071,8849072,8849073,8849074,8849075,8849076,8849077,8849078,8849079,8849080,8849081,8849082,8849083,8849084,8849085,8849086,8849087,8849088,10418186,8849089,8849090,8849091,8849092,8849093,8849094,8849095,8849096,8849097,8849098,8849099,8849100,8849101,8849102,8849103,8849104,8849105,8849106,8849107,8849108,8849109,8849110,8849111,8849112,8849113,8849114,8849115,8849116,8849117,8849118,8849119,8849120,8849121,8849122,8849123,8549465,9190746,7020510,9207297,10115670,10115671,10115672,10115673,10115674,10115675,10115676,10115677,10115678,10115679,10115680,10115681,10115682,10115683,9207599,9207600,9207601,9176193,10169809,10169810,10888860,10893873,10893874,10170751,10170752,10170753,10170754,10170755,10170756,10170757,10170758,10170759,10170760,10170761,10155902,10155903,10155904,10155905,10155906,10155907,10155908,10155909,10155910,10155911,10155912,10155913,10155914,10155915,10155916,10155917,10155918,10892507,10892508,10892509,10168869,10169000,10169001,10169002,10154011,10154012,10898400,10162162,10896479,10896480,10896481,10896482,10896483,10896484,10896485,10881516,10187768,10187769,10877178,10649518,10649519,10649520,10643542,10643543,10643544,10643545,10643546,10643547,10643548,10643549,10643550,10602477,10602478,10602479,10602480,10602481,10602482,10602483,10602484,10602485,10602486,10602487,10602488,10602489,10602490,10602491,10602492,10602493,10602494,10602495,10602496,10602497,10602498,10602499,10602500,10602501,10602502,10602503,10602504,10602505,10602506,10602507,10652779,10652789,10583757,10650110,10587272,10587295,10587296,10587541,10644650,10644651,10644652,10644653,10644654,10644655,10644656,10645904,10519277,10519278,10525514,10545529,10545534,10541760,10541761,10545768,10545769,10545770,10545771,10545772,10545773,10541805,10541916,10522281,10528526,10522735,10522736,10424591,10424592,10496485,10495166,10476611) 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'