Date: 03/17/06 (MySQL Communtiy)    Keywords: no keywords

Why would this query below bring up more than 150 records?

SELECT Story.*, Author.Author, Author.Email, Rating.Rating FROM Rating, CharacterStory, Story LEFT JOIN AuthorStory ON AuthorStory.StoryID = Story.ID LEFT JOIN Author ON AuthorStory.AuthorID = Author.ID INNER JOIN Characters ON CharacterStory.StoryID = Story.ID WHERE CharacterStory.CharacterID = '1' and Author.Author BETWEEN 'C' and 'D' and Story.RatingID = Rating.ID and Story.Approved = 'Y' GROUP BY Story.ID ORDER BY Author.Author, Story.Title LIMIT 150, 300

Source: http://community.livejournal.com/mysql/89536.html