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(10962653,10962664,10962665,10962678,8068893,8068894,10962692,10943429,10943786,10943793,7068532,7068535,10940404,8569786,8569787,8569788,8569789,10963499,10963500,7068827,7068828,10963521,8569860,10976573,7065968,10963815,7066174,10437134,7074280,10437135,4968647,7074715,7066718,7066744,10938478,10961632,10961657,10961658,10961659,10938860,10961928,10938868,10961929,10938869,10938881,10939174,10939380,10939384,10939403,10939416,8068816,10931285,10931286,10931287,10931328,10972726,7064044,10972803,10972855,10972860,10972862,10972863,7072256,10973108,10973177,10973178,7072561,7072567,7072609,7072616,10931974,7072674,7072809,4967042,4967043,4967044,7064843,7064844,7072862,7064902,7072904,7072967,7072972,7072973,7073124,7073310,7073468,10961306,10961307,10933087,10961501,7070936,7070937,7070938,7070939,7070940,8063954,7071014,7071183,10958986,10943010,10943011,11049303,10972147,10972148,10972156,10972157,10943141,10972204,10959222,10972342,10972343,10972344,10972345,10972346,7071665,7071667,7071670,7071672,5999993,7071713,8064692,10972453,10972464,10972542,10972543,7071866,7068992,10969935,7069284,7069285,7069286,7069287,7069288,7069289,7069290,7069292,7069294,10970002,10970014,10970015,10970016,10970017,10970018,7069441,10944862,7069483,10970215,10970216,10970256,10970257,10970258,10970286,10970403,10970405,10970406,10970407,10957462,10957463,10957464,10957465,11047816,10970619,11047839,11047840,11047841,11047842,11047843,11047844,11047845,11047846,11047847,11047918,11047919,11047920,11047921,11047922,11047923,11047924,11047925,11047926,11047927,11047928,11047929,11047930,11047931,11047932,11047933,10970721,10970746,10970747,10970749,10970750,10941703,10970869,10971014,10971024,10971025,3656995,10971172,10971183,10971251,10971252,10971253,10971282,10971336,11048653,8073497,8073518,10918529,10623064,10618134,10918721,10918739,10918744,10618286,8070243,8070244,8070245,8070246,8070262,10955218,8070275,8070276,8070277,8070278,8070279,8070280,8070281,8070282,8070283,8070284,8070285,8070402,8070403,8070404,8070405,8070406,8070407,8070408,8070409,8070410,8070411,8070412,8070415,8070416,8070417,8070418,8070419,10924303,10955540,10955541,10955542,10955543,10955544,10955545,10955546,10955547,10955548,10955549,10955550,10955551,10955552,10955553,10955554,10955555,10955556,10955557,10618901,10968602,10968615,10955681,10955682,10955683,10955684,10955685,10955686,10955687,10955688,10955689,10955690,10955691,10955692,10955693,10955694,10955695,10955696,10955697,10955698,10955699,10955700,10955701,10955702,10955703,10955704,10955705,10955706,10955707,10955708,10955709,10955710,10955711,10955712,10955713,10955714,10955715,10955716,10955717,10955718,10955719,10955720,10955721,10955722,10955723,10924575,10924576,10955724,10924577,10924580,10924581,10924582,10924583,10924584,10924585,10924586,10924587,10924588,10924589,10924590,10924591,10924592,10924593,10924594,10924595,10968744,10924596,10968745,10924597,10968746,10924598,10968747,10924599,10968748,10924600,10924601,10924602,10924603,10924604,10924613,10924614,10924615,10924623,10924624,10924625,10924626,10924627,10919628,10924628,10919629,10924629,10919630,10924630,10919631,10924631,10924632,10924638,10924644,10924645,10924646,10924647,10924648,10924649,10924650,10924651,10924652,10924653,10924669,10924670,10924671,10924672,10924673,10924674,10924681,10924688,10924689,10924690,10924691,10924692,10924693,10924694,10924701,10924702,10924703,10924704,10924706,10924707,10924708,10924709,10924710,10924711,10924712,10924719,10924722,10924723,10924724,10924725,10924726,10924727,10924728,10924744,10924745,10924750,10924751,10924752,10924753,10924754,10924755,10924756,10924757,10924758,10924759,10924760,10619261,10919916,10919927,10919928,10919929,10969151,10969152,10969153,10969154,10969155,10969156,10969232,10969233,10969234,10969235,10969236,10969237,10969240,10969241,10969242,10969243,10969244,10969245,10969246,10969247,10969248,10969249,10969250,10969251,10619898,10917489,10917508,10917509,10917510,10917511,10917512,10917513,10917514,10917515,10917516,10917517,10917518,10917519,10917520,10917521,10917522,10917523,10917525,10622028,10617039,10622040,10622121,10917742,10917743,10917744,10917745,10622263,10617324,10954020,10954021,10922901,10922902,10622400,10917966,10917967,10917968,10917969,10917970,10917971,10917972,10917974,10917975,10917976,10917977,10954191,10954195,10954197,10954199,10954201,10954223,10622917,10622918,10620010,10915742,10915743,10920773,10920774,10920775,10615289,10620317,8570284,10620340,10915884,10915885,10915886,8570327,10915887,10915888,10915889,10915890,10915891,10915892,10915893,10915894,10915895,10915896,10915897,10915898,10915899,10915900,10915901,10915902,10915903,10915904,10915905,10915906,10915907,10915908,10915909,10915910,10915911,10615448,10920984,10615573,10921095,10965281,10965287,10921265,10921272,10926279,10965482,10921350,10921351,10921416,10921424,10921425,10930850,10965694,10616080,10921626,10921627,10621117,10921628,10621119,10921629,10621120,10621124,10621125,10621126,10621132,10616203,10965905,10965906,10965907,10965908,10965909,10965910,10965911,10965912,10965913,10965914,10965915,10965916,10965917,10926835,10966060,10616476,10616477,10616478,10616486,10616496,10616497,10616498,10616499,10616500,10616501,10616502,10616505,10616506,10616507,10616508,10616514,10616521,10616529,10616546,10917088,10917089,10917090,10917091,10917092,10917093,10917094,10917095,10917096,10917097,10616739,10616791,10616941,10922461,10562119,10562120,10562121,10562122,10562123,10610998,10611146,10611147,10611148,10611179,10611253,10611434,10562669,10562670,6665897,10614648,10614649,10614650,10611694,10562951,10611806,10611807,10612040,10609104,10557343,10612209,10612213,10557457,7057815,7057816,7057817,7057818,7057821,7057822,7057823,10563583,10563585,10612487,10563693,7058130,10609640,10563791,10563792,10563793,10609719,10609723,10563923,8862703,10609903,10612924,10612945,7058457,8862951,10613275,10613277,10613297,10613298,10613300,10613303,10610354,10613356,10613357,10613367,10558546,10558547,10558548,10558549,10558550,10558551,10558552,10558553,10558554,10558578,10610696,8863716,7055511,10515292,7055749,10515433,10555486,10555487,10555492,7055850,10555539,10555540,10555541,10555542,10555543,10555544,10555551,10555552,10555553,10555554,10555555,10513627,10515731,7056087,10515784,10513790,10513791,10513792,10513793,7056146,10515793,10513794,10515794,10513795,10513796,10513797,10513798,10515798,10513799,10515799,10513800,10515800,10513801,10513802,10513803,10513804,10513805,10513806,10513807,10513808,10513809,10515814,10515815,10515816,10515822,10515837,10515838,10515839,10515840,10515841,10515842,10515843,10515897,10515898,10515899,10515900,10515901,10515902,10515903,10515904,10515905,10515906,10515951,10515952,10515953,10515954,10515981,10515982,10515983,10515984,10515985,10515986,10515987,10515997,10515998,10515999,10516000,10556029,10556030,10556031,10556032,10556033,10556034,10556035,10556036,10556037,10556038,10556039,7056411,7056413,10514262,10514263,10514279,10514282,10514283,10514284,10514289,10514291,10514292,2809150,10556339,10556340,10514436,10514437,10514448,10514466,10514467,10514475,10514476,10516597,10516598,10512808,10517028,10517042,10517066,10517067,10517068,10517069,10517070,10557097,10417222,10418230,10417257,10416269,10417312,10419314,10415318,10417372,10416446,10417449,10417479,4973428,10415501,10417507,10418517,10418520,10418527,10415598,10417634,10418646,10418668,10418669,10419685,10418695,10418697,10418698,10415759,10416834,10416836,10416840,10418847,10416882,10416890,10419891,10419895,10419907,10415952,10416978,10416980,10416982,10418985,10417050,10417053,10417054,10417055,10417056,10417118,10418122,10418123,10416153,10417170,10417174,10417176,10417177,10417205,10417210,10462909,10463024,4971357,4971358,4971359,4971509,4971555,4971556,10471681,10471682,4971959,10471683,4971960,10471684,10471685,10471686,4971963,10471687,4971964,10471688,10471689,10471690,10471691,10471692,4971968,4971969,4971970,4971971,4971972,4971973,4971975,4972009,4972022,10471767,10471768,10471819,10471820,10471821,10471822,10471823,10471824,10471825,10471826,10471827,10471828,10471829,10470003,10470126,4972457,4972458,4972459,4972460,4972461,4972462,4972463,4972464,4972465,4972466,4972467,4972468,4972469,4972471,4972473,4972474,4972475,4972476,4972477,10466250,10466372,10468515,10468531,10470728,10470731,10462741,10468784,10466860,10628272,10628314,10628642,10629731,10627785,10627803,10627812,10627818,10627845,10627853,10627860,10627907,10627908,10627917,10626124,10626320,10626321,10626322,10626323,10626339,10626826,10568646,10568647,10568648,10568677,10568679,10568901,10568952,10567654,10567655,10567656,10567677,10520755,10520756,10420286,10420424,10421075,10473221,10473459,10473462,10473467,10472829,10472854,10472855) 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'