id | language | title | menu_title | slug | path | has_url_overwrite | redirect | meta_description | page_title | page_id | creation_date | published | publisher_is_draft | publisher_public_id | publisher_state
----+----------+-----------+------------+-----------+-----------------------+-------------------+----------+------------------+------------+---------+----------------------------+-----------+--------------------+---------------------+-----------------
1 | en | Home | | home | | f | | | | 1 | 2015-10-06 10:04:26.317+00 | t | t | 2 | 0
2 | en | Home | | home | | f | | | | 2 | 2015-10-06 10:04:26.317+00 | t | f | 1 | 0
3 | en | Core | | snappy | snappy | f | | | | 3 | 2015-10-06 10:04:26.317+00 | t | t | 4 | 0
4 | en | Core | | snappy | snappy | f | | | | 4 | 2015-10-06 10:04:26.317+00 | t | f | 3 | 1
5 | en | Guides | | guides | snappy/guides | f | | | | 5 | 2015-10-06 10:04:26.317+00 | t | t | 6 | 0
6 | en | Guides | | guides | snappy/guides | f | | | | 6 | 2015-10-06 10:04:26.317+00 | t | f | 5 | 1
7 | en | Devel | | devel | snappy/guides/devel | f | | | | 7 | 2015-10-06 10:04:26.317+00 | t | t | 8 | 0
8 | en | Devel | | devel | snappy/guides/devel | f | | | | 8 | 2015-10-06 10:04:26.317+00 | t | f | 7 | 1
9 | en | Current | | current | snappy/guides/current | f | | | | 9 | 2015-10-06 10:04:26.317+00 | t | t | 10 | 0
10 | en | Current | | current | snappy/guides/current | f | | | | 10 | 2015-10-06 10:04:26.317+00 | t | f | 9 | 1
11 | en | Snapcraft | | snapcraft | snappy/snapcraft | f | | | | 11 | 2015-10-06 10:04:26.317+00 | t | t | 12 | 0
12 | en | Snapcraft | | snapcraft | snappy/snapcraft | f | | | | 12 | 2015-10-06 10:04:26.317+00 | t | f | 11 | 1
(12 rows)