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(7076207,10448464,10448465,10448466,10448467,10448468,10448469,10448470,8839109,8839110,8839111,8839112,8839113,8839114,10933475,10933476,10933477,10933478,10933479,10933480,10933481,10933482,10933483,10933484,10933485,10933486,10933487,10933488,10933489,10933490,10933491,10437775,10437776,10437777,8075490,8075491,8075492,8075493,8911884,8911885,8911886,8911887,8911888,8911889,8911890,10104734,10104735,10104736,10104737,10104738,10104739,10104740,10104741,10104742,10104743,11049522,11049523,10945098,3657160,3657161,3657162,3657163,3657164,3657165,3657166,3657167,3657168,3657169,3657170,3657171,3657172,3657173,3657174,3657175,3657176,3657177,3657178,3657179,3657180,3657181,8579184,8579185,8579186,8579187,8579188,8579189,8579190,8579191,11046306,11046307,11046308,11046309,11046310,11046311,11046312,11046313,11046314,11046315,11046316,11046317,11046318,11046319,11046320,11046321,11046322,11046323,11046324,11046325,11046326,11046327,11046328,11046329,11046330,11046331,11046332,11046333,11046334,11046335,11046336,11046337,11046338,11046339,11046340,11046341,11046342,11046343,11046344,11046345,11046346,11046347,11046348,11046349,10928437,10928438,10928439,10928440,10928441,10928442,10928443,10928444,10928445,10928446,10928447,10928448,10928449,10928450,10952714,10952715,7059828,7059829,7059830,9213079,9213080,9213081,9213082,9213083,9213084,9213085,9213086,9213087,9213088,9213089,9213090,9213091,9213092,9213093,9213094,9213095,9213096,9213097,9213098,9213099,9213100,9213101,9213102,9213103,9213104,9213105,9213106,9213107,9213108,9213109,9213110,9213111,9213112,9213113,9213114,9213115,9213116,9213117,9213118,9213119,9213120,9213121,9213122,9213123,9213124,9213125,9213126,9213127,9213128,9213129,9213130,9213131,9213132,9213133,9213134,9213135,9213136,9213137,9213138,9213139,9213140,9213141,9213142,9213143,9213144,9213145,9213146,9213147,9213148,9213149,9213150,9213151,9213152,9213153,9213154,9213155,9213156,9213157,9213158,9213159,9213160,9213161,9213162,9213163,9213164,9213165,9213166,9213167,9213168,9213169,9213170,9213171,9213172,9213173,9213174,9213175,9213176,9213177,9213178,9213179,9213180,9213181,9213182,9213183,8563577,8563578,8563579,8563580,8563581,6668205,6668206,6668207,6668208,6668209,6668210,6668211,6668212,6668213,10632239,10632240,10632241,10188202,10188203,10188204,10188205,10188206,10188207,10188208,10188209,10188210,10188211,10188212,10188213,10595380,10595381,10595382,10595383,10595384,10595385,10595386,10595387,10595388,10595389,10595390,10595391,10595392,10595393,10595394,10595395,10595396,10595397,10595398,10595399,10595400,10595401,10595402,10595403,10595404,10595405,10595406,10595407,10595408,10595409,10595410,10595411,10595412,10595413,10595414,10595415,10595416,10595417,10595418,10595419,10595420,10595421,10595422,10595423,10595424,10595425,10595426,10595427,10595428,10595429,10595430,10595431,10595432,10595433,10595434,10595435,10595436,10595437,10595438,10595439,10595440,10595441,10595442,10595443,10595444,10595445,10595446,10595447,10595448,10595449,10595450,10595451,10595452,10595453,10595454,10595455,10595456,10595457,10595458,10595459,10595460,10595461,10595462,10595463,10595464,10595465,10595466,10595467,10595468,10595469,10595470,10595471,10595472,10595473,10595474,10595475,10595476,10595477,10595478,10595479,10595480,10595481,10595482,10595483,10595484,10595485,10595486,10595487,10595488,10595489,10595490,10595491,10595492,10595493,10595494,10595495,10595496,10595497,10595498,10595499,10595500,10595501,10595502,10595503,10595504,10595505,10595506,10595507,10595508,10595509,10595510,10595511,10595512,10595513,10595514,10595515,10595516,10595517,10595518,10595519,10595520,10595521,10595522,10595523,10595524,10595525,10595526,10595527,10595528,10595529,10595530,10595531,10595532,10595533,10595534,10595535,10595536,10595537,10595538,10595539,10595540,10595541,10595542,10595543,10595544,10595545,10595546,10595547,10595548,10595549,10595550,10595551,10595552,10595553,10595554,10595555,10595556,10595557,10595558,10595559,10595560,10595561,10595562,10595563,10595564,10595565,10595566,10595567,10595568,10595569,10595570,10595571,10595572,10595573,10595574,10595575,10595576,10595577,10595578,10595579,10595580,10595581,10595582,10595583,10595584,10595585,10595586,10595587,10595588,10595589,10595590,10595591,10595592,10595593,10595594,10595595,10595596,10595597,10595598,10595599,10595600,10595601,10595602,10595603,10595604,10595605,10595606,10595607,10595608,10595609,10595610,10595611,10595612,10595613,10595614,10595615,10595616,10595617,10595618,10595619,10595620,10595621,10595622,10595623,10595624,10595625,10595626,10595627,10595628,10595629,10595630,10595631,10595632,10595633,10595634,10595635,10595636,10595637,10595638,10595639,10595640,10595641,10595642,10595643,10595644,10595645,10595646,10595647,10595648,10595649,10595650,10595651,10595652,10595653,10595654,10595655,10595656,10595657,10595658,10595659,10595660,10595661,10595662,10595663,10595664,10595665,10595666,10595667,10595668,10595669,10595670,10595671,10595672,10595673,10595674,10595675,10595676,10595677,10595678,10595679,10595680,10595681,10595682,10595683,10595684,10595685,10595686,10595687,10595688,10595689,10595690,10595691,10595692,10595693,10595694,10595695,10595696,10595697,10595698,10595699,10595700,10595701,10595702,10595703,10595704,10595705,10595706,10595707,10595708,10595709,10595710,10595711,10595712,10595713,10595714,10595715,10595716,10595717,10595718,10595719,10595720,10595721,10595722,10595723,10595724,10595725,10595726,10595727,10595728,10595729,10595730,10595731,10595732,10595733,10595734,10595735,10595736,10595737,10595738,10595739,10595740,10595741,10595742,10595743,10595744,10595745,10595746,10595747,10595748,10595749,10595750,10595751,10595752,10595753,10595754,10595755,10595756,10595757,10595758,10595759,10595760,10595761,10595762,10595763,10595764,10595765,10595766,10595767,10595768,10595769,10595770,10595771,10595772,10595773,10595774,10595775,10595776,10595777,10595778,10595779,10595780,10595781,10595782,10595783,10595784,10595785,10595786,10595787,10595788,10595789,10595790,10595791,10595792,10595793,10595794,10595795,10595796,10595797,10595798,10595799,10595800,10595801,10595802,10595803,10595804,10595805,10595806,10595807,10595808,10595809,10595810,10595811,10595812,10595813,10595814,10595815,10595816,10595817,10595818,10595819,10595820,10595821,10595822,10595823,10595824,10595825,10595826,10595827,10595828,10595829,10595830,10595831,10595832,10595833,10595834,10595835,10595836,10595837,10595838,10595839,10595840,10595841,10595842,10595843,10595844,10595845,10595846,10595847,10595848,10595849,10595850,10595851,10595852,10595853,10595854,10595855,10595856,10595857,10595858,10595859,10595860,10595861,10595862,10595863,10595864,10595865,10595866,10595867,10595868,10595869,10595870,10595871,10595872,10595873,10595874,10595875,10595876,10595877,10595878,10595879,10595880,10595881,10595882,10595883,10595884,10595885,10595886,10595887,10595888,10595889,10595890,10595891,10595892,10595893,10595894,10595895,10595896,10595897,10595898,10595899,10595900,10595901,10595902,10595903,10595904,10595905,10595906,10595907,10595908,10595909,10595910,10595911,10595912,10595913,10595914,10595915,10595916,10595917,10595918,10595919,10595920,10595921,10595922,10595923,10595924,10595925,10595926,10595927,10595928,10595929,10595930,10595931,10595932,10595933,10595934,10595935,10595936,10595937,10595938,10595939,10595940,10595941,10595942,10595943,10595944,10595945,10595946,10595947,10595948,10595949,10595950,10595951,10595952,10595953,10595954,10595955,10595956,10595957,10595958,10595959,10595960,10595961,10595962,10595963,10595964,10595965,10595966,10595967,10595968,10595969,10595970,10595971,10595972,10595973,10595974,10595975,10595976,10595977,10595978,10595979,10595980,10595981,10595982,10595983,10595984,10595985,10595986,10595987,10595988,10595989,10595990,10595991,10595992,10595993,10595994,10595995,10595996,10595997,10595998,10595999,10596000,10596001,10596002,10596003,10596004,10596005,10596006,10596007,10596008,10596009,10596010,10596011,10596012,10596013,10596014,10596015,10596016,10596017,10596018,10596019,10596020,10596021,10596022,10596023,10596024,10596025,10596026,10596027,10596028,10596029,10596030,10596031,10596032,10596033,10596034,10596035,10596036,10596037,10596038,10596039,10596040,10596041,10596042,10596043,10596044,10596045,10596046,10596047,10596048,10596049,10596050,10596051,10596052,10596053,10596054,10596055,10596056,10596057,10596058,10596059,10596060,10596061,10596062,10596063,10596064,10596065,10596066,10596067,10425152,10425153,10425154,10425155,10475995,10475996,10475997,10475998,10475999,10476000,10476001,10476002,10476003,10476004,10476005,10476006,10476007,10476008,10476009,10476010,10476011,10476012,10476013,10476014,10476015,10476016,10476017) 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'