SELECT notat.id, notat.notation, (SELECT COUNT(music.id)
FROM catalogue_music AS music
WHERE music.not_neu_1 LIKE CONCAT(notat.id, "%") OR
music.not_neu_2 LIKE CONCAT(notat.id, "%") OR
music.not_neu_3 LIKE CONCAT(notat.id, "%") OR
music.not_neu_4 LIKE CONCAT(notat.id, "%") OR
music.not_neu_5 LIKE CONCAT(notat.id, "%")
) AS anzahl
FROM catalogue_music_notation AS notat
WHERE (notat.id REGEXP "^L 102 ?[0-9]$")
AND (SELECT COUNT(music.id)
FROM catalogue_music AS music
WHERE music.not_neu_1 LIKE CONCAT(notat.id, "%") OR
music.not_neu_2 LIKE CONCAT(notat.id, "%") OR
music.not_neu_3 LIKE CONCAT(notat.id, "%") OR
music.not_neu_4 LIKE CONCAT(notat.id, "%") OR
music.not_neu_5 LIKE CONCAT(notat.id, "%")
) > 0
ORDER BY notat.notation SELECT DISTINCT `notat`.`id`, `notat`.`notation`, `notat`.`prefix`, `notat`.`suffix`, COUNT(music.id) AS `anzahl` FROM `catalogue_music_notation` AS `notat`
LEFT JOIN `catalogue_music` AS `music` ON music.not_neu_1 = "L 102" OR
music.not_neu_2 = "L 102" OR
music.not_neu_3 = "L 102" OR
music.not_neu_4 = "L 102" OR
music.not_neu_5 = "L 102" WHERE (notat.id = ('L 102')) GROUP BY `notat`.`id` LIMIT 1Nach oben springen