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(7067997,7067998,7067999,7068000,7068001,7068002,7068003,7068004,7068005,7068006,7068007,7068008,7068009,7068010,7068011,7068012,7068013,7068014,10962699,7068015,7068016,7068017,7068018,7068019,7068020,7068021,7068022,10943465,10943466,10943467,10943468,10939723,10939724,10939725,10939726,10939727,10939728,10939729,10939730,8569387,8569388,8569389,8569390,8569391,8569392,8569393,8569394,10940048,10940049,10940179,4971144,7074572,7074642,7074655,7074656,7074831,7074832,10938513,10938514,10938515,10938516,10964577,10938517,10938518,10938519,10938520,10938521,10938522,10938523,10938524,7074901,10938525,10938526,10938527,10938528,10938529,10938530,10938531,10938532,10938533,10938534,10938535,10938536,10938537,10938538,10938539,10938540,10938541,10938542,10938543,10938544,8067833,8067834,8067835,8067836,8067837,7074959,7075253,7075254,7075255,7067268,7075863,6000230,7064103,7064104,7064105,7064106,7064107,7064108,7064109,7064110,7064111,7064112,7064113,7064114,7064115,7064116,7064117,7064118,7064119,7064120,7064121,7064122,7064123,7064124,7064125,7064126,7064127,7064128,7064129,7064130,7064131,7064132,7064133,7064134,7064135,7064136,7064137,7064138,7064139,7064140,7064141,7064142,7064143,7064144,7064145,7064146,7064147,7064148,7064149,7064150,10973250,10973251,10973252,10973253,10973254,10973255,10973256,10973257,10973258,10986390,10986391,10986392,10986393,10986394,10932098,4967106,4967167,4967168,4967169,4967170,4967171,4967172,4967173,4967174,4967175,4967176,4967177,4967178,4967179,4967180,4967181,4967182,4967183,4967184,4967185,4967186,4967187,4967188,4967189,4967190,4967191,4967192,4967193,4967194,4967195,4967196,4967197,4967198,4967199,4967200,4967201,4967202,4967203,4967204,4967205,4967206,4967207,4967208,4967209,4967210,4967211,4967212,4967213,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967225,4967226,8065988,4967227,4967228,4967229,4967230,4967231,4967232,4967233,4967234,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967248,4967249,4967250,4967251,4967252,4967253,4967254,4967255,4967256,4967257,4967258,4967259,4967260,4967261,4967262,4967263,4967264,4967265,4967266,4967267,4967268,4967269,4967270,4967271,4967272,4967273,4967274,4967275,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967283,4967284,4967285,4967286,4967287,4967288,4967289,4967290,4967291,4967292,4967293,4967294,4967295,4967296,4967297,4967298,4967299,4967300,4967301,4967302,4967303,4967304,4967305,4967306,4967307,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967317,4967318,4967319,4967320,4967321,4967322,4967323,4967324,4967325,4967326,4967327,4967328,4967329,4967330,10961528,8064015,8064016,8064017,8064018,8064019,8064020,8064021,8064022,8064023,8064024,8064025,8064026,8064027,8064028,8064029,8064030,8064031,8064032,8064033,8064034,8064035,11048958,8064036,8064037,8064038,8064039,8064040,8064041,8064042,8064043,8064044,8064045,8064046,8064047,8064048,8064049,8064050,8064051,8064052,8064053,8064054,8064055,8064056,8064057,8064058,8064059,8064060,8064061,8064062,8064063,8064064,8064065,8064066,8064067,8064068,8064069,8064070,8064071,8064072,8064073,8064074,8064075,8064076,8064077,8064078,8064079,8064080,8064081,8064082,8064083,8064084,8064085,8064086,8064087,8064088,8064089,8064090,8064091,8064092,8064093,8064094,8064095,8064096,8064097,8064098,8064099,8064100,8064101,8064102,8064103,8064104,8064105,8064106,8064107,8064108,8064109,8064110,8064111,8064112,8064113,8064114,8064115,8064116,8064117,8064118,8064119,8064120,8064121,8064122,8064123,8064124,8064125,8064126,8064127,8064128,8064129,8064130,8064131,8064132,8064133,8064134,8064135,8064136,8064137,8064138,8064139,8064140,8064141,8064142,8064143,8064144,8064145,8064146,8064147,8064148,8064149,8064150,10942970,10942971,10943055,8970239,7068962,7069023,11047592,11047593,11047594,11047595,11047596,11047597,11047598,11047599,3656635,3656636,3656637,3656638,3656639,3656640,3656641,3656642,3656643,10971245,10958369,11049550,11049551,11049552,11049553,11048658,10918541,10918542,10918543,10918544,10918545,10918546,10923581,10923597,10923598,10923630,10923631,10923632,10918826,10923843,10923844,10923845,10923846,10924071,10924072,10924073,10924074,10924075,10924077,10924078,10924079,10919227,10924448,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10924468,10924469,10924470,10924471,10924472,10924473,10924474,10924475,10924476,10924477,10924478,10924479,10924480,10924481,10924482,10924483,10924484,10924485,10924486,8070811,10924681,10924682,10924683,10924684,10924685,10924686,10924687,10924771,10919858,10919859,10919860,10919861,10919862,10919863,10919864,10919865,10919875,10919876,10919968,10920046,10920047,10920048,10982242,10922686,10927926,10915502,10915503,10915504,10915523,10915524,10915525,10915526,10915527,10915528,10915529,10915530,8570295,10620563,10926108,10926109,10926110,10926111,10926112,10926113,10926114,10926115,10926116,10926117,10926118,10926119,10930646,10921650,10921782,10921783,10952949,10952950,10952951,10952952,10952953,10952954,10952955,10952956,10952957,10952958,10952959,10952960,10952961,10952962,10952963,10952964,10952965,10952966,10952967,10952968,10952969,10952970,10952971,10952972,10952973,10952974,10952975,10952976,10952977,10952978,10952979,10952980,10952981,10952982,10952983,10952984,10952985,10952986,10952987,10952988,10952989,10952990,10952991,10952992,10952993,10952994,10952995,10952996,10952997,10952998,10952999,10953000,10953001,10953002,10953003,10953004,10917045,10610988,10610989,7057638,10612344,7057865,7057866,10609690,10609691,10609692,10609693,10609694,8862839,8862840,8862841,8862842,8862843,8862844,8862845,8863198,8863260,7059434,7059435,4974269,10515349,10515350,10515351,4974428,4974824,4974928,2809073,2809074,2809075,2809076,2809077,2809078,2809079,2809080,2809081,2809395,7057006,2809653,8861579,8861580,8861581,8861582,8861583,8861584,8861585,8861586,8861587,8861588,8861589,8861590,8861591,8861592,8861593,8861594,8861595,8861596,8861597,8861598,8861599,8861600,8861601,8861602,8861603,8861604,8861605,8861606,8861607,10518978,8918097,9160516,9160517,9160518,9160519,9160520,9160521,9160522,9160523,9160524,9160525,9160526,9160527,9160528,9160529,9160530,9160531,9160532,9160533,9160534,10418823,10419099,10417131,10417136,4974142,8864876,8864877,8864878,8864879,8864880,4971393,4971394,4971395,4971700,10467555,10462674,10462675,10462676,10462773,10462774,10462775,10462776,10462777,10462778,10462779,10462780,10462781,10462782,10462783,10462784,10462785,10462786,10462787,10462788,10462789,10462790,10462791,10462792,10462793,10462794,10462795,10462796,10462797,10462798,10462799,10462800,10462801,10462802,10462803,10462804,10462805,10462806,10462807,10462808,10462809,10462810,10462811,10462812,10462813,10462814,10462815,10462816,10462817,10462818,10462819,10462820,10462821,10462822,10462823,10462824,10462825,10462826,10462827,10462828,10462829,10462830,10462831,10154036,10154037,10154038,10154039,10154040,10154041,10154042,10154043,10154044,10154045,10154046,10154047,10154048,10154049,10154050,10154051,10154052,10154053,10154054,10154055,10154056,10154057,10154058,10154059,10154060,10154061,10154062,10154063,10154064,10154065,10154066,10154067,10154068,10154069,10154070,10154071,10154072,10154073,10154074,10154075,10154076,10154077,10154078,10154079,10154080,10154081,10154082,10154083,10154084,10154085,10154086,10154087,10154088,10154089,10154090,10154091,10154092,10154093,10154094,10154095,10154096,10154097,10154098,10154099,10154100,10154101,10154102,10154103,10154104,10154105,10154106,10154107,10154108,10154109,10154110,10154111,10154112,10154113,10154114,10154115,10154116,10154117,10154118,10154119,10154120,10154121,10154122,10154123,10154124,10154125,10154126,10154127,10154128,10154129,10154130,10154131,10154132,10154133,10154134,10154135,10154136,10154137,10154138,10154139,10154140,10154141,10154142,10154143,10154144,10154145,10154146,10154147,10154148,10154149,10154150,10154151,10154152,10154153,10154154,10154155,10154156,10154157,10154158,10154159,10154160,10631423,10631424,10626533,10626534,10571376,10571391,10571392,10571393,10571394,10571395,10571709,10568891,10569489,10570445,10571056,10520798,10520799,10520800,10520801,10520802,10520803,10520804,10520805,10520806,10520807,10520808,10520809,10520810,10520811,10420579) 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'