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(4970762,4970763,4970764,4970765,8583435,8583436,7066242,7066243,7066244,10863065,10863100,10866615,8595048,8595049,8595050,8595051,8595052,8595053,8595054,8595255,8595256,8595257,8595284,8595285,5654568,5654569,5654570,5654673,7202656,7200284,7200285,7200286,7200287,7200288,7200289,7200290,7200291,7200292,7200293,7200294,7200295,7200296,7200297,7200298,7200299,7200300,10865774,10865775,10865776,10865777,10865778,10865779,10865780,10865781,10865782,10865783,10865784,10865785,10865786,10865787,10865788,10865789,10863248,10863249,7199396,7199397,7199545,10101462,10101463,10101464,10101465,10101466,10865050,10865051,10865052,10865053,10865054,10865055,10865056,10865057,10865058,10865059,10865060,10865061,10865062,10865063,10865064,10865065,10865066,10865067,10865068,10865069,10865070,10865071,10865072,10865073,10865074,10865075,10865076,10865077,10865078,10865079,10865080,10865081,10865082,10865083,10865084,10865085,10865086,10865087,10865088,10865089,10865090,10865091,10865092,10865093,10865094,10865095,10865096,10865097,10865098,10865099,10865100,10865101,10865102,10865103,10865104,10865105,10865106,10865107,10865108,10865109,10865110,10865111,10865112,10865113,10865114,10865115,10865116,10865117,10865118,10865119,10865120,10865121,10865122,10865123,10865124,10865125,10865126,10865127,10865128,10865129,10865130,10865131,10865132,10865133,10865134,10865135,10865136,10865137,10865138,7196971,8906783,7197261,7197262,7197263,7197264,7197265,7197266,7197267,7197268,7197269,7197270,7197271,7197272,7197273,7197274,7197275,7197276,7197277,7197278,7197279,7197280,7197281,10854929,10854930,10854931,10854932,10854933,10854934,10854935,10854936,10854937,10854938,10854939,10854940,10854941,10854942,10854943,10854944,10854945,10854946,10854947,10854948,10854949,10854950,10854951,10854952,10854953,10854954,10854955,10854956,10854957,10854958,10854959,10854960,10854961,10854962,10854963,10854964,10854965,10854966,10854967,10854968,10854969,10854970,10854971,10854972,10854973,10854974,10854975,10854976,10854977,10854978,10854979,10854980,10854981,10854982,10854983,10854984,10854985,10854986,10854987,10854988,10854989,10854990,10854991,10854992,10854993,10854994,10854995,10854996,10854997,8905004,8905005,8905006,8905007,8905008,8905009,10615933,10615934,10615935,10615936,10615937,10615938,10615939,10615940,10426444,8540607,8540608,8611291,10616694,10616695,10616696,10616697,10616698,10616699,10616700,10616701,10616702,10616703,10616704,10616705,10616706,10616707,10616708,10616709,10616710,10616711,10616712,10616713,10616714,10616715,10616716,10616717,10616718,10616719,10616720,10616721,10616722,10616723,10616724,10616725,10616726,10616727,10616728,10616729,10616730,10616731,10616732,10616733,10616734,10616735,10616736,10616737,10616738,10616739,7059524,10714186,10612135,10612136,10612137,8566725,10609954,10609955,10609956,10609957,10609958,10609959,10609960,10609961,10609962,10609963,10609964,8852697,8852698,8852699,10613719,10613720,10117509,10117510,10117511,10117512,10117513,10117514,10117681,7055655,7055656,9911829,9911830,9911831,9911832,9911833,9911834,9911835,9911836,9911837,9911838,9911839,9911840,9911841,9911842,9169669,9169670,9169799,9169800,9169801,9169802,9169803,9169804,9169805,9169806,9912207,6674264,6674265,6674266,8850111,10118518,10118569,10118570,10118571,10118572,10118573,10118574,10118575,10118576,10118577,10118578,8552223,8552224,9913186,9913234,9913235,9913236,9913237,9913238,9913239,9913240,9913241,9913242,9913243,9913244,9913245,9913246,10427678,10427679,6672606,6672607,6672608,9168405,10418337,10418338,10418339,10418340,10418341,10418342,10418343,10418344,10418345,10418346,10418347,10418348,10418349,10418350,10418351,10418352,10418353,10418354,10418355,10418356,10418357,10418358,10418359,10418360,10418361,10418362,10418363,10418364,10418365,10418366,10418367,10418368,10418369,10418370,10418371,10418372,10418373,10418374,10418375,10418376,10418377,10418378,10418379,10418380,10418381,10418382,10418383,10418384,10418385,10418386,10418387,10418388,10418389,10418390,10418391,10418392,10418393,10418394,10418395,10418396,10418397,10418398,10418399,10418400,10418401,10418402,9168481,10418403,10418404,10418405,10418406,10418407,10418408,10418409,10418410,10418411,10418412,10418413,10418414,10418415,10418416,10418417,10418418,10418419,10418420,10418421,10418422,10418423,10418424,10418425,10418426,10418427,10418428,10418429,10418430,10418431,10418432,10418433,10418434,10418435,10418436,10418437,10418438,10418439,10418440,10418441,10418442,10418443,10418444,10418445,10418446,10418447,10418448,10418449,10418450,10418451,10419496,10416618,10416649,10416779,10416781,9168964,10418987,10418988,10418989,10418990,10418991,10418992,10418993,10418994,10418995,10471078,10471079,10471080,10471081,10471082,10471083,10471084,8549949,8549950,8549951,8549952,8550015,10467627,10467628,10467629,10467630,8550211,8550212,8550232,8550233,8550234,8550235,8550236,8550237,8550238,976434,976527,976547,9167852,9167853,9167854,9167855,10888967,10888968,10888969,10888970,10888971,10888972,10888973,10888974,10888975,10888976,10888977,10888978,10888979,10889572,10889573,10889574,10889575,10889576,10889577,10889578,10889579,10889580,10889581,10889582,10889583,10889584,10889585,10889586,10889587,10889588,10889589,10889590,10889591,10889592,10889593,10889594,10889595,10889596,10889597,10889598,10889599,10889600,10889601,10889602,10889603,10889604,10889605,10889606,10889607,10889608,10889609,10889610,10889611,10889959,10889960,10882999,10883000,10883001,10883002,10883003,10883004,10883005,10883006,10883007,10883008,10883009,10883010,10883011,10883012,10883013,10883014,10883015,10883016,10883017,10883018,10883019,10161830,10161831,10161832,10161833,10885948,10885949,10410180,10410181,10410182,10410183,10410184,10410185,10410186,10410187,10410188,10410189,10410190,10410191,10410192,10410193,10410194,10410195,10410196,10410197,10410198,10410199,10410200,10410201,10410202,10410203,10410204,10410205,10410206,10410207,10714786,10714787) 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'