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(4970670,4970671,10944265,7065947,8583441,8573243,7201676,8595719,7202367,7202369,7202371,7202373,7202375,7202378,7202381,7202383,7202384,7202385,7202386,7202388,7202390,7202392,7202394,7202396,7202398,7202400,7202402,7202404,7202406,7202408,7202410,7202413,7202415,7202417,7202419,7202421,7202423,7202425,7202427,7202430,7202432,10855809,10855813,10855818,10855819,10855820,10855821,10855822,10855823,10855824,10855825,10855826,10855827,10855828,10855829,10855830,10855831,10855832,10855833,10855834,10941262,10855835,10855836,10855837,10855838,10855839,10855840,10855841,10855842,10855843,10855844,10855845,10855846,10855847,10855848,10855849,10855850,10855851,10855852,10855853,10855854,10855855,10855856,10855857,10855858,10855859,10855860,10855861,10855862,10855863,10855864,10855865,8908708,8908709,8908710,8908711,8908713,8908714,8908715,8908716,8908717,8908718,8908722,8908723,8908730,8908738,8908739,8908741,8908746,8908747,8908750,8908751,8908752,8908753,8908754,8908755,8908758,8908759,8908760,8908761,8908762,3923420,10838793,8905183,8905184,8905185,8905186,8905187,8905188,8905189,8905190,8905191,8905192,8905193,8905194,8905195,8905196,8905197,8905198,8905199,7155257,7155258,7155259,9220274,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10610633,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10117592,10117593,10117594,10117595,10117596,10117597,10117598,10117599,10117600,10117601,10117602,10117603,8592692,9911982,9911983,9911984,9911985,9911986,9911987,9911988,9911989,9911990,9911991,9911992,9911993,9911994,9911995,9911996,9911997,9911998,9911999,9912000,9912001,9912002,8850280,8850281,8850282,8850283,8850284,8850285,8850286,8850287,8850288,8850289,8850290,8850291,8850292,8850293,8850294,8850295,8850296,8850297,8850298,8850299,8850300,8850301,8850302,8850303,8850304,8850305,8850306,8850307,8850308,8850309,8850310,8850311,8850312,8850313,8850314,8850315,8850316,8850317,8850318,8850319,8850320,8850321,8850322,8850323,8850324,8850325,8850326,8850327,8850328,8850329,8850330,8850331,8850332,8850333,8850334,8850335,8850336,8850337,8850338,8850339,8850340,8850341,8850342,8850343,8850344,8850345,8850346,8850347,8850348,8850349,8850350,6672724,6672725,6672726,6672727,6672728,6672729,6672730,6672731,6672732,6672733,6672734,8549972,3963318,3963319,10467896,10467897,10467898,10467899,10467900,10467901,10467902,10467903,10467904,10467905,10467906,10467907,10467908,10467909,10467910,10467911,10467912,10467913,10467914,10467915,9168000,9168001,9168002,9168003,9168004,10427638,10427639,10427640,10427641,10427642,10883518,10883519,10883520,10883521,10883522,10883523,10883524,10883525,10883526,10883527,10883528,10883529,10883530,10883531,10883532,10883533,10883534,10883535,10883536,10883537,10883538,10883539,10883540,10883541,10883542,10883543,10883544,10883545,10883546,10883547,10883548,10883549,10883550,10883551,10883552,10161853,10161854,10161855,10161856,10161857,10161858,10161859,10161860,10647401,10647402,10647403,10647404,10647405,10647406,10647407,10647408,10647409,10647410,10647411,10647412,10647413,10647414,10647415,10647416,10647417,10647418,10650733,10650741,10650819,10650820,10507625,10410952,10410960,10410962,10410965,10410970,10410971,10410972,10410973,10410974,10410975,10410976,10410977,10410978,10410979,10410980,10410981,10410982,10410983,10410984,10410985,10410986,10410987,10410988,10410989,10410990,10410991,10410992,10410993,10410994,10410995,10410996,10410997,10410998,10410999,10411000,10411001,10411002,10411003,10411004,10411005,10411006,10411007,10411008,10411009,10411010,10411011,10411012,10411013,10411014) 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'