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(10962578,10962693,10962694,7076041,7076042,10962733,10962734,7076286,7076287,7076288,7076289,7076290,7076291,7076292,7076293,7076296,7076297,7076353,4970721,4970722,4970723,4970731,4970732,4970733,4970734,4970738,8569453,8569563,8569564,8569565,8569625,10940507,8066998,8066999,10963750,7066105,7066106,7066107,7066108,7066109,7066110,7066111,10963826,10963827,10963831,10963832,10963833,8067255,8067256,8067257,10437271,8067396,7066344,7066348,8067927,8067931,8067942,7075771,7072249,7072259,7072263,10931826,10931828,10931829,10931830,10931834,10931836,10931837,8065506,8065807,7064747,7064748,7064751,7064754,7064756,8065841,8065842,7073317,7073327,7065457,7065694,7065695,7070953,8860980,7071093,10942913,7071260,7071261,7071264,7071265,7071266,7071267,7071274,7071297,7071298,7071299,7071300,7071301,7071303,7071304,7071309,7071325,8861260,8064474,8064475,8064476,7071514,7071523,7071524,7071537,7071660,7071661,7071662,7071674,8970239,10944447,10944645,10944646,3655849,3655890,10944725,10944726,10944727,10944728,10944729,10944730,10944731,10944732,10944733,10944734,10944735,10944736,10940960,10940969,7069389,10941285,7069602,7069606,10941688,10941689,10941690,10941691,10941692,10941693,10941694,10941695,10941696,10941697,10941698,10941699,10941700,10941701,10941702,10941703,10941704,10941705,10941713,10941716,10941717,10941718,10941719,10941720,10941724,10941725,10941726,10941727,10941734,10941738,10941739,10941740,10941741,10941745,10941749,10941751,10941752,10941753,10941754,10941755,10941756,10941757,10941758,10941759,10941760,10941762,10941763,10941764,10941765,10941766,10941767,10941768,10941769,10941770,10941771,10941772,10941773,10941774,10941775,10941776,10941777,10941778,10941779,10941780,10941781,10941782,10941783,10941791,10941809,10941838,10941839,10941849,10941913,10941920,10941926,10941929,10941948,10941961,10941969,10941979,10941984,10942027,10942028,10942100,10942106,10942123,10942141,10942147,7070473,8860412,7070729,7070749,7070757,7070760,7070761,7070793,10623063,10623064,10623065,10623092,10623093,10623113,10623114,10623115,10623116,10623165,10623166,10623167,10623169,10623177,10618183,10618209,10623258,10623259,10623260,10623481,10623482,10623490,10623810,8070909,8070910,10619229,10619835,10619836,10619844,10619863,10619864,10619865,10619866,10619885,10619886,10619889,10619891,10619892,10619893,10619895,10619896,10619901,10619902,10617126,10617138,10617139,10617140,10617157,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10622269,10617322,10617323,10617324,10622360,10622365,10622402,10622405,10622408,10622428,10622431,10622441,10622445,10622447,10622460,10622508,10622514,10622516,10622523,10617573,10617793,10617955,10617957,10614969,10615076,10615167,10615179,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620207,10620208,10615222,10620297,10620298,10615334,10615338,10615343,10615344,10615363,10615389,10926086,10926087,10615598,10926113,10926176,10615674,10615709,10615711,10926285,10615780,10615938,10621034,10616476,10616479,10616655,10927259,10927260,10927261,10927262,10927263,10927264,10927265,10927266,10927267,10927268,10616888,10616898,10616907,10613962,10613963,10613964,10613965,10613966,10613967,10613968,10613969,10613970,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10613985,10613986,10613987,10613988,10613989,10613990,10613991,10613992,10613993,10613994,10613995,10613996,10613997,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,10614014,10614015,10614016,10614017,10614018,10614019,10614020,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10614037,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,10614064,10614085,10614086,10559321,10614182,10614186,10565349,10614203,10614220,10614221,10614243,10614246,10614257,10614260,10614261,10614262,10614263,10614264,10614267,10614268,10614269,10614270,10565478,10614338,10559498,10614376,10614377,10614415,10614416,10559585,10559609,10614475,10614476,10614495,10614496,10565646,10614497,10565647,10614498,10614499,10614500,10614501,10614502,10614503,10614504,10614505,10614518,10614548,10559701,10559709,10614565,10562767,10611646,10611655,10562851,10611789,10611856,10611954,10611957,10611969,10611976,10611983,10611995,10611996,10611997,10612000,10612001,10612002,10612003,10612004,10612059,10612069,10612132,10612135,10612136,10612137,10609155,10609285,10612291,10609307,10609313,10612380,10612381,10609707,10609749,10609834,10609844,10609845,10561087,10561088,10561089,10561090,10561091,10561092,10561093,10609971,10610030,10610075,10613127,10613136,10558317,10558318,10558319,10558320,10613172,10610347,10613350,10613369,10613391,10613392,10613393,10613394,10613406,10613421,10613431,10613432,10613434,10613435,10613475,10613483,10613498,10613501,10613504,10613505,10613506,10613513,10613514,10613515,10613523,10613524,10613525,10613527,10613528,10613529,10613531,10613545,10613547,10613695,10610697,10613697,10613698,10613699,10610709,10613732,10564883,10613733,10613736,10613738,10613750,10613760,10610777,10613797,10613811,10613812,10613813,10613814,10613815,10613816,10613817,10613818,10613819,10613820,10613821,10613822,10613823,10613824,10613825,10613826,10613827,10613828,10613829,10613830,10613831,10613832,10613833,10613834,10613835,10613836,10613837,10613838,10613839,10613840,10613841,10613842,10613843,10613844,10613845,10613846,10613847,10613848,10613849,10610850,10613850,10613851,10613852,10613853,10613854,10613855,10613856,10613857,10613858,10613859,10613860,10613861,10613862,10613863,10613864,10613865,10613866,10613867,10613868,10613869,10613870,10613871,10613872,10610873,10613873,10610874,10613874,10613875,10613876,10613877,10613878,10613879,10613880,10613881,10613882,10613883,10613884,10613885,10613886,10613887,10613888,10613889,10613890,10613891,10613892,10613893,10613894,10613895,10613896,10613897,10613898,10613899,10613900,10613901,10613902,10613903,10613904,10613905,10613906,10613907,10613908,10613909,10613910,10613911,10613912,10613913,10613914,10613915,10613916,10613917,10613918,10613919,10613920,10613921,10613922,10613923,10613924,10613925,10613926,10613927,10613928,10613929,10613930,10613931,10613932,10613933,10613934,10613935,10613936,10613937,10613938,10613939,10613940,10613941,10613942,10613943,10613944,10613945,10613946,10613947,10613948,10613949,10613950,10613951,10613952,10613953,10613954,10613955,10613956,10613957,10613958,10613959,10613960,10613961,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10515309,10515341,10515342,10515343,10515344,10515345,10515346,10515347,10513407,10513552,10513553,10513554,10513555,10513556,10513557,10513558,10513559,10513560,10513561,10513562,10513563,10513564,10513565,10513728,10513729,10517789,10517790,10517791,10517792,10517793,10517794,10517795,10517796,10517797,10517798,10517799,10517801,10517802,10517803,10517804,10517805,10517806,10517807,10517808,10513952,10513961,10513994,10513997,10513998,10513999,10514017,10514023,10514028,10514031,10514032,10514033,10516119,10516120,10516121,10516122,10516123,10516124,10516125,10516126,10516127,10516128,10516129,10516130,10516131,10516132,10516136,10516137,10516138,10516139,10516142,10516193,10512530,10516789,10516792,10516928,10415232,10415242,10415251,10415325,10415342,10415366,10415367,10415368,10415369,10415370,10415371,10415372,10415373,10415374,10415375,10415376,10415392,10415393,10415394,10417398,10417399,10417400,10417401,10417406,10417407,10417408,10419469,10416481,10419494,10419496,10417531,10417532,10417533,10417534,10417535,10415586,10415614,10417633,10419994,10419995,10419996,10419997,10419998,10419999,10420000,10420001,10420002,10420003,10420004,10420005,10420006,10420007,10420008,10420009,10420010,10420011,10420012,10420013,10420053,10420054,10463181,10463182,10463183,10469245,10469289,10469337,10469338,10469339,10469340,10469341,10469342,10469343,10469344,10469345,10469346,10469347,10469348,10469349,10469350,10469351,10469352,10469353,10469354,10469355,10469356,10469357,10469358,10469359,10469360,10469361,10469362,10469363,10469364,10469365,10469366,10469367,10469368,10469369,10469370,10469371,10469372,10469373,10469374,10469375,10469376,10469377,10469378,10469379,10469380,10469381,10469382,10469383,10469384,10469502,10469573,10463587,10463588,10463589,10463590,10463591,10463592,10463593,10463594,10463595,10463596) 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'