Musikalien-Katalog

Kategorie: Werke einzelner Komponisten

Diese Kategorie enthält 37 Titel.

Diese Kategorie enthält keine weiteren Unterkategorien.

Zur Oberkategorie: Gitarre oder Laute solo

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