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
500
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
500
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 | |
|---|---|---|---|---|---|---|---|---|---|
| Jeroen Ticheler | Jeroen Ticheler | Veenderweg 13 | The Netherlands | Gelderland | 6721WD Bennekom | 51° 59' 57.48" N, 5° 40' 25.32" E | Nederlands | jeroen.ticheler@geocat.net | |
| Jerome Jacovella-St-Louis | Jérôme Jacovella-St-Louis | 347 rue Docteur-J.-Cousineau | Canada | Québec | Gatineau | 45° 28' 35.40" N, 75° 42' 4.68" W | Ottawa Chapter | jerome@ecere.com | http://ecere.ca/ |
| JessJ | |||||||||
| Jezierski Maciej | |||||||||
| Jgcasta | Jose Gomez Castaño | Madrid | 40° 18' 0.00" N, 3° 45' 0.00" W | ||||||
| Jgcasta | |||||||||
| Jgrocha | Jorge Gustavo Rocha | Rua Afonso Palmeira, 31 | Portugal | Braga | 40° 36' 43.67" N, 8° 45' 3.96" W | Portugal | jgr@geomaster.pt | ||
| Jidanni | |||||||||
| Jim Strevinas | Jim Strevinas | Chania, Greece | 35° 30' 28.80" N, 24° 2' 2.40" E | ||||||
| Jim Strevinas | |||||||||
| Jive | Jody Garnett | Canada | Victoria | 48° 25' 42.00" N, 123° 21' 53.74" W | British Columbia Chapter | jody.garnett@how2map.com | https://how2map.com/ | ||
| Jjesus | Jorge Samuel Mendes de Jesus | The Netherlands | Gelderland | Wageningen | 51° 58' 22.51" N, 5° 40' 15.53" E | jorge.mendesdejesus@isric.org | |||
| Jjkirkendall | Deleted | ||||||||
| Jjquispe | |||||||||
| Jlevente | |||||||||
| Jmejugon | |||||||||
| Jmejugon | Javier Mejuto González | Madrid | 40° 24' 0.00" N, 3° 40' 48.00" W | ||||||
| JoCook | Jo Cook | UK | 51° 19' 57.49" N, 0° 16' 19.10" W | OSGeo UK https://uk.osgeo.org | |||||
| JoWalsh | |||||||||
| Jochen Albrecht | |||||||||
| Joe Larson | |||||||||
| Johannes Wilden | |||||||||
| Johanvdw | Johan Van de Wauw | Belgium | Ghent | 51° 2' 59.14" N, 3° 43' 55.71" E | Belgium | http://blog.gisky.be/ | |||
| John Bryant | John Bryant | Australia | WA | Fremantle | 32° 3' 45.50" S, 115° 45' 33.14" E | Oceania | johnwbryant@gmail.com | https://mammothgeospatial.com | |
| John Callahan | |||||||||
| John McMorran | |||||||||
| John Tate | |||||||||
| John.Zastrow | Portland_Maine_USA | Portland, ME | 43° 41' 48.62" N, 70° 15' 31.26" W | ||||||
| John.t | John Tate | Bristol, UK | 51° 27' 36.00" N, 2° 36' 0.00" W | ||||||
| Jonahsullivan | Jonah Sullivan | Australia | Oceania | ||||||
| Jonaseberle | Jonas Eberle | Germany | Bavaria | Munich | 50° 55' 35.04" N, 11° 35' 16.44" E | FOSSGIS e.V. | jonas.eberle@gmx.de | ||
| Jonathan Hardiman | Nightmooneagle | Melbourne, Australia | 37° 49' 12.00" S, 144° 58' 12.00" E | ||||||
| Jonathan Hardiman | |||||||||
| Jorge Sanz | Jorge Sanz | Spain | Valencia | València | 39° 28' 12.00" N, 0° 22' 33.60" W | Capítulo Local de la comunidad hispano-hablante | jorge@jorgesanz.net | http://jorgesanz.net | |
| Jose Manuel Mira | |||||||||
| Jose Paredes | |||||||||
| Jose Tomas Navarro | |||||||||
| Josetomas | Jose Tomas Navarro Carrion | El Campello, Alicante, Spain | 38° 24' 41.42" N, 0° 24' 19.95" W | ||||||
| Joxta | Pintea Fabian Vladimir | Romania | Neamt | Roman | 46° 55' 49.36" N, 26° 55' 39.85" E | Romanian | |||
| João Gaspar | |||||||||
| Jparedesg | Jose Paredes | near Campeche, Mexico | 19° 20' 52.08" N, 90° 43' 46.20" W | ||||||
| Jpreciado | Julio Preciado | México D.F. | 41° 22' 48.00" N, 2° 10' 48.00" E | ||||||
| Jripolles | Juanjo Ripollés | Valencia, Spain | 39° 27' 22.32" N, 0° 22' 33.96" W | ||||||
| Jrosenthal | Josh Rosenthal | United States | MA | Boston | 42° 21' 30.35" N, 71° 3' 35.17" W | North America | |||
| Jsanz | Jorge Sanz | Spain | Valencia | València | 39° 28' 12.00" N, 0° 22' 33.60" W | Capítulo Local de la comunidad hispano-hablante | jorge@jorgesanz.net | http://jorgesanz.net | |
| Jsenag | J Sena | Spain | Barcelona | 41° 22' 56.68" N, 2° 10' 38.06" E | jessisena@gmail.com | https://github.com/jessisena | |||
| Jsonnentag | Jeffrey Sonnentag | Redlands, CA | 34° 3' 41.35" N, 117° 13' 8.36" W | ||||||
| Jtmapmedia | Jörg Thomsen | Germany | Berlin | Berlin | 52° 28' 27.84" N, 13° 24' 7.92" E | FOSSGIS e.V. | joerg.thomsen@fossgis.de | ||
| Jtotton | Jarrett Totton | Norton, Canada | 45° 38' 42.89" N, 65° 47' 55.20" W | ||||||
| Juanluisrp | Juan Luis Rodríguez Ponce | Seville, Spain | 37° 22' 59.00" N, 5° 59' 47.00" W |