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(10861230,10861231,10861243,10861257,10848692,10848697,10873763,10873770,10873781,10873792,10873802,10873807,3228987,8583491,10862441,10849460,10862477,10862481,10849509,10849537,10849546,10849646,10849869,8632547,10860637,10860709,10861107,10861167,10861181,10861192,10861203,10861206,10861212,10861215,10858322,10858327,10858334,10858337,10866481,10866485,10858714,10866748,10866752,8595109,8595110,10866756,8595111,8595112,8595113,10866759,8595114,8595115,8595116,8595117,10866768,10866774,10866777,10866780,10866783,10866794,10866799,10858828,10859170,7202689,7202690,10855570,10864100,10864101,10856849,10856861,10856866,10856873,10856874,10856877,10856882,10856883,10856899,10856904,10856906,10857117,10857122,10857126,3923505,3233597,10853513,10853514,10853516,10853519,10853527,10853528,10853532,10853536,10853537,10853545,10853546,10853552,10853559,10853560,10853564,10853567,10853570,10853571,10853574,10853579,10853580,10853586,10853587,10853593,10853601,10853602,10853607,10853608,10853615,10853616,10853624,10853625,10853630,10853631,10619177,7197901,7197909,7198053,10927510,10852285,10852371,10852372,10852373,10852638,10852667,10852677,10852680,10852683,10852686,10852688,10852691,10853094,10850368,10850432,10850842,10850846,10850849,10616540,10851956,10851977,10851978,10852187,10852192,10852196,10852215,10614637,10612084,10612085,10612086,10612168,10612169,10609348,10609358,10609363,10609376,10613056,10613080,10613643,10613804,7055498,6673762,10118041,10118074,10118075,9161891,9161892,9161893,10118243,10118275,8850055,10118453,7016877,7016878,7016879,7016880,7016881,7016882,7016883,7016884,7016885,7016886,7016887,7016888,7016889,7016890,7016891,7016892,7016893,7016894,7016895,7016896,7016897,7016898,7016899,7016900,7016901,7016902,7016903,7016904,7016905,7016906,7016907,7016908,7016909,7016910,7016911,7016912,7016913,7016914,7016915,7016916,7016917,7016918,7016919,7016920,7016921,7016922,7016923,7016924,7016925,7016926,7016927,7016928,7016929,7016930,7016931,7016932,7016933,7016934,7016935,7016936,7016937,7016938,7016939,7016940,10415224,8848164,10417289,9910579,9168390,9168391,10419604,10419608,10419611,10419615,10419624,10419630,10419634,10419638,10419643,10419648,10419656,10419660,10419663,6673174,6673175,6673176,6673177,6673178,6673179,6673180,6673181,6673182,6673183,6673184,6673185,6673186,6673187,6673188,6673189,6673190,6673191,6673192,6673193,6673194,6673195,6673196,6673197,6673198,6673199,6673200,6673201,6673202,6673203,6673204,6673205,6673206,6673207,6673208,6673209,6673210,6673211,6673212,6673213,6673214,6673215,6673216,6673217,6673218,6673219,6673220,6673221,6673222,6673223,6673224,6673225,6673226,6673227,6673228,6673229,6673230,6673231,6673232,6673233,6673234,6673235,6673236,6673237,6673238,6673239,9169033,6673240,6673241,6673242,6673243,6673244,6673245,6673246,6673247,6673248,6673249,6673250,6673251,6673252,6673253,6673254,6673255,6673256,6673257,6673258,6673259,6673260,6673261,6673262,6673263,6673264,6673265,6673266,6673267,6673268,6673269,6673270,6673271,6673272,6673273,6673274,6673275,6673276,6673277,6673278,6673279,6673280,6673281,6673282,6673283,6673284,6673285,6673286,6673287,6673288,6673289,6673290,6673291,6673292,6673293,6673294,6673295,6673296,6673297,6673298,6673299,6673300,6673301,6673302,6673303,6673304,6673305,6673306,6673307,6673308,6673309,6673310,6673311,6673312,6673313,6673314,6673315,6673316,10416079,10416115,10416119,976479,976480,976481,976482,976483,8848029,10888950,10884787,10884788,10884789,10884790,10884791,10884792,10884793,10885018,10890047,10174093,10876687,10876821,10647479,10604496,10601723,10424409,10424419,10424430,10424435,10508041,10413256,10407370,10409644,10409654,10409655,10411761,10411769,10411773,10411779,10411786,10411787,10411793,10411794,10411811,10411813,10411951,10411956,10408059,10408063,10408066,10414138,10408640,10408654,10408655,10410734,10408828,10412846,10412856,10412861,10412868,10412871,10414879,10414943,10406959,10406964,10407050,10409068,10409085,10409089,10409093,10407097,10415113,10407124,10407133,10415161,10415171,10415173,10415181,10415183,10415199,10415201) 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'