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(7075863,10943465,10943466,10943467,10943468,7067997,7067998,7067999,7068000,7068001,7068002,7068003,7068004,7068005,7068006,7068007,7068008,7068009,7068010,7068011,7068012,7068013,7068014,7068015,7068016,7068017,7068018,7068019,7068020,7068021,7068022,8569387,8569388,8569389,8569390,8569391,8569392,8569393,8569394,10198807,10250989,10250990,4971144,10199567,10199568,7074572,7074642,7074655,7074656,10251922,10265035,10265036,7074831,7074832,8067833,8067834,8067835,8067836,8067837,7074901,7074959,7075253,7075254,7075255,7067268,10197562,10262768,10262769,10262770,10262771,10263013,10263014,10263015,10263016,10263043,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,10234385,7064148,10234386,7064149,7064150,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,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,10235457,10209715,10209716,10209717,10209718,10209719,10209720,10209721,10209722,10209723,10222829,10222830,10222831,10222832,10222833,10246069,10194255,8860929,10942970,10942971,10943055,10207724,8970239,10244109,7068962,7069023,10257519,10257520,10257521,10257522,10244531,10218754,8859505,8859506,8859507,8859508,8859509,8859510,8859511,8859512,10244872,10245205,10245206,10245207,10245526,10232695,10232831,10232832,10232833,10245860,10245861,10245862,10245863,10245864,10245865,10245866,10245867,10245868,8860619,10245981,10255108,10255109,10255110,10255111,10255112,10255113,10255114,10255115,10255116,10255117,10255118,10255119,10923581,10923597,10923598,10923630,10923631,10923632,10923843,10923844,10923845,10923846,10255623,10255624,10255625,10255635,10255636,10255637,10255638,10924071,10924072,10924073,10924074,10924075,10924077,10924078,10924079,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,10243624,10244057,10922686,10254279,10254280,10254281,10254282,10927926,8570295,10620563,10926108,10926109,10926110,10926111,10926112,10926113,10926114,10926115,10926116,10926117,10926118,10926119,10200795,10930646,10252981,10921650,10253325,10921782,10921783,10188702,10188703,10188704,10188705,10188706,10188707,10188708,10188709,10188710,10188711,10188712,10188713,10188714,10188715,10188716,10188717,10188718,10188719,10188720,10188721,10188722,10188723,10188724,10188725,10188726,10188727,10188728,10188729,10188730,10188731,10188732,10188733,10188734,10188735,10188736,10188737,10188738,10188739,10188740,10188741,10188742,10188743,10188744,10188745,10188746,10188747,10188748,10253908,9189459,9173948,9173949,9173950,9173951,9173952,9173953,9173954,9173955,9173956,9173957,9173958,9173959,9173960,9173961,9173962,9173963,9173964,9173965,9190162,7057638,10612344,7057865,7057866,9187921,9187922,8862839,8862840,8862841,8862842,8862843,8862844,8862845,9172442,9172443,8863198,8863260,9189014,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,9160535,9160536,9160537,9160538,9160539,9160540,9160541,9160542,9160543,9160544,9160545,9160546,9160547,9160548,9160549,9160550,9160551,9160552,9160553,9160554,9160555,9160556,9160557,9160558,9160559,9160560,9160561,9160562,9160563,9160564,9160565,9160566,9160567,9160568,9160569,9160570,9160571,9160572,9160573,9160574,9160575,9160576,9160577,9160578,9160579,9160580,9160581,9160582,9160583,9160584,9160585,9160586,9160587,9160588,9160589,9160590,9160591,9160592,9160593,9160594,9160595,9160596,9160597,9160598,9160599,9160600,9160601,9160602,9160603,9160604,9160605,9160606,9160607,9160608,9160609,9160610,9160611,9160612,9160613,9160614,9160615,9160616,9160617,9160618,9160619,9160620,9160621,9160622,9160623,9160624,9160625,9160626,9160627,9160628,9160629,9160630,9160631,9160632,9160633,9160634,9160635,9160636,9160637,9160638,9160639,9160640,9160641,9160642,9160643,9160644,9160645,9160646,9160647,9160648,9160649,9160650,9160651,9160652,9160653,9160654,9160655,9160656,9160657,9160658,9160659,9160660,9160661,9160662,9160663,9160664,9160665,9160666,9160667,10418823,9177042,9177043,9177044,10419099,10417131,10417136,4974142,8864876,8864877,8864878,8864879,8864880,4971393,4971394,4971395,4971700,10467555,9175228,9175232,9175252,9183339,9175912,10174875,10166296,10163523,10158558,10158559,10158560,10158561,10158562,10158563,10158564,10158565,10158566,10158567,10158568,10158569,10158570,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,10171543,10631423,10631424,10626533,10626534,10571376,10571391,10571392,10571393,10571394,10571395,10571709,10568891,10569489,10573209,10573210,10573443,10573444,10573445,10570445,10573446,10573447,10573448,10573449,10573450,10571056,10527868,10527869,10527870,10527871,10520798,10520799,10520800,10520801,10520802,10520803,10520804,10520805,10520806,10520807,10520808,10520809,10520810,10520811,10420579,10424924,10423965,10423966,10423967,10423968,10481003,10481004,10479672,10479673,10479674,10479675,10479676,10479677,10479679,10479680,10479681,10479682,10479683,10479684,10479685,10479686,10479687,10479688,10479689,10479690,10480016,10480017,10480018,10480019,10480020,10480021,10480022,10480023,10476585,10476586) 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'