1create view IF NOT EXISTS PAGE_REFERENCES_VW as 2select 3 p.path as referent_path, 4 pr.reference as reference_path 5from 6 page_references pr 7 inner join pages p on pr.page_id = p.page_id; 8