Semantic search
Jump to navigation
Jump to search
Query-Depth:0
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
55
OFFSET
150
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
55
OFFSET
150
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | 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:1Query-Depth:0
Errors and Warnings
None| Name | Address | Country | State | City | Coordinate | LocalChapter | EmailThis property is a special property in this wiki. | Website | |
|---|---|---|---|---|---|---|---|---|---|
| Blow | |||||||||
| BlueOrange | Cheng Lan | Edmonton, Canada | 53° 30' 0.00" N, 113° 24' 0.00" W | ||||||
| Bluecoder1 | Siddarth Peddi | United States | New Jersey | South Brunswick | 40° 22' 50.52" N, 74° 31' 54.12" W | ||||
| Bob Bruce | Bob Bruce | Winnipeg, Manitoba | 49° 51' 38.02" N, 97° 6' 17.60" W | ||||||
| Bob Bruce | |||||||||
| Bogdan Grama | Bogdan Grama | Bucharest, Romania | Romania | Bucharest | 44° 25' 4.86" N, 26° 8' 32.02" E | Romanian | https://ro.linkedin.com/in/bogdan-grama-56a2a99 | ||
| Bogzab | |||||||||
| Bolosig | Wladimir Szczerban | Barcelona, Spain | 41° 22' 48.00" N, 2° 10' 48.00" E | ||||||
| Boonen | Jan Boonen | The Netherlands | Tilburg | 51° 33' 39.95" N, 5° 3' 24.35" E | Dutch | janboonen5@gmail.com | https://www.linkedin.com/in/janboonen/ | ||
| Borysiasty | Borys Jurgiel | Poland | Warsaw | 52° 16' 52.32" N, 20° 57' 2.52" E | Poland | http://www.borysjurgiel.pl | |||
| Bpuls52 | Brandon Puls | United States | Iowa | Cedar Rapids | 42° 1' 28.85" N, 91° 40' 49.80" W | ||||
| Brandon Whitehead | Brandon Whitehead | Aotearoa New Zealand | Palmerston North | 40° 23' 18.89" S, 175° 37' 7.04" E | Oceania | brandonnodnarb@gmail.com | |||
| Brendan Harmon | Brendan | College of Design, 50 Pullen Rd | USA | NC | Raleigh | 35° 47' 4.04" N, 78° 39' 53.55" W | North America | brendan.harmon@gmail.com | http://baharmon@github.io |
| Brent Wood | |||||||||
| Brent Wood | pcreso | Wainuiomata, New Zealand | 41° 16' 55.20" S, 174° 58' 8.40" E | ||||||
| Brfr | Frank Broniewski (Metrico) | Niederdonven | 49° 38' 7.80" N, 6° 24' 14.04" E | ||||||
| Brian H Wilson | Brian Wilson | California | Cotati | 38° 19' 56.19" N, 122° 41' 35.55" W | California Chapter | brian@wildsong.biz | http://wildsong.biz | ||
| Brian Hamlin | Brian M Hamlin | USA | CA | Berkeley | 37° 53' 9.60" N, 122° 14' 42.00" W | California Chapter | http://blog.light42.com | ||
| Brianrusso | |||||||||
| Bruce Carvalho | |||||||||
| Brucepc | Bruce Pinheiro de Carvalho | Manaus, Brasil | 3° 6' 22.57" S, 60° 1' 22.69" W | ||||||
| Bsolanki | Bhupendra Solanki | Indian Institute of Technology, Bombay, Mumbai, Maharashtra | India | Maharashtra | Mumbai | 19° 8' 0.24" N, 72° 54' 47.88" E | India | ||
| CHANON | |||||||||
| Cameron Green | Cameron Green | South Africa | Pretoria | 25° 45' 16.20" S, 28° 13' 53.04" E | Africa Local Chapter | cameron.green@tuks.co.za | http://camgreen.co.za | ||
| Camerons | Cameron Shorter | Australia | NSW | Sydney | 33° 51' 25.93" S, 151° 12' 53.42" E | Aust-NZ | http://cameronshorter.blogspot.com/ | ||
| Candan Eylul Kilsedar | Candan Eylül Kilsedar | via Enrico Fermi, 2749 | Italiano | Ispra (VA) | 45° 48' 3.42" N, 8° 37' 41.63" E | candan.kilsedar@ext.ec.europa.eu | |||
| Carlos Krefft | |||||||||
| Carmen Tawalika | |||||||||
| Carolina Arias | Carolina Arias Munoz | Italiano | 45° 48' 53.28" N, 8° 36' 46.58" E | Sudamerica | carolina.arias.munoz@gmail.com | https://it.linkedin.com/in/krolinarias | |||
| Cassu | Antti Castrén | Espoo, Finland | 60° 9' 3.26" N, 24° 41' 1.73" E | ||||||
| Cayetano Benavent | Cayetano Benavent | Spain | Sevilla | 37° 21' 0.00" N, 5° 58' 48.00" W | Capítulo Local de la comunidad hispano-hablante | cayetano@carto.com | https://github.com/cayetanobv | ||
| Cayetanobv | Cayetano Benavent | Seville, Spain | 37° 21' 0.00" N, 5° 58' 48.00" W | ||||||
| Cderunz | Cyril de Runz | Reims, France | 49° 15' 46.01" N, 4° 2' 4.99" E | ||||||
| Chaedri | Caitlin Haedrich | USA | NC | Raleigh | 35° 47' 7.08" N, 78° 40' 30.00" W | North America | chaedri@ncsu.edu | https://chaedri.github.io/ | |
| Chaitanya | Chaitanya Kumar CH | Bengaluru,India | 13° 2' 12.45" N, 77° 31' 52.39" E | ||||||
| Channah | Craig Hannah | Simsbury, USA | 41° 52' 41.26" N, 72° 47' 58.23" W | ||||||
| Charles Burnett | |||||||||
| Charlie Schweik | |||||||||
| Chavis.K | Chavis Krittanai | Thailand | Bangkok | 13° 45' 4.68" N, 100° 29' 22.56" E | |||||
| Chen Su | |||||||||
| Chetanm | Chetan Mahajan | Indian Institute of Technology Bombay, Mumbai | India | Maharashtra | Mumbai | 19° 7' 59.16" N, 72° 54' 54.36" E | India | chetan.mahajaniitb@gmail.com | |
| Chingchai | Chingchai Humhong | Naresuan University, Phitsanulok, Thailand | Thailand | Phitsanulok, Thailand | Mueang Phitsanulok | 16° 44' 45.81" N, 100° 11' 44.76" E | Thai | chingchai.h@gmail.com | https://gistnu.wordpress.com/ |
| Chiossif | Christos 'Chiossif' Iosifidis | Greece | Athens | 37° 58' 40.09" N, 23° 47' 4.62" E | Greek | http://users.ntua.gr/chiossif/index-en.html | |||
| Chouse | |||||||||
| Chris Schmidt | |||||||||
| Ckuntzsch | Christian Kuntzsch | Potsdam, Germany | Germany | Potsdam | 52° 23' 26.05" N, 13° 3' 52.10" E | FOSSGIS e.V. | http://christian.kuntzsch.me/ | ||
| Clara | Clara Tattoni | Trento, Italy | 46° 3' 59.76" N, 11° 7' 12.00" E | ||||||
| Clara Tattoni | |||||||||
| Claudia Engel | |||||||||
| Claudia Engel | Cengel | Stanford, USA | 37° 25' 36.64" N, 122° 10' 10.36" W |