Dies ist ein Test-Einleitungstext.
select count(*) from (select music_albums.*, music_album_categories.category, music_media_types.media_type, music_labels.label as musiclabel, music_genres.genre from music_albums left join music_album_categories on music_albums.album_category_id=music_album_categories.id left join music_media_types on music_albums.media_type_id=music_media_types.id left join music_labels on music_albums.label_id=music_labels.id left join music_genres on music_albums.genre_id=music_genres.id where music_albums.active = 1 order by IF(music_albums.sort_order IS NULL,1,0), music_albums.sort_order, music_albums.artist, music_albums.release_year, music_albums.title) as foo