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(10447831,11014781,8838792,8631033,10448294,7068428,10870809,4970901,4970943,4970979,10976488,10976489,10976490,10976491,10976492,10976493,10976494,8621734,10976602,10846813,7074093,7074110,7074111,10950822,8583667,10871693,8575591,8583900,10871750,8583995,10868996,8632441,8632442,8632443,8632444,8632455,8632456,8632457,8576090,8609756,8619910,8837626,8619976,8620057,10872512,10872534,10872535,10872578,8620167,10872631,8573655,8573691,8573728,8838043,8838044,8838045,8573793,10861100,10861101,10861102,10861103,10861104,8574046,10972717,10972718,10972719,8911127,10972809,10972850,10972851,10986082,10858723,8836017,10999337,7072667,7072708,7072899,7072964,7072965,7073097,8836650,8836668,8619577,8619647,10860108,8837411,8837412,10102175,11048963,10942737,10102246,8617001,7071172,7071205,8617130,8617200,8617363,8617457,8617458,8617537,7071703,8617556,10972435,10972436,4430381,7071775,4430422,7071862,8617699,8617714,8617715,10944451,3925565,10863585,10863586,10969998,3925880,10863800,3925968,10970318,10970319,11035355,11035356,10970387,10941332,3926219,8615684,10970633,10970634,3926387,10970710,10970711,3926477,8909144,7070100,8909172,8909290,8909291,10970932,10970959,10970960,10971085,8626066,10101565,10942082,8909545,10101684,3926991,11048520,10971333,3657272,8834238,3927151,3927152,10942434,10942460,8909923,8906063,10618087,10618103,8906179,7196403,10918701,7156746,10618320,8906352,10918867,7156903,11007374,11007375,11007376,11007377,11007378,10919258,10968601,10968679,10919586,10919587,10919588,10919589,7157738,10919847,10982004,10982005,7197576,7157941,10969102,10969103,10969104,10969105,10969106,10969107,8614322,8614324,10839296,10839317,8907628,8907857,8907858,11018826,10917734,10917735,10917736,10852701,10918027,11006213,11019437,10925488,10990667,10990668,10990669,10990670,10990671,10920695,10920696,10920756,10920757,10920758,10920759,10920877,10920917,10850716,10921083,10921084,8633197,8633206,8576780,8576911,10930778,8577031,8577032,10921411,8633608,10921521,8577239,10921615,10921616,10921699,8577405,8577406,8577407,8577408,10426618,8611273,8611277,8611297,8611463,10427108,6677551,6677552,10611012,8853224,6677638,6677758,6677899,10714367,6678192,9190051,6678291,6678292,6678293,9190089,9190090,8853917,9916341,8854106,8854107,9171349,9203374,9203375,9203376,9195439,9195440,7057644,9203481,9203482,10557339,10557340,9187613,9195631,10119847,10557485,9203675,9203676,9203677,9913904,9195711,10609375,9187713,9203753,9203754,9203755,9195776,9195777,9187796,6676064,9914100,9187898,10563721,10563722,10563723,10563724,10563725,10563726,10563727,10563728,10563729,10563730,10563731,10563732,9203949,9914267,10563975,10563976,10563977,10563978,10563979,10563980,10563981,10563982,9204215,9204216,10564188,10564189,10564190,10564191,10564192,10564193,10564194,10564195,10564196,10564197,10564198,10564199,10564200,10564201,10564202,10564203,9204418,7058695,9204552,9204553,9204585,7058760,7058762,8852487,8863276,8567397,9915185,10613736,7014953,4974181,9193387,9193388,9193612,8849460,9193667,9193668,8849586,9193775,8592995,9193897,9201983,9201984,9194093,9194094,9194095,9194096,9194097,9202098,9194098,10555969,10555970,6674423,9202242,9194335,9202422,10556298,10556299,10556300,10556301,10556302,9202578,9194597,9194598,10556446,10556447,10556448,10556449,6674852,6674880,10556539,9202738,9202739,6675008,9202852,9194857,9194858,9194859,9194860,10556706,10556707,10556708,10556709,10512792,10512830,10512831,10512837,8850902,8850903,8850904,8850905,8850906,9195105,9195106,10556926,9171188,10557054,10557055,10557056,10557057,10557058,10557059,10557060,10557061,9171253,9171285,10124519,10124520,10417264,6680597,9200459,8848333,8848334,6680767,9200608,9176618,9176650,9200717,9200718,9200719,10428100,9200835,9208934,8848815,10417111,10417112,8849034,8849035,9201234,7014948,7014949,7014950,7014951,7014952,9916556,6678638,8854284,6678723,6678810,8854461,6678868,4971591,10463392,10463393,10463394,10463395,10463396,10463397,10463398,10463399,10463400,10463401,10463402,10463403,8854774,8854835,8854997,6679431,8847371,6679772,8847529,6679943,6679944,6680075,8847719,8847720,976679,10470484,9200011,6680233,6680234,6680235,6680236,6680237,10124406,8848087,8848088,10164516,10164517,10164518,10164519,10164520,10164521,10628015,10628037,10883644,10174702,10174703,10913694,10913695,10164783,10883790,10174820,10913999,10914000,10914001,10909002,10909003,10884037,10165058,10909094,10180130,10180131,10165205,10909231,10165348,10909351,10909352,10909353,10909354,10909355,10894360,10909403,10909404,10909405,10894435,10894436,10904460,10914461,10904461,10904462,10909506,10909507,10909508,10909509,10884529,10180543,10180544,10894556,10170625,10909621,10909622,10165691,10165692,10904700,10909724,10909725,10909726,10909727,10909728,10899729,10909729,10899730,10894734,10909791,10909792,10165858,10909867,10165890,10165891,10180929,10180930,10914941,10914942,10629534,10181214,10900223,10900224,10900225,10629722,10629723,10629724,10890275,10629794,10629824,10181475,10181476,10181477,10181478,10183532,10183609,10183610,10912928,10912929,10913167,10888179,10174378,10179472,10179473,10166588,10905725,10890818,10182034,10182035,10182036,10167048,10182203,10906211,10182365,10182366,10906456,10906457,10182471,10162553,10182607,10182608,10182609,10187712,10906767,10182798,10182799,10172859,10182945,10177982,10177983,10177984,10182985,10177985,10177986,10177987,10897046,10183072,10183137,10887227,10183248,10897240,10183317,10887311,10183419,10649235,10577213,10577214,10577215,10602117,10571297,10571298,10649387,10571419,10571420,10571421,10571422,10571423,10571424,10571425,10568640,10568641,10602547,10602548,10574760,10574820,10571827,10571828,10571829,10571830,10577863,10577864,10577865,10577866,10577867,10577868,10577869,10577870,10577871,10577872,10577873,10577874,10577875,10574899,10568899,10568900,10653011,10653012,10653013,10653014,10653044,10653218,10575167,10575168,10653235,10578341,10578450,10578521,10566534,10566535,10569544,10575552,10575553,10578766,10578870,10578871,10578872,10578873,10578874,10578875,10578928,10578929,10570104,10570105,10570106,10570107,10579382,10651521,10651522,10582541,10582545,10579556,10579557,10579558,10570561,10570562,10570563,10570564,10573692,10573693,10573694,10573695,10573696,10573697,10576704,10576705,10576706,10576707,10576708,10576709,10576710,10576711,10601846,10571084,10577106,10577107,10652170,10553178,10553179,10553180,10553181,10553182,10553183,10553184,10553185,10553186,10553187,10553188,10553189,10553190,10525391,10535395,10535396,10539579,10551581,10551582,10527796,10553870,10553871,10553872,10553873,10553874,10553875,10553876,10553877,10535980,10535981,10535982,10535983,10524139,10554259,10552430,10552431,10552432,10552433,10552434,10552435,10552436,10552437,10552438,10552439,10552440,10552441,10552442,10552443,10552444,10552445,10552446,10552447,10552448,10552449,10552450,10552451,10552452,10552453,10552454,10552455,10552456,10552457,10552458,10552459,10552460,10552461,10552462,10534637,10536661,10554717,10554718,10554719,10554720,10554721,10554722,10554723,10554724,10554725,10554726,10554727,10554728,10554729,10554730,10554731,10554732,10554733,10554734,10554735,10528793,10540793,10528797,10540844,10540860,10534895,10534896,10534897,10534898,10534899,10534900,10534901,10550929,10550930,10550931,10550932,10550933,10550934,10551081,10509275,10480886,10480887,10480888,10493889,10413265,10487925,10478930,10478931,10480993,10481002,10494007,10488007,10494008,10488078,10494127,8562545,8562546,10494239,10494298,10494317,10494335,10494336,10407971,10496937,10481965,10481966,10496984,10478013,10497040,10478067,10478068,10478118,10478119,10493410,10495449,10495525,10495545,10495554,10493734,10415104,10415105,10415106,10415107,10415108,10415109,10415110,10482780) 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'