Demo:Location

Debug output SQLStore

ASK Query

[[Has Location::+]]

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_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id=4611)
  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
  0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, p_id, s_id_2, s_id_3	p_id	4	const	5		Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	my_wiki.t1.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:1

Errors and Warnings

None

Has Location	Has population
Taipei	2,553,798
Jakarta	10,562,088
Taiwan	23,451,837
Indonesia	270,203,917

Has Location	Has population
Bali
Indonesia	270,203,917
Jakarta	10,562,088
Taipei	2,553,798
Taiwan	23,451,837

More Text

asdfafdsa

Some Text in between

	Has Location	Has population
Bali	Bali
Indonesia	Indonesia	270,203,917
Jakarta	Jakarta	10,562,088
Taipei	Taipei	2,553,798
Taiwan	Taiwan	23,451,837

Pie Chart

Has Location	Has population
Bali
Indonesia	270,203,917
Jakarta	10,562,088
Taipei	2,553,798
Taiwan	23,451,837

Second Chart

Has Location	Has population
Taipei	2,553,798
Jakarta	10,562,088
Taiwan	23,451,837
Indonesia	270,203,917