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,7068139,7068166,7068177,7068178,7068228,7068243,7068245,7068253,7076275,7068285,7068286,7076287,7068287,7068295,7068296,7076311,7076324,7076325,10939955,7068368,7068372,7068373,10940005,10940150,10940151,10940152,10940153,7068618,7068619,7068632,7068633,7068650,7068654,7068658,7068665,4970900,10940331,7068713,10940336,10940337,4970940,7068725,7068734,7068739,7068757,8569734,4970978,4970982,4970983,4970984,4970992,4970993,10940404,7068790,7068806,7068827,10976514,7068833,7068834,7068874,10976569,8569869,7068898,7068927,8066940,7065983,10976749,10976750,10976751,10976752,10976754,7074107,10976793,10976794,10976795,10976796,10976797,10976798,10976799,10976800,10976801,10976802,10976803,10976804,7074300,10976985,10976986,10976987,10976988,10976989,10976990,10976991,10976992,10976993,10976994,10976995,10976996,10976997,10976998,10976999,10977000,10977001,10977002,8067519,7066649,7066650,7066651,7066652,7066653,7066654,7066655,7066656,7066657,7066658,8067666,8067697,8067698,8067719,7074744,10437607,8067749,7074822,7074877,7074980,7067084,10961956,10961959,10962020,7075388,7075467,10962163,10962164,7067748,10939386,10939409,10939427,7067918,10972691,10972700,7072129,10972839,10972940,10931614,7072301,7072307,7072335,7072338,7072339,7072340,7072343,7072384,7072435,10973159,7072531,7072595,7072702,7072754,7072794,7072885,7072886,10960653,10960654,10960655,10960656,10960657,7072997,7072998,7073009,7073010,7073047,7073063,7073096,7073106,7073142,8066166,8066197,8066202,8066206,8066214,10961017,7065339,10932774,8066458,8066607,8066608,8066609,7073636,8066715,7070943,7070961,7070962,7070963,7070964,7070965,7070994,7070996,7070999,7071004,7071016,7071020,7071022,7071027,7071034,7071049,7071050,10942791,10942810,11049104,11049118,7071239,10942909,10942914,10942915,10942917,10942937,10942941,10942943,10942991,10943036,10972104,10943084,10943107,10943110,10972174,10943126,10959188,10959189,10943157,10943179,7071565,7071600,7071606,7071608,7071618,7071619,7071620,7071621,7071622,7071623,7071624,11049537,7071640,7071641,7071642,7071643,10943321,10943322,10943326,10972428,10972429,10972430,10972431,7071750,7071765,7071766,10943392,10943411,7071864,10959569,7068974,7068975,7068976,3655586,10969707,10969732,10969770,10940710,10940758,10940759,10940760,10940761,10940769,10940833,10940834,10969918,10969919,10969920,10969921,10969922,10969965,10969966,10969967,7069283,7069373,7069374,7069375,7069376,7069379,7069380,7069383,7069386,7069388,7069410,7069415,7069421,7069483,7069485,10970233,10970234,10970235,10970236,10970237,10970291,10970292,10970293,3656220,3656221,3656222,10970369,7069693,10941342,10941343,10941344,10941347,10970497,10970523,10970524,3656451,10970582,10970624,10970656,10970657,10941690,10941691,10941692,10941693,7070071,10941694,10941695,7070073,10941696,10941697,10941698,10941699,7070077,10941700,10941701,10941702,10941703,10941704,10941705,7070088,7070090,7070094,7070096,7070097,7070098,7070102,7070103,3656680,3656701,3656705,3656729,3656730,3656731,3656732,3656733,10941804,10970884,10970885,10970886,10941851,10941901,10941906,10941943,10941944,10941994,10942001,10942010,10942032,7070459,11048411,11048412,10942327,7070734,8073495,11048664,11048669,8073505,8073514,8073517,8073521,7070822,7070824,7070857,10928595,10618096,10618097,10928609,10618100,10928620,10928631,10923651,10923652,10923723,10923724,10923725,10923726,10923727,10923728,10923729,10923730,10918731,10918732,10618229,10623305,10623309,10923822,10923823,10923824,10923875,10923876,10923877,10923878,10923879,10923959,10923960,10923961,10923962,10923963,10923964,10923965,10923966,10623501,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,10616967,10616968,10616969,10621982,10617008,10617014,10927556,10927557,10927558,10927560,10622072,10622073,10622113,10622114,10617125,10622128,10622129,10622130,10922668,10617189,10617190,10617191,10617192,10922862,10922927,10923028,10918133,10918134,10923146,10923196,10918296,10918297,10918298,10918299,10918300,10918301,10918302,10928320,10622886,10622887,10620084,10615321,10615322,8570281,10925855,10925856,10920861,10920862,10925865,10620373,10620374,10615374,10615375,10615376,10615378,10620401,10920914,8570399,8570406,10926007,8570518,10620663,10921204,10921205,10926277,10926278,10926279,10930725,10926305,10926306,10930728,10930753,10930760,10921346,10921399,10921400,10921401,10615924,10616006,10921525,10921538,10921539,10921584,10921585,10921587,10921588,10621110,10621111,10621112,10621115,10921637,10952788,10926697,10926703,10926704,10621281,10926825,10922109,10922110,10922111,10953442,10616857,10565150,10614060,10614068,10611069,10611070,10611071,10611072,10611073,10611074,10611077,10611078,10611138,10611139,10611179,10559332,10559333,10559360,8864216,8864217,10611358,10614384,10611432,10611433,10611434,10611435,10611436,10611437,10611438,10611439,10611440,10611441,10611442,10611443,10611444,10611445,10611446,10611447,10614662,10611803,10611806,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611895,10611902,10611903,10611904,10611942,8861980,8861981,10612179,10612188,10609326,10557507,10612597,8862567,10557865,10612741,10557972,10612942,10609946,10609947,10609948,10609949,10609950,10612997,10612999,10613003,10613005,10613009,10613010,10613016,10610024,10610071,8863078,8863126,10613297,8863161,10610349,10610350,10610484,10610493,10558683,8863469,8863470,10613700,8863574,10610724,10610768,10613785,10613786,8863729,8863809,10515171,10515173,10515174,10515175,10517242,10517244,10517245,10517246,4974396,10555366,10555367,10555368,10555369,10555370,10555371,10555372,4974413,10555373,10555374,10555375,10555376,10555377,10555378,10555379,10555380,10513486,10513487,10513488,10513489,10513490,10513491,10513492,10513493,10513494,10513495,10513496,10513497,10513528,10513529,4974646,4974811,4974818,4974823,4974834,4974835,4974836,4974837,10555811,4974859,4975174,10556242,10556243,10556244,10556245,10556246,10556247,10556248,10556249,10556250,10556251,10556252,10556253,10556254,10556255,10556256,10556257,10556258,10556259,10556260,10556424,10556425,10556426,10556427,10556428,10556429,10556430,10556431,10556503,10556504,10556505,10556506,10556507,10556508,10556509,10556510,10556511,10556512,10556513,10556514,10556515,10556516,10556517,10556518,10556519,10556520,10512552,10512553,10512554,10512555,10512556,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,10514794,10512816,10512834,10512835,10512836,10512839,10512840,10512841,10556906,10556907,10556908,10556909,10556910,10556911,10556912,10556913,10556914,10556915,10556916,10512963,10516988,10557018,4973195,10416345,10416346,10415409,10415410,4973705,4973706,4973707,4973708,4973710,4973711,10417813,10417814,10417831,10417832,4973768,10417850,10417867,10417868,10417884,10417885,10417902,10417903,10417099,10418147,10418148,10418149,10418150,10471190,10471191,10471192,10471214,10471217,10471219,10471220,10471221,10471222,4971504,10471230,10471231,4971541,4971542,4971543,4971544,10467338,10471484,10471485,10471486,10471501,4971948,4971963,4971964,4971968,4971969,4971970,4971981,4971982,4971997,4972014,4972015,4972021,4972023,4972029,4972115,4972116,10467895,10467918,10467937,10467945,10467955,4972253,10468114,4972442,4972457,4972458,4972459,4972460,4972461,4972462,4972463,4972464,4972465,4972466,4972474,4972475,4972476,4972477,4972478,4972479,4972488,4972489,10470371,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,10628012,10628013,10628096,10628110,10628111,10628119,10628120,10628271,10629691,10629715,10629716,10629717,10629718,10629828,10629829,10629852,10629853,10629854,10629906,10629907,10627015,10627694,10627714,10626329,10568594,10568595,10568895,10566134,10520815,10520816,10520817,10420704,10421070,10421072,10421075,10421126,10421200) 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'