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
25
OFFSET
20
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 | 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
NoneName | 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 |