[P4-2] Discovery Page — Tab Queries

[realproject7]

Context

Implement the data queries powering each discovery tab.

Sub-tickets

• P4-2a: Implement the "New" tab — query Supabase for recently created storylines, sorted by creation time descending. Exclude hidden = true.
• P4-2b: Implement the "Completed" tab — query for storylines where sunset = true, sorted by plot count or creation time.
• P4-2c: The "Trending" and "Rising" tabs depend on trading data from Phase 5. Create placeholder tabs that fall back to "New" ordering with a TODO note linking to P5-6.

Proposal Reference

§6.3 (Discovery)

Dependencies

P4-1 (layout), P0-2 (Supabase)

[realproject7]

Completed — merged via duplicate issue. Closing.