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(8630669,8630676,8630677,8630678,8630681,8630682,8630687,8630688,8630689,8630690,8630692,8630693,8630694,8630695,8630696,8630697,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630705,8630706,8630707,8630708,8630709,8630710,8630711,8630712,8630713,8630714,8630716,8630717,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630742,8630743,8630744,8630745,8630746,8630747,8630748,8630749,9215018,8631780,8631781,10849775,10990505,8632578,10869263,11040261,8630268,8630271,8630272,8630273,8630275,8630276,8630277,8630278,8630280,8630282,8630283,8628128,8628133,8595422,8628798,8628880,8628881,8628882,8628883,8628884,8628885,8628886,8628887,8628888,8629360,8629361,8629362,8629363,10840318,8625232,8625233,8625234,8625235,8625236,8625520,8625521,8625522,8625523,8625524,8625525,8625526,8625527,8625528,8625529,8625530,8625550,8625551,8625552,8625556,8625557,8625558,8625559,8625560,8625561,8625562,8625563,8625564,8625565,8625566,8625567,8625568,8625569,8625570,8625571,8625572,8625582,8625583,8625584,8625585,8625586,8625587,8625621,8625622,8625623,8625624,8625625,8625626,8625628,8625629,8625630,8625631,8625632,8625633,8625634,8625635,8625636,8625637,8625638,8625639,8625640,8625641,8625642,8625643,8625644,8625645,8625646,8625647,8625648,8625649,8625650,8625651,8625652,8625653,8625654,8625655,8625656,8625657,8625658,8625659,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625667,8625668,8625669,8625670,8625671,8625672,8625673,8625674,8625675,8625676,8625677,8625678,8625679,8625680,8625681,8625682,8625683,8625684,8625685,8625686,8625687,8625688,8625689,8625696,8625697,8625698,8625699,8625700,8625701,8625702,8625703,8625704,8625705,8625706,8625707,8625708,8625709,8625710,8625711,8625712,8625713,8625714,8625715,8625716,8625717,8625718,8625719,8625720,8625721,8625722,8625723,8625724,8625725,8625726,8625728,8625729,8625730,8625731,8625732,8625733,8625734,8625735,8625736,8625738,8625739,8625740,8625741,8625742,8625743,8625744,8625745,8625746,8625747,8625748,8625749,8625750,8625751,8625752,8625753,8625754,8625755,8625756,8625757,8625758,8625759,8625760,8625761,8625762,8625763,8625764,8625765,8625766,8625767,8625768,8625769,8625770,8625771,8625779,8625791,8625792,8625793,8625795,8625797,8625799,8625802,8625803,8625805,8625807,8625810,8625811,8625812,8625815,8625816,8625818,8625819,8625820,8625821,8625822,8625823,8625825,8625827,8625829,8625830,8625832,8625834,8625835,8625836,8625837,8625838,8625839,8625840,8625841,8625842,8625843,8625844,8625846,8625849,8625850,8625852,8625855,8625856,8625857,8625859,8625861,8625862,8625876,8625879,8625894,8625895,8625896,8625899,8625900,8625901,8625902,8625903,8625904,8625905,8625906,8625907,8625908,8625909,8625910,8625911,8625912,8625913,8625914,8625915,8625951,8625952,8625953,8625954,8625959,8625960,8625961,8625962,8625963,8625964,8625971,8625972,8625973,8625974,8625975,8625976,8625994,8625995,8625996,8625997,8625998,8625999,7070469,3926877,8626350,8626351,8626352,8626353,8626354,10623256,10623257,11008158,8624377,8634768,8634769,8634770,8542157,8542281,11045545,8632584,8632585,8632796,8632797,8632798,10615343,10991287,10991288,10930674,8633392,8633393,8540642,9217807,9217808,8540846,8634279,8634280,8634281,8634282,8634283,8634287,8634295,8634296,8634297,8634298,8634299,8634300,10121940,8853650,8853794,8853820,8853827,8853828,8853829,10609375,8851567,8851568,8851569,8851570,8851571,9172234,9212330,9212331,9212332,9212333,9212334,9172533,9172534,9172535,9172542,10558562,10558563,10558592,9197109,9169443,9169449,10515280,10515281,10515282,9185545,9185546,9169908,6674189,8850074,8850091,8850092,10516159,10119453,9168712,9168799,9169290,9174354,9174355,9174356,9174357,9174358,9182560,8854913,8854915,10123576,8855342,10123830,10123831,10123833,9167781,10156033,10156034,10892664,10644770,10654137,10654160,10591143,10591144,10591145,10591146,10591147,10591148,10591149,10591150,10591151,10591152,10591153,10591154,10591155,10527350,10519549,10519550,10519551,10519552,10519553,10519554,10519555,10519556,10519557,10519558,10519559,10519560,10519561,10519562,10508175,10425336,10421473,10508449,10508545,10507572,10507573,10507623,10498671,10407306) 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'