xref: /template/strap/db/combo/update0019.sql (revision 4cadd4f8c541149bdda95f080e38a6d4e3a640ca)

create view IF NOT EXISTS PAGE_REFERENCES_VW as
select
    p.path as referent_path,
    pr.reference as reference_path
from
    page_references pr
        inner join pages p on pr.page_id = p.page_id;