Semantic search

[[Category:Equipment]]

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
  55
OFFSET
  50

Limit  (cost=1820.09..1820.22 rows=55 width=86)
  └──   Sort  (cost=1819.96..1836.26 rows=6521 width=86)
        Sort Key: t0.smw_sort
        └──   HashAggregate  (cost=1503.23..1568.44 rows=6521 width=86)
              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=932.88..1199.78 rows=17340 width=86)
                    Merge Cond: (t1.o_id = t2.id)
                    └──   Sort  (cost=753.10..756.50 rows=1360 width=90)
                          Sort Key: t1.o_id
                          └──   Hash Join  (cost=42.99..682.31 rows=1360 width=90)
                                Hash Cond: (t0.smw_id = t1.s_id)
                                └──   Seq Scan on smw_object_ids t0  (cost=0.00..560.51 rows=6521 width=86)
                                      Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text) AND (smw_iw <> ':smw-redi'::text))
                                └──   Hash  (cost=23.55..23.55 rows=1555 width=8)
                                      └──   Seq Scan on smw_fpt_inst t1  (cost=0.00..23.55 rows=1555 width=8)
                    └──   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)