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(8630637,8630639,8630652,7076042,10962734,8630787,8631476,8631477,8631479,10950606,8631630,8583487,8631712,8631856,8631857,8631858,10459914,10459915,10459916,10459917,10459918,10459919,10459920,10459921,10459922,10459926,10459927,10459928,10459956,10459957,10459958,10459959,10459960,10459961,10459962,10459963,10459964,10459968,10459969,10459970,10459996,10459997,10459998,10459999,10460000,10460001,10460002,10460003,10460004,10460008,10460009,10460010,10460036,10460037,10460038,10460039,10460040,10460041,10460042,10460043,10460044,10460048,10460049,10460050,10460076,10460077,10460078,10460079,10460080,10460081,10460082,10460083,10460084,10460088,10460089,10460090,10951163,10460116,10460117,10460118,10460119,10460120,10460121,10460122,10460123,10460124,10460128,10460129,10460130,10460156,10460157,10460158,10460159,10460160,10460161,10460162,10460163,10460164,10460168,9216252,10460169,10460170,9216253,10460196,10460197,10460198,10460199,10460200,10460201,10460202,8622468,10460203,8622469,10460204,10460208,10460209,10460210,10460236,10460237,10460238,10460239,10460240,10460241,10460242,10460243,10460244,10460248,10460249,10460250,10460276,10460277,10460278,10460279,10460280,10460281,10460282,10460283,10460284,10460288,10460289,10460290,8632383,3230164,10460316,10460317,10460318,10460319,10460320,10460321,10460322,10460323,10460324,10460328,10460329,10460330,10460356,10460357,10460358,10460359,10460360,10460361,10460362,10460363,10460364,10460368,10460369,10460370,8632472,8632474,8632476,8632480,8632481,8632483,8632487,8632489,8632567,8632568,8632570,8629620,8629641,8629672,8629673,8067931,8629745,8629746,8629748,8629754,8629755,8629756,8629838,8629868,8629890,8629915,8629921,8629925,8629930,8629936,8629938,8629939,8629947,8629957,8629958,8630280,8630282,8630283,8630443,8630445,8630446,8627582,8627590,8627596,8627613,8627620,8627621,8627622,8627623,8627626,8627630,8627631,8627632,8627633,7201319,10842951,8628521,8628526,8628527,8628528,8628529,8628531,8065957,7064985,8628724,8628725,8628729,7202439,7202683,7202684,8629093,8629095,8629096,8629099,10104659,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629233,8629234,8629235,8629236,8629237,8629258,8629429,8629430,8629439,3237393,3237395,7071093,8626834,8626893,8626897,8626898,8626899,10958987,10958988,10958989,8627106,8627237,8627238,8627242,8627243,8627251,8627252,8627253,8627283,8627288,8627289,8627293,8627310,7200911,7200912,8627312,8627313,8627316,8627317,10102852,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627436,8627437,8627438,8627439,8627440,8627441,8627442,8627443,8627444,7201080,8627530,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8071683,8071684,8071685,8071686,8071687,8071692,8071693,8071694,8071695,8071704,8071705,8071707,8071748,8071749,8071750,8071751,8071752,8071757,8071758,8071759,8071760,8071769,8071770,8624682,8071772,8071813,8071814,8071815,8071816,8071817,8071822,8071823,8071824,8071825,8071834,8071835,8071837,8071878,8071879,8071880,8071881,8071882,8071887,8071888,8071889,8071890,8071899,8071900,8071902,8071943,8071944,8071945,8071946,8071947,8071952,8071953,8071954,8071955,8071964,8071965,8071967,8072008,8072009,8072010,8072011,8072012,8072017,8072018,8072019,8072020,8072029,8072030,8072032,8072073,8072074,8072075,8072076,8072077,8072082,8072083,8072084,8072085,8072094,8072095,8072097,8072138,8072139,8072140,8072141,8072142,8072147,8072148,8072149,8072150,8072159,8072160,8072162,7198681,7198683,7198685,7198710,7198711,8072203,8072204,8072205,8072206,8072207,7198719,8072212,8072213,7198724,8072214,7198725,8072215,7198728,7198730,8072224,8072225,8072227,7198742,7198748,7198750,7198760,8072268,8072269,8072270,8072271,8072272,8072277,8072278,8072279,8072280,8072289,8072290,8072292,8625627,8625692,8625695,10941689,8625774,8625775,8625783,8625784,8625786,8625789,8625868,8625877,8625878,8625879,8625897,8625959,8625960,8625961,8625962,8625963,8625964,8626233,8626286,8626287,8626291,8626293,8626298,8626300,8626308,8626309,8626319,8626323,8626325,8626330,8626331,8626333,11048594,8626340,8626348,7070729,8626451,8626467,8626468,8626469,7200121,3923673,11045991,4937288,4937289,4937290,4937291,4937292,4937297,4937298,4937299,4937300,4937310,4937311,4937313,4937357,4937358,4937359,4937360,4937361,4937366,4937367,7196890,4937368,7196891,4937369,7196892,4937378,4937379,4937381,4937422,4937423,4937424,4937425,4937426,4937431,3234127,4937432,4937433,4937434,4937443,4937444,4937446,4937487,4937488,4937489,4937490,4937491,4937496,4937497,4937498,4937499,4937508,4937509,4937511,4937552,4937553,4937554,4937555,4937556,4937561,4937562,4937563,4937564,4937573,4937574,4937576,4937617,4937618,4937619,4937620,4937621,4937626,4937627,4937628,4937629,4937638,4937639,4937641,4937682,4937683,4937684,4937685,4937686,4937691,4937692,4937693,4937694,4937703,4937704,4937706,4937747,4937748,4937749,4937750,4937751,4937756,4937757,4937758,4937759,4937768,4937769,4937771,4937812,4937813,4937814,4937815,4937816,4937821,4937822,4937823,4937824,4937833,4937834,4937836,4937877,4937878,4937879,4937880,4937881,4937886,4937887,4937888,4937889,4937898,4937899,4937901,4937942,4937943,4937944,4937945,4937946,4937951,4937952,4937953,4937954,4937963,4937964,4937966,4938007,4938008,4938009,4938010,4938011,4938016,4938017,4938018,4938019,4938028,4938029,4938031,3234740,3234741,3234742,8907528,8907529,3234901,3234902,3234904,3234905,3234906,3234956,3234957,3234958,8624380,8624417,11047482,8624449,8071550,8071551,8071552,8071553,8071554,8071559,8071560,8071561,8071562,8071572,8071573,8071575,8624502,8624508,8624512,8071618,8071619,8071620,8071621,8071622,8071627,8071628,8071629,8071630,8071639,8071640,8071642,8541578,11044804,11044807,11044808,11044809,11044810,11044811,11044812,11044813,10617322,10617323,10617324,10617409,10617422,10617423,10617427,10617428,10617429,10617434,8541921,10617435,10617438,10617456,10993417,10993418,10993421,8542252,8542370,8632618,8632626,8632627,10425553,10615229,10848006,10848007,10615338,8633160,3581902,8633196,8633219,8633279,3582242,8633569,10991712,10991713,10991714,8540566,8540567,10991740,8540590,8540591,8540592,10991921,10991922,8540781,8540782,8633948,10616475,10992238,8611468,8634443,8634444,8634445,8634450,8634451,8634452,8634455,8634456,8634457,8634459,8634460,8634461,8634462,8634463,8634466,8634467,8634468,8634469,8634470,8634471,8634476,8634478,8634479,8634480,8634481,8634482,8634483,8634484,8634485,8634486,8634490,8634491,8634492,8634493,8634494,8634495,8634497,8634498,8634499,8634500,8634502,8634503,8634504,8634505,8634506,8634507,10616888,8634509,8634510,8634511,8634512,8634513,8634514,8634515,8634516,8634517,8634518,8634519,8634520,8634521,8634524,8634525,8634526,8634527,8634528,8634529,8634530,8634531,8634532,8634533,8634534,8634535,8634536,8634537,8634538,8634539,8634540,8634541,8634542,8634543,8634544,8634545,8634546,6669823,9173987,6666259,9182280,10611969,8565891,8565947,9211554,9211555,9211567,9212319,9212320,10613369,10613736,9193475,9193476,9193477,9193478,9193479,9193480,8849319,8849320,8849321,8849322,8849323,8849329,8849330,8849332,8849378,9185579,9185739,9185791,9185900,9169953,6674310,6674311,6674328,6674329,6674330,6674331,10118374,10118375,10119085,8848157,8848719,8848725,8848726,8848728,8848730,8848741,8848744,8848746,8848747,8848756,10122662,8549957,9207323,8563358,8563359,8563361,8563363,9207715,9168121,10883624,10883627,10883629,10889231,10890144,10890145,10890146,10890147,10890154,10883045,10883415,10886057,10886058,10886059,10886060,10626204,10626241,10887096,10887097,10626725,10590273,10590277,10590279,10590280,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590310,10590311,10647703,10579778,10579779,10579780,10579781,10541443,10541444,10423563,10422597,10420629,10409350,10407369,10407370,10409501,10407925,10497401,10497402,10497404,10497405,10478513,10406983,10406984,10406985,10408988,10406992) 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'