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,3229182,8631480,8631481,8631482,8631611,10950747,10950748,8631924,8631925,8631926,8631927,8631928,8631929,8631930,8631931,8631932,8631933,8631934,8631935,8631936,8631937,8631938,8631939,8631940,8631941,8631942,8631943,8631944,8631945,8631946,8631947,8631948,8631949,8631950,8631951,8631952,8631953,8631954,8631955,8631956,8631974,8631975,8631976,8631977,8631978,8631979,8631980,8631981,8631982,8631983,8631984,8631985,8631986,8631987,8631988,8631989,8631990,8631991,8631992,8631993,8631994,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632038,8632039,8632040,8632041,8632042,8632043,8632044,8632045,8632046,8632047,8632048,8632049,8632050,8632051,8632052,8632053,8632054,8632055,8632056,8632057,8632058,8632059,8632060,8632061,8632062,8632063,8632064,8632065,8632066,8632067,8632068,8632069,8632070,8632071,8632072,8632073,8632074,8632075,8632076,8632077,8632078,8632079,8632080,8632081,8632082,8632083,8632084,8632085,8632086,8632087,8632088,8632089,8632090,8632091,8632092,8632093,8632094,8632095,8632096,8632097,8632148,8632149,8632150,8632151,8632152,8632153,8632154,8632155,8632156,8632157,8632158,8632159,8632160,8632161,8632162,8632163,8632164,8632165,8632166,8632167,8632168,8632169,8632170,8632171,8632172,8632173,8632174,8632175,8632176,8632177,8632178,8632179,8632180,8632181,8632182,8632183,8632184,8632185,8632186,8632395,8632396,8632397,8632398,8632399,8632437,8632438,8632441,8632442,8632445,8632446,8632449,8632450,8632452,8632453,8632455,8632456,8632458,8632459,8629522,8067927,8067931,8629617,8629618,8629619,8629620,8629621,8629622,8629987,8630442,8630443,8630445,8630446,8630447,8630448,8630449,8630450,8630451,8630452,8630453,7201399,7201406,7201413,7201464,7201468,7201477,7201478,7201479,7201483,7201487,7201492,7201498,7201499,7201502,7201504,7201505,7201508,7201514,8627991,8627992,8627993,8627994,8627995,8627996,8627997,8627998,8627999,8628000,8628001,8628002,8628003,8628004,8628005,8628006,8628007,8628008,8628009,8628011,8628012,8628014,8628015,8628016,8628018,8628019,8628020,8628021,8628022,8628023,8628024,8628025,8628027,8628028,8628029,10960174,8628194,8628232,8628265,7202037,8628801,8628802,8628836,8628837,8628838,8628839,8628840,8628841,8628842,8628843,8628844,8628846,8628848,8628849,5654537,8628850,8628852,5654541,8628854,8628855,8628856,8628858,8628860,8628862,8628864,8628865,8628866,5654555,8628868,8628870,8628871,8628872,8628876,8628879,8628882,8628885,8628888,8628889,5654577,5654578,8628890,5654579,8628891,5654580,8628892,5654581,8628893,8628894,8628896,8628897,8628898,8628899,8628900,8628901,8628904,8628905,8628906,8628907,8628908,8628909,8628910,8628913,8628914,8628915,8628916,8628917,8628918,8628919,8628920,8628921,8628922,8628923,8628924,5654613,8628925,5654614,8628926,8628927,8628928,8628929,8628930,8628931,8628934,8628937,5654627,8628942,8628945,8628948,8628950,8628952,8628953,8628954,8628955,8628957,8628959,8628960,8628961,8628963,8628965,8628966,8628967,8628969,8628971,8628972,8628973,8628975,8628977,8628978,8628979,8628981,8628983,8628984,8628985,8628987,8628989,8628990,8628991,8629340,8629341,8629433,8629434,8629435,8629436,8629437,3237362,8626821,8626822,8626823,8626824,8626825,8626826,8626847,8626848,8626849,8626850,8626851,8626852,8626853,8626854,7200456,7200458,7200470,7200922,7200923,8624531,8624532,8624533,8624534,8624535,8624536,8624537,8624538,8624539,8624540,8624541,8624542,7198395,8624836,8624837,8624838,8624839,8624840,8624841,8624842,8624843,8624844,8624845,8624846,8624847,8624848,8624849,8624850,8624851,8624852,8624853,8624854,8624855,8624856,8624857,7198457,8624858,7198458,8624859,7198459,8624860,7198460,8624861,7198461,8624862,7198462,8624863,7198463,8624864,7198464,8624865,7198465,8908277,8624866,8908278,8624867,8624868,8624869,8624870,8624871,8624872,8624873,8624874,8624875,8624876,8624877,8624878,8624879,8624898,8624899,8624900,8624901,8624902,8624903,8624904,8624905,8624906,8624907,8624908,8624909,8624910,8624911,8624912,8624913,8624914,8624915,8624916,8624917,8624918,8624919,8624920,8624921,8624922,8625022,7198683,8908495,8908496,7198690,7198694,8908508,7198760,8625243,8625244,8625245,8625246,8625247,7199395,10101516,10101518,8626069,8626421,8626422,8626423,8626424,8626425,8626426,8626427,8626428,8626429,8626430,8626431,8626432,8626433,8626434,8626435,8626436,10618182,10618183,8613064,7197128,7197129,7197130,10838834,3234730,8907436,8907461,8907462,8907463,8907464,8907465,7197853,8624261,8624262,8624263,8624264,8624265,8624266,8624267,8624268,8624269,8624270,8624271,8624272,8624273,8624274,8624275,8624276,8624277,8624278,8624279,8624297,8624298,8624299,8624300,8624301,8624302,8624303,8624304,8624305,8624306,8624307,8624308,8624309,8624318,8624319,8624320,8624321,8624322,8624323,8624324,8624325,10619844,8624416,8624446,8624454,8624455,8624456,8624457,8905221,10617322,10617323,10617324,8905259,8905260,10622365,8905290,8905291,10617461,3232798,3232899,3232900,3232901,3232902,3232903,3232904,3232909,3232910,3232912,3232915,3232917,8542165,10615108,10615109,3581873,3581878,10425937,10426019,10426204,10616006,10426341,8540604,8540605,8611319,8611374,10610964,10610984,10610985,10611197,10611830,10611831,10611832,10611833,10611834,10611835,10611891,10611892,8566649,8566650,8566651,8566652,8566653,8566654,8566655,8566656,8566657,8566658,8566659,8566660,8566661,8566662,10612937,10612960,10612961,10612972,10612987,10612988,10612989,10613017,10613018,10613024,10613025,10613026,10613031,10613034,10613056,10613057,10613058,10613063,10613066,10613079,10613080,10613081,10613082,10613089,10613093,10613096,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613127,10613133,10613135,10613136,10613137,10613372,6673523,6673524,6673552,10117645,10117646,7015120,7015121,10515280,10515281,7015122,10515282,7015123,7015124,7015125,7015126,7015127,7015128,7015129,7015130,7015131,7015132,6673685,7015133,7015134,7015135,7015136,7015137,7015138,7015139,6673692,7015140,6673693,7015141,7015142,6673695,7015143,7015144,7015145,7015146,7015147,7015148,7015149,7015150,7015151,7015152,7015153,7015154,7015155,7015156,7015157,7015158,7015159,7015160,7015161,7015162,7015163,7015164,7015165,7015166,7015167,7015168,7015169,7015170,7015171,7015172,7015173,7015174,7015280,7015281,7015282,7015283,7015284,7015285,7015286,7015287,7015288,7015289,7015290,7015291,7015292,7015293,7015294,7015295,7015296,7015297,7015298,7015299,7015300,7015301,7015302,7015303,7015304,7015305,7015306,7015307,7015308,7015309,7015310,7015311,7015312,7015313,7015314,7015315,7015316,7015317,7015318,7015319,7015320,7015321,7015322,7015323,7015324,7015325,7015326,7015327,7015328,7015329,7015330,7015331,7015332,7015333,7015334,7015335,7015336,7015337,7015338,7015339,9169695,10117904,10118030,10118177,10118410,10516160,10516161,10516162,10516163,10512852,6672802,10419538,6672829,6672830,6672831,6672832,6672833,6672864,6672865,6672866,6672867,6672868,6672869,6672870,6672871,6672872,6672873,6672874,6672875,6672876,6672881,6672882,6672883,6672884,6672885,6672886,6672887,6672888,6672889,6672890,6672892,6672893,10415614,9168733,9168752,9168765,9168774,9168775,10418708,10418709,10418710,9168790,9168796,9168799,9168804,9168816,9168817,9168818,9168819,10418914,10418915,10418916,10418917,10418918,10418919,9169071,10418109,10418110,8550028,8550029,8550063,8550064,8550065,9167887,9168005,9168101,10883568,10888607,10883627,10888655,10883945,10884085,10884629,10884652,10884653,10889853,10889858,10890006,10890007,10890008,10885156,10885362,10885374,10885465,10885468,10885469,10883392,10883398,10883432,10885499,10885525,10626299,10626300,10626301,10886818,10631455,10631456,10887190,10887192,10887193,10887194,10887195,10887196,10887197,10887198,10887199,10887200,10887201,10887263,10590310,10590311,10647552,10532142,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532151,10532152,10532153,10532154,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10544310,10407782,10407783,10407784,10407785,10407786,10407787,10407788,10407789,10407790,10407791) 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'