I broke 1,000 Episodes Today!!!
SELECT s.OriginalTitle as [TV Series], ((Iif(a.InfoValue <>'','[url='+a.InfoValue+']','')+Iif(ep.EpisodeOriginalTitle<>'', ep.EpisodeOriginalTitle, ep.EpisodeTitle)+Iif(a.InfoValue<>'','[/url]',''))) AS [Episode], DAY(e.EventTimeStamp) as [Watched on], "[mr]"+ i.InfoValue + "[/mr]" AS [Rating] FROM (((Episodes ep INNER JOIN Events e ON ep.EpisodeID=e.ProfileID) LEFT OUTER JOIN AdditionalInfo a ON (a.ProfileID=ep.EpisodeID AND a.InfoName='Review')) LEFT OUTER JOIN AdditionalInfo i ON (i.ProfileID=ep.EpisodeID AND i.InfoName='MyRating')) INNER JOIN TVSeries s ON (s.SeriesID=ep.SeriesID) WHERE e.EventType='Watched' AND e.UserID='Thomas' AND YEAR(e.EventTimeStamp)=2009 AND MONTH(e.EventTimeStamp)=$Month$ AND i.ProfileID=ep.EpisodeID ORDER BY e.EventTimeStamp ASC, ep.EpisodeNo ASC;$User$="SELECT UserID FROM Users ORDER BY UserID";$Month$="1|2|3|4|5|6|7|8|9|10|11|12"