| | 1 | == User Removes a Story from a Reading List |
| | 2 | |
| | 3 | === Authors: **Regular User / Writer** |
| | 4 | A user removes a story from one of their reading lists. |
| | 5 | |
| | 6 | **1.** The user navigates to their reading list page. |
| | 7 | |
| | 8 | **2.** The system displays all stories in the selected reading list. |
| | 9 | {{{#!sql |
| | 10 | SELECT rli.story_id, s.short_description, rli.added_at |
| | 11 | FROM READING_LIST_ITEMS rli |
| | 12 | JOIN STORY s ON rli.story_id = s.story_id |
| | 13 | WHERE rli.list_id = 1 |
| | 14 | ORDER BY rli.added_at DESC; |
| | 15 | }}} |
| | 16 | |
| | 17 | **3.** The user selects a story and clicks "Remove from List". |
| | 18 | |
| | 19 | **4.** The system deletes the story from the reading list. |
| | 20 | {{{#!sql |
| | 21 | DELETE FROM READING_LIST_ITEMS |
| | 22 | WHERE list_id = 1 AND story_id = 1; |
| | 23 | }}} |
| | 24 | |
| | 25 | **5.** The system confirms removal and refreshes the reading list view. |