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(10939596,7068045,7068047,7068052,10988887,10939925,10989064,10989066,10940010,10940011,4970666,4970667,4970668,4970669,7068485,8569704,8569705,10963566,10963567,10963568,10963569,10963570,10963726,7066130,7066131,7066132,7066133,7066134,7066135,10437064,10437073,7074373,10437250,10437252,10437253,7074527,7066677,10437577,10437578,10437579,10437580,7074903,7074908,10938615,7075156,7067277,7075322,10962050,10962051,10962052,7075419,10962150,10939135,7075525,7075589,7075592,7075593,7075607,7075616,7075640,7075641,7075642,10988423,10962449,7075772,7075773,7067809,10939436,7067846,10939548,10985665,7072147,7064254,10931652,10931653,7064458,10931815,10986168,10960242,10986260,10986261,10986265,10960355,10960356,10960359,7064690,10986480,10986481,10986482,10986483,10986484,10986485,10986486,10986487,10986488,10986489,10986490,10960506,4967134,4967140,7065007,7065008,7065066,7065067,7073131,7065251,7073390,7073408,7073419,7073488,10961233,4967835,10987346,7071130,10984918,10984924,10984925,10984926,10984927,10984928,10984929,10984930,10985071,10985072,7071407,7071442,7071446,10943270,10943272,10943338,7071832,10959562,10959569,7068959,10940584,7069091,10940883,10940969,7069357,7069364,7069365,3655956,7069497,7069503,10941369,10941439,11047718,11047731,7069985,10941710,3656712,10941794,10941796,7070175,10941803,10941804,10941805,10941806,10941807,10941808,10941816,10941818,10941824,10941835,10941836,7070235,7070237,10941896,10941897,10941900,10941901,10941902,10941904,10941906,10941907,10941945,10941947,10941984,10941989,10941990,10941994,10941996,10941998,10941999,10942002,10942003,10942007,10942008,7070391,7070392,8073129,10942019,10942020,10942025,10942029,10942034,7070435,10942107,10942206,10958377,10958378,10958387,10958388,10958389,10958390,7070715,7070804,11048721,10942524,10928497,10623048,10623050,10623058,10623059,10623063,10623064,10623065,10618257,10618258,10967917,10967918,10967927,10967928,10967944,10967945,10967952,10967953,10967954,10967955,8070064,8070080,8070116,8070117,10618442,10618448,10618452,10623491,10623492,10623493,10623494,10623499,10955221,10955367,10955391,10955431,10968583,10968584,10968585,10968586,10955586,10968587,10968588,10968589,10623976,8070808,8070809,8070810,10619194,10619195,10619196,10619202,10624536,10624583,10619864,10619865,10619866,10619875,10622142,10622143,10622144,10622154,10622188,10622190,10622192,10622193,10622194,10622195,10622196,10622197,10622228,10622230,10927886,10927887,10954146,10954176,10622599,10928362,10928371,10928372,10928400,10928401,10928402,10928403,10928416,10928417,10928418,10928420,10928438,10928440,10928441,10928456,10928464,8570028,8570107,10620167,8570126,10620183,10620207,10615285,10925894,10925929,10925942,10615451,10615452,8570403,10615453,10615454,10615455,10615456,10615457,10615458,10615460,10615461,8570413,10620523,8570495,10615549,8570514,8570515,8570516,10615598,10965296,10965297,10965298,10965299,10965428,10620860,10620861,10616002,10616003,10616004,10616005,10616033,10616059,10621075,10616856,10616862,10616872,10616880,10616881,10611201,10611202,10559403,10559404,10559405,10559476,7059868,6665743,6665746,6665931,6665932,9166227,6666263,6666266,10609330,10609348,10609357,10557702,10557703,10557704,10557705,10557706,10557712,10557713,10557714,7058182,7058202,7058258,10610001,10610024,10558306,10613164,10613165,10558317,10558318,10558319,10558320,9164536,10558402,10610333,10610337,10610351,10610418,10564609,10564610,10564611,10564612,10564613,10564623,10564624,10564625,10564626,10564637,10564638,10564640,10564641,10564642,10564643,10564644,10564663,10564665,10564667,10564834,10564840,10564841,10564842,10564859,10564860,10564862,10564873,10564881,10613743,10613750,10564936,10564937,10564938,10564939,10564940,10564941,10564943,10564974,10559007,10559008,10559009,10559010,10559012,10517244,10517245,10517246,10517247,10517248,10517249,10517250,10517251,10517252,10517253,10517254,10517255,10517256,10517257,10517258,10517259,10517260,10517261,10517262,10517263,10517264,10517265,10517266,10517267,10517268,10517269,10517270,10517271,10517272,10517273,10517274,10515274,10517275,10515275,10517276,10515276,10517277,10517278,10517279,10517280,10517281,10517282,10517283,10517284,10517285,10517286,10517287,10517288,10517289,10517290,10517291,10517292,10517293,10517294,10517295,10517296,10517297,10517298,10517299,10517300,10517301,10517302,10517303,10517304,10517305,10517306,10517307,10517308,10517309,10517310,10517311,10517312,10517313,10517314,10517315,10517316,10517317,10517318,10517319,10517320,10517321,10517322,10517323,10517324,10517325,10517326,10517327,10515339,10515340,10513344,10513345,10513346,10513347,10513348,10513349,10513350,10513351,10513352,10513353,10513354,10513355,10513356,10513357,10513358,10513359,10513360,10513361,10513362,10513363,10513364,10513365,10513366,10513367,10513368,10513369,10513370,7055723,10513371,10513372,10513381,10513382,10513383,10513384,10513385,7055747,7055748,10515433,10515434,10515435,7055857,7055868,7055933,10517789,10517790,10517791,10517792,10517793,10517794,10517795,10517796,10517797,10517798,10517799,10517800,10517801,10517802,10517803,10517804,10517805,10517806,10517807,10517808,10512180,10512181,10512182,10512183,10512184,10512185,10512186,10512187,10512188,10512189,10512190,10516491,10516492,10512530,10512571,10512573,10512574,10512575,10514629,7057097,7057148,7057149,7057158,10514834,10514835,10514836,7057206,10514895,10512910,10512912,10512913,7057273,10512920,10512921,10512922,10512923,10512930,7057289,10512936,10512937,10512946,10512947,10512948,10512951,10512958,10512959,10512960,10512961,4973256,7054861,7054920,10420053,10420054,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,6666480,6666483,6666484,6666487,6666602,6666641,6666645,6666646,6666726,6666727,6666728,6666729,6666778,6666798,6666799,6666802,4971692,6667019,6667020,6667021,6667022,6667023,6667024,6667025,6667026,6667028,6667029,6667078,6667079,6667080,8916795,8917030,4972256,4972257,4972258,4972259,8917220,8563473,8563541,4972534,8917563,8917564,8917686,10628851,10628853,10631998,10631999,10632000,10627016,10627018,10632167,10632168,10627187,10627188,10632257,10153849,10627634,10627667,10627713,10627714,10627771,10627772,10627773,10627780,10627781,10627782,10627783,10627784,10627785,10627786,10627787,10627788,10627790,10627791,10627792,10627794,10627795,10627796,10627797,10627798,10627799,10627800,10627801,10627802,10627803,10627805,10627806,10627807,10627808,10627809,10627810,10627811,10627812,10627813,10627814,10627815,10627816,10627817,10627818,10627819,10627820,10627824,10627825,10627826,10627827,10627828,10627829,10627830,10627833,10627834,10627835,10627836,10627837,10627838,10627839,10627840,10627841,10627842,10627843,10627844,10627845,10627846,10627847,10627848,10627849,10627850,10627851,10627852,10627853,10627854,10627855,10627860,10627861,10627862,10627863,10627864,10627866,10627867,10627868,10627869,10627870,10627871,10627872,10627873,10627874,10627876,10627877,10627878,10627879,10627880,10627881,10627882,10627883,10627884,10627887,10627888,10627889,10627890,10627891,10627892,10627897,10627898,10627899,10627900,10627901,10627902,10627903,10627904,10627905,10627906,10627907,10627908,10627909,10627911,10627912,10627913,10627914,10627915,10627916,10627917,10627919,10627920,10627921,10627922,10627923,10627924,10627925,10627926,10627948,10624965,10625001,10625002,10630114,10630191,10630192,10630193,10630284,10630285,10626143,10626144,10626193,10626194,10626196,10626225,10626275,10626302,10631352,10631353,10631455,10631456,10631549,10626951,10626955,10566140,10566198,10566199,10566200,10566202,10566203,10566204,10566205,10566206,10566207,10566212,10566213,10566214,10566215,10566216,10566217,10566218,10566219,10566220,10566221,10566222,10566223,10566224,10566225,10566226,10566228,10566229,10566230,10566232,10566238,10566239,10566240,10566241,10566244,10566245,10567554,10521266,10521413,10521414,10521415,10521416,10521417,10521418,10521419,10521420,10521421,10521422,10521423,10521647,10522476,10522477,10522478,10522479,10522480,10522481,10522482,10522483,10522484,10522485,10522486,10522487,10522488,10522489,10522490,10522491,10522492,10522619,10522620,10522814,10522815,10523062,10523063,10421237,10421242,10421243,10421244,10420717,10420746,10420747,10420748) 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'