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(4970645,4970646,4970647,4970648,4970649,4970652,4970653,4970654,4970655,4970656,4970657,4970658,4970666,4970667,4970668,4970669,4970713,4970745,4970749,4970750,4970752,4970853,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970865,4970866,4970867,4970868,4970869,4970870,4970871,4970872,4970873,4970874,4970875,4970876,4970877,4970878,4970879,4970880,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970938,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970974,4970975,4970976,4970977,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970995,4971007,4971008,4971020,4971026,4971027,4971028,4971031,4971037,4971051,4971054,4971055,4971056,4971057,4971058,4971060,4971061,4971062,4971068,4971073,4971074,4971075,4971076,4971097,4971125,4968193,4968194,4968211,4968212,4968340,4968458,4968678,4968679,4968680,4968681,4968690,4968691,4968698,4968702,4968703,4968723,4968727,4968744,4968768,4969184,4969252,4969266,4969267,4969268,4969269,8075244,8075284,8075285,8075286,8075287,8075290,8075291,8075292,8075307,8075308,8075309,8075310,8075311,8075312,8075320,8075332,8075337,8075338,4967030,4967031,4967032,4967033,4967134,4967140,4967147,4967835,4967941,4967980,4967981,4967982,4967983,4967984,4967985,4967986,4967987,4967988,4967989,4967990,4967991,4967992,4967993,4967994,4967995,4967996,4967997,4967998,4967999,4968000,4968001,4968002,4968003,4968004,4968005,4968006,4968007,4968008,4968009,4968010,4968011,4968012,4968013,4968014,4968015,4968016,4968017,4968018,4968019,4968020,4968021,4968022,4968023,4968024,4968025,4968026,4968027,4968028,8071708,8071709,8071711,8071712,8071713,8071714,8071715,8071716,8071717,8071773,8071774,8071776,8071777,8071778,8071779,8071780,8071781,8071782,8071838,8071839,8071841,8071842,8071843,8071844,8071845,8071846,8071847,8071903,8071904,8071906,8071907,8071908,8071909,8071910,8071911,8071912,8071968,8071969,8071971,8071972,8071973,8071974,8071975,8071976,8071977,8072033,8072034,8072036,8072037,8072038,8072039,8072040,8072041,8072042,8072098,8072099,8072101,8072102,8072103,8072104,8072105,8072106,8072107,8072163,8072164,8072166,8072167,8072168,8072169,8072170,8072171,8072172,8072228,8072229,8072231,8072232,8072233,8072234,8072235,8072236,8072237,8072308,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072396,8072407,8072408,8072409,8072410,8072411,8072412,8072417,8072418,8072419,8072420,8072421,8072422,8072429,8072438,8072439,8072440,8072441,8072442,8072448,8072449,8072450,8072451,8072452,8072453,8072454,8072463,8072464,8072465,8072466,8072467,8072468,8072470,8072472,8072474,8072475,8072476,8072477,8072478,8072479,8072480,8072481,8072482,8072494,8072495,8072496,8072500,8072501,8072502,8072506,8072507,8072508,8072511,8072512,8072513,8072514,8072515,8072520,8072521,8072522,8072523,8072528,8072529,8072530,8072535,8072536,8072537,8072541,8072543,8072545,8072550,8072556,8072562,8072563,8072564,8072567,8072568,8072569,8072570,8072571,8072577,8072579,8072590,8072591,8072593,8072594,8072600,8072601,8072603,8072604,8072610,8072611,8072613,8072614,8072615,8072616,8072617,8072619,8072620,8072621,8072622,8072623,8072624,8072626,8072627,8072633,8072634,8072636,8072637,8072693,8072694,8072695,8072696,8072697,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,8072809,8072810,8072811,8072812,8072813,8072814,8072815,8072816,8072825,8072826,8072827,8072828,8072829,8072830,8072831,8072832,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8072841,8072842,8072843,8072844,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8072865,8072866,8072867,8072868,8072869,8072870,8072871,8072872,8072885,8072886,8072887,8072888,8072889,8072890,8072901,8072902,8072903,8072904,8072905,8072906,8072907,8072908,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072950,8072951,8072952,8072953,8072954,8072955,8072956,8072957,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,8072992,8072993,8073095,8073096,8073097,8073446,8073448,8073449,8073458,8073512,8073533,8073534,8073535,8073537,8073538,8073539,8073542,8073543,8073545,10622986,10623003,10623016,10623019,10623022,10623024,10623055,10623058,10623094,10623095,10623101,10623170,10623183,10623184,10623253,10623254,10623255,10623256,10623257,10623291,10623292,10623293,10623294,10623295,10623310,10623399,10623491,10623504,10624056,10624057,10624084,10624085,10624086,10624087,10624121,10624614,10624615,10624650,10624674,10624693,10624823,10621981,10621985,10621986,10621996,10622010,10622011,10622012,10622014,10622032,10622033,10622049,10622050,10622055,10622060,10622071,10622101,10622102,10622113,10622114,10622115,10622121,10622125,10622126,10622127,10622192,10622199,10622200,10622201,10622238,10622239,10622246,10622257,10622344,10622420,10622700,10622718,10622719,10622720,10622902,10622914,10622915,10622916,10620062,10620076,10620097,10620106,10620211,10620217,10620238,10620307,10620320,10620346,10620347,10620348,10620349,10620350,10620351,10620353,10620354,10620381,10620382,10620487,10620488,10620491,10620637,10620638,10620639,10620640,10620641,10620642,10620643,10620644,10620645,10620646,10620647,10620648,10620649,10620650,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620859,10620860,10620861,10620862,10621070,10621076,10621077,10621078,10621144,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621247,10621248,10621249,10621250,10621251,10621252,10621253,10621254,10621255,10621256,10621257,10621258,10621259,10621260,10621261,10621262,10621263,10621264,10621288,10621289,10621290,10621291,10621292,10621293,10621294,10621295,10621296,10621297,10621298,10621299,10621300,10621301,10621302,10621303,10621304,10621305,10621306,10621307,10621308,10621309,10621310,10621311,10621312,10621313,10621314,10621315,10621316,10621317,10621318,10621319,10621320,10621321,10621322,10621323,10621324,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621341,10621342,10621343,10621344,10621345,10621346,10621347,10621348,10621349,10621350,10621351,10621352,10621353,10621354,10621355,10621356,10621357,10621358,10621381,10621382,10621421,10621422,10621423,10621424,10621425,10621426,10621427,10621428,10621429,10621430,10621431,10621432,10621433,10621434,10621439,10621440,10621441,10621445,10621446,10621447,10621456,10621460,10621464,10621480,10621510,10621511,10621512,10621513,10621514,10621515,10621516,10621517,10621518,10621519,10621520,10621521,10621522,10621523,10621524,10621525,10621526,10621527,10621528,10621529,10621530,10621531,10621532,10621533,10621534,10621535,10621536,10621537,10621538,10621539,10621540,10621541,10621542,10621543,10621544,10621545,10621564,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621630,10621646,10621649,10621658,10621668,10621669,10621675,10621676,10621732,10621745,10565148,10565149,10565159,10565249,10565308,10565309,10565310,10565311,10565319,10565320,10565321,10565349,10565445,10565446,10565447,10565448,10565449,10565843,10565844,10565845,10565846,10565847,10565848,10565849,10565850,10565851,10565852,10565853,10565854,10565855,10565856,10565857,10565858,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565875,10565876,10565953,10565954,10565955) 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'