Semantic search
SQLStore debug output
ASK Query
[[Has event type::Meeting]] [[Has coordinates::50° 40' 58.34" N, 4° 22' 9.37" E (50 km)]]
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t2
INNER JOIN
`smw_di_coords` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='1344' AND t2.o_id='41620'
AND (
(t5.o_lat < '51.132533025182' AND t5.o_lat > '50.233211419263' AND t5.o_lon < '5.0789260125871' AND t5.o_lon > '3.6596128763018') AND t5.p_id='2791')
)
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
50
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t2
INNER JOIN
`smw_di_coords` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='1344' AND t2.o_id='41620'
AND (
(t5.o_lat < '51.132533025182' AND t5.o_lat > '50.233211419263' AND t5.o_lon < '5.0789260125871' AND t5.o_lon > '3.6596128763018') AND t5.p_id='2791')
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t5 | range | s_id,p_id,o_lat | o_lat | 9 | 557 | Using index condition; Using where; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | p_id | 8 | const,mediawiki_prod.t5.s_id | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki_prod.t5.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneHas coordinates | In city | |
---|---|---|
Crew BW/Meeting/10 08 2012 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/10 10 2014 | 50° 40' 6.36" N, 4° 36' 58.36" E | Louvain-la-Neuve |
Crew BW/Meeting/11 01 2013 | 50° 40' 27.01" N, 4° 36' 50.96" E | Louvain-la-Neuve |
Crew BW/Meeting/11 04 2014 | 50° 41' 1.68" N, 4° 22' 14.25" E | Braine-l'Alleud |
Crew BW/Meeting/11 05 2012 | 50° 40' 6.84" N, 4° 36' 57.90" E | Louvain-la-Neuve |
Crew BW/Meeting/11 07 2014 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/11 08 2017 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/11 11 2016 | 50° 40' 27.01" N, 4° 36' 50.96" E | Louvain-la-Neuve |
Crew BW/Meeting/12 04 2013 | 50° 40' 20.24" N, 4° 37' 24.58" E | Louvain-la-Neuve |
Crew BW/Meeting/12 05 2017 | 50° 39' 57.42" N, 4° 36' 40.16" E | Louvain-la-Neuve |
Crew BW/Meeting/12 06 2015 | 50° 40' 5.87" N, 4° 37' 10.22" E | Louvain-la-Neuve |
Crew BW/Meeting/12 07 2013 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/12 09 2014 | 50° 40' 6.36" N, 4° 36' 58.36" E | Louvain-la-Neuve |
Crew BW/Meeting/12 12 2014 | 50° 39' 53.47" N, 4° 36' 21.75" E | Louvain-la-Neuve |
Crew BW/Meeting/13 01 2017 | 50° 39' 57.42" N, 4° 36' 40.16" E | Louvain-la-Neuve |
Crew BW/Meeting/13 04 2018 | 50° 39' 53.47" N, 4° 36' 21.75" E | Louvain-la-Neuve |
Crew BW/Meeting/13 06 2014 | 50° 41' 4.88" N, 4° 22' 26.10" E | Braine-l'Alleud |
Crew BW/Meeting/13 07 2012 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/13 07 2018 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/13 09 2013 | 50° 40' 6.36" N, 4° 36' 58.36" E | Louvain-la-Neuve |
Crew BW/Meeting/14 02 2014 | 50° 40' 58.88" N, 4° 22' 11.49" E | Braine-l'Alleud |
Crew BW/Meeting/14 03 2014 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/14 06 2013 | 50° 41' 1.70" N, 4° 22' 19.46" E | Braine-l'Alleud |
Crew BW/Meeting/14 07 2017 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/14 11 2014 | 50° 39' 53.47" N, 4° 36' 21.75" E | Louvain-la-Neuve |
Crew BW/Meeting/14 12 2012 | 50° 40' 27.01" N, 4° 36' 50.96" E | Louvain-la-Neuve |
Crew BW/Meeting/14 12 2018 | 50° 39' 57.42" N, 4° 36' 40.16" E | Louvain-la-Neuve |
Crew BW/Meeting/15 05 2015 | 50° 40' 5.87" N, 4° 37' 10.22" E | Louvain-la-Neuve |
Crew BW/Meeting/15 10 2016 | 50° 40' 12.10" N, 4° 37' 2.41" E | Louvain-la-Neuve |
Crew BW/Meeting/15 12 2017 | 50° 39' 57.42" N, 4° 36' 40.16" E | Louvain-la-Neuve |
Crew BW/Meeting/17 03 2017 | 50° 39' 57.42" N, 4° 36' 40.16" E | Louvain-la-Neuve |
Crew BW/Meeting/17 04 2015 | 50° 40' 5.87" N, 4° 37' 10.22" E | Louvain-la-Neuve |
Crew BW/Meeting/18 10 2013 | 50° 41' 1.68" N, 4° 22' 14.25" E | Braine-l'Alleud |
Crew BW/Meeting/19 10 2012 | 50° 40' 20.24" N, 4° 37' 24.58" E | Louvain-la-Neuve |
Crew BW/Meeting/20 02 2015 | 50° 40' 27.01" N, 4° 36' 50.96" E | Louvain-la-Neuve |
Crew BW/Meeting/20 10 2017 | 50° 39' 57.42" N, 4° 36' 40.16" E | Louvain-la-Neuve |
Crew BW/Meeting/21 09 2012 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/24 08 2012 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/26 09 2012 | 50° 40' 24.01" N, 4° 37' 26.80" E | Louvain-la-Neuve |
Crew BW/Meeting/26 10 2012 | 50° 40' 24.01" N, 4° 37' 26.80" E | Louvain-la-Neuve |
Crew BW/Meeting/27 01 2013 | 50° 40' 20.24" N, 4° 37' 24.58" E | Louvain-la-Neuve |
Crew BW/Meeting/27 04 2012 | 50° 40' 6.80" N, 4° 36' 59.42" E | Louvain-la-Neuve |
Crew BW/Meeting/27 07 2012 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/29 06 2012 | 50° 40' 5.93" N, 4° 36' 44.90" E | Louvain-la-Neuve |
Crew BW/Meeting/31 08 2012 | 50° 41' 1.70" N, 4° 22' 19.46" E | Braine-l'Alleud |
Crew Brussels/Meeting/01 02 2012 | 50° 50' 37.22" N, 4° 22' 2.77" E | Brussels |
Crew Brussels/Meeting/02 11 2011 | 50° 50' 37.22" N, 4° 22' 2.77" E | Brussels |
Crew Brussels/Meeting/04 09 2012 | 50° 50' 37.22" N, 4° 22' 2.77" E | Brussels |
Crew Brussels/Meeting/07 08 2012 | 50° 50' 37.22" N, 4° 22' 2.77" E | Brussels |
Crew Brussels/Meeting/08 08 2012 | 50° 50' 29.62" N, 4° 23' 54.23" E | Etterbeek |