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(8630914,4970670,10989074,10989075,10989076,10989077,10940136,8631073,8631075,8569524,10944265,7065837,7065947,8583441,10950602,10950603,10950604,10849385,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,7066348,8631993,7074350,8575582,8575584,10862877,8632265,8067927,10869243,10860478,10858106,10858107,10858108,10858109,7201275,8627790,10843159,10843160,7201676,10986174,10866810,10866813,10866814,10866821,10866823,10866837,10866838,10866839,10866843,10866844,10866846,10866864,10866865,10866866,10866953,10866954,8911773,8628397,8065853,10843582,8595615,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,8629283,10859960,7200091,3237398,8626706,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,10855212,8624571,8624573,7198368,8624894,8624917,10855592,10855593,10855594,10855597,10855598,10855602,10855603,8908517,7198720,7198721,7198722,7198724,7198763,10855818,10855819,10855820,11009284,11009285,8908715,8908716,8908750,8908753,8908755,10856186,10856200,8564730,10996895,10996896,10996905,10996906,10996907,10996908,7199480,8626345,11010447,8626418,10853229,10853230,10853231,10853232,10853233,10623165,10623166,10623167,3923420,10853922,7197612,7197626,10624555,7197676,7197744,3924977,8624345,8624346,8555689,8624400,10855049,10855054,10855057,10855058,10855061,10855062,8634468,10852254,8905184,8905185,8905186,8905187,11044826,8905211,10617381,10852623,10928029,8635058,3922830,3922834,3232959,10990514,10990515,10990516,10990517,10990518,9216510,10850173,10951572,10620335,10620336,10620337,10425582,10848006,10850686,8540569,10616211,8634318,8634319,8634320,8634344,10610975,10610976,10610977,10610978,8853177,8863986,10612022,9187551,9187552,9211566,10609285,10119836,9211918,9211937,8566586,10609845,9212315,9188369,9188370,10613107,10558297,10558298,10558299,10558300,9172538,10610482,10613513,10613514,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,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10613739,8567652,10117592,10117593,10117594,10117595,10117596,10117597,10117598,6673685,6673686,9169520,8592692,10513563,9911983,9911984,9911985,9911986,9911987,9911988,9911989,9911990,9911991,9911992,9911993,9169938,10515834,10515835,10515836,10118247,10118248,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,9913359,6672724,10416443,10419675,10419677,10419678,10419687,10419689,10419708,10419709,10419710,10419714,10419715,10419717,10419745,10419746,10419747,10419837,10419838,6673159,8848781,8848782,8848783,8549890,8549972,3963318,9183124,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,8855351,9183544,10468323,10468324,10468325,10468326,10468327,10468328,10468329,9168000,9168001,9184062,9168103,8848050,8848051,10427638,10427639,10883521,10883522,10883523,10883524,10883525,10883526,10883527,10883528,10883529,10883530,10883559,10883560,10883561,10884094,10889583,10890139,10905191,10632054,10632160,10632310,10900509,10900510,10895568,10895569,10161853,10161854,10161855,10161856,10161857,10161858,10900938,10900939,10900940,10900941,10900942,10906059,10906060,10906066,10906067,10906068,10906069,10906070,10906071,10906072,10906073,10906074,10886556,10886557,10901822,10901823,10188047,10188049,10631911,10631916,10601359,10601360,10601403,10598819,10598820,10590271,10590275,10590276,10590290,10590291,10590292,10590293,10590294,10590295,10590296,10590297,10647401,10647402,10647403,10647404,10647405,10647406,10647407,10647408,10647409,10647410,10647411,10601437,10546314,10522454,10522455,10522464,10522465,10534571,10534572,10534573,10534574,10534589,10534590,10534597,10421451,10507861,10507862,10507863,10420980,10411283,10411297,10407559,10483475,10484534,10496905,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,10410756,10410757,10414757,10410758,10414758,10410761,10410762,10410763,10410768,10410769,10406991) 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'