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(10962575,10962578,7075912,7076124,7076125,7076126,10939882,10939907,10939908,4970670,4970671,4970675,4970685,4970738,8569474,8569607,8569608,8569625,4971081,7065836,7065837,10963637,10963674,8067396,10964441,10964442,10964443,10964444,10964445,10964446,10964447,10964448,10964449,10964450,10437751,10437753,10437774,8067942,8067943,7067196,10961933,10962360,10962361,10939443,7071829,7064168,8075333,8075334,8075335,8075336,10960404,10960411,10960412,10960413,7064733,7064735,8065807,7064760,7064761,7064771,8065853,10960474,10960475,7064822,7064856,7064863,7064878,10960568,10960569,8065957,7064892,7064911,7064912,7064926,7064947,7064977,7064983,7064984,7064985,7064986,7065004,7073161,7065457,10961222,8861260,10959088,10959092,10959184,7071537,8970239,8071673,8071676,8071682,8071687,8071691,8071695,8071701,8071703,8071705,8071706,8071707,8071717,8071726,8071733,8071738,8071741,8071747,8071752,8071756,8071760,8071766,8071768,8071770,8071771,8071772,8071782,8071791,8071798,8071803,8071806,8071812,8071817,8071821,8071822,8071831,8071833,8071835,8071836,8071837,8071847,8071856,8071863,8071868,8071871,8071877,8071882,8071886,8071890,8071896,8071898,8071900,8071901,8071902,8071912,8071921,8071928,8071933,8071936,8071942,8071947,8071951,8071955,8071961,8071963,8071965,8071966,8071967,8071977,8071986,8071993,8071998,8072001,8072007,8072012,8072016,8072020,8072026,8072028,8072030,8072031,8072032,8072042,8072051,8072058,8072063,8072066,8072072,8072077,8072081,8072085,8072091,8072093,8072095,8072096,8072097,8072107,8072116,8072123,8072128,8072131,8072137,8072142,8072146,8072150,8072156,8072158,8072160,8072161,8072162,8072172,8072181,8072188,8072193,8072196,8072202,8072207,8072211,8072215,8072221,8072223,8072224,8072226,8072227,8072237,8072246,8072253,8072258,8072261,8072267,8072272,8072276,8072280,8072286,8072288,8072290,8072291,8072292,10941262,10945086,10945101,10941948,8860412,10618183,8070049,8070054,8070057,8070061,8070094,8070101,8070107,8070111,8070125,8070131,8070134,8070136,8070139,8070149,8070152,8070157,8070168,8070171,8070172,8070178,8070180,8070186,8070189,8070196,8070198,10623495,10623496,8070212,8070214,8070219,8070224,8070225,8070230,8070234,8070237,8070314,8070319,8071516,8071525,8071535,8071540,10619835,8071543,10619836,8071549,8071554,8071558,8071562,8071569,8071571,8071573,8071574,8071575,10619871,8071587,10619887,8071596,10619895,8071603,10619896,8071608,8071611,8071617,8071622,8071626,8071630,8071636,10619928,8071638,8071640,8071641,8071642,8071652,8071661,8071668,10953511,10953512,10953513,10617138,10617171,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10617322,10617323,10617324,10617325,10617326,10617332,10617333,10617334,10617335,10617336,10617337,10617338,10617339,10617340,10617341,10617342,10617343,10617344,10617345,10617346,10617347,10617348,10617349,10617350,10617351,10617352,10617353,10617354,10617355,10617356,10617357,10617358,10617359,10617360,10622360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617369,10617370,10617371,10617372,10617373,10617374,10617375,10617376,10617377,10617378,10617379,10617380,10617381,10617382,10617383,10617384,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10617405,10622405,10617406,10617407,10617408,10622408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617424,10617425,10617426,10617427,10617428,10617429,10617430,10617431,10622431,10617432,10617433,10617434,10617435,10617436,10617437,10617438,10617439,10617440,10617441,10622441,10617442,10617443,10617444,10617445,10622445,10617446,10617447,10622447,10617455,10617456,10617461,10622514,10622516,10622523,10622533,10954310,10620183,10620208,10615222,10615229,8570104,10620303,10615339,10615340,10615341,10615342,10615343,10615352,8570413,10615598,10615709,10615721,10615722,10615780,10615896,10616005,10616044,10616045,10616058,10616542,10616543,10616544,10616644,10616898,10616905,10610963,10610964,10610965,10610984,10610985,10610987,10610988,10610989,10610994,10610995,10610997,10611037,10565319,10614203,10614220,10614376,10611377,10611378,10611390,10611391,10611393,10611394,10611398,10611400,10611408,10611411,10611412,10611413,10611428,10611432,10611435,10611436,10611437,10611441,10611443,10611444,10611450,10611451,10611452,10611463,10611464,10611480,10611482,10611491,10611492,10611493,10611498,10614499,10614501,10614502,10614503,10614504,10614505,10611507,10611526,10611527,10611536,10611537,10611538,10611539,10611542,10611543,10611551,10614552,10611552,10614553,10614554,10611555,10559705,10559706,10559709,10559715,10559716,10559717,10611567,10559718,10611569,10559719,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10611581,10611585,10611586,10611590,10611594,10611597,10611598,10611600,10611604,10611612,10611613,10562767,10611618,10611619,10611621,10611623,10611635,10611636,10611637,10611638,10611640,10611643,10611649,10611655,10611660,10611676,10611856,10611891,10611892,10611969,10609035,10609036,10609155,10612194,10612201,10612268,10612294,10609313,10612320,10612321,10609369,10612381,8862481,10612916,10609916,10609921,10612936,10609936,10612937,10612938,10609938,10612939,10612941,10609941,10612942,10612943,10609986,10609988,8862865,10613089,10613093,10613096,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613133,10613136,10613144,10558317,10558318,10558319,10558320,10613192,10613220,10613221,10613235,10610241,10610242,10610243,10610244,10610245,10610246,10610247,10610248,10610249,10610250,10610251,10613362,10613369,10561523,10561524,10610479,10610480,10610481,10610482,10613506,10613513,10613514,10613545,10610697,10610709,10613729,10564883,10613736,10613740,10613750,10564973,10610874,10610881,10610901,10610947,10610954,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10515309,10515310,10515327,10515377,10515422,10515423,10517614,10517615,10517616,10517617,10517618,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10513974,10513975,10514015,10516119,10516120,10516121,10516122,10516123,10516124,10516125,10516126,10516127,10516136,10516137,10516138,10516139,10516193,4975237,10512530,10512562,10512563,10512564,10512565,10516866,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10516917,10516918,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10419306,4973244,10419349,10419350,10416358,10416359,10416361,10415366,10415367,10415368,10415369,10415370,10415371,10415372,10415373,10415374,10415375,10419375,10415376,10419468,10419469,10419473,10419474,10419475,10419477,10419478,10419479,10419480,10419481,10416481,10419482,10419484,10419485,10419487,10419489,10419491,10419493,10419509,10419510,10415614,10415685,10418708,10418709,10418710,4973643,4973736,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,10420150,10420151,10420152,10420153,10420155,10420156,10420158,10420159,10420161,10420163,10420165,10420166,10419166,10420168,10420170,10420171,10420172,10419172,10419173,10420174,10420176,10420177,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420194,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10471171,10471172,10471173,10471174,10467217,10467218,10467221,10469277,10469278,10467327,10467796,10467797,8563250,8563251,8563252,8563299,8563358,8563359,8563360,8563361,8563362,8563363,10468234,10468235,10468236,10468237,10468239,10628177,10627145,10627319,10627405,10627775,10626241,10626299,10626300,10626301,10626429,10626430) 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'