Musikalien-Katalog

Kategorie: Werke einzelner Komponisten für eine Singstimme mit Klavier

Diese Kategorie enthält 1144 Titel.

Diese Kategorie enthält keine weiteren Unterkategorien.

Zur Oberkategorie: Eine Singstimme mit Klavier


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 "^A 203 ?[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 = "A 203" OR music.not_neu_2 = "A 203" OR music.not_neu_3 = "A 203" OR music.not_neu_4 = "A 203" OR music.not_neu_5 = "A 203" WHERE (notat.id = ('A 203')) GROUP BY `notat`.`id` LIMIT 1
Nach oben springen