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(10939649,4970675,4970685,4970738,4971081,10933336,10933337,10933357,8067396,8067523,8067524,8067527,10437503,10437521,10437522,10437559,10437560,10437568,7066917,8067942,8067943,10939465,10931548,7064168,8065807,8065823,8065932,8065933,8065934,8065935,8065957,10932783,10932785,10932790,10932792,10932793,10932796,10932797,10932798,10932799,10932800,10932801,10932802,10932803,10932804,10932805,10932806,10932807,10932808,10932809,10932810,10932819,10932820,10932821,10932822,10932823,10932824,10932825,10932826,10932827,7065457,10932917,10932932,10932955,10932956,10932957,10932958,10932959,10932960,10932962,10932963,10932964,10932965,10932966,10932967,10932968,10932969,10932970,10932973,10932974,10932975,10932976,10932977,10932979,10933000,10942605,10942620,10942734,10942735,10942737,10942743,10942745,10942793,10942799,10942804,10942812,10942817,10942861,10942913,10942992,10942994,10943018,10943019,10943026,8861229,10943044,10943045,10943048,8861260,10943113,10943122,10943248,10943256,10943270,8970239,8071673,8071676,8071682,8071687,8071691,8071695,8071701,8071703,8071705,8071706,8071707,8071717,8071726,8071733,8071738,8071741,8071747,8071752,8071756,8071760,8071766,8071768,8071770,8071771,8071772,8071782,8071791,8071798,8071803,8071806,8071812,8071817,8071821,8071822,8071831,8071833,8071835,8071836,8071837,8071847,8071856,8071863,8071868,8071871,8071877,8071882,8071886,8071890,8071896,8071898,8071900,8071901,8071902,8071912,8071921,8071928,8071933,8071936,8071942,8071947,8071951,8071955,8071961,8071963,8071965,8071966,8071967,8071977,8071986,8071993,8071998,8072001,8072007,8072012,3655849,8072016,8072020,8072026,8072028,8072030,8072031,8072032,8072042,8072051,3655890,8072058,8072063,8072066,8072072,8072077,8072081,8072085,8072091,8072093,8072095,8072096,8072097,8072107,8072116,8072123,8072128,10944786,8072131,8072137,8072142,8072146,8072150,8072156,8072158,8072160,8072161,8072162,8072172,8072181,8072188,8072193,8072196,8072202,8072207,8072211,8072215,8072221,8072223,8072224,8072226,8072227,8072237,8072246,8072253,8072258,8072261,8072267,8072272,8072276,8072280,8072286,8072288,8072290,8072291,8072292,10941251,10941262,10941265,10941266,10941268,10941278,10941285,10941296,3656385,3656393,3656396,10941948,8073128,8073136,8073171,8073172,8073179,8073180,8073181,8073209,8073210,8073251,8860337,8073292,8073293,8073294,8860363,8073335,8073529,10623064,10623495,10623496,10623507,10624548,10624552,10624553,10624554,10624555,10624582,10624627,10624628,10624632,10624633,8071516,8071525,8071535,8071540,8071543,8071549,8071554,8071558,8071562,8071569,8071571,8071573,8071574,8071575,8071587,8071596,8071603,8071608,8071611,8071617,8071622,8071626,8071630,8071636,8071638,8071640,8071641,8071642,8071652,8071661,8071668,10922496,10922497,10922498,10922499,10922500,10922501,10922502,10922503,10922504,10922505,10922506,10922507,10922508,10922509,10922510,10922511,10922512,10922513,10922514,10922515,10922518,10922520,10622217,10622224,10622225,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10622360,10927886,10927887,10922895,10922896,10922899,10922900,10622405,10622408,10622431,10922949,10622441,10622445,10622447,10927985,10927986,10622514,10622516,10622523,10622533,10620079,10620080,10620081,10620082,10620183,10620207,10621034,10922074,10922075,10922076,10922077,10922078,10922133,10922134,10922135,10922136,10922137,10922138,10922139,10922140,10922141,10922142,10922143,10922205,10922206,10922207,10922208,10922209,10922210,10922211,10922212,10922213,10922214,10922215,10922216,10922217,10922251,10922252,10922253,10922254,10922255,10922256,10922257,10922258,10922259,10922260,10922261,10922262,10922263,10922264,10922265,10922266,10922267,10922268,10922269,10922270,10922271,10922272,10922273,10922274,10922275,10922277,10922282,10922285,10922286,10922287,10922288,10922289,10922290,10922291,10922292,10922304,10922305,10922436,10922437,10922441,10922442,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10922451,10610963,10610964,10610965,10610966,10610967,10610969,10610971,10610975,10610976,10565127,10610977,10610978,10610980,10610982,10610984,10610985,10610987,10610988,10610989,10565144,10610994,10610995,10610996,10610997,10610999,10565150,10565155,10565158,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10611037,10614048,10614085,10614086,10565319,10614182,10614186,10614203,10614220,10614243,10614246,10614267,10614268,10614269,10614270,10611338,10611375,10614376,10611376,10611377,10611378,10611380,10611381,10611382,10611383,10611390,10611391,10611392,10611393,10611394,10611396,10611398,10611399,10611400,10611404,10611406,10611407,10611408,10611409,10611411,10611412,10611413,10611414,10611416,10611417,10611422,10611423,10611426,10611427,10611428,10611431,10611432,10611434,10611435,10611436,10611437,10611440,10611441,10611442,10611443,10611444,10611445,10611449,10611450,10611451,10611452,10611455,10611456,10611457,10611459,10611461,10611462,10611463,10611464,10611466,10611467,10611469,10611470,10611472,10611473,10611476,10611477,10611479,10611480,10611482,10611483,10611485,10611486,10611491,10611492,10611493,10611495,10611496,10611498,10611499,10611500,10611505,10611507,10611509,10611514,10611517,10614519,10611519,10614520,10611520,10614521,10611521,10614522,10611522,10614523,10611523,10611525,10611526,10611527,10611528,10614530,10611530,10611532,10611536,10611537,10611538,10611539,10611542,10611543,10611544,10611546,10611549,10611550,10611551,10611552,10614552,10614553,10611554,10614554,10611555,10611560,10611563,10611564,10611567,10611568,10611569,10611570,10611571,10611572,10611573,10611574,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611594,10611596,10611597,10611598,10611600,10611603,10611604,10611605,10611608,10611611,10611612,10611613,10611615,10611617,10611618,10611619,10611620,10611621,10611623,10611624,10611635,10611636,10611637,10611638,10611640,10611641,10611643,10611646,10611647,10611648,10611649,10611655,10611658,10611659,10611660,10611665,10611666,10611676,10611830,10611831,10611856,10611891,10611892,10609035,10609036,10612134,10612135,10612136,10612137,10609155,10612194,10612201,10612268,10609285,10612291,10609313,10612319,10612320,10612321,10609839,10612916,10609916,10609921,10609936,10609938,10609941,10609986,10612987,10612988,10609988,10612989,10613017,10610030,10613056,10613057,10613058,10613063,10613066,10613089,10613093,10613096,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613133,10613143,10613144,10613162,10613172,10613175,10613176,10613179,10613191,10613192,10613208,10613214,10613215,10613220,10613221,10610233,10613235,10610241,10610242,10610243,10610244,10610245,10610246,10610247,10610248,10610249,10610250,10610251,10613311,10613362,10613475,10613506,10613513,10613514,10564666,10564669,10613545,10613565,10610666,10610677,10610691,10613695,10610695,10613696,10610697,10610709,10613722,10613729,10610729,10610730,10564883,10564885,10613736,10564886,10564887,10564888,10564889,10610739,10564890,10564891,10564892,10564893,10564894,10564895,10564896,10564897,10610775,10610777,10610791,10564973,10564989,10564990,10610841,10564992,10564993,10564995,10610850,10610873,10610874,10610881,10565037,10565038,10565039,10565040,10610890,10565041,10610895,10610898,10610899,10610901,10610913,10610914,10610917,10610918,10610919,10610935,10610947,10610954,10610958,10517143,10517144,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517220,10517221,10517222,10517223,10517224,10517225,10517670,10517791,10517792,10517793,10517794,10517795,10517796,10517797,10517798,10512562,10512563,10512564,10512565,10419306,10419307,10419349,10419350,10415366,10415367,10415368,10415369,10415370,10419370,10415371,10415372,10415373,10415374,10415375,10419375,10415376,10419468,10419469,10416481,10415595,10415614,10415792,10415795,10415797,10420150,10420151,10420152,10420153,10420155,10420156,10420158,10420159,10420161,10420163,10420165,10420166,10420168,10420170,10420171,10420172,10420174,10420176,10420177,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420194,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10471171,10471172,10471173,10471174,8563199,8563200,8563201,8563202,8563204,8563229,8563250,8563251,8563252,8563299,8563358,8563359,8563360,8563361,8563362,8563363) 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'