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,8631480,8631481,8631482,8631611,10950747,10950748,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8632240,8632242,8632243,8632244,8632245,8632247,8632249,8632250,8632251,8632253,8632254,8632255,8632256,8632257,8632258,8632259,8632260,8632261,8632262,8632263,8632264,8632265,8632266,8632267,8632268,8632269,8632271,8632272,8632273,8632274,8632275,8632276,8632277,8632278,8632279,8632280,8632281,8632282,8632361,8632362,8632363,8632364,8632365,8632366,8632367,8632368,8632369,8632370,8632371,8632372,8632373,8632374,8632375,8632376,8632377,8632378,8632379,8632395,8632396,8632397,8632398,8632399,8632437,8632438,8632441,8632442,8632445,8632446,8632449,8632450,8632452,8632453,8632455,8632456,8632458,8632459,8632464,8632466,8632468,8632470,8632471,8632472,8632474,8632475,8632476,8632478,8632480,8632481,8632483,8632485,8632487,8632489,8632516,8632517,8632518,8632519,8629617,8629618,8629619,8629620,8629621,8629622,8067927,8067931,8629712,8629713,8629987,8630178,8630180,8630182,8630184,8630442,8630443,8630445,8630446,8630447,8630448,8630449,8630450,8630451,8630452,8630453,7201464,7201468,7201477,7201478,7201479,7201483,7201487,7201492,7201498,7201499,7201502,7201504,7201505,7201508,7201514,8595055,8595056,8595057,8595092,8595093,8595114,8595117,8595175,8628265,8911775,7202211,7202212,7202213,7202214,8628836,8628837,8628838,8628839,8628840,8628841,8628842,8628843,8628844,8628846,8628848,5654537,8628849,8628850,8628852,8628854,8628855,8628856,8628858,8628860,8628862,8628864,8628865,8628866,5654555,8628868,8628870,8628871,8628872,8628876,8628879,8628882,8628885,8628888,5654577,8628889,5654578,8628890,8628891,5654579,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,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,7202685,7202686,7202688,7202692,7202696,7202697,8629340,8629341,8629472,8629522,3237362,8626825,7200456,7200458,7200470,8626884,7198395,8908277,8908278,8625022,7198683,7198694,7198695,8908508,7198696,7198697,7198698,7198702,7198703,7198710,7198711,7198712,7198714,7198716,7198721,7198724,7198727,7198747,7198752,7198757,7198759,7198760,7198762,7198766,8625243,8625244,8625245,8625246,8625247,10101518,8626319,8626320,8626321,8626322,8626323,8626324,8626325,8626326,8626327,8626328,8626329,8626330,8626331,8626332,8626333,8626334,8626335,8626336,8626337,8626338,8626339,8626340,8626341,8626342,8626343,8626344,8626345,8626346,8626347,8626348,8626349,3923593,8613064,8906883,8906884,3234730,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,8905221,8905259,8905260,8905290,8905291,8634890,8634891,8634892,10617322,10617323,10617324,10617327,10617331,10622365,10617371,10617379,3232798,10617454,10617455,10617461,3232899,3232900,3232901,3232902,3232903,3232904,3232909,3232910,3232912,3232915,3232917,8542165,10425387,10425388,10425389,10425390,10425391,10425392,10425551,10425552,10425553,10425554,10425556,10615222,10425577,10425579,10425580,10425582,10425583,10425585,10620301,10620302,10620303,3581873,3581878,3581902,10425911,10425937,10426019,10426204,10616006,10616332,8633952,10616417,10616426,8634100,8634421,8634423,8634442,8634443,8634444,8634445,8634446,8634447,3232238,8634580,10610964,10610984,10610985,8853169,8853170,8853172,8853173,8853174,8853175,8853176,8853177,8853178,8853179,8853180,8853207,8853208,8853209,8853210,8853211,8853212,8853213,8853214,8853215,8853216,8853217,8853218,8853219,8853220,8853221,8853222,8853223,8853224,8853225,8853226,8853227,8853228,8853229,8853230,8853231,8853232,8853233,8853234,8853235,8853236,8853237,8853238,8853239,8853240,8853241,8853242,10611891,10611892,8566649,8566650,8566651,8566652,8566653,8566654,8566655,8566656,8566657,8566658,8566659,8566660,8566661,8566662,8566663,8566664,8566665,7017850,7017851,7017852,7017853,7017866,7017867,7017868,7017869,7017882,7017883,7017884,7017885,7017896,7017897,7017898,7017899,7017906,7017907,7017908,7017909,10612937,10612941,10613081,10613082,10613127,10613135,10613136,10613137,10613369,8852772,6673523,6673524,10117529,6673552,10117645,10117646,7015120,7015121,10515280,7015122,10515281,7015123,10515282,7015124,7015125,7015126,7015127,7015128,7015129,9169475,7015130,7015131,7015132,6673685,7015133,7015134,7015135,7015136,7015137,7015138,7015139,6673692,7015140,6673693,7015141,7015142,6673695,7015143,7015144,8849316,7015145,8849317,7015146,8849318,7015147,8849319,7015148,8849320,7015149,7015150,8849321,7015151,8849322,8849323,7015152,8849324,7015153,8849325,7015154,7015155,8849327,7015156,7015157,7015158,8849329,8849330,7015159,7015160,8849331,7015161,8849332,7015162,7015163,7015164,7015165,7015166,7015167,7015168,7015169,7015170,7015171,7015172,7015173,7015174,8849378,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,8551565,10516160,10516161,10516162,10516163,10118674,8850596,10512852,8848124,8848127,8848128,8848130,8848141,8848142,8848145,8848147,8848150,8848151,8848153,8848157,8848166,8848167,8848170,8848176,8848178,8848179,8848181,8848187,8848188,8848190,8848193,8848195,8848198,8848200,8848203,8848205,10419473,10419475,10419478,10419479,10419480,10419482,10419484,10419485,10419487,10419489,10419491,10419498,10419501,10419502,10419503,10419505,10419506,10419508,6672802,10419538,10116818,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,9168765,9168774,9168796,9168816,9168817,9168818,8848715,8848716,8848717,8848718,8848719,8848720,8848722,8848725,8848726,8848727,8848728,8848729,8848730,8848731,8848733,8848734,8848735,8848736,8848737,10418914,10418915,10418916,10418917,10418918,10418919,9169071,10417053,10417061,10417069,10417072,10417074,10418109,10418110,10471173,10471174,10471175,8550063,8550064,8550065,8550264,8550265,9167988,9168005,9168101,10883559,10883561,10883562,10883568,10883570,10883571,10883585,10883586,10883587,10883588,10883589,10883590,10883591,10883592,10883593,10883596,10883622,10883623,10883624,10883626,10883627,10883629,10883630,10888655,10883660,10883664,10884085,10884086,10894377,10884652,10884653,10890006,10890007,10890008,10890103,10890106,10890255,10890256,10890257,10890258,10890259,10885465,10885468,10885469,10887475,10887479,10887481,10883392,10883398,10883432,10626299,10626300,10626301,10886818,10887263,10887471,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,10506825,10507920,10507921,10409619,10409621,10409642,10409887,10409888,10409889,10409890,10409891,10409892,10409893,10409894,10409895,10409896,10409897,10409898,10410914) 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'