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(10930288,11027754,11027755,11027756,11027757,11027758,11027759,11027760,11027761,11027762,11001807,11001808,11001809,11001810,7076155,10448030,11027899,11027900,11027901,11027902,11027903,11027904,11027905,11027906,11027907,11027908,11027909,11001912,11001913,11001980,11001981,10848640,10848641,10848642,10848643,10848644,10848647,10848648,10848649,10848650,10848651,10848655,10848656,10848659,10848660,10848666,10848679,10848680,8631046,8631047,8631050,11002280,11002281,10874015,8621577,11002490,10950679,11002826,11002936,11003037,10437288,11003191,11003192,11003193,11003194,11003195,11003196,8575697,8575698,8575699,8575700,11003294,10862979,11039637,11039638,11039639,11039640,11039641,8067931,11013748,11013841,10844983,8629993,7067414,7067415,8573599,11014254,10929930,7072172,8627824,7072542,11025265,11025400,11025401,11025402,11025403,11025404,11025405,10843499,10843500,8595466,8595474,11012579,8065961,8065962,8066040,8596008,10859753,7073543,8629282,11013363,8837193,8837194,8629485,8629518,11023693,11048987,10997785,10997786,10997787,8616966,7071407,10865840,8627221,8627222,8627223,8627224,8627225,8627226,8627227,8627228,8627229,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627244,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627265,8627266,8627267,8627269,8627270,8627271,8627272,8627273,8627278,8627279,8627280,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627290,8627291,8627292,8627293,8627294,8627295,8627296,8627297,8627298,8627299,8627300,8627301,8627302,8627303,8627306,8627310,8627311,8627312,8627313,8627460,8627462,8627465,10102961,10102962,10102963,8627479,8627489,8627490,8627494,8627495,8627497,8627525,8627526,8627527,11008678,11034714,11034715,11034716,10863388,11034788,11034789,10863393,11034790,11034791,11034792,11034821,10995946,10995947,10995948,11021967,11021968,11021969,11021970,11021971,11021972,11021973,11021974,11021975,11021976,11035206,11035302,11035303,11035325,11035326,11035327,11035366,8615563,3926161,3926162,11035549,10840657,11022635,11022636,10840767,11035766,11035767,11022950,11022951,8557379,10856830,10997230,11023312,11023313,11023314,11023315,11023316,11023317,8626347,8626348,8626349,10997396,7156783,11020001,11020002,11020003,11020004,11020005,11020006,11020007,11020008,11020009,11020010,11020011,11020012,11020013,11020014,10838102,3233956,3233957,3924121,11033628,10994706,7157597,11033774,8555085,10994833,10994834,10994835,11020934,11020935,11020936,11034246,11034247,10925099,11034248,11034558,11034559,11034560,11034614,11034615,11034616,11034617,11034618,11034619,11044620,11044621,11044622,11044623,11044624,11044625,11044626,11044627,11044628,11044629,11044630,11044631,11044632,11044633,11044634,11044635,11044636,11044637,11044638,11044639,11044640,11044641,11044642,11044643,11044644,11044645,11044646,11044647,11044648,11044649,11044650,11044651,11044652,11044653,11044654,11044655,11044656,11044657,11044658,11044659,11044660,11044661,11044662,11044663,11044664,11044665,11044666,11044667,11044668,11044669,11044670,11044671,11044672,11044673,11044674,11044675,11044676,11044677,11044678,11044679,11044680,11044681,11044682,11044683,11044684,11044685,11044686,11044687,11044688,11044689,11044690,11044691,11044692,11044693,11044694,11044695,11005695,11031750,11031764,11031765,11031766,11031767,10966824,11005909,11005910,10928046,7156066,7156067,10928250,11019509,11032540,10967569,10967570,10967571,10967572,10967573,10620016,10620018,11003715,11003716,11003723,11003724,11003725,11003726,11003727,11003728,11003792,11003793,11003794,11003795,11003959,11003960,11029960,11003961,11029961,11003962,11029962,11003963,11029963,11029964,11030047,11030048,11030049,11030050,11030051,11030052,11030053,11030054,11030055,11030056,11030057,11004068,10615472,10916007,10916008,10916009,10916010,10916011,10916012,10916013,10850864,10848367,11017325,11017326,11017327,11017328,11017329,11017330,11017331,10426012,11017332,11004364,3582187,3582212,3582244,11004565,10965701,10965702,10965703,10965704,11030776,11030777,11030778,11004884,11004908,11004909,10965951,10965952,10965953,10965954,10965955,10965956,10965957,10965958,10965959,10965960,10965961,10965962,10965963,10965964,10965965,10965966,10965967,10965968,10965969,10965970,10966176,10966177,10966178,10966179,10966180,10966249,10966250,10966251,11031294,10966320,10966391,10966392,10966393,10966394,10966395,10966396,10966397,10966398,10966399,10966400,10966401,10966402,10966403,10966404,10966405,10852020,11031469,11031470,11031471,11031472,11031473,11031474,11044615,11044616,11044617,11044618,11044619,8567810,9165411,9915891,8864275,9197782,9173792,10119668,10612883,10610015,9188748,9188749,9188750,9188751,9188752,9188753,9188754,9188755,9188756,9188757,9188758,9201318,10660168,7056141,8593180,3285820,6674663,6674668,9171080,9176356,10116700,10116701,10116702,10116703,10116704,10116705,10116706,10116707,10116708,10116709,10116710,10116711,10416544,4973558,10416930,10416931,9201042,10419014,10117373,9193256,4971349,9174587,8854755,9917205,9175363,9175364,9175365,9175389,6679617,6679618,6679619,8550685,9175625,8917333,9207973,10914108,10884503,10885065,10171160,10880218,10880219,10171245,10171246,10171247,10171248,10156281,10156282,10156283,10163833,10163853,10163855,10163888,10164007,10164008,10174365,10174366,10630066,10630102,10630359,10630593,10172614,10172615,10172616,10172617,10172618,10172619,10172620,10172621,10172622,10178289,10178290,10178403,10602747,10647435,10584412,10584413,10584414,10644971,10644972,10588007,10588008,10588009,10588010,10588011,10588012,10588013,10588014,10579644,10579645,10579646,10573907,10573908,10573909,10573910,10573911,10573912,10573913,10652133,10539813,10539814,10519965,10519966,10519967,10508336,10508337,10411745,10408071,10414189,10489371,10489372,10489373,10489374,10489375,10489376,10489377,10489378,10489379,10715079,10715080,10406901,10406902,10406903,10406904,10406905,10406908,10406909,10406910,10406911,10406912,10406913,10406917,10406918,10406919,10406922,10406923,10406929,10406944,10406945,10476792,10476793,10487816) 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'