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(10447733,10962575,10447787,4970675,3229020,3229021,3229153,3229206,8067027,8575146,8583524,8583525,8583665,8583666,8067368,10847070,3229962,8575732,10990291,10437559,7074632,3230164,3227259,8067927,10938794,8573309,8573310,8573311,8573312,10447478,8620482,7201070,7201071,10959563,10103025,11011612,11011613,7201319,7201424,10842937,7201610,8065514,8065515,8065516,10931901,7201741,7201742,7201777,10960216,10960217,7201804,7201805,8836127,7201895,10843422,10843447,10986468,10986469,7202082,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,10843772,10843774,10843775,10843776,10843777,10843797,10986740,7202378,7202472,7202473,7202474,7202475,7202476,5654581,5654649,7202586,10932797,10932798,10932800,11000165,9794587,7202771,10997528,3237398,10102115,11036708,11036709,7200603,7200613,8910574,8910599,8910603,10985232,10985233,10985234,10985235,10985236,7200817,7200907,10102864,7201007,7201008,10102904,7071808,7071809,10995709,10995719,7198375,7198408,7198464,3235819,7198685,7198695,7198710,7198711,7198714,7198719,7198730,7198731,7198742,7198762,7198766,7198770,8908750,8908751,7199005,10996551,10996552,10996553,8615758,10941704,10941774,10840912,10941948,8564996,8564997,10841150,8860418,8565228,8565229,8565230,8565231,8565232,10101736,3237097,3237098,3237103,3237111,3237112,3237114,7070761,10837649,7196195,7196197,7196229,7196251,7196307,7196316,7196337,10618278,10618279,10967818,10967819,10967820,10618287,10618289,7196471,8613073,10618442,10618448,10618452,11007049,11046091,11007188,11007189,7196892,10838519,7197046,7197048,7197073,11046638,10619229,10838924,11046971,11046976,11047009,11047010,11047082,8907463,11047127,8907591,7197791,7197805,10995370,10619835,10619906,8907822,11047462,11047468,11047473,11047474,11047487,10927507,10927508,10992578,10617118,10617151,8541576,8541577,8541586,8541587,8541588,8541589,8541590,8541591,8541592,11044777,11044779,11044825,10617381,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617402,10617406,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617418,10617419,10617420,10617421,10617433,10617446,10617448,10954113,10993173,10622714,10928302,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10993372,10993401,10993402,8542251,8542286,8905862,10990672,10990673,10990674,10990675,10990676,10425390,10425393,10620186,10951666,10620187,10620188,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620207,10620208,10615229,10620301,10620302,10620303,10615329,10615330,10615710,11043257,11043258,10615820,10615823,10848432,10930735,10930736,8540352,10426204,10991552,10952581,10991691,10991692,10426384,10426385,10991743,10991744,8540599,10952791,8540638,10991882,10952889,8904265,8904329,11043965,10991991,10922256,10922257,10922258,10922259,10922260,10992324,10992387,10992388,10427106,8904857,10610980,9189359,10611025,10614057,7019065,9165415,7019100,7019138,7059732,6669829,7019293,7019327,10559498,7019359,10611457,10614476,6670024,10614503,10614504,10614505,10611641,6665992,10714483,10611812,6666233,9214240,9190242,9190243,10611910,10611915,9190253,9182262,9182263,9182264,9182265,7019952,8549453,10612086,10612195,10612196,10612197,10612198,9211551,9211552,9211562,9211563,9211564,8862099,8862146,9211629,10612293,9211630,10612294,9211631,10609354,10609366,9211925,9172148,9172149,10609834,7058373,10561036,10609919,10609920,10609921,10612938,10612943,10609947,7017942,10612960,10612961,7017962,7017982,9188362,9196363,9188371,9188377,9188380,9188393,10613097,10613098,10613099,9212464,9212465,10120713,7018181,10610310,10610311,10613350,10610479,10610482,10613483,10613504,10613514,7018517,10613531,7018551,7018585,9196936,9204938,9204939,9188958,9188959,7018619,7018653,10610697,10613739,9221124,10613830,7018825,7018859,7018893,10610914,9169317,9169370,9169473,10515345,9185608,10117819,9185626,7015286,7015306,7015326,9185850,7056038,10513728,10513729,9185921,9169942,10126199,9170036,9186049,10118607,10118608,10118678,9186542,9186543,9186544,9186782,9186801,9178828,8552371,9171116,9171117,10516953,10516954,10515060,10515062,10515063,10515064,10515065,10515066,7057450,10416361,10416365,9192464,10416387,10416398,10416400,10116727,10419453,10419498,10419515,10417531,10417532,10417533,10417535,10418546,10415614,7054903,10419668,10419687,10419704,10419707,10419708,10419709,10419713,10419714,10419715,10419720,10419725,10415729,10415735,10416806,10416807,10416808,10418808,10416809,10418810,10418813,10418814,10418815,10419815,10418817,10418820,10418821,10418823,10419823,10419824,10418825,10419825,10419826,10416826,10418827,10419827,10418831,10418832,10415833,10418834,10418836,10418838,10418840,10418842,10418844,10418846,10418848,10418850,10418852,10418854,10418856,10418860,10418861,10418863,10419888,10420037,10420041,10420042,7055300,10417057,10417058,9161147,10417076,10417088,10417092,10417093,10417103,10417105,10417106,10417107,10417108,10417109,10419112,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10420171,10420172,8549463,7019980,7020008,7020036,7020064,10122665,10122666,7020189,7020217,7020245,10467171,10122826,10122827,10122828,10122829,10122834,10122835,10122836,10122837,10122838,10122839,8549884,8549888,8549894,8549919,10463430,9190866,9190867,10467457,7020689,10123239,9199085,7020767,10463775,10463785,10463797,10465807,10463833,9167264,10465847,10463878,9207333,9207334,8550631,9207481,9183522,4972480,4972613,10466350,10466352,10466396,10466450,10466468,10462513,9167953,10883559,10883560,10883561,10883563,10883586,10883590,10883625,10883627,10888637,10888638,10888639,10888640,10888641,10888642,10883665,10159956,10889699,10884720,10884721,10884724,10889838,10875001,10890148,10890149,10890152,10890156,10890171,10880207,10880208,10880209,10176265,10163536,10632048,10163786,10632300,10632301,10632302,7001019,10627321,7001072,10184010,10184011,10184012,10184016,10184018,10627589,10627793,10883396,10948420,10948421,10630243,10885852,10172092,10886118,10886119,10886120,10886121,10886122,10886123,10886124,10886125,10886126,10886127,10886128,10886129,10886130,10886131,10886132,10162243,10162244,10162247,10625926,10625927,10187507,10626145,10626229,10172758,10172759,10631247,10631248,10631249,10172893,10172894,10172896,10172897,10172898,10631413,10631415,10631417,10631418,10631421,10631422,10631424,10631426,10631427,10631428,10631429,10631430,10631432,10631434,10631436,10631437,10631440,10631442,10631445,10631447,10631449,10631450,10631452,10631453,10631454,10887197,10626711,10887228,10626720,10887231,10188259,10950080,10950081,10626798,10626878,10626879,10626880,10626881,10626882,10626883,10626884,10631885,10626885,10626886,10626887,10626888,10626889,10626890,10626891,10626892,10626893,10626894,10626895,10626896,10626897,10626898,10626899,10626900,10626901,10626902,10887465,10580255,10580256,10580258,10580259,10580260,10601359,10601360,10601400,10643478,10598541,10598542,10598543,10598544,10598545,10598546,10598575,10598576,10598672,10598676,10598806,10598807,10598865,10590271,10590290,10590291,10590292,10590293,10590294,10590295,10590296,10599386,10590887,10579803,10579804,10579805,10579806,10579818,10579819,10579820,10579836,10579837,10579838,10579839,10579840,10591908,10591909,10591942,10591943,10591944,10591945,10591947,10591948,10591949,10539115,10525335,10539803,10539804,10539810,10527909,10527910,10532142,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532151,10532152,10532153,10532154,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10532164,10532165,10528172,10528173,10528174,10528175,10528191,10528226,10530282,10524418,10524419,10524420,10524422,10544464,10544465,10544471,10522614,10522615,10539036,10539037,10420288,10421312,10421331,10421333,10424334,10422354,10422375,10422379,10421426,10421427,10421576,10423583,10424583,10423584,10422595,10422596,10422597,10420643,10422749,10421765,10421766,10421773,10421774,10421775,10421776,10421777,10421778,10422821,10422824,10420861,10420862,10420863,10420864,10420865,10420866,10420867,10420868,10420869,10420870,10420871,10420872,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10424886,10424890,10424897,10420899,10424940,10420966,10424966,10422995,10424997,10424998,10423008,10423125,10423150,10423153,10422167,10483070,10490324,10490325,10490326,10490327,10490328,10490329,10490330,10490331,10490332,10490333,10490334,10490335,10490336,10490337,10490338,10490339,10490340,10490341,10490342,10490343,10490344,10490345,10483407,10483408,10496936,10478011,10497032,10497039,10482047,10497387,10497388,10497389,10497398,10497407,10489431,10487524,10406873,10406875,10406877,10406986,10406987,10406988,10406991,10406992,10482831,10482840,10482841) 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'