Chamber 58 · Fractured Transept

Integrity Rite

JOIN + NULL + IN

INNER JOINNULLIN+360 XP

Locked

Clear the previous chamber to unlock this one. You can still preview the briefing.

Briefing

Only relics with a real shrine assignment and wings in East or West pass the integrity rite.

Return relic name and shrine wing for relics with non-null shrine_id on shrines where wing IN ('East', 'West'), ordered by relic name.

INNER JOIN shrines, shrine_id IS NOT NULL, wing IN ('East', 'West'), ORDER BY relics.name.

Chamber schema

relics3 cols

Cathedral relics and shrine links

idnameshrine_id

shrines2 cols

Shrines by wing

idwing

chamber_58.sql

Results appear here after you run a query. Correct rows alone are not enough — the Warden must seal your loot.

Ask the Warden

AI SQL coach — hints and fail reviews, not spoilers

Warden

I am the Warden. Ask for a hint, paste a failing query, or request a review — I won't hand you the full answer.