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(10861354,3229184,3229191,3229192,3229193,3229194,3229195,3229207,10849389,7066209,8631856,8631859,7066266,8632190,10862885,10862897,10849985,10863085,8632561,8632562,8632563,10860289,10861075,10861076,8594637,8594638,8594639,8594640,8594641,8594642,8594643,8594644,8594645,8594646,8594647,8594648,8594649,8594650,8594651,10866383,10866384,10866616,10866617,10858822,10858861,10858866,10858878,8595288,7202108,7202109,7202110,7202111,7202112,7202113,10859294,10859356,10859422,10859448,8628812,7202767,3227052,8629340,8629341,10859992,10859993,10859994,10865412,10857434,8834762,8834763,10857578,10857579,10857582,10857583,10865926,10865927,10865928,10865929,10865930,10865931,10865940,10865942,10865946,10865947,10865948,10865949,10865950,10865953,10865954,10865955,10865957,7200919,8064692,10100083,8624681,8624682,8624683,8624684,8624688,8624691,8624692,7198347,7198348,7198410,10863488,7198662,7198693,10863982,10863983,10863984,10864432,7199689,7199744,10864818,10864819,10857092,3237338,3237339,3923602,3923604,10618275,8906551,8906567,8906568,8906569,8906570,8906572,8906573,8906767,8906800,8906801,10838929,10838930,10838931,7197608,7197619,7197621,7197630,7197633,7197635,7197636,7197639,7197640,7197641,7197644,7197679,10616967,10616968,10616969,10617101,10617103,10617104,10617105,10617106,10617108,10617112,10617162,10617163,10617169,10617170,8905395,8905396,8905397,10622429,10954097,10954099,8905473,10617454,3922823,8905502,8905509,8905528,8905529,8905530,8905531,8905582,8905595,8905596,8905658,8905807,8905827,10615024,10850371,10615170,10615268,10425910,8633220,8633221,8633222,8633223,10615605,10615614,10615620,10615639,10615642,10930631,10615919,10615920,10615948,10615958,10615973,10615974,10616089,8540595,8540596,10616223,10616242,10616261,10616263,10616316,10616846,10616849,10616850,10616851,10616853,10616854,10616911,10611012,10614093,9165541,10614274,10614282,10614291,10614292,10614301,10714119,10611367,10611368,10611369,10714186,10614375,10614486,10611713,10611764,8851132,8851149,8851170,8851280,10609171,8851339,10612263,10612265,10612267,10612440,10612442,10612465,10612467,10612469,10612470,10612471,10612472,10612474,10612516,10612517,10612518,10612519,10612520,10612522,10612523,10612525,10612526,10612527,10612533,10612540,10612541,10612544,10612545,10612553,10612565,10612604,10612611,10612613,10612614,10612617,10612618,10612619,10612662,10612675,10612685,10609713,10612746,10612755,10612757,10609817,10612832,10612849,10612851,10609886,10612890,10612895,10612896,10612900,10612904,10612905,10610054,8852311,8852365,8852366,8852367,8567072,8567073,10610271,10610298,10610396,10613464,10613490,10613562,10613662,10613664,10610666,10613673,10610675,10610676,10613682,10613683,10613685,10613691,10613694,10613708,10613709,10613710,10613716,10613717,10610868,7055491,6673563,7055657,10515335,9169674,9169675,9911939,9911940,9169822,9169870,9169871,9169901,6674190,9169985,9169986,6674250,6674256,6674315,6674326,9912359,9912371,9912372,9912381,9912403,9912485,9912493,9912514,9912515,9912518,9912738,9912740,8850617,9913194,8850920,8850941,9913327,9913328,9913329,9913333,8850978,6672563,10415315,10415323,10419382,10419383,10419384,10419385,10417388,10417389,10417390,10418451,10416453,10416466,10419497,10419498,9910828,10417743,9168962,10417017,6673331,6673332,6673333,6673334,10419097,10419098,10419099,10419100,10419101,10419102,10419103,10419108,10419109,10419111,10419115,10419116,10419117,10419118,10419119,10418142,10418143,6673476,6673496,10471108,10471111,10471114,10471117,10471118,10471119,6670760,10471175,8549913,8550043,8550105,8550154,10467615,8550243,8550244,8550245,9167398,976457,976472,976473,976487,976521,976522,976525,976548,10470693,10470697,10427663,9168290,10883493,10888688,10888710,10888839,10888842,10888850,10888967,10888978,10888979,10888997,10888998,10888999,10889006,10889023,10889052,10889060,10889219,10884519,10899571,10889591,10889708,10879876,10879878,10879882,10879883,10875004,10875005,10875006,10875007,10875008,10875010,10875014,10875015,10890015,10875017,10875018,10875019,10875020,10875021,10890022,10875026,10885026,10875027,10875028,10890028,10875035,10875043,10875044,10875045,10875046,10875057,10890094,10890110,10890114,10890116,10890169,10890170,10890171,10890173,10875180,10890211,10890212,10885229,10875233,10885248,10885297,10885299,10885300,10627298,10882901,10883032,10888115,10888463,10885580,10885616,10885617,10885691,10885928,10161960,10876593,10876600,10886744,10886748,10897016,10897049,10897079,10897080,10882360,10602294,10602310,10602445,10608610,10647389,10603221,10647499,10603783,10603879,10604067,10508606,10507675,10507676,10508034,10413394,10413398,10413399,10413409,10407448,10413733,10413784,10413805,10413806,10413888,10413891,10413913,10411933,10412204,10412205,10412208,10412209,10414388,10414389,10414390,10414391,10414632,10415087,10415088) 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'