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(4970677,4970681,4970684,4970702,4970708,4970709,4970710,4970711,4970712,4970713,4970714,4970715,4970716,4970717,4970718,4970719,4970720,4970721,4970722,4970723,4970724,4970725,4970726,4970727,4970728,4970729,4970730,4970731,4970732,4970733,4970734,4970735,4970736,4970737,4970738,4970739,4970744,4970762,4970763,4970764,4970765,4970770,4970771,4971029,4969289,8075307,8075308,8075309,8075310,8075312,8075313,8075314,8075316,8075317,8075318,8075323,4967134,4967140,4967835,4967996,8072533,8072534,8072535,8072536,8072537,8072538,8072539,8073007,8073008,10622976,10623058,10623059,10623060,10623061,10623062,10623069,10623070,10623071,10623072,10623073,10623074,10623075,10623076,10623077,10623078,10623079,10623080,10623081,10623082,10623083,10623084,10623085,10623086,10623087,10623088,10623089,10623090,10623091,10623092,10623093,10623094,10623095,10623096,10623097,10623098,10623099,10623100,10623101,10623102,10623103,10623104,10623105,10623106,10623107,10623108,10623109,10623110,10623111,10623112,10623113,10623114,10623115,10623116,10623117,10623118,10623119,10623120,10623121,10623122,10623123,10623124,10623125,10623126,10623127,10623128,10623129,10623130,10623131,10623132,10623133,10623134,10623135,10623136,10623137,10623138,10623139,10623140,10623141,10623142,10623143,10623144,10623145,10623146,10623147,10623148,10623149,10623150,10623151,10623152,10623153,10623154,10623155,10623156,10623157,10623158,10623159,10623160,10623161,10623162,10623163,10623164,10623165,10623166,10623167,10623168,10623169,10623170,10623171,10623172,10623173,10623174,10623175,10623176,10623177,10623178,10623179,10623180,10623181,10623182,10623183,10623184,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623198,10623199,10623200,10623201,10623202,10623203,10623204,10623205,10623206,10623207,10623208,10623209,10623210,10623211,10623212,10623213,10623214,10623215,10623216,10623217,10623218,10623219,10623220,10623221,10623222,10623223,10623224,10623225,10623226,10623227,10623228,10623229,10623230,10623231,10623232,10623233,10623234,10623235,10623236,10623237,10623238,10623239,10623240,10623241,10623242,10623243,10623244,10623245,10623246,10623247,10623248,10623249,10623250,10623251,10623252,10623253,10623254,10623255,10623256,10623257,10623258,10623259,10623260,10623261,10623262,10623263,10623264,10623265,10623266,10623267,10623268,10623269,10623270,10623271,10623272,10623273,10623274,10623275,10623276,10623277,10623278,10623279,10623280,10623281,10623282,10623283,10623284,10623285,10623286,10623287,10623288,10623289,10623290,10623291,10623292,10623293,10623294,10623295,10623296,10623297,10623298,10623299,10623300,10623301,10623302,10623303,10623304,10623305,10623306,10623307,10623308,10623309,10623494,10623502,10623605,10623606,10623694,10623810,10623917,10623976,10624234,10624235,10624237,10624247,10624249,10624536,10624538,10624539,10624560,10624561,10624562,10624567,10624568,10624569,10624570,10624573,10624574,10624576,10624640,10624641,10624723,10624724,10624760,10624761,10624783,10624784,10624785,10624799,10624811,10624812,10624813,10624814,10624815,10624827,10624828,10624829,10624830,10624838,10624839,10624850,10624851,10624886,10624895,10624953,10624954,10624955,10624956,10624957,10624958,10621986,10622030,10622196,10622257,10622258,10622259,10622260,10622261,10622262,10622263,10622264,10622265,10622266,10622267,10622268,10622269,10622270,10622271,10622272,10622273,10622274,10622275,10622276,10622277,10622278,10622279,10622280,10622281,10622282,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10622305,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622343,10622344,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622360,10622361,10622362,10622363,10622364,10622365,10622366,10622367,10622368,10622369,10622370,10622371,10622372,10622373,10622374,10622375,10622376,10622377,10622378,10622379,10622380,10622381,10622382,10622383,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622399,10622400,10622401,10622402,10622403,10622404,10622405,10622406,10622407,10622408,10622409,10622410,10622411,10622412,10622413,10622414,10622415,10622416,10622417,10622418,10622419,10622420,10622421,10622422,10622423,10622424,10622425,10622426,10622428,10622431,10622432,10622433,10622434,10622435,10622436,10622437,10622438,10622439,10622440,10622441,10622442,10622443,10622444,10622445,10622446,10622447,10622448,10622449,10622450,10622451,10622452,10622457,10622458,10622459,10622460,10622461,10622464,10622465,10622466,10622467,10622468,10622469,10622470,10622471,10622472,10622473,10622474,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,10622496,10622497,10622498,10622499,10622500,10622501,10622502,10622503,10622504,10622505,10622506,10622507,10622508,10622509,10622510,10622511,10622512,10622513,10622514,10622516,10622518,10622519,10622520,10622521,10622522,10622523,10622524,10622525,10622526,10622527,10622528,10622529,10622530,10622531,10622532,10622534,10622535,10622536,10622537,10622538,10622539,10622548,10622549,10622605,10622606,10622607,10622608,10622609,10622610,10622611,10622614,10622615,10622616,10622617,10622618,10622619,10622620,10622622,10622623,10622627,10622634,10622635,10622696,10622697,10622698,10622750,10622751,10622752,10622877,10622878,10622879,10622880,10622881,10622882,10622883,10622884,10622885,10622886,10622887,10622888,10622889,10622890,10622891,10622892,10622893,10622894,10622895,10622896,10622897,10622898,10622899,10622900,10622901,10622902,10622903,10622904,10622905,10622906,10622907,10622908,10622909,10622910,10622911,10622912,10622913,10622914,10622915,10622916,10622917,10622918,10622919,10622920,10622937,10619962,10619963,10619964,10619965,10619966,10619967,10619968,10619969,10619970,10619971,10619972,10619973,10619974,10619975,10619976,10619977,10619978,10619979,10620077,10620107,10620112,10620113,10620114,10620115,10620129,10620138,10620203,10620204,10620205,10620206,10620226,10620227,10620228,10620229,10620230,10620231,10620232,10620233,10620297,10620298,10620306,10620326,10620338,10620339,10620340,10620341,10620342,10620343,10620344,10620345,10620346,10620347,10620348,10620349,10620350,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620389,10620390,10620391,10620392,10620395,10620396,10620402,10620406,10620407,10620408,10620409,10620410,10620411,10620412,10620413,10620415,10620477,10620512,10620646,10620764,10621089,10621162,10621940,10621951,10565478,10565646,10565647,10565648,10563518,10563567,10564129,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564137,10564138,10564139,10564140,10564141,10564142,10564143,10564144,10564145,10564146,10564147,10564148,10564149,10564150,10564151,10564152,10564153,10564154,10564155,10564156,10564157,10564158,10564159,10564160,10564161,10564162,10564163,10564164,10564165,10564166,10564167,10564168,10564169,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10564186,10564187,10564188,10564189,10564190,10564191,10564192,10564193,10564194,10564195,10564196,10564197,10564198,10564199,10564200,10564201,10564202,10564203,10564204,10564205,10564206,10564207,10564208,10564209,10564210,10564211,10564212,10564213,10564214,10564215,10564216,10564217,10564218,10564219,10564220,10564221,10564222,10564223,10564224,10564225,10564226,10564227,10564228,10564229,10564230,10564231,10564232,10564233,10564234,10564235,10564236,10564237,10564238,10564239,10564240,10564241,10564242,10564243,10564244,10564245,10564246,10564247,10564248,10564249,10564250,10564251,10564252,10564253,10564254,10564255,10564256,10564257,10564258,10564259,10564260,10564261,10564262,10564263,10564264,10564265,10564266,10564267,10564268,10564269,10564270,10564271,10564272,10564273,10564274,10564275,10564276,10564277,10564278,10564279,10564280,10564281,10564282,10564283,10564284,10564285,10564286,10564287,10564288,10564289,10564290,10564291,10564292,10564293,10564294,10564295,10564296,10564297,10564298,10564299,10564300) 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'