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(8630625,8630626,8630627,8630628,8630629,8630630,8630631,8630633,8630634,8630635,8630637,8630644,8630655,8630656,8630657,8630670,8630671,8630673,8630674,8630675,8630680,8630684,8630759,8630760,8630786,8630810,8630811,8630852,8630862,8630886,8630893,8630899,8630900,8630905,8631119,8631120,8631121,3229106,3229107,3229108,3229110,3229130,3229131,3229206,3229285,8631630,8583517,7066265,8632395,8632396,8632397,8632398,8632399,8632437,8632438,8632439,8632440,8632441,8632442,8632443,8632444,8632445,8632446,8632447,8632448,8632449,8632450,8632451,8632452,8632453,8632454,8632455,8632456,8632457,8632458,8632459,8632460,8837331,8837358,8837361,8837384,8837386,8837418,8837446,8837460,8837505,8629861,8629877,8629927,8630259,8630260,8630261,8630262,8630294,8627468,8627469,7201070,8627471,8627472,8627473,8627474,8627475,8627476,8627478,8627479,8627487,8627488,8627489,8627490,8627492,8627493,8627494,8627495,8627496,8627497,8627498,8627499,8627502,8627510,8627515,8627516,8627517,8627525,8627526,8627527,8835397,8835404,7201200,7201201,7201309,7201319,7201366,7201386,7201387,8627821,8627822,7201624,7201741,7201742,8628257,8628258,8628259,8628261,8628263,8628264,8628265,8836149,7201959,8628394,7202133,7202165,7202168,7202171,8836420,7202209,7202210,8628813,8628814,7202445,7202446,7202447,7202448,7202449,7202450,7202451,7202452,7202453,7202454,7202455,7202456,7202457,7202458,7202459,7202460,7202461,7202462,7202463,7202464,7202465,7202466,7202467,7202468,7202469,7202470,7202471,7202472,7202473,7202474,7202475,7202476,7202477,7202478,7202479,7202480,7202481,7202482,7202483,7202484,7202485,7202486,7202487,7202488,5654577,7202489,5654578,7202490,7202491,5654579,7202492,5654580,5654581,7202493,7202494,7202495,7202496,7202497,7202498,7202499,7202500,7202501,7202502,7202503,7202504,7202505,7202506,7202507,7202508,7202509,7202510,7202511,7202512,7202513,7202514,7202515,7202516,7202517,7202518,7202519,7202520,7202521,7202522,7202523,5654617,5654682,5654683,7202672,7202673,7202688,9794588,8629164,8629166,8629173,8629174,8629177,8629178,8629188,8629250,8629258,8629271,3227078,8837157,8837161,8629324,8629332,8629336,8629337,8837240,8629401,8629403,8837250,8837283,8626475,8626477,8626478,8626479,8626480,8626481,8626482,8626483,8626484,8626485,8626486,8626487,8626488,8626489,8626491,8626492,8626493,8626495,8626496,8626497,8626499,8626500,8626501,8626502,8626503,8626504,8626505,8626507,8626512,8626513,3237391,3237392,3237393,7200233,8910056,8616849,8626719,8626720,8626721,8626722,8626827,8626829,8834735,7200507,7200509,10958953,8626914,10958954,8834762,8834763,8626926,7200548,8627012,8627013,8627017,8627019,8627022,8910453,8910454,8910455,8910456,8910457,8910458,8910459,8910460,8910461,8910462,8910463,7200753,7200763,7200765,7200778,7200779,7200780,8910600,8910601,8910602,8910603,7200817,7200901,10102834,10100083,8908406,7198678,7198679,7198680,7198681,7198683,7198684,7198685,7198688,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198757,7198759,7198760,7198762,7198763,7198764,7198765,7198766,7198769,7198772,7198781,7198782,7198784,7198785,7198853,7199063,7199135,7199211,7199449,7199569,8860265,10101493,10618177,8613162,8613321,7196890,7196891,7196892,8906886,8906887,8906888,8906892,8906900,8907048,7197239,10838834,7197395,7197396,7197397,7197417,7197546,7197551,7197552,7197555,7197557,7197559,7197573,7197575,7197582,8907434,8907435,3234860,7197799,7197800,7197812,10619885,10619886,10619887,10619889,3232382,8905156,8541669,10617328,10617329,10617332,10617333,10617336,10617337,10617338,8905258,10617426,10617456,10617512,3232910,8905663,8542254,8905822,10615229,10615343,10951828,10425575,10615363,10426254,10616044,10616045,10426338,8540605,8540612,8540613,10426474,8540631,8540633,10616644,8904798,10616888,10616905,10610984,10610985,10610995,10610996,10610997,10614048,10611105,10559396,10614269,10611350,10614376,10611393,10611412,10614497,10614498,10611856,10611969,10611983,10611995,10611996,10611997,10609155,10612191,10612192,10612194,10612201,10609285,10612294,10609706,7017820,7017821,7017822,7017823,7017824,7017825,7017826,7017827,7017828,7017829,7017830,7017831,7017832,7017833,7017834,7017835,7017836,7017837,7017838,7017839,7017840,7017841,7017842,7017843,7017844,7017845,7017846,7017847,7017848,7017849,7017850,7017851,7017852,7017853,7017854,7017855,7017856,7017857,7017858,7017859,7017860,7017861,7017862,7017863,7017864,7017865,7017866,7017867,7017868,7017869,7017870,7017871,7017872,7017873,7017874,7017875,7017876,7017877,7017878,7017879,7017880,7017881,7017882,7017883,7017884,7017885,7017886,7017887,7017888,7017889,7017890,7017891,7017892,7017893,7017894,7017895,7017896,7017897,7017898,7017899,7017900,7017901,7017902,7017903,7017904,7017905,7017906,7017907,7017908,7017909,7017910,7017911,7017912,7017913,10612940,10612942,10612959,10609988,9172407,10613144,10613147,10613148,10613157,10613220,10613221,10613235,10613337,10613362,10613393,10613421,10613431,10613432,10558592,10610480,10610481,10613524,10613525,10613736,10610739,10613750,10610954,10610958,6673506,9169318,6673524,6673540,6673545,6673546,6673548,6673550,6673552,7055541,7055546,10117609,10117643,6673699,6673738,7055722,10117763,10117792,10117904,10515551,10515609,10515610,10515611,10515612,10515613,10515668,10515669,10515670,10118062,10517681,10513728,10513729,9169936,9169941,6674152,6674175,6674241,10118247,6674256,10118248,6674276,6674278,6674280,6674326,10118364,10118365,10118366,10118367,10118368,10118371,10118372,10118373,10514037,10514038,10514090,10514091,10514092,10514093,10516171,10516172,10516173,10516174,10516175,10516176,10118606,10118607,10118608,10118609,10118610,10118675,10514364,10514388,10514389,10514390,10514402,10514405,10514406,10514407,10514410,9171102,10514964,10514965,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,6672524,6672592,10415342,9168453,10419470,10419493,10419497,10419501,10419502,10419503,10419505,10419506,10419508,10419511,10419514,10419520,10415685,9168937,9168938,9168939,9168940,9168941,10420154,10420157,10420160,10420162,10420164,10419166,10420167,10420169,10419169,10419172,10419173,10420192,10420193,10420195,7055440,10123006,8550018,8550036,10467558,10467803,10467871,10467876,8917157,8917164,10468323,10468324,10468325,10468326,10468327,10468328,10468329,9167770,9167946,9167947,9168073,9168148,9168149,9168216,10883475,10883559,10883560,10883561,10883570,10883571,10883626,10883664,10884078,10884080,10884081,10884082,10884083,10884084,10884085,10884088,10884089,10889231,10884466,10889583,10889584,10889585,10884652,10884653,10884697,10889775,10885072,10890104,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890126,10890129,10890161,10890162,10890165,10890173,10890174,10890175,10885347,10885348,10885350,10626963,10882596,10632106,10632109,10632110,7000826,10882675,10883044,10883137,10883306,10883307,10883403,10883404,10883405,10885564,10630068,10630069,10630070,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630078,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630089,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10885751,10161868,10885867,10886064,10886065,10162081,10162249,10949057,10886250,10881491,10891654,10891655,10886918,10882127,10882145,10188259,10887263,10887462,10598535,10647338,10647339,10647714,10648050,10648051,10591360,10591361,10591362,10529335,10529342,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529398,10529399,10529409,10529410,10529411,10529412,10529413,10529423,10541443,10541445,10541446,10541447,10541448,10543041,10543042,10498367,10421498,10422598,10498499,10498867,10486561,10486562,10486563,10486564,10486565,10486566,10486567,10486568,10486569,10486570,10486571,10408828) 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'