gharris999 wrote: > Code: > -------------------- > > SELECT COUNT( DISTINCT( track_2.id ) ) FROM genres me > LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id ) > JOIN tracks track ON ( track.id = genreTracks.track ) > LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track > = track.id ) > JOIN contributors contributor ON ( contributor.id = > contributorTracks.contributor ) > LEFT JOIN contributor_track contributorTracks_2 ON ( > contributorTracks_2.contributor = contributor.id ) > JOIN tracks track_2 ON ( track_2.id = contributorTracks_2.track ) > WHERE ( ( ( ( ( contributorTracks.role IN ( '1', '5' ) ) > AND ( me.id = '7' ) ) ) ) ); > --------------------
I ran this on the slimserver DB from phpMyAdmin and got the following result: Showing rows 0 - 0 (1 total, Query took 1.5777 sec) COUNT( DISTINCT ( track_2 . id ) ): 2010 I then looked in genres and chose one that had a lot of tracks - Rock in my case: Showing rows 0 - 0 (1 total, Query took 37.2680 sec) COUNT( DISTINCT ( track_2 . id ) ): 7518 Hmmm. Something definitely not right there. R. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
