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(8630696,3228554,3228555,10861842,3228978,3229187,8631480,8631481,8631482,3229284,8631539,8631554,8631555,10950608,8621878,10950698,10862577,10849646,10862804,10862805,10437392,10862850,10862867,10862868,10862869,10868928,8632335,8632336,8632436,10872749,10872750,10962198,10860893,10860894,8630447,8630448,8630449,8630450,8630451,8630452,8630453,8630454,8630455,10962586,10962587,7201239,7201245,7201246,7201274,8627810,8627816,7201432,7201472,7201474,7201481,7201482,10866542,7201504,10960043,8595207,10960307,8628442,7202136,7202137,7202138,7202139,7202140,10960624,10960628,10960629,10960630,10960631,10960643,10859246,10960644,10960645,10960646,10960681,10960682,8628699,8628718,8628719,10859383,7073153,10859460,8629117,8629118,8629119,8629120,8629121,8629122,8629123,8629124,8629125,8629126,8629127,8629128,8629129,8629130,8629131,8629132,8629137,8629138,8629139,8629141,8629142,8629143,8629144,8629145,8629146,8629147,8629148,8629149,8629150,8629151,8629152,8629153,8629154,8629155,8629156,8629157,8629158,8629159,8629160,8629161,8629162,8629163,8629167,8629168,8596166,8629169,8629170,8629171,8629172,8629173,8629178,8629179,8629180,8629181,8629182,8629183,8629184,8629186,8629187,8629207,8629208,8629209,8629210,8629211,8629212,8629213,8629214,8629215,8629216,8629217,8629218,8629265,10859986,10859987,3237392,10857373,8834751,8834752,7200530,7200531,7200533,7200537,7200538,8627002,8627061,7200673,7200674,7200675,7200676,7200677,7200678,7200679,7200698,7200699,7200700,7200701,7200702,7200717,7200719,7200726,10857968,10857969,10858025,10858066,10858067,10858068,10858072,10858073,10858091,10858113,10858130,10858132,10858141,10858177,7198182,7198184,10855297,7198309,8624787,7198393,8624836,8624837,8624838,8624839,8624840,8624841,8624842,8624843,8624844,8624845,8624846,8624847,8624848,8624849,8624850,8624851,8624852,8624853,8624854,8624855,8624856,8624857,8624858,8624859,8624860,8624861,8624862,8624863,8624864,8624865,8624866,8624867,8624868,8624869,8624870,8624871,8624872,8624873,8624874,8624875,8624876,8624877,8624878,8624879,7198689,11009188,11009322,11009323,10855938,10855939,10855940,10863961,10863999,10864000,8625689,10996729,10996730,8625700,8625701,11009753,11009754,8625720,8625721,8625722,8625728,8625729,8625731,8625732,8625733,8625734,8625735,8625744,8625745,8625746,8625747,8625748,8625749,8625750,8625751,8625752,8625753,8625754,8625755,8625758,8625759,8625760,10101302,10101303,10101304,10101306,10101307,10101308,10101309,10101327,10101329,10101330,10101331,10101332,7199531,7199532,7199533,7199537,7199538,7199539,7200030,10857140,10857141,10857143,10857144,7200103,8626514,10865202,7200178,3923414,7196272,7196284,7196287,7196290,7196291,7196293,7196294,7196295,8906108,7196300,7196301,7196302,7196303,7196304,7196305,7196306,7196309,7196310,7196311,7196312,7196313,7196314,7196315,7196318,7196319,7196320,7196321,7196322,7196323,7196325,7196326,7196327,7196328,7196332,7196333,7196334,7196335,7196336,7196338,7196339,7196340,7196341,7196342,7196343,7196350,7196351,7196352,7196353,7196354,10967800,10967801,10967802,10967896,7196462,7196463,7196464,7196465,7196467,7196468,7196469,3923639,10618292,7196532,7196533,7196534,7196535,7196536,7196537,7196538,7196539,7196540,7196541,10838079,10838083,10838087,10853654,10853658,10853876,7197019,7197020,7197021,10854063,7197026,7197028,8554795,8554796,8554802,10838796,10838797,10838803,7197633,7197635,7197639,7197668,7197671,7197672,7197682,7197725,7197726,7197745,7197746,7197747,3234983,7197916,7198044,8624517,7198180,10617108,10617124,10617134,10617137,10617367,10617368,10617370,10617377,10617390,10617391,10617392,10617401,10617407,10617408,10617424,8905558,11045204,10852900,10852901,8905708,8905709,10853134,10853135,10853139,10853140,10837610,10615063,10850372,10850432,11042938,10615556,10615598,10615647,10991590,10991591,10426273,10615957,10615979,10615980,10426320,10426321,10426324,10426325,10426338,8611332,10616686,8634317,8634321,8634345,8634346,8634347,8634348,8634349,8634350,10616804,10852212,10852213,10621952,10852214,10852215,10852216,10852217,10852218,10852219,10852220,9205314,10562215,10614077,10614086,10614089,10611218,6669828,10611338,10611342,6669999,10614476,10614485,10614488,10614492,9197862,10614592,10614713,10611725,10611731,10611750,10119650,8851305,10612194,10612195,10612196,10612197,10612198,10609269,10612303,10612328,10612412,10612414,10612426,10612427,10612428,10609700,10609701,10612723,10612724,10612725,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612738,10612740,10612756,10612757,10612761,10612762,10612763,10612764,10612765,10612766,10612769,10612771,10612772,10612781,10612782,10612783,10612784,10612785,10612786,10612787,10612797,10612800,10612803,10612805,10612806,10609829,10612897,10612898,10612910,10612911,10609980,10613029,9172369,10610039,10610046,10610132,10610259,10610414,10610486,10613519,9204938,10610671,9205238,10610909,10515122,6673645,6673660,989924,10117965,10118190,10118208,6674315,9912329,8849987,8850034,10514616,10514617,10514618,9913017,9913033,8850693,8850694,991345,991346,10514784,10514845,10514846,10514847,10514848,10514849,10514850,10514851,10514893,10514894,7057452,10416228,9168318,10427712,6672588,10416367,10416368,9168453,9192470,9192471,9192472,10417404,10417405,10416414,10416430,10416433,10416434,9168797,9168929,10117378,6673478,9169287,10468877,10471171,9198636,10463362,10469567,9175040,8916774,6667365,6667366,6667600,6667601,9167637,10468439,10116195,10116196,10116197,10116198,9168072,9168168,10466854,10888595,10879848,10884973,10890141,10890143,10890144,10890145,10885149,10890151,10885159,10885462,10887546,7000836,10882747,10882748,10882807,10882893,10158983,10158995,10158999,10159000,10159006,10885483,10885653,10885660,10885664,10171779,10876751,10626292,10626293,10897024,10897027,10887052,10887171,10626878,10882421,10882423,10605423,10608607,10599332,10599333,10603514,10603875,10591149,10591150,10607248,10607249,10607250,10607251,10601540,10521269,10521270,10543295,10543296,10521852,10528350,10543008,10421239,10508198,10510295,10508350,10498366,10510374,10508395,10505542,10505543,10505574,10505577,10505578,10423687,10423688,10508603,10507619,10507620,10507621,10508625,10508626,10508681,10508687,10508688,10508689,10508690,10508691,10508692,10508697,10508698,10508701,10508707,10508718,10510723,10510743,10510780,10508793,10507844,10507845,10507846,10507847,10507897,10507898,10507902,10507927,10507937,10507986,10508002,10508019,10409235,10409236,10409346,10409347,10409349,10409675,10407736,10407737,10413837,10412130,10412131,10414379,10414380,10412555,10412556,10412609,10412645,10412646,10412647,10412651,10412652,10412670,10412691,10412702,10412704,10412712,10412746,10411097,10411098,10411099) 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'