Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Villages]]
SQL Query
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 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1895)
AND 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
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 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1895)
AND 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
SQL Explain
Limit (cost=89.96..90.12 rows=8 width=79)
└── Unique (cost=88.96..90.12 rows=58 width=79)
└── Sort (cost=88.96..89.10 rows=58 width=79)
Sort Key: t0.smw_sort, t0.smw_id, t0.smw_title, t0.smw_namespace, t0.smw_iw, t0.smw_subobject, t0.smw_sortkey
└── Hash Join (cost=9.24..87.26 rows=58 width=79)
Hash Cond: (t0.smw_id = t1.s_id)
└── Seq Scan on smw_object_ids t0 (cost=0.00..70.88 rows=1049 width=79)
Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text) AND (smw_iw <> ':smw-redi'::text))
└── Hash (cost=8.49..8.49 rows=60 width=4)
└── Bitmap Heap Scan on smw_fpt_inst t1 (cost=4.74..8.49 rows=60 width=4)
Recheck Cond: (o_id = 1895)
└── Bitmap Index Scan on smw_fpt_inst_indexpo (cost=0.00..4.73 rows=60 width=0)
Index Cond: (o_id = 1895)
└── Unique (cost=88.96..90.12 rows=58 width=79)
└── Sort (cost=88.96..89.10 rows=58 width=79)
Sort Key: t0.smw_sort, t0.smw_id, t0.smw_title, t0.smw_namespace, t0.smw_iw, t0.smw_subobject, t0.smw_sortkey
└── Hash Join (cost=9.24..87.26 rows=58 width=79)
Hash Cond: (t0.smw_id = t1.s_id)
└── Seq Scan on smw_object_ids t0 (cost=0.00..70.88 rows=1049 width=79)
Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text) AND (smw_iw <> ':smw-redi'::text))
└── Hash (cost=8.49..8.49 rows=60 width=4)
└── Bitmap Heap Scan on smw_fpt_inst t1 (cost=4.74..8.49 rows=60 width=4)
Recheck Cond: (o_id = 1895)
└── Bitmap Index Scan on smw_fpt_inst_indexpo (cost=0.00..4.73 rows=60 width=0)
Index Cond: (o_id = 1895)
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneVillage | Name | Description | Location |
---|---|---|---|
Village:SUWS | SUWS | Village for the southampton university wireless society and friends | |
Village:Swiss Village | Swiss Village | Some visitors from Switzerland | |
Village:Symbiosis | Symbiosis | Not a village, but an installation. | |
Village:Sympathe | Sympathe | Tea and Sympathy Join us for a tisane (a caffeine free herbal infusion). Tonight's (Saturday) infusion is lemon and ginger tea. | |
Village:The Hacking Hamlet | The Hacking Hamlet | It's too small to be a village, so it's a hamlet where we'll be building, tinkering and wiring stuff up. | |
Village:The Maths Village | The Maths Village | At this village we will do maths. | |
Village:The Northern Quarter | The Northern Quarter | A village where the North East and Cumbria makers will be gathering. It is not in the north and is not a quarter, but you know how names stick. | |
Village:The Reckless Engineers | The Reckless Engineers | Not just a film, more a way of life. | |
Village:Threat-centric | Threat-centric | A place to discuss infosec related activities... may include a dedicated talks track | |
Village:West London Hackers | West London Hackers | A group of hackers from west London, along with friends and family from further afield |