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(8066992,8583895,10951392,10869146,10869147,10869148,10869149,10869150,10869151,10869152,10869153,10869154,10869155,10869156,10869157,10869158,10869159,10869160,10869161,10869162,10869163,10929633,10929634,10985772,10985773,10985774,10985775,10985776,10985777,10985778,10985779,10985780,10985781,10985782,10985783,10985784,10985785,10985786,10985787,10985788,10985789,10985790,10985791,10985792,10985793,10985794,10985795,10985796,10985797,10985798,10985799,10985800,10985801,10985802,10985803,10985804,10985805,10985806,10985807,10985808,10985809,10985810,10985811,10985812,10985813,10985814,10985815,10985816,10985817,10842277,10944519,10940942,10940943,10940944,10940945,10940946,10940947,10940948,10940949,8908413,8908414,8908415,8908416,8908417,8908418,8908419,8908420,8908421,8908422,8908423,8908424,8908425,8908426,8908427,8908428,8908429,8908430,8908431,8908432,8908433,8908434,8908435,8908436,8908437,8908438,8908439,7069587,7069588,8860715,10622962,10622963,10622964,10622965,10622966,10622967,10622968,10622969,10622970,10622971,10622972,10622973,10622974,10622975,10622976,10622977,10622978,10622979,10622980,10622981,10622982,10622983,10622984,10622985,10622986,10622987,10622988,10622989,10622990,10622991,10622992,10622993,10622994,10622995,10622996,10622997,10622998,10622999,10623000,10623001,10623002,10623003,3924930,3924931,3924932,3924933,3924934,3924935,3924936,3924937,3924938,3924939,8614505,8614506,8614507,8614508,8614509,8614510,8614511,8614512,7155787,10622922,10622923,10622924,10622925,10622926,10622927,10622928,10622929,10622930,10622931,10622932,10622933,10622934,10622935,10622936,10622937,10622938,10622939,10622940,10622941,10622942,10622943,10622944,10622945,10622946,10622947,10622948,10622949,10622950,10622951,10622952,10622953,10622954,10622955,10622956,10622957,10622958,10622959,10622960,10622961,8853618,8853619,8853620,8853621,10612230,6676792,6676793,6676794,6676795,6676796,6676797,6676798,6676799,6676800,6676801,6676802,6676803,6676804,6676805,6676806,6676807,6676808,6676809,6676810,6676811,6676812,6676813,6676814,6676815,6676816,6676817,6676818,6676819,6676820,6676821,6676822,6676823,6676824,6676825,6676826,6676827,6676828,6676829,6676830,6676831,6676832,6676833,6676834,6676835,6676836,6676837,6676838,6676839,6676840,6676841,6676842,6676843,6676844,6676845,6676846,6676847,6676848,6676849,6676850,6676851,6676852,6676853,6676854,6676855,6676856,6676857,6676858,6676859,6676860,6676861,6676862,6676863,6676864,6676865,6676866,6676867,6676868,6676869,6676870,6676871,6676872,6676873,6676874,6676875,6676876,6676877,6676878,6676879,6676880,6676881,6676882,6676883,6676884,6676885,6676886,6676887,6676888,6676889,6676890,6676891,6676892,10120919,10120920,10120921,10120922,10120923,8592869,9182941,9182942,9182943,9182944,9182945,9182946,9182947,9182948,9182949,9182950,9182951,9182952,9182953,9182954,9182955,9182956,9182957,9182958,9182959,9182960,9182961,9182962,9182963,9182964,9182965,9182966,9182967,9182968,9182969,9182970,9182971,9182972,9182973,9182974,9182975,9182976,9182977,9182978,9182979,4972548,4972549,4972550,4972551,4972552,4972553,4972554,4972555,8069046,10170902,10170903,10170904,10170905,10170906,10170907,10170908,10170909,10170910,10170911,10900361,10900362,10900363,10900364,10900365,10900366,10900367,10900368,10900369,10900370,10900371,10900372,10900373,10900374,10900375,10900376,10163771,10650323,10650324,10650325,10650326,10650327,10650328,10650329,10650330,10650331,10650332,10526964,10526965,10526966,10526967,10526968,10526969,10526970,10526971,10526972,10526973,10526974,10526975,10526976,10526977,10526978,10526979,10526980,10526981,10526982,10526983,10526984,10526985,10526986,10526987,10526988,10526989,10526990,10526991,10526992,10526993,10526994,10526995,10526996,10526997,10526998,10526999,10421373,10421374,10421375,10421376,10421377,10421378,10421379,10421380,10421381,10421382,10421383,10421384,10421385,10421386,10477734,10477735,10477736,10477737,10477738,10477739,10477740,10477741,10477742,10477743,10477744,10477745,10477746,10477747,10477748,10477749,10477750,10477751,10477752,10477753,10477754,10477755,10477756,10477757,10477758,10477759,10477760,10477761,10477762,10477763,10477764,10477765,10477766,10477767,10477768,10477769,10477770,10477771,10477772,10477773,10477774,10477775,10477776,10477777,10477778,10477779,10477780,10477781,10477782,10477783,10477784,10477785,10477786,10477787) 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'