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(7067913,8068807,8068823,8068824,7075935,10962749,7076131,7076140,10963044,10963090,10963091,10963092,7068485,8569719,8569731,8569732,4971095,4971096,10963567,10963568,10963569,10963570,10963638,10963639,10963717,10963718,10963872,10963873,10963874,7066242,7066244,7066276,8067337,10437249,10437424,7066583,7066606,7074632,7066677,8067787,8067788,8067789,8067790,8067791,8067792,7067002,7067003,7067047,7067049,8067941,7067051,7067058,7067358,7067583,7067697,7067713,7067731,7067732,7067733,7067734,7075778,7075779,7075783,7067793,7067839,7067892,7067893,7067894,7067895,7067896,7067897,7067898,7067899,7067900,7067901,7067902,7067903,7072046,7072048,7072052,7072073,7072074,7072249,7072259,7072263,7072280,7064337,10960034,10931765,7072455,7072456,7072457,7072458,7072459,7072460,7072461,7072462,7072463,7072464,7072465,7072466,7072467,10960160,10960161,10960164,7072543,8075310,8075314,8075318,10932050,10932057,10932060,10932063,10932069,10960417,10932232,10932233,10932234,8066105,8066106,8066107,8066108,8066109,8066110,8066111,8066112,8066113,8066114,8066115,7073161,10960946,10932759,10932760,10932761,10932768,10932769,10932770,10932771,10961130,10961131,7065455,7065592,7073632,7073633,7073634,7073635,7073663,7065907,11049165,7071536,7071899,3655527,3655528,3655529,3655530,3655531,10944411,10944412,10944430,10944431,10944432,10944433,10944434,10944435,10944436,10944437,10944438,10944439,10944440,3655750,10944743,10944764,7069592,7069718,7069773,8072547,8072549,8072553,8072555,8072561,8072566,8072569,8072571,8072574,8072576,8072583,8072585,8072587,8072589,10941716,3656931,3656932,10942123,7070754,10942405,7070794,7070840,10942493,10942494,10942495,10622968,10622971,10623003,10623064,10623065,10618229,10967860,10967861,10618232,10618233,10967876,10618265,10967900,10618271,8070020,8070021,8070022,8070023,10623516,10623517,10623655,10968420,10968421,10968455,10968456,10968458,10968459,10968460,10968461,10968462,10968463,10968464,10619219,10619835,10619864,10619865,10619869,10619870,10619872,10619873,10619874,10619875,10621974,10966794,10617209,10617223,10966865,10966866,10966867,10966868,10966869,10966870,10966871,10966872,10966873,10966874,10966875,10966876,10966897,10927803,10927804,10927805,10617538,10617539,10954178,10954179,10617573,10954313,10617745,10617957,10614983,10614992,10614994,10614995,10925526,10615037,10620069,10620070,10615088,10615090,10620107,8570059,8570060,8570061,8570062,10615155,10615156,10615159,8570093,8570094,8570095,8570096,8570097,8570098,8570099,8570100,8570101,8570102,8570103,8570104,8570105,8570106,8570108,8570109,8570110,8570111,8570112,8570113,8570114,8570115,8570116,8570117,8570118,8570119,8570120,8570121,8570122,8570123,8570124,10620203,8570125,10620204,10620205,10620206,8570137,8570138,8570146,8570147,8570148,10964891,10964892,10615266,10615271,10615276,10964939,10925824,10615315,10615334,10615339,10615340,10615341,10615342,10615356,10615491,10615520,10965283,10965284,10965285,10615674,10615682,10620800,10930718,10965470,10965471,10621067,10621068,10621069,10922133,10922134,10922135,10922136,10922137,10922138,10922139,10922140,10922141,10922142,10922143,10616955,10565150,10611162,7059680,10562332,10614221,10614238,7059745,10614245,10614247,10614248,10614249,10614250,10614252,10614253,10614254,10614256,10614257,10614260,10614261,10614263,10614264,10614269,10614271,10614272,7059787,7059800,7059852,6665751,10614548,8864434,8864435,8864436,8864437,8864438,8864439,8864440,8864441,10559746,10559747,10559750,10559751,10559752,8864553,10559865,10559866,10614744,10611762,10611805,10611821,10560015,10560059,10611944,10611948,7057470,7057471,10611986,10560175,10560176,10612040,10560191,10560192,10612062,10612063,10612064,10612074,10612076,8861949,7057600,10560268,10560269,7057722,7057732,7057733,10612253,10560426,10609311,10612319,10557515,10557517,10557518,10563546,10563564,10563565,10563566,10563570,10609443,10609444,10557663,10557664,10557719,10557720,7058094,7058129,7058144,7058145,7058147,7058148,7058150,7058182,7058202,10609717,10609749,10557969,10609886,10612927,10612987,10612988,10612989,10610023,10613055,8862997,10558289,10613143,10558294,10613158,10613159,10613160,10613162,10613166,8863026,8863027,8863028,8863029,8863030,10613171,8863031,8863032,8863033,8863034,8863035,8863036,8863037,10613178,8863038,10613179,8863039,8863040,8863041,8863042,8863043,8863044,8863045,8863046,8863047,8863048,8863049,8863050,10613191,8863051,10613192,8863052,8863053,8863054,8863055,8863056,8863057,8863058,8863059,8863060,8863061,8863062,8863063,8863064,8863065,8863066,8863067,8863068,8863069,8863070,8863071,8863072,8863073,10613214,10613215,10613221,10613225,10613264,10610327,10613355,10613557,10613734,10613735,10610911,10610912,10610913,10610914,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,10517275,10517276,10517277,10517278,10517279,10517280,10517281,10517282,10517283,10517284,10517285,10517286,10517287,10517288,10517289,10517290,10517291,10517292,10517293,10517294,10517295,10517296,10517297,10517298,10517299,10515322,10515323,10515324,10515325,10513393,10513394,10513395,10515395,10515396,10515397,10515398,10515399,10515400,10511454,10511456,10511457,10511458,10511459,10515490,10517758,10517759,10517760,10517761,10517762,10517763,10517764,10517768,10517769,10517770,10517820,10517821,10513866,10513867,10513868,10513869,10513870,10513871,10513872,10518204,10518205,10518206,10518207,10518208,10518209,10518210,10518211,10518212,10518213,10518214,10518215,10518216,10518217,10518218,10518219,10518220,10518221,10518222,10518223,10518224,10518225,10518226,10518290,10518291,10518292,10516292,10516293,10518293,10518294,10518295,10516295,10518296,10516296,10518297,10516297,10518298,10518299,10518300,10518301,10518302,10518303,10518406,10518407,10518408,10518409,10518410,10518411,10518595,10518596,10518597,10512780,10514789,10514790,10512876,10512877,10512878,10512899,10516928,10417410,10417411,10417412,10417413,10417414,10417415,10417416,10417422,10417423,4973379,4973380,10418513,10418515,10418517,10418519,10418523,10418525,4973791,10418157,10418158,10418161,4971385,4971386,4971387,4971388,8563229,10468153,10628146,10628147,10628450,10629405,10626963,10627017,10627019,10627113,10627114,10627115,10627145,10627190,10627321,10627663,10627664,10627706,10627707,10627708,10627709,10627710,10627711,10627712,10627713,10627714,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10627724,10627725,10627726,10627727,10627728,10627729,10627730,10627731,10627732,10627733,10627734,10627735,10627736,10627737,10627738,10627739,10627740,10627741,10627742,10627743,10627744,10627745,10627746,10627747,10627748,10627749,10627750,10627751,10627752,10627753,10627754,10627755,10627756,10627757,10627758,10627759,10627760,10627761,10627762,10627763,10627764,10627765,10627766,10627767,10627768,10627769,10627770,10627771,10627772,10627773,10627774,10627775,10627776,10627777,10627778,10627779,10627780,10627781,10627782,10627783,10627784,10627785,10627786,10627787,10627788,10627789,10627790,10627791,10627792,10627793,10627794,10627795,10627796,10627797,10627798,10627799,10627800,10627801,10627802,10627803,10627804,10627805,10627806,10627807,10627808,10627809,10627810,10627811,10627812,10627813,10627814,10627815,10627816,10627817,10627818,10627819,10627820,10627821,10627822,10627823,10627824,10627825,10627826,10627827,10627828,10627829,10627830,10627831,10627832,10627833,10627834,10627835,10627836,10627837,10627838,10627839,10627840,10627841,10627842,10627843,10627844,10627845,10627846,10627847,10627848,10627849,10627850,10627851,10627852,10627853,10627854,10627855,10627856,10627857,10627858,10627859,10627860,10627861,10627862,10627863,10627864,10627865,10627866,10627867,10627868,10627869,10627870,10627871,10627872,10627873,10627874,10627875,10627876,10627877,10627878,10627879,10627880,10627881,10627882,10627883,10627884,10627885,10627886,10627887,10627888,10627889,10627890,10627891,10627892,10627893,10627894,10627895,10627896,10627897,10627898,10627899,10627900,10627901,10627902,10627903,10627904,10627905,10627906,10627907,10627908,10627909,10627910,10627911,10627912,10627913,10627914,10627915,10627916,10627917,10627918,10627919,10627920,10627921,10627922,10627923,10627924,10627925,10627926,10627927,10627928,10627929,10627930,10627931,10627932,10627933,10627934,10627935,10627936,10627937,10627938,10627939,10627940,10626226,10626227,10626228,10626296,10626720,10626731,10626733,10626787,10626929,10626951,10420698,10420699,10420700,10420701,10420702) 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'