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(7076333,10939978,7068654,7068655,7068656,7068711,10963559,8066941,8066948,8067308,8067374,8067467,8067468,11029231,11029232,11029233,11029234,11029235,7066756,10961901,11040079,11040080,11040081,11040082,11040083,11040084,11040085,11040086,11040087,11040088,11040089,11040090,11040091,11040092,11040093,11040094,11040095,11040096,11040097,10962368,7064024,7064025,7064026,7064027,7064028,7064029,7064030,10972782,10972783,10959857,7072174,10972935,11012017,11012018,11012019,11012020,10986036,10986112,10986113,10986114,10986115,10986122,10999162,10999163,10999164,10999165,10999166,10999167,10999244,10999245,10999246,10999247,10999248,10999249,10999250,10999251,10999252,10999253,10999254,10999255,10999256,10999257,10999258,10999259,10999260,10999261,10999262,8065967,8065968,8065969,8065970,8065971,8065999,8066000,8066001,8066002,8066003,7073450,7073451,11000145,11000146,11010704,11010705,11010706,11048965,10942723,11049090,7071223,7071231,7071232,7071233,11024001,11024002,10972167,10972168,10972169,5999978,5999979,5999980,5999981,11011446,11011447,10969730,7069050,10969820,10969821,10969822,10969823,10969824,10969825,10969826,10969827,10969828,10969829,10969830,10969831,10969832,10969833,10969834,10969835,10969836,10969837,10969838,10969839,10969840,10969841,10969842,3655793,7069236,7069273,7069298,7069323,11035056,11035057,11035058,11035059,3655971,3655972,3655973,10970098,10970099,10970129,10970130,11035160,11035161,11035184,11035190,11035191,11035192,11035193,11009336,11009337,11009338,11009341,10996396,10996412,10970484,10970485,10970486,10970487,10970488,10983493,10970517,10970518,10970519,10970520,10970521,10970558,10970559,10970560,10941826,10970910,10970911,10941856,10941857,10941858,10941894,10941909,10941914,10941915,10970989,10970990,10970991,10970992,10970993,10941957,10941972,10942087,7070799,7070800,7070816,7070863,10618158,10618213,10618287,11032945,11032946,11032947,11032948,11032949,11032950,11032951,11032952,11032953,10618297,11033102,11033103,11033104,11033105,11033106,11033107,11033108,11033109,11033110,11033111,11033112,11033113,11033114,11033115,11033116,11033117,11033118,11033119,11033120,11033121,11033122,11007124,11007179,11007180,11007181,11033299,11033300,11033301,11033302,11033303,11033304,11033305,11033306,10995122,10995124,10995141,10624841,10622018,10622019,10622020,10992707,10992708,10992709,10992710,10992711,10992712,10992721,10622064,10622065,10622066,10622068,10992728,10622070,10622074,10622075,10622076,10622078,10622079,10622080,10992739,10992740,10992741,10622089,10622093,10622107,10622108,10622109,10622110,10992780,10992878,10992879,10992880,10992946,10992947,10992948,10992949,10992983,10992984,10992985,10992986,10992987,10992988,10993079,10993080,10954113,10967152,10967153,10967154,10967155,10967156,10967157,10967158,10993173,10993198,10993199,10928060,10928062,10993272,10993273,10993275,10993316,10993425,10993426,10993427,10993428,10993429,10993430,10993431,10993432,10993433,10993507,10993534,10993535,10993536,10993537,10925484,10925485,10925486,10925522,10925523,10615117,10615152,10615153,10615229,10620303,10620397,10620417,10620418,10930643,10930644,10930645,10965391,10930735,10930736,11004503,10991525,10991658,10991659,10991759,10991760,11030820,10991823,10616201,10616209,10992010,10992023,10621421,11005098,10992105,10992417,10992430,10992431,10992432,10992433,10992434,10992435,10992436,10992437,10992438,10992439,10992440,10992441,10992500,10992501,10992502,10992503,10992504,10992505,10992569,10992598,10922456,10922457,10922458,10922459,9181420,10565304,10565305,7059797,8864238,9189743,9173770,9173797,10611682,9174139,7057481,7057522,9187556,9187557,9187559,10563584,10563585,7058048,7058049,7058050,7058051,7058052,9195903,7058072,7058073,7058074,9195920,7058087,9171968,9188073,9188166,9188167,9188168,9188213,9188224,9188225,9188226,9188227,9188233,10612973,10613083,9196440,8863105,8863115,8863150,10558442,10558443,10558444,10558445,10558446,9196801,9196803,9196804,9172939,10610697,10610719,8863598,8863606,8863614,8863707,9189251,9189276,9189277,9189278,9189281,10517117,10517118,10517119,10517120,10517121,10517122,10517123,10517124,10517125,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,10517139,10517140,10517141,10517145,10517146,10517147,10517148,10517170,10517171,10517172,10517173,10517174,10517175,10517176,10517177,10517178,10515319,9185586,7055821,9185672,9161763,7055957,9193851,7056038,7056071,9186020,9186021,9186055,9186107,9186137,9186155,9170158,9186158,9186170,9186192,9186197,9186204,9186213,9186214,9186222,9186240,9186251,9186261,9186262,9186263,9186389,9186390,9186391,9186454,9186455,9186466,9186467,9186493,9186496,9186497,9186575,9186576,9186579,9186651,9186652,9186653,9186657,9186821,9186896,10513027,9168369,8918052,4973282,9176486,9176487,9176597,9176699,10419637,10419638,10419639,10419640,9168720,4973897,7055447,9161282,9161285,9174585,4971579,4971624,4971646,4971648,9175009,4971931,8916885,10467956,6667474,8917175,9175575,4972437,4972438,4972439,4972440,6667593,6667597,9191602,9191603,10468194,10468195,10468196,9191698,10462292,10462293,9191951,9184031,6668090,6668181,10627987,10628087,10174724,10179849,10164922,10164923,10164924,10164925,10164926,10164927,10164928,10164929,10164930,10175172,10175173,10175174,10175175,10175176,10175177,10175178,10175179,10175180,10175181,10170194,10170223,10170306,10170307,10170308,10165346,10165370,10170370,10165371,10170371,10165372,10170372,10165373,10170373,10165374,10165375,10170394,10170408,10170409,10170410,10165438,10165439,10170468,10170469,10170470,10170501,10170502,10170539,10170589,10170623,10170629,10170638,10165907,10165908,10165950,10629429,10165951,10165952,10166032,10166033,10166034,10166035,10166036,10166037,10166038,10166039,10171071,10171085,10171086,10166141,10632064,10173610,10173618,10627426,10627427,10627428,10627457,10627458,10627459,10627460,10627461,10166611,10166612,10166613,10166614,10166615,10166616,10166617,10166689,10166690,10166691,10166736,10166737,10166801,10166832,10166871,10166908,10166911,10166949,10166964,10166966,10167035,10167128,10167167,10167185,10167208,10167209,10162243,10162244,10167259,10177268,10177269,10177270,10177271,10177272,10177273,10177274,10177275,10177276,10167276,10177277,10177278,10177279,10177280,10177281,10177282,10177283,10177284,10177285,10177286,10177287,10177288,10177289,10177290,10177291,10177292,10177293,10177294,10177295,10177296,10167435,10162620,10162621,10626192,10626195,10162734,10162735,10162736,10162779,10162780,10162802,10162807,10162811,10162821,10626502,10568557,10566123,10581912,10567687,10567688,10567689,10567690,10531223,10531224,10531225,10531226,10531227,10531228,10531229,10531384,10531385,10531386,10523414,10523415,10523416,10523417,10523431,10531498,10531499,10531500,10531501,10531502,10531503,10531504,10531505,10531506,10531555,10523630,10523631,10523632,10531636,10531637,10531664,10531682,10531683,10531684,10531685,10531686,10531687,10531688,10531689,10531690,10531691,10531692,10531693,10531694,10531695,10531696,10531697,10529880,10529881,10529973,10530105,10522256,10522257,10530303,10530304,10530305,10530309,10524342,10524373,10524374,10524375,10524376,10530397,10530398,10530399,10530400,10524403,10524404,10524405,10524406,10524407,10524408,10524418,10524419,10524420,10524421,10524439,10524440,10524441,10524442,10524443,10530453,10530454,10530455,10530465,10530488,10530489,10530490,10530491,10530492,10530493,10530494,10530495,10530496,10530497,10530498,10530499,10530500,10530501,10522501,10530502,10530503,10530504,10522504,10530505,10530506,10530507,10530508,10530509,10530510,10530511,10530512,10530513,10522518,10524632,10524633,10524674,10524698,10524699,10524702,10524703,10524704,10530795,10530796,10530797,10530815,10530816,10530817,10530818,10530819,10530820,10530821,10530822,10530823,10530824,10530825,10530826,10530827,10530828,10530887,10530894,10530895,10530896,10530897,10530898,10530899,10530900,10520918,10530943,10530944,10530945,10530976,10530977,10525013,10525014,10531016,10531029,10531036,10531037,10531038,10531039,10531040,10531088,10531089,10531090,10531091,10531092,10531093,10531094,10531095,10531096,10498413,10422733,10421112,10421113,10422121,10421129,10421138,10421140,10421217,10480973,10480974,10481106,10481107,10481108,10481109,10481110,10481111,10481112,10481113,10481114,10481115,10481116,10481117,10481118,10483145,10479154,10479155,10483177,10481334,10481335,10481336,10481337,10481338,10481339,10481340,10481341,10481342,10481343,10481344,10481345,10481346,10481347,10481508,10481509,10481553,10481569,10481570,10481583,10481584,10481681,10481682,10481683,10481684,10481685,10481864,10481865,10481866,10481867,10481893,10481894,10481895,10481896,10481980,10481986,10478040,10478041,10482561) 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'