Changes between Version 2 and Version 3 of UserBrowsesStoriesByGenre

Timestamp:

08/24/26 16:15:15 (13 days ago)

Author:

211099

Comment:

--

UserBrowsesStoriesByGenre

@@ -2 +2 @@
 
 === Actor: **Regular User / Guest User**
+
 A user browses the platform filtering published stories by a specific genre to discover new content.
 
@@ -8 +9 @@
 **2.** The system retrieves and displays all available genres.
 {{{#!sql
-SELECT g.genre_id, g.name, COUNT(hg.story_id) AS total_stories
+SELECT g.genre_id, g.genre_name, COUNT(hg.story_id) AS total_stories
 FROM GENRE g
 LEFT JOIN HAS_GENRE hg ON g.genre_id = hg.genre_id
@@ -27 +28 @@
 JOIN GENRE g ON hg.genre_id = g.genre_id
 JOIN USERS u ON s.user_id = u.user_id
-JOIN STATUS st ON s.story_id = st.story_id
 LEFT JOIN LIKES l ON s.story_id = l.story_id
 LEFT JOIN COMMENT c ON s.story_id = c.story_id
-WHERE g.name = 'Fantasy' AND st.status = 'published'
+WHERE g.genre_name = 'Fantasy' AND s.status = 'published'
 GROUP BY s.story_id, u.username
 ORDER BY total_likes DESC;