error 892|SELECT *,count(*) as g_merge,
GROUP_CONCAT(DISTINCT a.angebot_uid order by a.angebot_extern,a.angebot_uid SEPARATOR ",") as g_angebot_uids,
GROUP_CONCAT(DISTINCT a.metatarif order by a.angebot_extern,a.angebot_uid SEPARATOR ",") as g_tarif_uids,
GROUP_CONCAT(DISTINCT a.inklusive_icon order by a.angebot_extern,a.angebot_uid SEPARATOR "|") as g_inklusive_icon,
GROUP_CONCAT(DISTINCT a.inklusive_stoerer order by a.angebot_extern,a.angebot_uid SEPARATOR "|") as g_inklusive_stoerer,
GROUP_CONCAT(DISTINCT a.highlights order by a.angebot_extern,a.angebot_uid SEPARATOR "|") as g_highlights,
GROUP_CONCAT(DISTINCT a.angebot_extern order by a.angebot_extern,a.angebot_uid SEPARATOR "|") as g_angebot_extern,
MIN(NULLIF(a.preiskategorie_i_minprice, 0)) as preiskategorie_i_minprice,
MIN(NULLIF(a.preiskategorie_a_minprice, 0)) as preiskategorie_a_minprice,
MIN(NULLIF(a.preiskategorie_b_minprice, 0)) as preiskategorie_b_minprice,
MIN(NULLIF(a.preiskategorie_s_minprice, 0)) as preiskategorie_s_minprice,
MIN(NULLIF(a.preiskategorie_fb_minprice, 0)) as preiskategorie_fb_minprice,
MIN(NULLIF(a.preiskategorie_minprice, 0)) as preiskategorie_minprice
FROM asr_shadow_angebote as a
WHERE FIND_IN_SET(598, route_haefen) AND FIND_IN_SET(74, route_country) AND (a.quelle='asr'
)
AND a.preiskategorie_minprice > 0
AND a.routenzeitraum_startdate > '1781283599'
GROUP BY a.schiff_uid,a.routenzeitraum_startdate_d,a.routenzeitraum_enddate_d
ORDER BY min((a.preiskategorie_all_minprice)) asc
error
query