Fehlende Daten in einer Zelle bei SELECT

[Philipp F]

SELECT literature.*,
GROUP_CONCAT(DISTINCT AUTOR ORDER BY POSITION SEPARATOR ' & ') AS AUTORS,
GROUP_CONCAT(DISTINCT CONCAT_WS(' ', species.SPECIES_GENUS, species.SPECIES_SPECIES) SEPARATOR ', ') AS DESCRIBED_SPECIES, // <-- Hier fehlt manchmal was
GROUP_CONCAT(DISTINCT IFNULL(genusLit.GENUS, '') SEPARATOR ', ') AS DESCRIBED_GENUS,
GROUP_CONCAT(DISTINCT CONCAT_WS(' ', species_ref.SPECIES_GENUS, species_ref.SPECIES_SPECIES) SEPARATOR ', ') AS NOV_SPECIES,
GROUP_CONCAT(DISTINCT IFNULL(genus_gref.GENUS, '') SEPARATOR ', ') AS NOV_GENUS,
GROUP_CONCAT(DISTINCT IFNULL(genus_fref.FAMILY, '') SEPARATOR ', ') AS NOV_FAMILY
FROM literature JOIN autorLit
ON autorLit.LITERATURE_ID = literature.ID
LEFT JOIN (speciesLit JOIN species ON speciesLit.SPECIES_ID = species.ID)
ON speciesLit.LITERATURE_ID = literature.ID
LEFT JOIN genusLit
ON genusLit.LITERATURE_ID = literature.ID
LEFT JOIN species AS species_ref
ON species_ref.ORIGINAL_DESCRIPTION_SPECIES_REF = literature.ID
LEFT JOIN genus AS genus_gref
ON genus_gref.ORIGINAL_DESCRIPTION_GENUS_REF = literature.ID
LEFT JOIN genus AS genus_fref
ON genus_fref.ORIGINAL_DESCRIPTION_FAMILY_REF = literature.ID
GROUP BY literature.ID
ORDER BY AUTORS, YEAR;

Diese Abfrage wird verwendet um eine neue Tabelle zu erstellen. Das Problem dabei ist, dass bei DESCRIBED_SPECIES irgendwann einmal der letzte TEil abgeschnitten wird:

Atelomycterus marmoratus, Atelomycterus macleayi, Atelomycterus sp., Aulohalaelurus labiosus, Schroederichthys bivius, Schroederichthys chilensis, Schroederichthys maculatus, Schroederichthys tenuis, Cephaloscyllium fasciatum, Cephaloscyllium isabellum, Cephaloscyllium laticeps, Cephaloscyllium nascione, Cephaloscyllium silasi, Cephaloscyl
statt:
Atelomycterus marmoratus, Atelomycterus macleayi, Atelomycterus sp., Aulohalaelurus labiosus, Schroederichthys bivius, Schroederichthys chilensis, Schroederichthys maculatus, Schroederichthys tenuis, Cephaloscyllium fasciatum, Cephaloscyllium isabellum, Cephaloscyllium laticeps, Cephaloscyllium nascione, Cephaloscyllium silasi, Cephaloscyllium sufflans, Cephaloscyllium ventriosum, Poroderma africanum, Poroderma pantherinum, Scyliorhinus besnardi, Scyliorhinus boa, Scyliorhinus canicula, Scyliorhinus capensis, Scyliorhinus cervigoni, Scyliorhinus garmani, Scyliorhinus haeckeli, Scyliorhinus hesperius, Scyliorhinus meadi, Scyliorhinus retifer, Scyliorhinus stellaris, Scyliorhinus torazame, Scyliorhinus torrei, Asymbolus analis, Asymbolus vincenti, Cephalurus cephalus, Galeus atlanticus, Galeus arae, Galeus boardmani, Galeus eastmani, Galeus melastomus, Galeus murinus, Galeus nipponensis, Galeus piperatus, Galeus polli, Galeus sauteri, Galeus schultzi, Halaelurus boesemani, Halaelurus buergeri, Halaelurus canesc

wenn man allerdings nun ein WHERE literature.ID = <ID des fehlerhaften Eintrags> anhängt, funktioniert es problemlos