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(7201616,8559379,8559380,8559381,8559382,8559383,8559384,8559385,8628202,8628203,8628205,8628206,8628207,8628209,10873856,10873857,10873858,10873859,10873860,10873861,10873862,10873863,10873864,7201848,7068112,7068113,7076127,7076128,10103845,8628400,8628401,8628402,8628403,8628404,7202133,10859195,7202165,7202168,7202171,8836425,7202212,8628739,8628742,10250915,10250916,10250917,10250918,10250919,10250920,10251130,10251131,10251132,8629290,8629304,8629308,10251479,10251480,8629641,10199967,10199973,10199978,10199983,10199988,10860595,10860598,8558354,4430186,10870885,10870886,10870892,10870894,10870896,10857932,10858129,10858138,10858140,10858143,10858158,10858159,10858164,10858165,10842809,10103344,8559172,8559173,8559174,8627874,8627876,6000112,6000113,6000114,6000119,10195099,10840159,7198679,6000194,6000195,6000196,6000197,6000198,6000199,7198719,10868916,10868917,10868918,10856185,10856198,10856199,8626047,10274210,10870074,10932792,10932793,10857175,10857176,10857177,10857178,10857179,10857280,8626657,8626658,10209765,10209766,10209773,10209774,8626817,7197616,7197617,7197619,7197654,7197656,7197660,7197661,7197664,10867709,7197695,7197697,7197721,7197736,8555466,8555467,8555468,7197769,8555469,7197771,7197843,10285333,8624320,8624321,10855040,8624400,10194524,8624578,10868290,7198368,10194866,8624880,8624892,8624898,8624914,8635057,8635059,3922833,3922851,3922859,10853132,10941118,7196383,7196427,7196452,10866537,3923796,10853774,10941691,10866810,10866813,10866814,10866824,10866834,10941758,10941759,10941760,7196962,7196981,8554690,7197001,10838529,7197044,7197047,10193536,10942027,10838994,7070757,10285012,10285050,10850697,10229151,8633111,8633149,8633152,10433157,10229374,10229375,10848433,3582191,8540366,8070180,10229581,10229582,10229583,10623507,10229624,10229636,10851523,3231701,10230010,10230085,8634271,10204360,10204361,8634351,8634352,8634353,10865005,10427106,10282591,10282592,10282593,3232331,3232332,3232333,3232334,3232335,3232337,3232338,3232339,3232340,3232341,3232342,3232343,3232346,8634688,8634693,10836856,8905212,8612008,8612009,8612010,8612011,8612012,8612013,8612014,8612015,10619842,10619843,10852571,10852572,10619906,10865600,8631999,8632005,8632006,10431967,10849689,8575734,10849857,8632263,8622460,8622467,10617348,10617354,9216505,9216506,9216507,9216508,9216509,8632605,10425553,10863532,10863533,10863534,10863535,10848001,10863536,10863537,10863538,10863539,10863540,10863541,10848029,10860695,8630179,8630180,8630181,8630198,8630199,10860845,10860846,10860847,10860848,10615338,9214509,8630660,8630863,8630864,8630865,8630919,8630927,8630928,10615962,10848695,10848696,10848697,10848698,10861836,10861837,8631572,8583486,8631782,8631910,8631911,8631939,8631940,8631941,10616906,8631965,8631966,8631987,8631988,10939610,9915684,8853315,9915700,9173746,9173747,10559609,10940094,10122129,9182258,9182259,9182260,7019923,7019924,10612069,10612106,10120021,10120022,10120023,10120024,7058533,7058534,9196373,10613105,7058620,9196459,9196460,9172470,9172471,9172472,9172473,9172474,9172475,6677267,6677268,6677276,3654303,10939439,10613930,10613931,10613932,10613933,10613934,10613935,10613936,10613937,10613938,10613939,10613940,9169395,7055656,9185611,9911858,10513559,10513560,10513562,9185797,9185836,9185837,9185898,9185916,9185917,9185918,9169936,8849786,9912267,8849890,8849891,6674281,8849910,9912459,6674698,9186785,10518693,10518694,10518695,10518696,10518697,7057147,9913358,9913361,6672521,10419675,10419677,10419678,10419690,10419703,10418828,9177085,9177092,9177093,9177094,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10122730,10467119,10467129,9182746,10469356,10467429,10465761,9175245,10465828,10465834,10465836,10465838,10465841,10123837,10123846,10123847,10123848,10466305,8550898,10466333,10466365,10466380,10466383,10466387,9167887,10466861,10466862,10466866,10903660,10899910,10899911,10899912,10890111,10890133,10890136,10171187,10895299,10895300,10895301,10895302,10895303,10895304,10895305,10895306,10632041,10632052,10172080,10162088,10886438,10886439,10886440,10886441,10886442,10625926,10886443,10625927,10886444,10886445,10886446,10886447,10886448,10886449,10886450,10886451,10886452,10886453,10886454,10886455,10886456,10886457,10631914,10887460,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10610969,10568120,10568121,10610971,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10601238,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10601402,10598520,10590298,10590483,10647553,10647554,10647555,10647556,10647557,10609369,10582570,10567621,10567622,10567623,10567624,10567625,10591947,10591948,10591949,10568110,10568111,10539118,10525567,10525568,10548310,10522464,10522465,10524867,10524868,10539077,10539078,10539079,10539080,10539087,10539095,10421229,10421230,10421231,10498253,10420434,10424483,10424484,10424485,10424486,10424487,10424488,10424489,10424490,10424491,10422523,10422524,10422530,10422532,10422534,10415680,10421982,10507889,10507901,10407235,10411282,10411295,10411296,10463057,10463058,10463059,10477107,10483215,10463437,10484516,10407954,10407957,10411990,10411991,10411992,10411993,10411994,10463733,10463807,10477816,10463820,10410254,10414352,10482011,10482012,10482037,10482038,10482039,10482040,10482041,10482042,10412516,10493251,10493252,10493253,10493254,10493255,10493296,10493297,10493298,10493299,10493300,10493301,10493302,10412701,10412709,10412711,10412713,10412728,10412729,10412735,10412736,10462420,10462422,10462423,10462433,10462434,10462435,10478492,10478493,10414842,10478500,10414845,10478501,10414934,10406962,10406963,10406964,10406965,10409024,10409025) 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'