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(8574202,8574203,10102247,10102248,10102249,10102250,10971999,10972000,10972001,10972002,10972003,10972004,10972005,10972006,10972007,10972008,10972009,10972010,10972011,10972012,10972013,10972014,10972015,10972016,10972017,10972018,10972019,10972020,10972021,10972022,10972023,10972024,10972025,10972026,10972027,10972028,10972029,10972030,10972031,10972032,10972033,10972034,10972035,10972036,10972037,10972038,10972039,10972040,10972041,10972042,10972043,10972044,10972045,10972046,10972047,10972048,10972049,10972050,10972051,10972052,10972053,10972054,10972055,10972056,10972057,10972058,10972059,10972060,10972061,10972062,10972063,10972064,10972065,10972066,10972067,8835383,10620323,10620324,10620325,10426553,10426554,10426555,10426556,10426557,10426558,10426559,10426560,10426561,10426562,10426563,10426564,10426565,10426566,10426567,10426568,10426569,10426570,10426571,10426572,10426573,10426574,10426575,10426576,10426577,10426578,10426579,10426580,10426581,10426582,10426583,10426584,6675683,6675684,6675685,6675686,6675687,6675688,6675689,6675690,6675691,6675692,6675693,6675694,6675695,6675696,6675697,6675698,6675699,6675700,6675701,6675702,6675703,6675704,6675705,6675706,6675707,6675708,6675709,6675710,6675711,6675712,6675713,6675714,6675715,6675716,6675717,6675718,6675719,6675720,6675721,6675722,6675723,6675724,6675725,6675726,6675727,6675728,6675729,6675730,6675731,6675732,6675733,6675734,6675735,6675736,6675737,6675738,6675739,6675740,6675741,6675742,6675743,6675744,6675745,6675746,6675747,6675748,6675749,6675750,6675751,6675752,6675753,6675754,6675755,6675756,6675757,6675758,6675759,6675760,6675761,6675762,6675763,6675764,6675765,6675766,6675767,6675768,6675769,6675770,6675771,6675772,6675773,6675774,6675775,6675776,6675777,6675778,6675779,6675780,6675781,6675782,6675783,6675784,6675785,6675786,6675787,6675788,6675789,6675790,6675791,6675792,6675793,6675794,6675795,6675796,6675797,6675798,6675799,6675800,6675801,6675802,6675803,6675804,6675805,6675806,6675807,6675808,6675809,6675810,6675811,6675812,6675813,6675814,6675815,6675816,6675817,6675818,6675819,6675820,6675821,6675822,6675823,6675824,6675825,6675826,6675827,6675828,6675829,6675830,6675831,6675832,6675833,6675834,6675835,6675836,6675837,6675838,6675839,6675840,6675841,6675842,6675843,6675844,6675845,6675846,6675847,6675848,6675849,6675850,6675851,6675852,6675853,6675854,6675855,6675856,6675857,6675858,6675859,6675860,6675861,6675862,6675863,6675864,6675865,6675866,6675867,6675868,6675869,6675870,6675871,6675872,6675873,6675874,6675875,6675876,6675877,6675878,6675879,6675880,6675881,6675882,6675883,6675884,6675885,6675886,6675887,6675888,6675889,6675890,6675891,6675892,6675893,6675894,6675895,6675896,6675897,6675898,6675899,6675900,6675901,6675902,6675903,6675904,6675905,6675906,6675907,6675908,6675909,6675910,6675911,6675912,6675913,6675914,6675915,6675916,6675917,6675918,6675919,6675920,6675921,6675922,6675923,6675924,6675925,6675926,6675927,6675928,6675929,6675930,6675931,6675932,6675933,6675934,6675935,6675936,6675937,6675938,6675939,6675940,6675941,6675942,6675943,6675944,6675945,6675946,6675947,6675948,6675949,6675950,6675951,6675952,6675953,6675954,6675955,6675956,6675957,6675958,6675959,6675960,6675961,6675962,6675963,6675964,6675965,6675966,6675967,6675968,6675969,6675970,6675971,6675972,6675973,6675974,6675975,6675976,6675977,6675978,6675979,6675980,6675981,6675982,6675983,6675984,6675985,6675986,6675987,6675988,6675989,6675990,6675991,6675992,6675993,6675994,6675995,6675996,6675997,6675998,6675999,6676000,6676001,6676002,6676003,6676004,9914098,10427812,9176872,9176873,9176874,9176875,9176876,9176877,9176878,9176879,9176880,9176881,9176882,9176883,9176884,9176885,9176886,10894729,10894730,10166837,10166838,10166839,10166840,10166841,10166842,10166843,10166844,10166845,10166846,10166847,10166848,10166849,10166850,10166851,10166852,10166853,10166854,10166855,10166856,10166857,10166858,10166859,10166860,10166861,10166862,10166863,10166864,10166865,10166866,10166867,10166868,10166869,10166870,10166871,10166872,10166873,10166874,10166875,10166876,10166877,10166878,10166879,10166880,10166881,10166882,10166883,10166884,10166885,10166886,10166887,10166888,10166889,10166890,10166891,10166892,10166893,10166894,10166895,10166896,10166897,10166898,10166899,10166900,10166901,10166902,10166903,10166904,10166905,10166906,10166907,10166908,10166909,10166910,10166911,10166912,10166913,10166914,10166915,10166916,10166917,10166918,10166919,10166920,10166921,10166922,10166923,10166924) 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'