Semantic search
Jump to navigation
Jump to search
Query-Depth:0
SQLStore debug output
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 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='21765')
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
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 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='21765')
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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 614 | Using index; Using temporary; Using filesort |
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
No auxilliary tables used.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 | |
---|---|---|---|---|---|---|---|---|---|
18ttruongk | Tri Truong | 13090 Magnolia St | United States | CA | Westminster | 33° 46' 12.00" N, 117° 58' 12.00" W | California Chapter | 18ttruongk@gmail.com | |
42islife | Vrishank Paladugu | 11 N 4th St, St. Louis | United States | Missouri | St.louis | 38° 37' 32.43" N, 90° 11' 21.39" W | http://www.osgeo.org | ||
A Pushpendra | A Pushpendra | India | Odisha | Bhubaneswar | 20° 17' 45.81" N, 85° 49' 28.34" E | India | |||
ADennison | Andrew_Dennison | Australia | 31° 56' 18.09" S, 115° 50' 33.41" E | ||||||
Aaime | Andrea Aime | Reggiolo | 44° 55' 12.00" N, 10° 48' 36.00" E | ||||||
Aanthieni | Ariel Anthieni | Argentina | CABA | CABA | 34° 37' 19.46" S, 58° 22' 37.70" W | Argentinia | aanthien@gmail.com | https://wiki.osgeo.org/wiki/User:Aanthieni | |
Abdiel | Abdiel Cruz Robaina | La Habana | 23° 7' 55.85" N, 82° 21' 31.72" W | ||||||
Abhinav Raj | Abhinav Raj | Gobaria Bawari | India | Rajasthan | Kota | 28° 1' 19.47" N, 73° 19' 9.38" E | |||
Aborrell | alex borrell | Zapopan, Mexico | 20° 40' 12.00" N, 103° 24' 36.00" W | ||||||
Aculver1405 | Tyler Culver | US | Wa | Vancouver | 45° 37' 54.48" N, 122° 40' 17.76" W | ||||
Adamhusain12 | Adam Husain | Oman | Muscat | 23° 30' 0.00" N, 58° 24' 0.00" E | |||||
Adesinausman | Adesina usman | Nigeria | Osun | Osogbo | 7° 45' 4.23" N, 4° 34' 4.77" E | Maxphelon@gmail.com | |||
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 |
Adityabhinge | Aditya Bhinge | hadapsar | India | maharashtra | pune | 18° 30' 3.57" N, 73° 56' 26.52" E | India | adityabhinge94@gmail.com | |
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 | ||||||
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 | ||||||
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 | |||
Aleda Freeman | Aleda Freeman | 1 Ashburton Pl. | USA | Massachusetts | Boston | 42° 21' 33.90" N, 71° 3' 44.30" W | aleda.freeman@mass.gov | http://www.mass.gov/mgis | |
Aleroux | Alexandre Leroux | Montréal, Canada | 45° 28' 48.00" N, 73° 47' 24.00" W | ||||||
Alex Gabriel | Alex Gabriel Santiago Gonzalez | Dominican Republic | Santo Domingo | 18° 29' 9.81" N, 69° 55' 52.36" W | |||||
Alexandre Leroux | Aleroux | Montréal, Canada | 45° 30' 0.00" N, 74° 36' 0.00" W | ||||||
Alexbruy | Alexander Bruy | Ukraine | Zaporizhzhya | 47° 24' 59.43" N, 35° 55' 22.69" E | Ukraine | ||||
Alexneto | Alexandre Neto | Cascais, Portugal | 38° 41' 50.17" N, 9° 25' 18.32" W | ||||||
Algci2017 | A. L. | 35° 12' 3.60" N, 91° 49' 54.48" W | |||||||
Alireza Kashian | |||||||||
All Members | |||||||||
Alrocar | Alberto Romeu | Valencia, Spain | 39° 28' 25.32" N, 0° 22' 50.16" W | ||||||
Altjira | Greg R Perry | Towanda, United States | 41° 50' 24.00" N, 76° 24' 0.00" W | ||||||
Aman | aman | India | jammu and kashmir | jammu | 33° 55' 12.00" N, 74° 14' 24.00" E | India | |||
Amercader | Adrià Mercader | Newcastle upon Tyne | 55° 0' 0.00" N, 1° 37' 12.00" W | ||||||
Ameyad22 | Ameya Deshmukh | Opp. Chanakyapuri, Shahnoormiya Dargah | India | Maharashtra | Aurangabad | 19° 51' 21.94" N, 75° 20' 33.63" E | India | ||
Amidacoder | Mimche Njikam Amida | Foumban, Cameroon | Cameroon | West | Foumban | 5° 43' 13.05" N, 10° 54' 3.37" E | Africa Local Chapter | amida.njikam@gmail.com | |
Amyonthemap | Feng Amy Gao | USA | Maryland | Potomac | 39° 1' 4.57" N, 77° 12' 34.04" W | North America | |||
Andres Herrera | AndresHerrera | Cali, Colombia | 3° 25' 17.68" N, 76° 30' 26.70" W | ||||||
AndresHerrera | Andres Herrera | Cali, Colombia | 76° 30' 26.70" S, 3° 25' 17.68" E | ||||||
Andrew Hunter | |||||||||
Andrewbell | Andrew Bell | Southampton | 50° 51' 0.00" N, 1° 15' 0.00" W | ||||||
Andy Anderson | Andy Anderson | Amherst College, Academic Technology Services | USA | Massachusetts | Amherst | 42° 22' 15.60" N, 72° 31' 1.20" W | North America | aanderson@amherst.edu | https://www.amherst.edu/people/facstaff/aanderson |
AneeshM | Aneesh Malepatal | USA | TX | plano | 33° 1' 11.28" N, 96° 41' 56.04" W | aneeshmalepatal@gmail.com | |||
Anguscarr | Angus Carr | Thunder Bay, Canada | 48° 24' 0.00" N, 89° 15' 36.00" W | ||||||
Anirudh | Anirudh | 17° 49' 41.12" N, 83° 21' 25.38" E | pathaneni.anirudh9@gmail.com | https://wiki.osgeo.org/wiki/User:Anirudh \ | |||||
Anis | Anis Harmel | Tunis, Tunisia | 36° 46' 51.60" N, 10° 10' 32.88" E | ||||||
Anish | Anish Joshi | Kathmandu, Nepal | 27° 39' 36.00" N, 85° 18' 36.00" E |