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(11014642,11014691,11014692,11014713,11014736,11014747,11014748,11014755,11014781,11014782,11014783,8838621,8838650,11014898,11014951,11014952,11014953,11014954,11014955,11014956,11014957,11014958,8574500,11015011,11015012,11015013,11015020,11015084,11015085,11015086,11015087,11015088,11015089,11015090,11015133,8569705,7068802,11015508,10940524,10976602,11015631,11015632,11015633,11015634,11015635,11015636,11015637,11015638,11015639,11041658,10950620,11015693,7074010,11016023,11016024,11016025,11016026,11016027,11016028,11016029,11016030,11016031,11016032,11016033,11016034,11016035,11016036,11016037,11016038,11016039,11016040,11016041,11016042,11016043,11016044,11016045,11016046,11016047,11016048,11016049,11016050,11016051,11016052,11016053,11016054,11016055,11016056,11016057,11016058,11016059,11016060,11016061,11016062,11016063,11016064,11016235,11016236,11016237,11016238,8067673,11016435,11016465,11016476,11016513,11016542,11016574,11016575,11016576,11016577,11016578,11016579,11016580,11016581,11016582,11016583,11016584,11016585,11016586,11016587,11016588,11016589,11016590,11016591,11016592,11016593,11016594,11016595,11016596,11016597,11016598,11016599,11016600,11016601,11016602,11016603,11016604,11016605,11016606,11016607,11016608,11016609,11016610,11016611,11016612,11016613,11016614,11016615,11016616,11016617,11016618,8837433,8067909,11013793,11013794,8837625,8837626,8837627,8837628,11013882,11013883,11013884,11013933,11013934,11013935,11013936,11013937,11013938,11013939,11013940,11013941,11013942,11013943,7067316,7067325,7075358,11040118,11040176,11014187,8068402,8068404,11014219,11014220,11014221,11014222,11014223,11014224,11027338,11014422,11014423,11014463,11014517,11014520,11014527,11014530,11014534,11014570,8910995,8910996,8910997,8910998,8911011,8911014,10985701,8065073,10985827,10985835,11038111,11038115,7072808,10932366,7073111,7073174,8066192,8066205,8066361,8066427,11000242,8837095,8837096,8837097,11039301,8837121,8837122,8837154,8837155,8066643,8837156,11039447,8837337,8837353,8837354,8837355,8837356,8837357,8066873,8837408,8837409,8837410,8837411,8837412,11023668,10997691,10997702,11049315,10959244,10943234,10943244,8910795,8910796,8910797,11011438,11011439,11011441,11011443,11011444,11011445,8910876,8910877,8910878,8910879,8910959,8910961,11034700,11034701,10970009,11009190,8564419,8564805,3656989,3656990,3656991,3656992,3656994,11036226,11036229,11036231,11036233,7070930,11019676,11019687,11019708,11019751,11019809,11019810,10918702,8906376,11007198,10994446,10619220,10619221,10619222,10969202,11008563,10917487,10917488,11018690,11018691,11018692,11018693,11018694,11018695,11018731,11018733,11005757,10927631,10622127,11018820,11018821,11018822,11018823,11018824,11018825,11018826,11018827,11018828,11018829,10917710,10917711,10917712,10917734,10917735,10917736,10917905,10917906,10917907,10917908,10917909,10622399,10917910,10917911,10917912,10917913,10917914,10917915,10917916,10917917,10917918,10917919,10917920,10917921,10917922,10917923,10917924,10917925,10917926,10917927,10917928,10917929,10917930,10917931,10917932,10917933,10917934,11019389,11019402,11019403,11019404,11019437,11019438,11019609,11016643,10990667,10990668,10990669,10990670,10990671,11016712,11016713,11016714,10915699,10915700,10915701,10915702,10915703,10915704,10915705,10915706,10915707,10915708,10915709,10915710,10915732,10915733,11016902,11016946,11016966,11016967,10915833,10915834,11016998,10915894,10921093,10991249,10991250,10991251,10991252,10991253,10991254,10991255,10991256,10991257,10930751,11043531,10926412,10926413,10926414,10926415,10926416,11043668,11043669,11017789,11004806,11030968,10616326,10621455,11044141,11044142,11044143,11044144,11044145,11044146,11044147,11044148,10616494,10616495,10616512,10917032,10917033,10917034,10917069,10917070,10917071,10917072,10917073,10917074,10917075,10917076,10917077,11018234,10917150,10917151,10922317,11044485,11044486,11044487,10922343,10917425,11018609,11018610,11018611,11018612,7059582,7059655,9205495,7059705,10614435,10611461,10565614,10565615,10565616,10611467,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10611486,10611492,10611493,10611500,10611501,10611515,9190271,10611941,9187551,10564433,10564442,10564443,10613574,9196950,10610731,7059284,9205208,9165275,4974152,4974181,4974182,9185366,4974229,4974265,4974303,4974304,4974305,4974306,4974307,4974308,4974309,4974310,4974317,9201522,9201523,9201524,9201525,9201526,9201527,9201528,7055724,9201560,9201561,9201590,9201591,9201815,9201816,9201824,9201825,9201826,2809374,2809401,10415226,10416280,10415298,9200433,9200458,9200459,9200460,10417390,10415456,9200599,9200600,9200604,9200608,10415552,9200695,9200696,9200716,9200717,9200718,9200719,10419703,9200810,9200811,9200812,9200822,9200835,10417767,9200894,10419828,9200916,10415872,9200967,9200981,10418907,10418908,10418909,10418910,9200992,10415935,10415941,10415942,10417000,9201153,9201187,10416135,10419139,10419140,9201226,9201227,9201228,9201229,9201230,9201231,9201232,9201233,9201234,9201259,4974151,9190440,9166835,9183008,10463736,10463753,10463764,10463767,10463770,10463790,10463792,10463793,9191251,9191252,9191253,9191254,9191255,10463833,9175499,8917239,8917240,9168062,10179486,10179487,10184530,10174591,10179645,10179646,10628149,10179679,10179739,10179740,10179750,10159779,10154787,10179790,10179791,10179792,10179793,10179805,10179806,10179807,10179808,10179809,10179826,10169886,10165564,10170615,10629519,10168488,10178717,10178764,10178852,10178882,10184172,10179176,10184257,10179317,10159381,10179419,10179420,10179421,10179468,10179471,10179472,10179473,10159478,10169483,10181500,10166703,10625450,10182209,10177314,10177346,10177416,10177433,10177437,10177438,10177440,10177465,10177507,10162526,10162527,10162528,10162529,10162530,10162531,10162532,10177570,10177579,10177614,10177615,10177616,10177617,10177618,10177619,10177620,10177621,10177622,10177623,10177624,10177625,10177626,10177627,10177628,10177629,10177630,10177631,10177632,10177633,10177634,10177635,10177636,10177637,10177638,10177639,10177658,10177676,10177702,10177720,10177721,10177722,10177723,10177746,10177785,10177793,10631309,10177875,10162918,10162926,10177966,10177967,10177968,10177969,10177970,10177971,10177972,10177973,10177974,10177975,10177976,10177977,10177978,10177979,10177980,10177981,10177982,10177983,10177984,10177985,10177986,10177987,10177988,10177989,10177990,10177991,10177992,10177993,10626471,10177994,10177995,10182997,10178031,10178135,10178137,10168151,10178197,10178235,10178314,10168350,10158376,10158383,10571383,10571384,10571385,10571386,10571387,10571415,10571416,10571417,10571418,10571419,10571420,10571421,10571422,10571423,10571424,10571425,10571426,10574451,10574469,10574589,10574590,10574591,10574592,10574616,10574617,10574618,10574619,10574620,10574621,10574622,10574623,10574624,10574625,10574626,10571651,10571660,10571697,10571729,10571730,10571731,10571732,10571733,10571734,10571735,10571736,10571737,10571738,10586745,10586746,10571752,10571816,10571817,10571818,10571819,10571820,10571821,10571822,10571823,10571824,10571825,10571826,10571827,10571828,10571829,10571830,10571831,10571832,10571833,10571834,10589972,10572266,10572267,10572268,10572269,10572270,10572271,10572272,10572273,10572305,10572306,10572362,10572363,10572460,10572461,10572462,10572463,10572464,10572465,10572537,10572555,10572556,10572557,10572600,10572601,10572602,10587603,10572603,10572604,10587604,10587605,10572605,10587606,10572606,10587607,10572607,10572608,10572609,10572610,10572611,10572612,10572613,10572617,10572618,10572619,10572620,10573003,10573004,10573005,10573006,10573007,10573008,10573009,10573010,10573011,10573012,10588072,10588073,10588074,10588075,10588076,10588077,10588078,10588079,10588080,10588081,10588082,10588083,10588084,10588085,10588086,10588087,10573216,10573217,10573250,10573251,10588383,10588384,10588385,10585400,10585401,10573497,10573498,10573499,10573500,10573501,10573502,10573503,10573504,10573505,10573506,10573507,10573535,10573536,10573537,10573538,10573539,10573540,10573541,10573542,10573543,10573544,10573545,10573546,10573547,10573548,10573549,10573686,10573687,10573688,10573689,10573690,10573691,10573692,10573693,10573694,10573695,10573696,10573697,10573698,10573699,10573700,10573701,10525391,10527758,10530092,10530094,10530107,10530108,10528242,10528564,10528565,10528566,10522839,10524904,10525007,10525008,10420274,10420276,10422635,10420839,10424907,10423985,10423164,10423167,10482997,10481006,10483018,10477021,10473037,10477039,10473041,10481224,10479253,10479254,10479255,10479256,10479257,10479258,10477476,10477538,10484783,10473915,10481993,10480208,10480209,10480210,10480211,10480212,10480213,10480214,10480215,10480216,10480217,10480218,10474266,10474269,10472347,10476663,10476673,10487737) 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'