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(8569512,8569513,8569514,8569515,10944014,10944015,10944016,10944017,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,10963417,10963418,10963419,10963420,10963421,10963422,10963423,4971144,8067307,8067342,8067361,10437314,10437316,10437321,10437329,10437330,10437381,10437398,8067556,10990326,10990327,10990328,10990329,8067696,8067697,8067698,8067699,8067700,8067701,8067702,8067703,8067704,8067705,8067706,8067707,8067708,8067709,8067710,8067711,8067712,8067713,8067714,8067715,8067716,8067717,8067718,10437739,7074896,7074897,10990592,10990593,10990594,7066959,7066960,7067199,7067200,10961914,10961915,7067551,7067882,8068799,8068801,8068803,8068804,8068805,8068806,8065120,8065121,10931515,10931516,10931517,10931518,7072389,7072392,7072401,7072402,7072408,7072409,7072410,7072411,7072412,7072413,7072414,7072415,7072416,7072418,7072419,7072420,7072422,7072423,7072424,7072425,7072427,7072428,7072431,7072434,7072435,7072436,7072437,7072483,7072490,8075302,10931917,10986259,10986260,10986261,10931925,10986264,10931928,10931929,10931941,10931950,10931951,10931996,10931998,10931999,10932005,10932007,10932039,10932052,10986492,10986493,10986494,10986495,10932254,10932257,10932263,10932605,10932623,10932626,7065282,10932642,10932646,10932649,10932664,10932667,10932686,10932693,10932694,7065351,7065352,7065353,7065354,7065355,7065356,7065357,7065358,7065359,7065360,7065450,10932839,10932844,10932846,10932850,10932851,10932855,10932856,10932857,10932858,10932859,10932865,10932866,7073588,10932948,10933002,10933005,10933006,10933007,10933008,10933028,10961381,10961454,11049018,11049022,11049023,11049024,11049025,7071129,7071398,7071399,7071403,7071427,10943084,10943085,10943086,10943087,10943088,10943089,10943090,10943091,10943092,10943093,10943094,10943095,10943096,10943097,10943098,10943099,10943100,10943101,10943102,10943103,10943104,11049407,11049408,10985250,10985251,10985252,10985253,10985308,10985309,10985310,10985312,10985316,10985317,10985323,10972399,10972403,7071827,7069057,10944638,10944656,10944661,10944667,10944672,10944676,10944683,10944684,10944685,10944688,10944691,10944692,10944693,10944706,10944707,10944708,10944711,10944712,7069303,7069304,7069305,10944754,10944944,8072311,8072758,8072759,8072760,8072761,8072762,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,3656683,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8072873,8072874,8072875,8072876,8072877,8072878,8072879,8072880,8072891,8072892,8072893,8072894,8072895,8072896,8072909,8072910,8072911,8072912,8072913,8072914,8072915,8072916,8072925,8072926,8072927,8072928,8072929,8072930,8072931,10941821,10941829,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,10941862,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,3656828,8073029,10941920,10941921,10958011,10941963,10941980,8073097,10942118,7070646,11048643,10958452,10958453,10958454,10958455,10958456,10958457,10958458,10958459,10942402,8073541,10967921,10967957,10967958,10967959,10967960,10967961,10967962,10967963,10967964,10967965,10967966,10967967,10967968,10967969,10967970,10967971,10967972,10967973,10967974,10967975,10967976,10967977,10618955,8070865,8070949,8070957,8070967,8070970,8070972,8070975,8070980,8070983,8070993,8071014,8071150,8071206,8071214,8071218,8071221,8071225,8071229,8071233,8071237,8071241,8071245,8071252,8071255,8071315,8071316,8071330,8071346,8071358,10925177,10925178,10925179,10925180,10925181,10925182,10925183,10925184,10925185,10925186,10925187,10925188,10925189,10925190,10925191,10925192,10925193,10925194,10925195,10925196,10925197,10925198,10925199,10925200,10925201,10925202,10925203,10925204,10925205,10925206,10925207,10925208,10925209,10925210,10925211,10925212,10925213,10925214,10925215,10925216,10925217,10925218,10925219,10925220,10925221,10925222,10925223,10925224,10925225,10925226,10925227,10925228,10925229,10925230,10925231,10925232,10925233,10925234,10925235,10925236,10925237,10925238,10925239,10925240,10925241,10925242,10925243,10925244,10925245,10925246,10925247,10925248,10925249,10925250,10925251,10925252,10925253,10925254,10925255,10925256,10925257,10925258,10925259,10925260,10925261,10925262,10925263,10925264,10925265,10925266,10925267,10925268,10925269,10925270,10925271,10925272,10925273,10925274,10925275,10925276,10925277,10925278,10925279,10925280,10925281,10925282,10925283,10925284,10925285,10925286,10925287,10925288,10925289,10925290,10925291,10925292,10925293,10925294,10925295,10925296,10925297,10925298,10925299,10925300,10925301,10925302,10925303,10925304,10925305,10925306,10925307,10925308,10925309,10925310,10925311,10925312,10925313,10925314,10925315,10925316,10925317,10925318,10925319,10925320,10925321,10925322,10925323,10925324,10925325,10925326,10925327,10925328,10925329,10925330,10925331,10925332,10925333,10925334,10925335,10925336,10925337,10925338,10925339,10925340,10925341,10925342,10925343,10925344,10925345,10925346,10925347,10925348,10925349,10925350,10925351,10925352,10925353,10925354,10925355,10925356,10925357,10925358,10925359,10925360,10925361,10925362,10925363,10925364,10925365,10925366,10953634,10953635,10953636,10922528,10967029,10967030,10923083,10928172,10614975,8570384,8570385,10615676,10615683,10615841,10930892,10926922,10616548,10922311,10922312,10922313,10922318,10922319,10922320,10922321,10922361,8864225,8864271,8864287,8864343,10614502,8864414,8864447,8864476,6665957,6665958,6665959,6665960,6665961,6665962,6665963,6665964,10559794,10559795,10559796,10559797,10559798,10559799,10559801,10559802,10559803,10559804,10559805,10559889,10559890,10559892,10559893,10559980,10559981,10559982,10559983,10559984,10559985,10559986,10559987,10559988,10559989,10559990,10559991,10559992,10559993,10560005,10560006,10560007,7057482,10611988,10563182,10563183,10563192,10563193,10563194,10563215,10560253,10560254,10560255,10560256,10560257,10560261,10560364,10560365,10612229,10612230,10560401,10560402,10560403,10560404,10560405,10560406,10560407,10560408,10560409,10560410,10560411,10560412,10560413,10560414,10560415,10560416,10560417,7057886,7057890,8862691,10613077,10613177,10613178,10613197,10564474,10564475,10564476,10564477,10564478,10564479,10564480,10564481,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564519,10564520,10564521,10564522,10564537,10564538,10564555,10564618,10564619,10564620,10564621,10564650,10564651,10564652,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10564796,10564797,10564798,10564799,10564800,10564801,10564802,10610791,4974825,4974826,4974827,4974828,4974829,4974830,7056753,10514465,10416300,8918059,4973351,4973359,10418434,4973421,4973477,4973478,4973485,4973486,4973487,4973500,4973501,4973549,4973575,4973951,10419144,8916639,8916640,8916896,8563399,8917446,8917478,8917481,8917651,8917850,10627962,10627091,10627093,10627094,10627095,10632097,10627100,10627101,10627102,10627537,10627550,10627573,10627953,10627959,10631041,10631042,10626461,10631653,10626757,10626758,10626759,10626760,10626767,10626774,10626775,10626777,10626806,10566957,10521446,10521447,10521448,10521449,10521450,10519948,10519949,10519950,10519951,10522621,10522622,10522642,10420649,10422031,10422075,10422130,10473276,10473280,10473289,10473307,10473308,10473309,10473310,10473311,10473317,10473346,10473347,10473355,10473356,10473364,10473365,10473375,10473376,10473377,10473378,10473387,10473398,10473438,10473439,10473440,10473464,10473465,10473478,10473509,10473723,10473724,10473727,10473728,10473737,10473738,10473741,10473742,10473744,10473746,10473750,10473754,10475757,10475758,10473765,10473768,10473771,10473774,10473775,10473779,10473783,10473784,10473785,10473786,10473790,10473794,10473801,10473802,10473807,10473814,10473821,10473823,10473826,10473831,10473832,10473844,10473847,10473849,10473851,10473855,10473862,10473942,10473943,10474020,10474021,10474072,10474109,10474117,10474120,10474121,10474122,10474124,10472663,10472664,10472665,10472667,10472668,10472669,10472670,10472692,10472693,10472694,10472713,10472714,10472715,10472716,10472731,10472732,10472733,10472748,10472750,10472777,10472778,10472779,10472783,10472784,10472785,10472788,10472789,10472792,10472793,10472795,10472796,10472797,10472798,10472799,10472801,10472802,10472803,10472810,10472811,10472812,10472817,10472818,10472819,10472833,10472837,10472838,10472845,10472846) 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'