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(3228956,3228957,3228958,3229067,3229106,3229107,3229108,3229110,3229130,3229131,3229177,3229285,8583517,10950674,8583566,8609570,8609571,8609572,8609573,8837331,8837358,8837361,8837384,8837386,8837418,8837446,8837460,8837505,8573309,8573310,8573311,8573312,7201070,8835397,7201157,7201158,7201159,8835404,7201160,7201200,7201209,7201210,7201309,7201319,7201366,7201367,7201386,7201387,7201498,7201499,7201502,7201624,7201677,7201678,7201684,7201685,7201686,7201687,7201741,7201742,7201756,8836149,7201959,7202066,7202067,7202071,7202082,7202087,7202089,7202090,7202095,7202096,7202133,7202165,7202168,7202171,8836420,7202209,7202210,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,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,7202489,7202490,7202491,7202492,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,5654644,5654682,5654683,7202672,9794587,9794588,3227078,8837157,8837161,8837240,8837250,8837283,7200087,7200091,7200094,7200105,7200106,7200107,7200108,7200109,7200110,7200111,7200115,7200120,7200121,7200123,7200124,7200125,7200126,7200127,7200128,7200129,3237391,3237392,3237393,8910056,8616849,8834735,10958953,10958954,7200548,8910453,8910454,8910455,8910456,8910457,8910458,8910459,8910460,8910461,8910462,8910463,7200753,7200763,7200765,8910582,8910583,7200778,7200779,7200780,7200921,7200929,10102834,7198108,10100083,8908229,7198680,7198683,7198694,7198781,7198782,7198784,7198785,7198853,7199061,7199063,7199135,7199211,7199394,7199401,7199410,7199411,7199417,7199449,7199471,7199480,7199569,10101477,10101478,8860265,10101493,8860337,8860345,8860346,8860347,7199881,10958353,7200030,10618177,8613162,8613321,8906635,8906644,8906650,8906651,8906658,8906659,8906683,7196890,7196891,7196892,8906704,8906900,8907048,7197239,10838834,7197395,7197396,7197397,7197417,7197546,7197551,7197552,7197555,7197557,7197559,7197573,7197575,7197582,8907434,8907435,3234860,7197769,7197770,7197771,7197772,7197773,7197774,7197775,7197776,7197812,7197843,7197846,7197849,7197850,7197851,7197853,7197854,7197855,7197856,10619885,10619886,10619887,10619889,10619895,10619896,8541475,8541476,10617123,10617157,10617158,10617159,10617209,8905156,8541669,8905237,10617332,8905258,8905290,8905291,10622441,10622508,10617512,3232910,8905663,8542254,8905822,10615248,10425484,10951828,10425574,10615363,10615439,10615471,10615472,10425944,10615950,10615953,10426254,10616097,10616103,10616105,10616118,10616119,10426338,10616123,10616124,10616126,10616127,10616131,10616132,10616134,10616147,8540538,8540539,10616173,10616175,10616181,10616182,8540604,8540605,10616245,8540612,8540613,10616248,10426474,8540631,8540632,8540633,10616287,10616329,10616353,10616370,10616397,10616400,10616401,10616407,10616410,10616411,10616412,10616443,10616459,8611238,10616644,10616655,8611374,10616888,10616911,10616955,10610995,10610996,10610997,10611014,10611025,10611037,10614048,10614085,10614086,10611105,10611184,10611186,10611187,10611188,10611191,10611193,10611194,10611197,10614221,10559396,10611250,10611252,10611253,10614269,10611338,10611339,10611340,10611341,10611350,10614376,10611393,10611412,10614475,10614476,10611804,10611808,10611856,10614857,10611983,10611995,10611996,10611997,10612062,10612063,10612064,10609155,10612191,10612192,10612194,10612195,10612196,10612197,10612198,10612201,10609285,10609706,10609707,10609749,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,10612959,10609988,10613018,9172407,10610075,10613144,10613147,10613148,10613157,10613220,10613221,10613235,10613337,10613362,10613393,10613421,10613431,10613432,10558592,10613524,10613525,10610709,10610729,10610730,10610739,10613750,10610775,10610777,10610791,10610958,6673506,9169318,6673540,6673545,6673546,6673548,6673550,6673552,9169370,7055541,7055546,10117609,10117634,10117643,6673699,9169520,10117726,6673738,10117743,10117744,10117745,10117746,10117747,7055722,10117763,10117784,10117785,10117792,10117904,9169727,10515551,10515609,10515610,10515611,10515612,10515613,10515668,10515669,10515670,10118062,10517681,10513728,10513729,6674152,6674175,6674241,6674256,6674276,6674278,6674280,10516157,10516158,10516160,10516161,10516162,10516163,10516164,10516165,10516166,10514386,10514387,10514410,10514411,9171102,10514976,6672524,10419271,6672592,10415342,9168453,10417424,10419470,6672896,6672897,6672898,6672899,6672900,6672901,6672903,6672904,9168752,10419793,6673081,6673082,6673085,6673086,6673087,6673088,6673089,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,10417837,10417839,10417841,10417843,10417845,10417847,10417849,10417850,10417852,10417854,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10420154,10420157,10420160,10420162,10420164,10420167,10420169,10420192,10420193,10420195,7055440,10117478,10123006,8550003,8550018,8550036,10469502,10467558,10467803,10467871,10467876,10470084,8917157,10470089,10470090,8917164,10468323,10468324,10468325,10468326,10468327,10468328,10468329,9167770,9167946,9167947,9168073,9168121,9168126,9168148,9168149,9168162,9168216,10883475,10888524,10884172,10884173,10884174,10889201,10889202,10889210,10889213,10889224,10889225,10889231,10884324,10884420,10884421,10884423,10884466,10889583,10889584,10889585,10884652,10884653,10884720,10884721,10884723,10884725,10884738,10890048,10885072,10890161,10890162,10890165,10890177,10885361,10626963,10882596,10632106,10632109,10632110,7000826,10882675,10883044,10883137,10883304,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,10885709,10885751,10161868,10885867,10161923,10161924,10161926,10161927,10161928,10886064,10886065,10162081,10949057,10886250,10881491,10891654,10891655,10891910,10886918,10631546,10887075,10882127,10882145,10626720,10887263,10598535,10598615,10647338,10647339,10647714,10648050,10648051,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,10541446,10541447,10541448,10526866,10543041,10543042,10533104,10420247,10420248,10420249,10420250,10420251,10420252,10420253,10420254,10420255,10420256,10420257,10420258,10420259,10420260,10420261,10420262,10420263,10420264,10420265,10420266,10420267,10420268,10498367,10421498,10498499,10422889,10422898,10422934,10422942,10407236,10407237,10407238,10407239,10407240,10407241,10407242,10407247,10486561,10486562,10486563,10486564,10486565,10486566,10486567,10486568,10486569,10486570,10486571) 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'