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(10861358,10861360,4970747,8569558,8631559,8631701,8631703,7066267,10849985,10863058,10860264,8573321,10860982,10866126,7201096,8627500,8627501,8627504,8627505,8627506,8627507,8627509,8627513,8627514,10866382,10866385,3238520,10866391,3227052,10860031,10865103,10865117,10865120,10865132,10865137,8834762,8834763,8626938,8627015,8627020,8627028,7200800,8627222,8627226,8627229,8627245,8627265,8627271,8627274,8627276,8627278,8627281,8627294,8627295,8627296,8627297,8627298,8627299,8627300,8627301,7200901,8627302,8627303,8627304,8627305,8627306,8627307,8627308,8627309,8627311,7200918,8627390,8627391,8627392,8627393,8627394,8627396,8627397,8627398,8627399,8627400,8627401,8627402,8627403,8627404,8627408,8627409,8627410,8627411,8627413,8627414,8627415,8627419,7198736,10863917,10864195,10864196,10864197,10864198,10864199,10101205,10864442,10864697,10864702,10864706,10864707,10864709,10864927,10864928,10865077,10865084,10865090,10865091,10865095,10865098,10865102,3923414,3923485,3923548,3923567,3923593,3923640,3923641,3923642,10853734,10853735,8906551,8906853,8906856,3234501,3234502,8624357,10617107,10617120,10617121,10617122,10617123,10617128,10617129,10617130,10617131,10617132,10617133,10617142,10617150,10617151,10617152,10617157,10617158,8541671,3922823,8632633,8632634,8632635,8632636,10615437,10615439,10615545,10615548,10615568,10615569,10615570,10615690,10615691,10615692,10615693,10615695,10615696,10615713,10615722,10615950,10615953,10426392,10426422,8634103,8634105,8634106,8634108,8634109,8634111,8611398,10616863,10616911,10614085,10614086,10614089,10611095,10611126,9165541,10611367,10611368,10611369,10611370,10614376,10614475,10614485,10614501,10611812,10611819,10612051,7017671,7017672,7017703,7017704,7017707,7017708,7017775,7017776,7017777,7017778,8852027,8852029,8852030,8852032,8852033,8852034,8852035,8852036,8852037,8852038,10612896,10612915,10613019,8567072,8567073,8852404,10613310,10613325,10613350,10610396,10613639,10613640,10613641,10613642,10613654,10610901,10610956,10610957,6673514,9911581,6673701,9169518,9169536,6673749,9169577,9169578,9169579,9169580,6673804,9169602,9169603,9169604,9169605,9169606,9169607,9169608,9169609,9169610,9169611,9169612,9169613,9169614,9169615,9169616,6674177,6674179,6674190,6674316,6674323,6674326,7016022,7016023,7016026,7016027,7016030,7016031,7016034,7016035,7016038,7016039,7016042,7016043,7016046,7016047,7016052,7016053,7016058,7016059,7016064,7016065,7016070,7016071,7016076,7016077,7016080,7016081,7016084,7016085,7016088,7016089,7016092,7016093,7016096,7016097,7016100,7016101,7016104,7016105,7016110,7016111,9913033,9913104,9913105,9913118,9913125,9913126,8850757,9913143,9913144,9913145,9913330,9913334,9913336,10419255,10415321,10418369,10418375,10418379,10419381,10418385,10418386,10419386,10418387,10418388,10418390,10419392,10418393,10418399,10418402,10418403,10418404,10418405,10418418,10418428,6672713,10418431,10418432,10418444,10418449,10417531,10417532,10417533,10417534,10417535,10416612,10417753,7014500,7014501,6673078,6673080,9911271,10418014,10418023,10418027,10418030,10418032,10418033,10117397,10117398,10117399,10470115,10470155,10470164,10470165,10470191,6671918,976568,976580,9167828,10116075,9168096,9168097,10427645,10888565,10888566,10888676,10888705,10888737,10888738,10888739,10888746,10888747,10888748,10888780,10888781,10888782,10888842,10888843,10888844,10888845,10888846,10888847,10888848,10888849,10888850,10888972,10889019,10889020,10889021,10889024,10889060,10884503,10890022,10890023,10890024,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10885141,10890161,10890162,10885169,10890173,10890174,10890175,10890208,10890209,10890210,10890211,10890212,10885403,10885404,10887906,10887907,10887908,10888298,10888433,10888434,10885526,10885640,10885955,10881554,10882360,10608383,10608626,10608809,10647643,10647649,10647650,10603875,10604067,10604603,10604604,10508446,10507599,10507600,10507601,10507602,10507603,10507604,10507721,10508002,10508025,10508034,10407448,10409752,10415006) 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'