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(4970636,4970638,4970666,4970667,4970668,4970669,4971019,4971020,4971021,4971022,4971023,4971024,4971025,4971026,4971027,4971028,4971031,4971032,4971033,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4971095,4971096,4971119,4971120,4968379,4968443,4968608,4968613,4968614,4968619,4968620,4968621,4968626,4968627,4968631,4968634,4968636,4968637,4968642,4968643,4968655,4968836,4968839,4968840,4969227,4969381,4969570,8075309,8075312,8075317,8075357,8075361,8075379,8075414,8075415,8075419,8075457,8075471,8075481,8075489,8075539,8075540,8075541,4967134,4967140,4967835,4968029,8071670,8071671,8071672,8071673,8071674,8071675,8071676,8071677,8071678,8071679,8071680,8071681,8071682,8071683,8071684,8071685,8071686,8071687,8071688,8071689,8071690,8071691,8071692,8071693,8071694,8071695,8071696,8071697,8071698,8071699,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707,8071708,8071709,8071710,8071711,8071712,8071713,8071714,8071715,8071716,8071717,8071718,8071719,8071720,8071721,8071722,8071723,8071724,8071725,8071726,8071727,8071728,8071729,8071730,8071731,8071732,8071733,8071734,8071735,8071736,8071737,8071738,8071739,8071740,8071741,8071742,8071743,8071744,8071745,8071746,8071747,8071748,8071749,8071750,8071751,8071752,8071753,8071754,8071755,8071756,8071757,8071758,8071759,8071760,8071761,8071762,8071763,8071764,8071765,8071766,8071767,8071768,8071769,8071770,8071771,8071772,8071773,8071774,8071775,8071776,8071777,8071778,8071779,8071780,8071781,8071782,8071783,8071784,8071785,8071786,8071787,8071788,8071789,8071790,8071791,8071792,8071793,8071794,8071795,8071796,8071797,8071798,8071799,8071800,8071801,8071802,8071803,8071804,8071805,8071806,8071807,8071808,8071809,8071810,8071811,8071812,8071813,8071814,8071815,8071816,8071817,8071818,8071819,8071820,8071821,8071822,8071823,8071824,8071825,8071826,8071827,8071828,8071829,8071830,8071831,8071832,8071833,8071834,8071835,8071836,8071837,8071838,8071839,8071840,8071841,8071842,8071843,8071844,8071845,8071846,8071847,8071848,8071849,8071850,8071851,8071852,8071853,8071854,8071855,8071856,8071857,8071858,8071859,8071860,8071861,8071862,8071863,8071864,8071865,8071866,8071867,8071868,8071869,8071870,8071871,8071872,8071873,8071874,8071875,8071876,8071877,8071878,8071879,8071880,8071881,8071882,8071883,8071884,8071885,8071886,8071887,8071888,8071889,8071890,8071891,8071892,8071893,8071894,8071895,8071896,8071897,8071898,8071899,8071900,8071901,8071902,8071903,8071904,8071905,8071906,8071907,8071908,8071909,8071910,8071911,8071912,8071913,8071914,8071915,8071916,8071917,8071918,8071919,8071920,8071921,8071922,8071923,8071924,8071925,8071926,8071927,8071928,8071929,8071930,8071931,8071932,8071933,8071934,8071935,8071936,8071937,8071938,8071939,8071940,8071941,8071942,8071943,8071944,8071945,8071946,8071947,8071948,8071949,8071950,8071951,8071952,8071953,8071954,8071955,8071956,8071957,8071958,8071959,8071960,8071961,8071962,8071963,8071964,8071965,8071966,8071967,8071968,8071969,8071970,8071971,8071972,8071973,8071974,8071975,8071976,8071977,8071978,8071979,8071980,8071981,8071982,8071983,8071984,8071985,8071986,8071987,8071988,8071989,8071990,8071991,8071992,8071993,8071994,8071995,8071996,8071997,8071998,8071999,8072000,8072001,8072002,8072003,8072004,8072005,8072006,8072007,8072008,8072009,8072010,8072011,8072012,8072013,8072014,8072015,8072016,8072017,8072018,8072019,8072020,8072021,8072022,8072023,8072024,8072025,8072026,8072027,8072028,8072029,8072030,8072031,8072032,8072033,8072034,8072035,8072036,8072037,8072038,8072039,8072040,8072041,8072042,8072043,8072044,8072045,8072046,8072047,8072048,8072049,8072050,8072051,8072052,8072053,8072054,8072055,8072056,8072057,8072058,8072059,8072060,8072061,8072062,8072063,8072064,8072065,8072066,8072067,8072068,8072069,8072070,8072071,8072072,8072073,8072074,8072075,8072076,8072077,8072078,8072079,8072080,8072081,8072082,8072083,8072084,8072085,8072086,8072087,8072088,8072089,8072090,8072091,8072092,8072093,8072094,8072095,8072096,8072097,8072098,8072099,8072100,8072101,8072102,8072103,8072104,8072105,8072106,8072107,8072108,8072109,8072110,8072111,8072112,8072113,8072114,8072115,8072116,8072117,8072118,8072119,8072120,8072121,8072122,8072123,8072124,8072125,8072126,8072127,8072128,8072129,8072130,8072131,8072132,8072133,8072134,8072135,8072136,8072137,8072138,8072139,8072140,8072141,8072142,8072143,8072144,8072145,8072146,8072147,8072148,8072149,8072150,8072151,8072152,8072153,8072154,8072155,8072156,8072157,8072158,8072159,8072160,8072161,8072162,8072163,8072164,8072165,8072166,8072167,8072168,8072169,8072170,8072171,8072172,8072173,8072174,8072175,8072176,8072177,8072178,8072179,8072180,8072181,8072182,8072183,8072184,8072185,8072186,8072187,8072188,8072189,8072190,8072191,8072192,8072193,8072194,8072195,8072196,8072197,8072198,8072199,8072200,8072201,8072202,8072203,8072204,8072205,8072206,8072207,8072208,8072209,8072210,8072211,8072212,8072213,8072214,8072215,8072216,8072217,8072218,8072219,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072228,8072229,8072230,8072231,8072232,8072233,8072234,8072235,8072236,8072237,8072238,8072239,8072240,8072241,8072242,8072243,8072244,8072245,8072246,8072247,8072248,8072249,8072250,8072251,8072252,8072253,8072254,8072255,8072256,8072257,8072258,8072259,8072260,8072261,8072262,8072263,8072264,8072265,8072266,8072267,8072268,8072269,8072270,8072271,8072272,8072273,8072274,8072275,8072276,8072277,8072278,8072279,8072280,8072281,8072282,8072283,8072284,8072285,8072286,8072287,8072288,8072289,8072290,8072291,8072292,8072293,8072294,8072295,8072296,8072297,8072298,8072299,8072300,8072301,8072302,8072303,8072304,8072305,8072306,8072307,8072308,8072309,8072310,8072311,8072312,8072313,8072314,8072315,8072316,8072317,8072318,8072319,8072320,8072321,8072322,8072323,8072324,8072325,8072326,8072327,8072328,8072329,8072330,8072331,8072332,8072333,8072334,8072335,8072336,8072337,8072338,8072339,8072340,8072341,8072342,8072343,8072344,8072345,8072346,8072347,8072348,8072349,8072350,8072351,8072352,8072353,8072354,8072355,8072356,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072383,8072384,8072385,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072396,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072407,8072408,8072409,8072410,8072411,8072412,8072413,8072414,8072415,8072416,8072417,8072418,8072419,8072420,8072421,8072422,8072423,8072424,8072425,8072426,8072427,8072428,8072429,8072430,8072431,8072432,8072433,8072434,8072435,8072436,8072437,8072438,8072439,8072440,8072441,8072442,8072443,8072444,8072445,8072446,8072447,8072448,8072449,8072450,8072451,8072452,8072453,8072454,8072455,8072456,8072457,8072458,8072459,8072460,8072461,8072462,8072463,8072464,8072465,8072466,8072467,8072468,8072469,8072470,8072471,8072472,8072473,8072474,8072475,8072476,8072477,8072478,8072479,8072480,8072481,8072482,8072483,8072484,8072485,8072486,8072487,8072488,8072489,8072490,8072491,8072492,8072493,8072494,8072495,8072496,8072497,8072498,8072499,8072500,8072501,8072502,8072503,8072504,8072505,8072506,8072507,8072508,8072509,8072510,8072511,8072512,8072513,8072514,8072515,8072516,8072517,8072518,8072519,8072520,8072521,8072522,8072523,8072524,8072525,8072526,8072527,8072528,8072529,8072530,8072531,8072532,8072996,8073065,8073068,8073070,8073099,8073100,8073101,8073103,8073104,8073105,8073106,8073107,8073108,8073109,8073110,8073111,8073112,8073114,8073115,8073116,8073118,8073119,8073120,8073121,8073124,8073125,8073126,8073127,8073128,8073129,8073131,8073132,8073133,8073134,8073135,8073136,8073137,8073139,8073140,8073141,8073142,8073144,8073146,8073147,8073148,8073149,8073151,8073152,8073153,8073154,8073155,8073156,8073158,8073159,8073160,8073162,8073163,8073164,8073166,8073168,8073169) 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'