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(8630669,8630681,8630682,8630683,7076143,8574395,10458880,7076344,7076346,7076347,7076351,8574534,8631039,4970692,11041169,8631140,11041361,11041362,11041363,7068749,7068817,7068820,7068829,7068879,7065950,7065951,8583762,10951243,10951244,10951249,10951343,8629641,8573340,10929510,10929511,10961943,10929608,7075495,8068479,8630261,7067762,10447667,7075901,10842923,8835896,8065844,8066180,8066181,5654540,8066484,10928845,8629230,8629275,10104807,8629366,8629372,8629377,8629380,8629450,10929195,10984856,10102345,10102346,10102347,10102348,10984905,10984908,10102382,10959087,10959088,10959089,10959090,10959091,10959092,10943379,10943386,10943390,7068938,8907996,8908006,7069000,7069011,8625233,8625234,8625236,3236286,3236287,3236288,3236289,3236290,3236291,3236292,3236293,3236294,3236296,3236297,10983608,10983779,10983781,10983782,10983783,10983784,11035925,11035926,11035973,10941922,11048373,11048374,11048375,11048377,11048378,10841239,10841240,10841241,10841242,10841243,10841244,10841245,10841246,10841247,10841342,3237023,7070620,7070640,11010537,11010538,11010539,11010540,11010541,11010542,11010543,7196220,7196221,7196230,11045742,11045746,11045747,10928603,11045763,10928667,10928668,10928669,10928670,7196382,7196383,7196417,7196452,7196477,7196911,7196919,7196935,7196969,7196981,7196982,8613575,8613578,8613579,8613580,8613581,7197050,7197055,7197056,8613704,7197128,7197129,7197130,11046869,11046870,11046871,11046925,11046926,11046927,11046936,11046965,11046966,7197605,7197606,7197607,7197608,7197609,7197610,7197611,7197612,7197613,7197614,7197615,7197616,7197617,7197618,7197619,7197620,7197621,7197623,7197624,7197625,7197626,7197627,7197628,7197629,7197630,7197631,7197632,7197633,7197634,7197635,7197636,7197637,7197638,7197639,7197640,7197641,7197642,7197643,7197644,7197645,8614235,7197646,7197647,7197648,7197649,7197650,7197651,7197652,7197653,7197654,7197655,7197656,7197657,7197658,7197659,7197660,7197661,7197662,7197663,7197664,7197665,7197666,7197667,7197668,7197669,7197670,7197671,7197672,7197673,7197674,7197675,7197676,7197677,7197678,7197679,7197680,7197681,7197682,7197683,7197684,7197685,7197686,7197687,7197688,7197689,7197690,7197691,7197692,7197693,7197694,7197695,7197696,7197697,7197698,7197699,7197700,7197701,7197702,7197703,7197704,7197705,7197706,7197707,7197708,7197709,7197710,7197711,7197712,7197713,7197714,7197715,7197716,7197717,7197718,7197719,7197720,7197721,7197722,7197723,7197724,7197725,7197726,7197727,7197728,7197729,7197730,7197731,7197732,7197733,7197734,7197735,7197736,7197737,7197738,7197739,7197740,7197741,7197742,7197743,7197744,7197745,7197746,7197747,8907735,8907749,8907792,8907825,8907849,8907864,8907874,8907904,8907905,8907906,8907953,8907956,8907957,7155500,7155530,10622099,10622100,8905204,8905205,8905206,8905207,8905208,8905209,8905210,8905212,8905213,8905214,8905215,8905216,8905217,8905218,8905219,8905220,10622720,10977623,10977624,10977625,10977626,10977627,10977628,10977629,10977630,10977631,10425351,10425386,10847884,10425518,10425566,10425576,10977899,10977900,10977901,10977902,10977903,10977904,10425941,10978278,10978279,10978280,10978281,10978282,10978283,10978284,10848390,10426013,10426014,10978393,10978394,10991449,10991450,10991451,10991452,10978458,10426193,10991562,10978653,10965742,10965743,10621100,3231701,10426676,10426677,10426706,10426707,10426708,10426709,10426710,10992031,10992032,10992033,10992034,10992124,10992139,10616567,10427106,10427107,10427111,8541354,8541355,3232331,3232332,3232333,3232334,3232335,3232337,3232338,3232339,3232340,3232341,3232342,3232343,3232346,10565152,9189508,10614207,9213659,9213745,9213752,9213803,9213804,9213805,9213806,9213807,9213808,9213809,9213831,9213868,9181968,9181969,9181970,9181971,9181972,9181973,9181974,9181975,9181976,9181977,9181978,9181979,9181980,9181987,9181988,9181989,9181990,9181991,9181994,9181995,9181996,9181997,9181998,9214007,9214008,9214009,9214010,9214011,9214043,9182046,9182048,9182049,9182050,9182051,9182052,9182053,9182054,9182055,9182056,9182062,9182074,7057614,7057618,7057619,10612260,9211667,10557524,10557525,10557526,10557527,10557528,10557531,10612500,10612642,6676352,6676391,6676392,9196281,8862975,8566985,8567007,9204790,9204791,10558608,10610468,6677242,10515220,9193511,9193512,7056069,7056070,10126122,10126146,9177956,10517800,9178165,9178166,9178167,9178168,9178169,9178170,9178171,9178172,7056405,9178275,9178276,9178277,9178278,9178316,9178317,7056495,7056496,7056501,9162382,9162383,2809380,9186807,9178837,9178838,9178839,10119052,7057177,7057178,10519089,10418292,6673141,9169162,9169241,9169242,9169243,9169244,9169245,10463033,10463057,10463058,10463059,10467140,10467141,10467142,10467157,10467158,10467159,10467224,10463401,10463439,10467443,10469489,10469490,3963400,10463661,4971957,10465696,4971980,6667143,6667144,6667145,6667146,6667147,10465789,10463819,10463820,10463821,10463822,10465837,10465838,10465839,10465840,10465841,10465895,10465896,9175337,10463918,10463919,10463920,10467973,10467974,10467975,10467976,10467977,10467978,10467979,10467980,10467981,10467982,10467983,10467984,10467985,10467986,10467987,10467988,10467989,10467990,10467991,10467992,10467993,10467994,10467995,10467996,10467997,10467998,10467999,10468000,10468001,10468002,10468003,10468004,10468005,10468006,10468007,10468008,10468009,10468010,10468011,10468012,10468013,10468014,10468015,10468016,10468017,10468018,10468019,10468020,10468021,10468022,10468023,10468024,10468025,10468026,10468027,10468028,10468029,10468030,10468031,10468032,10468033,10468034,10468035,10468036,10468037,10468038,10468039,10468040,10468041,10468042,10468043,10468044,10468045,10468046,10468047,10468048,10468049,10468050,10468051,10468052,10468053,10468054,10468055,10468056,10468057,10468058,10468059,10468060,10468061,10468062,10468063,10468064,10468065,10468066,10468067,10468068,10468069,10468070,10468071,10468072,10468073,10468074,10468075,10468076,10468077,10468078,10468079,10468080,10468081,10468082,10468083,10468084,10468085,10468086,10468087,10468088,10468089,10468090,10468091,10468092,10468093,10468094,10468095,10468096,10468097,10468098,10468099,10468100,10468101,10468102,10468103,10468104,10468105,10468106,10468107,10468108,10468109,10468110,10468111,9175606,10466231,10462317,10466331,10466385,10466386,10466387,10466388,10466389,10466443,10466444,10462453,10462530,10462531,10462532,10462533,10462613,10462614,10462615,9192098,10462727,10462730,10462731,10466866,10883691,10170706,10899878,10899879,10899880,10899881,10899882,10899883,10899884,10899885,10899886,10899900,10899901,10899907,10884999,10173618,10173619,10173620,10173621,10627287,10883061,10949150,10949151,10896531,10896532,10896533,10896534,10896535,10896536,10949369,10167698,10167699,10167700,10167701,10896742,10167858,10167859,10167860,10167861,10167862,10167863,10167864,10167865,10168036,10168037,10168038,10168039,10168040,10168041,10168042,10887053,10887148,10168185,10168186,10168187,10168188,10877229,10643507,10586633,10598906,10650030,10599157,10599158,10599384,10599385,10599921,10599922,10599923,10599924,10599925,10599926,10599927,10599928,10599929,10599930,10599931,10599932,10581960,10599980,10591027,10591028,10600057,10600058,10600059,10591378,10591389,10591390,10591391,10591424,10591449,10591450,10591451,10600904,10600925,10600933,10600934,10600935,10600936,10600937,10600938,10600939,10600940,10529708,10521752,10521753,10521754,10521755,10521756,10529834,10529835,10529976,10529977,10520121,10520122,10520123,10524807,10524808,10524809,10524810,10524811,10524812,10524813,10524814,10524815,10524816,10524817,10524818,10524819,10524820,10524821,10524822,10524823,10524824,10524825,10524826,10524827,10524828,10524829,10524830,10524831,10524832,10524833,10524844,10524845,10524846,10524847,10524848,10524849,10524852,10524853,10524854,10538891,10538892,10538893,10538894,10538895,10538896,10538897,10538898,10538899,10538900,10538901,10538902,10538903,10538904,10538905,10538906,10538907,10538908,10538909,10538910,10538911,10538912,10538913,10538914,10538915,10538916,10538917,10538918,10538919,10538920,10538921,10538922,10538923,10538924,10538925,10538926,10538927,10538928,10538929,10538930,10538931,10538932,10531071,10421221,10421222,10421223,10421490,10483168,10483169,10479298,10479341,10492439,10479452,10479453,10479454,10479461,10479462,10479468,10479558,10407923,10479587,10481934,10481936,10481940,10481941,10481976,10481978,10481979,10481997,10481998,10482003,10482008,10482011,10482012,10482013,10482014,10482015,10482016,10482017,10482018,10497448,10497449,10497450,10497451,10497452,10497453,10407056) 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'