Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Category:OSGeo Member]]
 |?Name
 |?Address
 |?Country
 |?State
 |?City
 |?Coordinate
 |?LocalChapter
 |?Email
 |?Website
 |format=broadtable
 |limit=20
 |offset=20
 |sort=
 |order=asc
 |mainlabel=
 |searchlabel=Click here for a tabular overview
}}

Results 21 – 40 previous 20 20 50 100 250 500 next 20

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:OSGeo Member]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0324",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:OSGeo Member]]

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
`osgeo_smw_object_ids` AS t0
INNER JOIN
(`osgeo_smw_fpt_inst` AS t1
INNER JOIN
`osgeo_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
20

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t2	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	osgeo_wiki.t2.id	10	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	osgeo_wiki.t1.s_id	1	Using where

Auxilliary Tables

Temporary table t2
Recursively computed hierarchy for element(s) (21765).
SELECT s_id FROM `osgeo_smw_fpt_subc` WHERE o_id=21765 LIMIT 1

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

	Name	Address	Country	State	City	Coordinate	LocalChapter	EmailThis property is a special property in this wiki.	Website
Adiez	Agustín Diez Castillo		Spain		València	39° 40' 55.05" N, 0° 45' 55.59" W	Capítulo Local de la comunidad hispano-hablante
Adiez
Adik	Adrian Hassa		Polska	Śląskie	Tarnowskie Góry	50° 26' 56.76" N, 18° 52' 43.35" E	Poland
Aditi Sawant	Aditi Mohan Sawant	IIT Bombay, Powai, Mumbai	India	Maharashtra	Mumbai	19° 8' 16.07" N, 72° 54' 51.42" E	India	aditisawant007@gmail.com	https://wiki.osgeo.org/wiki/User:Aditi Sawant
Aditya Chondke	Aditya Chondke	Indian Institute of Technology Bombay	India	Maharashtra	Mumbai	19° 8' 3.79" N, 72° 54' 20.85" E	India	adityachondke96@gmail.com	https://wiki.osgeo.org/wiki/User:Aditya Chondke
Adityabhinge	Aditya Bhinge	hadapsar	India	maharashtra	pune	18° 30' 3.57" N, 73° 56' 26.52" E	India	adityabhinge94@gmail.com
Adrian Custer
Aemelchiori
Afabiani	Alessio Fabiani	Massarosa, Lucca, Italia	Italia		Massarosa	43° 52' 19.56" N, 10° 20' 14.64" E	Italiano		http://geo-solutions.it/
Afabiani	Alessio Fabiani	Massarosa, Lucca, Italia	Italia	Italia (ITA)	Massarosa	43° 52' 19.56" N, 10° 20' 14.64" E	Italiano	alessio.fabiani@geo-solutions.it	http://www.geo-solutions.it
Aggarwalmehak	Mehak Aggarwal		India	Haryana	Yamunanagar	23° 30' 0.00" N, 5° 13' 48.00" E	India
Aghisla	Anne Ghisla		Germany	Berlin	Berlin	52° 31' 1.33" N, 13° 23' 19.90" E	FOSSGIS e.V.
Ahendry	Ahendry	Edinburgh Office				55° 57' 18.00" N, 3° 13' 22.80" W
Ahocevar
Ahugenerd	St. Johns	St. Johns				47° 34' 41.52" N, 52° 42' 15.84" W
Ahunter	Andrew Hunter	Calgary, Canada				50° 54' 52.80" N, 114° 8' 0.00" W
Ajolma	Ari Jolma	Skinnarintie 12 H 20	Finland		Vantaa	60° 16' 1.20" N, 24° 47' 6.00" E	Finland (Board Member)		http://arijolma.org
Akotsev	Alexander Kotsev	Via E. Fermi, 2749 – TP 263 - 21027 Ispra (VA),	Italiano	VA	Ispra	45° 48' 36.00" N, 8° 37' 33.60" E		akotsev@gmail.com
Akotsev	Alexander Kotsev	Via E. Fermi, 2749 – TP 263 - 21027 Ispra (VA),	Italiano	VA	Ispra	45° 48' 36.00" N, 8° 37' 33.60" E		akotsev@gmail.com
Akshara	Akshara		United States of America	New Jersey	Harrison	40° 44' 47.40" N, 74° 9' 22.68" W	North America

Semantic search

Query log

Navigation menu

Search