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(10861363,10861587,3228908,3229189,3229190,3229191,3229192,3229193,3229194,3229195,3229196,3229197,3229198,3229201,3229207,3229280,7065968,10849389,7066267,10849985,10863023,8632425,8632426,10863085,8632490,8632495,8632496,8632497,8632500,8632502,8632503,8632561,8632562,8632563,8632564,8632565,3227423,10939419,10866367,10866745,10858850,10858851,7202048,10859162,10859279,10859286,10859288,8628812,8628813,7202687,7202767,8629340,8629341,3227206,10865412,8834762,8834763,8627233,8627236,8627257,8627273,8627282,10865953,10865954,10865955,10865956,10865957,10865996,8627377,8627378,10866020,8627379,8627380,8627381,8627382,10866177,7198525,7198526,7198527,7198528,3235778,7198693,10864331,10864749,10864757,10864760,10864761,10864762,10864763,10853411,3923548,3923593,3923625,3923632,3923640,3923641,3923642,8554349,10853731,10853732,10853733,10854226,10854227,10838929,10838930,10838931,10838934,10838935,7197439,7197608,7197619,7197621,7197630,7197633,7197635,7197636,7197639,7197640,7197641,7197644,7197649,7197651,7197654,7197657,7197660,7197661,7197663,7197664,7197667,7197668,7197671,7197672,7197674,7197676,7197679,7197681,7197682,10617025,10617047,10617164,3922823,10615024,10850371,10615268,10615335,10425910,8633219,8633220,8633221,8633222,8633223,8633224,8633225,8633226,8633227,8633228,8633229,8633230,8633231,8633232,8633233,8633234,10615719,8633376,10615919,10615920,10615971,10615972,10615973,10615974,10615980,10616060,10616089,10616092,8540594,8540595,8540596,8611398,8611451,8634376,8634377,8634378,8634379,10616866,10616911,10614024,10614050,9165541,10614274,10614282,10714149,10611367,10611368,10611369,10611370,10614375,10614476,10614486,10559766,10611764,10611802,10611819,10611965,10611966,10612051,10612263,10612267,10612344,10609397,10609398,10612506,10612518,10612519,10612521,10612524,10612528,10612532,10612542,10612546,10612547,10612551,10612553,10612558,10612565,10612567,10612571,10612580,10612601,10612604,10612611,10612618,10612619,10612663,10612675,10612685,10612697,10612755,10612757,10612842,10612843,10612844,10612850,10612852,10612853,10612856,10612895,10612896,10612897,10612910,10612911,10612912,10612913,10612914,10609978,10613019,10613139,10613140,8567072,8567073,10610268,10610271,10610396,8852564,10613547,10613562,10610666,10610674,10610675,10610676,10613682,10613683,10613691,7055491,6673534,6673535,6673536,6673537,6673538,6673539,6673540,6673541,6673542,6673543,6673544,6673546,6673549,6673550,6673563,6673642,9169438,6673644,6673645,9169901,6674175,6674190,9912217,6674251,6674256,6674276,6674278,6674280,6674281,6674323,6674326,10419288,6672592,10415323,10419371,10419372,10419377,6672706,6672896,6672897,6672898,6672899,6672900,6672901,10417650,6673078,6673080,6673331,6673334,10418060,10418068,10418076,10418077,10418078,10418079,10419176,6673476,6673477,6673494,6673495,6673496,10471111,8550105,9175061,8916797,9167681,976487,6671918,10470697,10427663,9168290,10888819,10888842,10888843,10888844,10888845,10888846,10888847,10888848,10888849,10888850,10889060,10884195,10889591,10889709,10889710,10879876,10879878,10879882,10879883,10884933,10874992,10889997,10875004,10875005,10875006,10875007,10875008,10875009,10875010,10875011,10890011,10890012,10875012,10875014,10890014,10875015,10875016,10875017,10875018,10875019,10875020,10875021,10875022,10875023,10875024,10875025,10875026,10875027,10875028,10875032,10875033,10875034,10875035,10875036,10875037,10875038,10875039,10875040,10875041,10875042,10875043,10875044,10875045,10875046,10875047,10875048,10890094,10890102,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890161,10890162,10890173,10890174,10890175,10890208,10890209,10890210,10890211,10890212,10890244,10890245,10888298,10885526,10885927,10885928,10885955,10881554,10876593,10876600,10897016,10897049,10897079,10897080,10897092,10882360,10882435,10590192,10603879,10604692,10527750,10508267,10508473,10508474,10508527,10508533,10508606,10507675,10507676,10507937,10508002,10508009,10508010,10508011,10508012,10508025,10508034,10413383,10413384,10407448,10413652,10409749,10409750,10409751,10409989,10409990) 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'