Semantic search

[[Category:Settlements]]

SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  "smw_object_ids" AS t0
INNER JOIN
  ("smw_fpt_inst" AS t1
INNER JOIN
  "t2" AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
  t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  25
OFFSET
  50

Limit  (cost=691.44..691.51 rows=25 width=112)
  └──   Sort  (cost=691.32..694.60 rows=1314 width=112)
        Sort Key: t0.smw_sort
        └──   HashAggregate  (cost=630.69..643.83 rows=1314 width=112)
              Group Key: t0.smw_sort, t0.smw_id, t0.smw_title, t0.smw_namespace, t0.smw_iw, t0.smw_subobject, t0.smw_sortkey
              └──   Merge Join  (cost=353.47..483.20 rows=8428 width=112)
                    Merge Cond: (t1.o_id = t2.id)
                    └──   Sort  (cost=173.69..175.34 rows=661 width=116)
                          Sort Key: t1.o_id
                          └──   Hash Join  (cost=127.25..142.72 rows=661 width=116)
                                Hash Cond: (t1.s_id = t0.smw_id)
                                └──   Seq Scan on smw_fpt_inst t1  (cost=0.00..13.29 rows=829 width=8)
                                └──   Hash  (cost=110.82..110.82 rows=1314 width=112)
                                      └──   Seq Scan on smw_object_ids t0  (cost=0.00..110.82 rows=1314 width=112)
                                            Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text) AND (smw_iw <> ':smw-redi'::text))
                    └──   Sort  (cost=179.78..186.16 rows=2550 width=4)
                          Sort Key: t2.id
                          └──   Seq Scan on t2  (cost=0.00..35.50 rows=2550 width=4)