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(10870446,8630858,7076286,7076287,7076288,7076289,7076290,7076291,7076292,7076293,7076294,7076296,10989074,10989075,10989076,10989077,8631059,8631073,8631075,4970670,8631141,8631142,10940136,8569524,10861935,10861940,10861942,10944265,11041605,7065947,8583441,10950602,10950603,10950604,8631751,9215782,9215783,9215784,9215785,9215786,9215787,9215788,9215789,9215790,9215791,9215792,9215793,10868428,8631786,9215794,9215795,9215796,9215797,9215798,9215799,9215800,9215801,9215802,9215803,9215804,9215805,9215806,9215807,9215808,9215809,9215810,9215811,9215861,9215871,9215872,9215873,8631914,8631945,8631946,8631947,8631948,8631969,8631970,8631992,8631993,7074350,8575582,8575584,10871818,10871819,10849851,10862877,8632265,8632329,8632330,8632331,8632473,8632474,10990514,10990515,10990516,10990517,10990518,8632482,8632483,8632488,8632489,9216510,10850154,10850155,10850156,10850157,10850158,10850159,10850160,10850161,10850162,10850164,10850165,10850166,10850167,10850168,10850169,10850170,10850171,10850172,10850173,10869243,8067927,10860478,8629972,8629973,8629977,8629981,8630118,8630172,10870118,10870119,8630478,7201275,7201277,8627790,8627902,8627903,8627930,10843159,10843160,7201676,10986174,10866810,10866813,10866814,8065506,10858816,10866821,10866823,8065514,8065515,8065516,10866837,10866838,10866839,10866843,10866844,10866846,10866864,10866865,10866866,10866953,10866954,8628354,8628356,8628397,10843582,8595615,8628681,8628687,8628693,8628694,8628695,8628696,8628697,8628698,8595711,8595719,8628728,7202367,7202369,7202371,7202373,7202375,7202378,7202381,7202383,7202384,7202385,7202386,7202388,7202390,7202392,7202394,7202396,7202398,7202400,7202402,7202404,7202406,7202408,7202410,7202413,7202415,7202417,7202419,7202421,7202423,7202425,7202427,7202430,7202432,8628880,8628881,8628882,8628896,8628897,8628898,10859569,8629283,10859960,10865254,10865255,10865256,10865257,10865258,10865259,10865260,10865261,3237398,8626706,10865444,10865445,10865446,10865447,10865448,10865452,3927570,3927571,10857964,10857965,10857982,10857984,10857985,10857990,10857991,10857996,10858014,10858015,10858016,10858017,10858018,10858021,10858022,10858027,10858028,10858032,10858033,10858034,10858035,10858036,10858038,10858039,10858040,10858041,10858042,10858043,10858047,10858056,10858057,10858058,10858059,10858060,10858086,10858088,10858090,10858092,10858093,10858095,10858096,10858097,10858100,10858106,10858107,10858108,10858109,10959556,10959557,10959558,10959559,10959560,10959561,10959562,10959563,10959564,10959565,10959567,10959568,10959571,8624766,8624767,8624768,8624769,8624770,8624771,8624772,8624773,8624774,8624775,8624776,8624777,8624778,8624779,8624780,10855531,8624894,8624917,10855592,10855593,10855594,10855597,10855598,10855602,10855603,8625018,8625019,8908517,7198720,7198721,7198753,7198754,7198755,10855818,10855819,10855820,11009284,11009285,3236028,8908715,8908716,8908750,8908753,8908755,3926192,10856186,10856200,8564730,10856309,10856310,10996895,10996896,10996905,10996906,10996907,10996908,7199480,8626096,8557471,8557472,8557473,10101699,8626345,11010447,8626418,7200091,8626528,10853230,10853232,10853233,10853242,10853243,10853244,10837777,3923420,10623165,10623166,10623167,10853922,7197612,7197622,7197626,7197666,7197667,7197676,3234917,7197744,3234918,3234919,3234920,3234921,10624555,3924977,8624345,8624346,8624373,8555689,8624400,10855049,10855054,10855057,10855058,10855061,10855062,10855212,8624571,8624573,10852254,8905184,8905185,8905186,8905187,11044826,8905211,10617381,8635058,3922830,3922832,3922834,10928029,3232959,10852895,10993366,10993367,10951572,8632610,8632611,10850510,10850512,10850513,10850514,10850515,10850518,10620335,10620336,10620337,10850686,10850826,8633191,8633193,8633237,8633322,8633610,10931016,10616211,8540751,8541104,8634318,8634319,8634320,8634344,8634438,8634439,8634468,8541358,10610975,10610976,10610977,10610978,10610984,10610985,8567908,8567909,8567910,8567911,8567912,8567913,8567914,8567915,8567916,8567917,8567918,8567919,8567920,8567921,8567922,8567923,8567924,8567925,8567926,8567927,8567928,8863986,7059859,10611831,10612022,9187551,9187552,10609285,10609287,10119836,9211918,8566438,9211937,10609845,9188369,9188370,10613107,10613127,10558297,10558298,10558299,10558300,9204489,10558317,10558318,10558319,10558320,10613208,10610482,10613513,10613514,9172859,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,9915156,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,8567652,6677375,6677376,10117592,10117593,10117594,10117595,10117596,10117597,10117598,6673685,6673686,9169520,8592692,10513563,9911983,9911984,9911985,9911986,9911987,9911988,9911989,9911990,9911991,9911992,9911993,10515834,10515835,10515836,8849936,8849999,8850035,8850280,8850281,8850282,8850283,8850284,8850285,8850286,8850287,8850288,8850289,8850290,8850291,8850292,8850293,8850294,8850295,8850296,8850297,8850298,8850299,8850300,8850301,8850302,8850303,8850304,8850305,8850306,8850307,8850308,9912747,10516568,10516569,10516570,10516571,10516572,10516573,10516574,10516575,6672724,10416443,10418561,10418562,10418563,10418564,10418565,10418566,10419675,10419677,10419678,10419687,10419689,7054936,10419708,10419709,10419710,10419714,10419715,10419717,10418734,10418735,10418736,10418737,10419745,10419746,10419747,10419837,10419838,6673159,10117386,8549890,8549972,3963318,9183124,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,6667412,9207486,9183544,10462301,6672141,6672142,9168000,9168001,9184062,9168103,10427638,10427639,10883521,10883522,10883523,10883524,10883525,10883526,10883527,10883528,10883529,10883530,10884094,10155224,10889583,10905191,10632054,10632310,7001102,10900509,10900510,10895568,10895569,10630094,10948420,10948421,10630105,10948458,10948459,10161853,10161854,10161855,10161856,10161857,10161858,10900938,10900939,10900940,10900941,10900942,10906059,10906060,10906066,10906067,10906068,10906069,10906070,10906071,10906072,10906073,10906074,10886556,10886557,10891780,10901822,10901823,10626815,10631911,10631916,10608091,10601359,10601360,10601403,10646620,10646621,10646622,10598819,10598820,10647401,10647402,10647403,10647404,10647405,10647406,10647407,10647408,10647409,10647410,10647411,10579809,10551769,10546314,10522454,10522455,10522464,10522465,10534571,10534572,10534573,10534574,10534589,10534590,10534597,10421451,10498499,10507861,10507862,10507863,10420980,10425075,10425076,10425077,10423128,10411283,10411297,10407359,10407360,10413366,10411385,10409437,10409438,10409439,10407557,10407558,10407559,10483475,10407822,10407823,10407824,10407825,10407828,10484534,10413998,10414007,10408048,10410262,10410270,10410271,10410274,10410275,10414355,10482020,10410400,10412551,10412552,10412568,10412570,10412571,10412576,10412577,10478237,10478238,10478239,10412600,10412601,10412602,10412605,10412606,10412611,10412612,10412616,10412617,10412618,10412619,10412620,10412621,10412622,10412623,10412624,10412634,10412635,10412636,10412637,10412638,10412639,10412665,10412667,10412669,10412671,10412672,10412674,10412676,10412677,10412680,10412685,10412686,10410694,10410756,10414757,10410757,10414758,10410758,10410761,10410762,10410763,10410768,10410769,8562173) 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'