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(10861394,10862015,10862016,10862017,10862018,10862019,10862020,10862021,10862022,10862023,10862024,10862025,10862026,10862027,10862028,10862029,10862030,10862031,10862032,10862033,10862034,10862035,10862036,10862037,10862038,10862039,10862040,10862041,10862042,10862043,10862044,10862045,10862046,10862047,10862048,10862049,10862050,10862051,10862052,10862053,10862054,10862055,10862056,10862057,10862058,10862059,10862060,10862061,10862062,10862063,10862064,10862065,10862066,10862067,10862068,10862069,10862070,10862071,10862072,10862073,10862074,10862075,10862076,10862077,10862078,10862079,10862080,10862081,10862082,10862083,10862084,10862085,10862086,10862087,10862088,10862089,10862090,10862091,10862092,10862093,10862094,10862095,10862096,10862097,10862098,10862099,10862100,10862101,10862102,10862103,10862104,10862105,10862106,10862107,10862108,10862109,10862110,10862111,10862112,10862113,10862114,10862115,10862116,10862117,10862118,10862119,10862120,10862121,10862122,10862123,10862124,10862125,10862126,10862127,10862128,10862129,10862130,10862131,10862132,10862133,10862134,10862135,10862136,10862137,10862138,10862139,10862140,10862141,10862142,10862143,10862144,10862145,10862146,10862147,10862148,10862149,10862150,10862151,10862152,10862153,10862154,10862155,10862156,10862157,10862158,10862159,10862160,10862161,10862162,10862163,10862164,10862165,10862166,10862167,10862168,10862169,10862170,10862171,10862172,10862173,10862174,10862175,10862176,10862177,10862178,10862179,10862180,10862181,10862182,10862183,10862184,10862185,10862186,10862187,10862188,10862189,10862190,10862191,10862192,10862193,10862194,10862195,10862196,10862197,10862198,10862199,10862200,10862201,10862202,10862203,10862204,10862205,10862206,10862207,10862208,10862209,10862210,10862211,10862212,10862213,10862214,10862215,10862216,10862217,10862218,10862219,10862220,10862221,10862222,10862223,10862224,10862225,10862226,7066142,10860301,8573292,8573293,3227552,8630187,7201185,10866375,10866376,10866377,10866378,10866379,10859281,10859282,10859283,5654636,8910251,8910252,8627357,8627358,8627359,8627360,8627361,8627362,8627363,8627377,8627378,8627379,8627380,8627381,8627382,7198347,7198348,8908468,8908469,8908470,8908471,7198722,8625411,8625412,7199299,8860396,8860397,8860398,8860399,10856983,8905896,8905897,8905898,3923537,10623490,10619240,8904983,10617147,10850584,10850585,10850586,10615720,8611343,8611386,8611396,8611415,8611416,8611417,8611418,8611419,8611458,8611459,7155300,10714172,10614732,10614733,10614734,10614735,10614736,10614737,10614738,10614739,10614740,10614741,10614742,10614743,10614744,10614745,10614746,10612347,10612408,10612409,10612410,10612411,10612412,10612632,8862553,10612825,10612826,10612851,10612861,8852250,8852251,8852252,8852253,8852254,8852255,8852307,10613659,10613692,10610872,7014960,7014961,7014962,7014963,7014964,7014965,7014966,7014967,7014968,7014969,7014970,7014971,7014972,7014973,7014974,7014975,7014976,7014977,7014978,7014979,7014980,7014981,7014982,7014983,7014984,7014985,7014986,7014987,7014988,7014989,7014990,7014991,7014992,7014993,7014994,7014995,7014996,7014997,7014998,7014999,7015000,7015001,7015002,7015003,7015004,7015005,7015006,9169353,7015007,9169354,7015008,9169355,9169356,7055675,6673751,6673752,6673753,6673754,6673755,6673756,6673757,6673758,6673759,6673760,6673761,6673762,6673763,6673764,6673765,6673766,9169773,10125985,9912119,9912120,9169919,10118133,10118270,10118271,10118272,10118273,10118274,10118275,10118276,10118277,9912355,9912837,9912846,9912847,9912848,9912849,9912850,9912851,9912852,9912853,9912854,9912855,9912856,9912857,9912858,9912859,9912860,9912861,9912862,9912863,9912864,9912865,9912960,9168403,9160404,10415339,9168698,9168699,9168857,10415789,10415790,10415791,10415792,9168871,10415793,10415794,9168873,10415795,10415796,10415797,10415798,10415799,10415800,10415801,10415802,10415803,10415804,10415805,10415806,10415807,10415808,10415809,10415810,10415811,10415812,10415813,10415814,10415815,10415816,10415817,10415818,10415819,10415820,10415821,10415822,10415823,10415824,10415825,10415826,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10415838,10415839,10415840,10415841,10415842,10415843,10415844,10415845,10415846,10415847,10415848,10415849,10415850,10415851,10415852,10415853,10415854,10415855,10415856,10415857,10415858,10415859,10415860,10415861,10415862,10415863,10415864,10415865,10415866,10415867,10415868,10415869,10415870,10415871,10415872,10415873,10415874,10415875,10415876,10415877,9168956,10415878,10415879,10415880,10415881,10415882,10415883,9168961,10415884,10415885,10415886,10415887,10415888,10415889,10415890,10415891,10415892,10415893,10415894,10415895,10415896,10415897,10415898,10415899,10415900,10415901,10415902,10415903,10415904,10415905,10415906,10415907,10415908,10415909,10415910,10415911,10415912,10415913,10415914,10415915,10415916,10415917,10415918,10415919,10415920,10415921,10415922,6673477,6673490,6673491,8549981,8916795,976500,9167979,10427664,10427665,10888828,10887605,10887667,10887668,10887669,10887670,10887671,10887672,10887673,10887674,10887675,10887676,10887677,10887678,10887679,10887680,10887681,10887682,10887683,10887684,10887685,10887686,10887687,10887688,10887689,10887690,10887691,10887692,10887693,10887694,10887695,10887696,10887697,10887698,10887699,10887700,10887701,10887702,10887703,10887704,10887705,10887706,10887707,10887708,10887709,10887710,10887711,10627918,10885931,10162012,10172067,10882100,10163318,10163321,10163322,10647485,10647506,10647618,10647619,10647620,10647621,10579772,10579773,10579774,10579775,10579776,10579777,10579778,10579779,10579780,10579781,10507572,10507573,10413728,10413729,10413730,10411843,10414222,10489231,10489232,10489233,10489234,10489235,10489236,10489237,10489238,10489239,10489240,10489241,10489242,10489243,10489244,10489245,10489246,10414644,10482849,10482850,10482851,10482852,10482853,10482854,10482855,10482856,10482857) 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'