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(8630798,8630799,8630801,8630802,8630803,8630804,8630805,8630806,8630807,8630839,8630847,8630848,8630853,8630896,8630897,8574473,8574478,8574480,8574490,8574501,8574502,8631061,8631076,8631077,10861809,8631191,10848915,8631573,8631658,8583488,8583489,8583552,8583553,8583554,8583555,8583556,8631901,8631902,8631903,8631904,8631905,8631906,8631907,8631908,8631909,8631910,8631911,8631912,8631913,8631914,8583746,8631957,8631958,8631959,8631960,8631961,8631962,8631963,8631964,8631965,8631966,8631967,8631968,8631969,8631970,8631971,8632014,8632015,8632016,8632017,8632018,8632019,8632121,8632122,8632123,8632124,3229967,8632234,8632258,8632259,8632308,8632309,8632310,8632311,8632406,8629705,8629707,8629709,8629726,10860426,8629892,8629894,8629896,8629962,8630006,8630007,8630049,8630050,8630051,8630052,8630053,8630054,8630082,8630083,8630084,8630103,8630104,8630105,8630106,8630120,8630126,8630148,8630259,8630322,10866224,8627636,8627637,8627638,8627639,8627641,8627642,8627643,8627644,8627645,8627646,8627647,8627648,8627649,8627650,8627652,8627653,8627654,8627655,8627656,8594725,8594726,7201404,8627838,8627843,10866485,10866486,8627848,8627849,8627854,8627859,8627999,8628000,8628001,8628002,10858870,8628245,8628262,8628264,7201958,7201963,8628426,8628464,8628485,8628490,7202133,7202170,8628576,7202243,7202257,7202264,7202265,7202266,7202267,7202272,8628796,10859533,10859546,10859683,10929182,10865247,10865251,8626655,8626656,8626657,8626658,8626659,7200295,8626750,8626751,8626753,10102356,10102359,7200602,8627006,7200778,10865935,10865936,10857949,8627337,10858002,8624586,8624594,8624595,8624596,8624597,8624598,8624599,8624600,8624601,8624602,8624603,8624604,8624605,8624606,8624607,8624608,8624609,8624610,7198219,8624648,8624649,10863344,10863345,10863366,10863491,7198691,7198692,7198711,7198714,7198728,10863811,10863812,7198772,8625277,8625278,8625279,8625280,10855928,8625491,8625492,10856259,10865031,10865032,10865033,10865034,10865035,10865036,10865037,10865038,10865039,10865040,10865041,10865042,10865043,10865044,10865045,10865175,10853255,10853257,10853258,10853259,10853261,10853263,10853296,10853297,10853300,10853301,7196266,7196267,3923421,7196294,7196295,7196296,10853434,3923593,7196458,10618277,7196671,10854014,10854133,3924392,7197657,3234987,8624256,8624260,8907806,8624439,8907909,7198170,10852223,10852266,10852267,10852270,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,8634719,8634720,10852370,8634798,8634799,8634800,8634801,8634802,8634803,8634804,8634805,8634806,8634807,8634808,8634809,8634810,8634811,8634812,8634813,8634814,8634815,8634816,8634817,8634818,8634819,8634820,8634822,8634823,8634824,8634825,8634826,8634827,8634828,10622258,8634878,10622264,10622268,10622360,8635024,8635025,8635030,10622431,10622447,10622514,10622516,10954196,10425359,10425394,8632750,10425471,8632791,8632847,8632848,8632849,8632850,10425582,10615291,8632989,8632990,8632991,8632992,8632993,8632994,8633057,10615443,8633087,8633088,8633212,8633226,8633270,8633389,10851164,10426330,10991663,10991664,10991665,10991666,10991667,10991668,10616044,10616045,8633682,10991757,10991760,10991775,10616193,10616203,10616207,10616208,8633840,8633841,8633842,8633843,8633844,8633845,8540716,8633853,8633854,8633855,8633856,8633857,8633858,8633859,10616242,10616280,10616281,10426628,10616294,10616339,10616340,8633990,10616398,10616399,10616416,10616442,8634167,10851974,10851977,10851978,10851979,8634339,8552639,10616815,8634463,10616888,10852187,10852188,10852192,10852193,10852196,10852197,10852199,10852200,10852201,10852208,10852209,10852215,10852216,10852219,10614048,10611489,10611545,10611625,10611675,10611678,8851241,8851243,10612082,10612083,8851330,8851419,8851448,10609303,8851528,8851546,10612495,10612642,10609679,8851855,10612704,10120370,10609980,10609981,10612990,10612993,10612994,10613071,8852317,10613292,8567170,8852580,8852588,8852589,8852608,8852633,8852648,8852650,6673531,7055654,6673721,9185555,9169700,10118129,6674229,6674237,6674240,6674242,9178414,9178427,9178477,8850818,8850820,8850822,8850847,8850887,8850889,8850895,8851086,8851087,8851111,9910579,10418316,10418317,10418318,10418319,10418320,10418321,10418322,10418323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10415451,10418488,10418553,10418557,9910881,9168685,10415634,10415657,10418877,10416879,10416880,9911185,10416903,10417015,10417021,10419105,10468893,9167503,9167534,976476,9208010,10470630,10427663,10888894,10884116,10884117,10889164,10889166,10889219,10889222,10884594,10889798,10890022,10890051,10890052,10890053,10885059,10890092,10890118,10890218,10890219,10890232,10885403,10885404,10885406,10885407,10887545,10882622,10888322,10888354,10883358,10883359,10885748,10161801,10885904,10167916,10167936,10167977,10167992,10897137,10882291,10607634,10505548,10505549,10505550,10508584,10413403,10409448,10409449,10409586,10409832,10411888,10409914,10413990,10414113,10408190,10412536,10412588,10408651,10408654,10408655,10408656,10411073) 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'