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(10939562,7075945,8068889,4970900,4970940,7068725,7068734,7068739,7068757,4970978,4970982,4970983,4970984,10940404,7068790,7068806,7068827,7068833,7068834,7068874,10976569,8569869,7068898,7068927,7065983,7074107,7074300,11042041,11042042,11042043,11042044,11042045,11042046,8067519,8067666,8067697,8067698,8067719,7074744,10437607,7074822,7074877,7074980,7075388,7072129,7072301,7072307,7072335,7072338,7072339,7072340,7072343,7072384,7072435,7072595,7072702,7072754,7072794,7072885,7072886,7072997,7072998,7073009,7073010,7073047,7073063,7073096,7073106,7073142,8066197,8066202,8066206,8066214,7065339,10932774,8066458,8066607,8066608,8066609,7073636,8066715,10942791,10942810,11049104,11049118,7071239,10942909,10942914,10942915,10942917,10942937,10942941,10942943,10942991,10943036,10943084,10943107,10943110,7071750,7071765,7071766,7068974,7068975,7068976,3655586,3656220,3656221,3656222,7069693,3656451,10996595,10996596,10996597,10996598,10996599,7070088,3656701,7070459,10942327,8073495,8073505,8073514,8073517,8073521,10618096,10618097,10618100,10923651,10923652,10923723,10923724,10923725,10923726,10923727,10923728,10923729,10923730,10918731,10918732,11006903,10623305,10623309,10923822,10923823,10923824,10923875,10923876,10923877,10923878,10923879,10923959,10923960,10923961,10923962,10923963,10923964,10923965,10923966,10924046,10924047,10924048,10924049,10924050,10924130,10924131,10924132,10924133,10924134,10924135,10924136,10924137,10924224,10924225,10924226,10924227,10924253,10924264,10924265,10924283,10924284,10924292,10924293,10919524,10919525,10919526,10919527,10919528,10924593,10924594,10924595,10924596,10924597,10924598,10924599,10924782,10924783,10919833,10924858,10924983,10924984,10924985,10924986,10924987,10924988,10924989,10924990,10924991,10924992,10925142,10925185,10925367,10925368,10925369,10925370,10925371,10617008,10992671,10922668,10922862,10922927,10923028,10993276,10918133,10918134,10923146,10923196,10918296,10918297,10918298,10918299,10918300,10918301,10918302,10993540,10622886,10622887,8570281,10925855,10925856,10920861,10920862,10925865,10920914,8570399,10921204,10921205,10930753,10930760,10921346,10921399,10921400,10921401,10921525,10921538,10921539,10621110,10621111,10621112,10621115,10921637,10991798,10621281,10979055,10979056,10979057,9189672,10614384,9189833,9189837,10611803,10611806,9171311,9171322,9195358,9195377,9171382,9195421,9195422,9195423,9195424,9195425,9195426,9195427,9195487,9195488,9195531,9195532,9195533,9195534,9195535,9187598,9187599,9195604,9195605,7057809,7057810,10557507,9195702,9195703,9187782,9187783,9195864,9195866,9187976,9196030,9196031,7058203,7058212,7058215,10557865,7058229,7058237,7058279,7058285,7058286,7058287,7058288,7058306,7058382,9196218,9188268,9188273,10613297,7058869,7058887,7058888,7058900,7058910,8863469,8863470,7059153,7059154,7059155,8863574,10610768,10517242,4974396,10555366,10555367,10555368,10555369,10555370,10555371,10555372,10555373,4974413,10555374,10555375,10555376,10555377,10555378,10555379,10555380,9193642,9193700,7055874,7055877,9193764,9193809,9193818,9193819,9193869,4974811,4974818,4974823,4974834,4974835,4974836,4974837,10555811,4974859,9194064,9194065,9194066,9186078,9186079,9194316,9194317,10556242,10556243,10556244,10556245,10556246,10556247,10556248,10556249,10556250,10556251,10556252,10556253,10556254,10556255,10556256,10556257,10556258,10556259,10556260,9194461,9194462,9194463,9194464,10556424,10556425,10556426,10556427,10556428,10556429,10556430,10556431,10556503,10556504,10556505,10556506,10556507,10556508,10556509,10556510,10556511,10556512,10556513,10556514,10556515,10556516,10556517,10556518,9194706,10556519,10556520,9194765,9194766,9194789,9194790,9194816,9194817,9194818,10556646,10556647,10556648,10556649,10556650,10556651,10556652,10556653,10556654,10556655,10556656,10556657,10556658,10556659,10556660,10556661,10556662,10556663,10556664,10556665,10556666,10556667,10556668,10556669,10556670,10512816,10512834,10512835,10512836,10512839,10512840,10512841,9195080,9195081,9195082,9195083,9195084,10556906,10556907,10556908,10556909,10556910,10556911,10556912,10556913,10556914,10556915,10556916,9171146,10516988,10557018,9195250,9195251,9195252,9195253,9187295,9160322,9160361,9168408,9160471,9192527,9192673,9192687,9192718,9192719,9192737,9192738,9192753,9192754,9192755,9192815,9192835,9192851,9192852,9192875,9192898,9192899,9192932,9192933,9192934,9192935,9192936,9193002,9193003,9193016,9193024,9193025,9193035,9193041,9193045,9193080,10417099,9190622,10471484,10471485,10471486,10471501,4971948,4971963,4971964,4971968,4971969,4971970,4971981,4971982,4971997,4972014,4972015,4972021,4972023,4972029,6667210,6667211,4972115,4972116,10467918,6667352,6667353,10467937,10467945,4972253,8917193,8917194,6667789,10470371,8917446,6667800,10462426,10462427,10462428,10462429,10462430,10462431,10462432,10462433,10462434,10462435,10462436,10462437,10462438,10462439,10462440,10462441,10462442,10462443,10462444,10462445,10462446,10462447,10462448,10462449,10462450,10462451,10462452,10462453,10462454,10462455,10462456,10462457,10462458,10462459,10462460,10462461,10462462,10462463,10470585,8917916,10174501,10174502,10174525,10628012,10628013,10628096,10628110,10628111,10628119,10628120,10179653,10179654,10179655,10179656,10179657,10179658,10179659,10179660,10174744,10179811,10179812,10179813,10174898,10179930,10179958,10180062,10180063,10180064,10180065,10180066,10180464,10180465,10181175,10181176,10181177,10629691,10629715,10629716,10629717,10629718,10629828,10629829,10629852,10629853,10629854,10629906,10629907,10168671,10168672,10168678,10153855,10173984,10174008,10169030,10169031,10174036,10627694,10169268,10169269,10169270,10169271,10169272,10169273,10169274,10169275,10174376,10174401,10174460,10174461,10174481,10630346,10630347,10630348,10630349,10161947,10630466,10630483,10630514,10630602,10630603,10630604,10630606,10630607,10630705,10630706,10630707,10630708,10630709,10630825,10630826,10630839,10630840,10630845,10630846,10630886,10630887,10630888,10630889,10630890,10630891,10631000,10631022,10631023,10162547,10167631,10167641,10167648,10167681,10167723,10167724,10167725,10167726,10167727,10167728,10167729,10167801,10167802,10167803,10167868,10167869,10167870,10167882,10167883,10167884,10167885,10167940,10167941,10167980,10167981,10167982,10167983,10167984,10167985,10167986,10168008,10168050,10168064,10168078,10168087,10168094,10168109,10168110,10168144,10168145,10168199,10168200,10168211,10168325,10577201,10577202,10577277,10577278,10577279,10577280,10577281,10577282,10577283,10577284,10577375,10577376,10577377,10568594,10568595,10571653,10580721,10580723,10574723,10577759,10577760,10577761,10577830,10577831,10568895,10578053,10578054,10575124,10575125,10575126,10575127,10575128,10566134,10581143,10581144,10581180,10581181,10581225,10581226,10581227,10581228,10578245,10578246,10572246,10578247,10572247,10578248,10572248,10572249,10572250,10578284,10578285,10578286,10578287,10569287,10578288,10569288,10578289,10569289,10578290,10578291,10578292,10578293,10578294,10578295,10578335,10578378,10578379,10578385,10578386,10578387,10578388,10578389,10578390,10575404,10575405,10575406,10575407,10575408,10575409,10581452,10581453,10581454,10581455,10581456,10581457,10581458,10581459,10581460,10578492,10578497,10578498,10569506,10581518,10581519,10578519,10581520,10581521,10581522,10581523,10575531,10575532,10578538,10578546,10581627,10581628,10581658,10575666,10575667,10581703,10581704,10581726,10581729,10581730,10581731,10581732,10581733,10581734,10581760,10581763,10581781,10581782,10575792,10575793,10575794,10575795,10575796,10575797,10575798,10578815,10578918,10578919,10578920,10581921,10578921,10581922,10578922,10581940,10579060,10579061,10579062,10579063,10579064,10579065,10579066,10579067,10579068,10570089,10576127,10576160,10576191,10576192,10579374,10573511,10573512,10573513,10573514,10573515,10582544,10576652,10576653,10576654,10576655,10576656,10576657,10576658,10576659,10576660,10576661,10576662,10576663,10576664,10576665,10576666,10576667,10576668,10576669,10576956,10576957,10576958,10576959,10576960,10576961,10576962,10577096,10523659,10523676,10523679,10523692,10523693,10523694,10523695,10529705,10527790,10530553,10530560,10530561,10530562,10530724,10530725,10423612,10424032,10421070,10421072,10421075,10421126,10479248,10479249,10479279,10479280,10479281,10479282,10479283,10479284,10479285,10479286,10479347,10479348,10479349,10479350,10479351,10479352,10479353,10479354,10479355,10479356,10479357,10479358,10479444,10479469,10479470,10479471,10479472,10479473,10479474,10479543,10479544,10479556,10479569,10479570,10479571,10479770,10479778,10479779,10479780,10479894,10480159,10480160,10480161,10480453) 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'