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(11014764,11001835,11014904,11014905,11014906,8838712,10845996,10845997,11001952,11001953,11001954,11001955,11001991,11001992,8630955,10846063,10846078,10846079,10846080,10846081,11002129,11002130,11002131,10846219,4970749,10846304,10846305,8631277,10989323,11002563,8583442,7074007,11002717,11002718,11015728,11015729,11015730,11015731,11015732,11015733,11015734,11015735,11015736,11015737,11015738,11015739,11015740,11015741,10963742,10963743,10963744,11002882,7074228,11002994,8575522,11003083,11029223,8575758,10990277,10990278,11003280,11029288,11029290,11029291,11029292,11029293,11029294,11029295,11029296,11029297,11029298,11029299,11029300,11029301,11029302,11029303,11003319,11003320,11003446,8067804,8632472,8632473,8632474,8632476,8632479,8632480,8632481,8632482,8632483,8632486,10990560,11003568,8576064,8576080,11013696,8619852,11026719,11026728,11026729,11026730,10961730,11026731,11026732,11026733,11026734,11026735,11026736,11026737,11026738,11026739,11026740,11026741,11026742,11026743,11026744,11026745,11026746,11026747,11026748,11026749,11026750,11026751,11026752,8619903,11026753,11026754,11026755,11026756,11026757,11026758,11026759,11026760,8619953,8619954,8619957,11013851,11013852,11013853,11013854,11013855,11013856,11013857,7067227,8620111,8620112,10929595,8837854,7067398,11040104,11040105,8573602,8573603,8620306,11014175,8837981,8620337,8620339,11040191,8838014,8838015,8838016,8838017,8838018,8838019,11040217,8620412,8838107,11014367,11001405,11001406,11001407,11001408,11001409,11001586,11001587,7072588,10843345,7072746,7072750,7072790,7072884,10843699,8618795,8065981,8065982,8065983,8065984,7073034,7073035,8066014,8066015,8066016,7073104,11012835,11012841,8836653,8836706,8619357,8619462,10961382,10961383,8619553,8619554,8619555,8619556,10961456,10961457,10961458,8619621,11013583,10961608,11023780,8617077,8617115,7200550,7200551,11024005,11024006,8617246,11024122,11024123,11024124,11024125,11024126,11024127,11024128,11024129,11024130,11024131,11024132,11024133,8910506,11024134,11024135,11024136,11024137,11024138,11024139,11024140,11024141,11024142,11024143,11024144,11024145,11024146,11024147,8910533,8617342,8617435,10985312,10985313,8617533,8835232,8835233,8835234,8835235,8835236,8835237,8835238,8835239,8835240,8835241,8835263,8617618,8835282,8835283,8835284,8617706,11034727,8614962,11035006,11035007,11035008,11035009,11035010,11035011,11035043,8615331,7198770,8615372,11035227,11035228,11035229,11035230,11035275,11035276,10840358,11035298,11035306,3656210,3656211,3656217,3656260,3656261,3656262,11022420,11022421,11022422,11022423,11022424,11035449,11035450,11035451,11035452,8615669,8615730,11035698,8909089,11022743,8909215,8909216,8909217,8909218,11022853,11022854,11022855,11022856,11022857,11022858,11022859,11022860,11022861,3236731,10997032,10997033,10841109,8909494,10942066,10997165,10997287,10997288,10997289,8909721,8909722,8909723,10997399,10997400,10997401,10997402,8909878,8909879,8909880,7200107,11023588,11023600,10918481,10918482,10618068,10618085,8612894,11032746,10618099,11032759,11032760,8906137,11045764,8906138,8906139,10618115,11032871,11032872,11032873,11032874,11032875,11032876,10918751,10918752,10918753,10918754,10918755,10918756,8906309,8906310,11033267,11033268,11033269,10919191,10919192,10919193,10919194,11033423,11020513,11020514,11020515,11020516,11020517,11020518,11020519,11020520,11020521,10994536,11033579,11033580,11046611,11046612,11046613,10919495,10919496,10919497,10919498,11033686,11033687,11033688,10994755,11046826,11046832,11046866,11033921,11033922,11033923,11033924,11033925,11033926,11033927,10919827,10919828,10619330,10619331,10619332,10619333,11034085,7197705,7197706,10839337,11021424,11021425,11021426,11021427,11021428,11021429,8541448,11018624,11018625,11018626,8541455,11018627,11018628,11018629,11018630,11018631,11005682,10966716,8541606,10836856,10836857,11031924,11031925,10966939,10966940,8541787,11045047,11045048,10917995,10917996,10917997,10928098,10918116,8542146,8542147,8905697,8612502,8612504,11019390,11019392,11019393,11019394,11019395,10918277,10918278,11006487,11006556,10622902,10622914,10622915,10622916,8576115,8576143,10990903,10990904,8570279,10920850,10920851,10620353,10620354,8576543,8576544,8576545,10920957,11004130,10921038,11004256,8576881,10930713,10848513,8576952,10921334,10921335,10921389,10921390,10921391,10615928,10921471,8577126,8577127,10616055,11004717,11004718,8577223,11030737,11030738,10921673,11030827,11030828,11030829,11030830,11030831,11030832,8904219,8577344,8577345,8577346,8540779,8540844,10921875,10921876,10921877,11005128,11005140,11005142,11005143,10922004,11031177,11031178,8577672,8577705,8577706,8577728,11005504,11005505,11005506,11031552,11031553,11031554,11031555,11031557,10917410,11031558,10917411,11031559,11031560,11031561,11031562,11031563,6677539,6677578,6677725,6677798,6677799,10614441,9173856,9173857,6678228,10562901,10562902,10562903,10562904,9190180,10611879,8864759,6678492,9171302,9171319,9171320,9203357,9195366,9195369,9195370,9195371,9203440,9203441,9203442,9203443,9203444,10557296,10557297,10557298,10557299,10557300,10557301,10557302,10557303,10557304,10557305,10557306,10557307,10557308,10557309,9187587,9187588,9187589,9203657,10557502,10557536,10557537,10557538,10557539,9203774,9203775,9203776,9211834,9211835,9195872,9187880,9203978,10609666,10609668,9196023,9204093,10612848,10612931,10612941,9204433,9172499,9172500,9204572,9204651,9196784,9196808,9204819,10613491,10613562,10613646,9205083,10610959,9193367,9169435,10555300,10555301,10555302,10555303,10555304,4974402,9185583,9193598,9193696,9193756,7055930,9193813,9193814,9193857,9193858,9193859,9193860,9193861,7023555,10513726,7056085,7056086,9201965,7056138,7056139,7056140,7056141,7056142,7056143,7056144,9194036,9194037,9194038,9194039,9194040,9194041,9194042,9202110,9202111,9202112,10555944,10555945,10515959,10515960,10515961,10515962,10515963,10515964,9202205,6674413,9194306,9194307,6674624,9202526,9202527,9202528,9202533,9194564,9194565,10512576,9186786,9202819,9203036,9203039,9195066,9195067,9171144,9171187,9195236,9195237,9171248,6675488,6675489,10124496,10419241,9200322,9200380,9200420,10124693,9200595,9200666,9200667,9200668,9200690,9176794,9200816,9208902,9208930,9200933,9208986,9208987,10417089,10417090,10122502,10122507,4971353,4971354,4971355,4971356,10122706,4971380,4971381,10122739,10122793,9190635,10469231,10469263,10471278,10471499,10471500,9198958,10123379,10123380,10123429,10123430,9199271,10115563,10115564,10467964,9175522,9175523,9175628,10124102,9199931,10124134,10124142,8917803,10124495,10893519,10893520,10893521,10893522,10893523,10893524,10893525,10893526,8593537,10893527,8593538,10893528,10893529,10628093,10628094,10893638,10893639,10893640,10893641,10174736,10179800,10174808,10883831,10174852,10883860,10883861,10179875,10883904,10180013,10180024,10180025,10180441,10180442,10180866,10180867,10890006,10629537,10181146,10181147,10181148,10181149,10166157,10166158,10629709,10629710,10629711,10629712,10629713,10629714,10629749,10890276,10890277,10181414,10629898,10629899,10183578,10183579,10632058,10183580,10882618,10163878,10163879,10163880,10163881,10163882,10163883,10163884,10163885,10163886,10163887,10163888,10163889,10163890,10163891,10163892,10163893,10163894,10183903,10888159,7001395,10174374,10179411,10630047,10630101,10630127,10630128,10890793,10890796,10890816,10875851,10890936,10181990,10181991,10167065,10182164,10182332,10182333,10172334,10177432,10177439,10182453,10177529,10177530,10177531,10177532,10182546,10182547,10182548,10162556,10162592,10182759,10182760,10183120,10183230,10183292,10163306,10887297,10887304,10626954,10577192,10577193,10577194,10577195,10577196,10577197,10577356,10577357,10577358,10577359,10577360,10577361,10571371,10571372,10571373,10571374,10571375,10598536,10598537,10598538,10598539,10598540,10568562,10568563,10568564,10568565,10571698,10571699,10571700,10571701,10571702,10571703,10571704,10577811,10574846,10574847,10574848,10574849,10574850,10574851,10574852,10574853,10578043,10575105,10575106,10578239,10578240,10572361,10575381,10575382,10575383,10575384,10575385,10575386,10578424,10647716,10575657,10575658,10575659,10578826,10581913,10575990,10579032,10579033,10576091,10576092,10576093,10576611,10576612,10576613,10648744,10648745,10648746,10576951,10521187,10521188,10521189,10535249,10539673,10527788,10535832,10535833,10535834,10535835,10522100,10536374,10536375,10522515,10522516,10536624,10536625,10540765,10541037,10420688,10423702,10420888,10487907,10493982,10487987,10480990,10494101,10483187,10481190,10481191,10481422,10486577,10486578,10481989,10497208,10497209,10497225,10497226,10497308,10493402,10493689,10493710,10487848) 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'