Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:postcode::EC1R 5HL]]
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_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='518'
AND (t4.p_id='523' AND t4.o_id='271210')
)
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
1
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_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='518'
AND (t4.p_id='523' AND t4.o_id='271210')
)
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
1
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 63 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | s_id | 4 | callto_wikidb.t4.s_id | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | callto_wikidb.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneCompanies:town | Companies:county | Has coordinates | |
---|---|---|---|
01206855407 | LONDON | 51° 54' 2.02" N, 0° 55' 46.52" E | |
01227833840 | LONDON | 51° 14' 42.00" N, 1° 7' 31.59" E | |
01268758487 | LONDON | 51° 33' 13.21" N, 0° 33' 17.75" E | |
01273645800 | LONDON | 50° 49' 29.22" N, 0° 8' 19.53" W | |
01332773333 | LONDON | 52° 53' 13.03" N, 1° 29' 9.22" W | |
01384457900 | LONDON | 52° 29' 42.15" N, 2° 5' 53.56" W | |
01438815492 | LONDON | 51° 49' 8.84" N, 0° 5' 51.80" W | |
01483273563 | 51° 8' 27.96" N, 0° 29' 24.18" W | ||
01494675402 | LONDON | 51° 37' 1.55" N, 0° 38' 55.07" W | |
01543672221 | LONDON | 52° 42' 25.07" N, 1° 55' 11.65" W | |
01604400388 | LONDON | 52° 15' 9.44" N, 0° 51' 0.48" W | |
01634717788 | LONDON | 51° 23' 49.28" N, 0° 30' 53.92" E | |
01637839542 | LONDON | 50° 26' 41.01" N, 5° 2' 21.74" W | |
01689859012 | 51° 31' 25.74" N, 0° 6' 37.13" W | ||
01698883480 | LONDON | 55° 43' 27.19" N, 3° 58' 7.89" W | |
01707636380 | LONDON | 51° 46' 8.02" N, 0° 14' 36.94" W | |
01752268598 | LONDON | 50° 23' 6.40" N, 4° 8' 7.97" W | |
01761408167 | LONDON | 51° 17' 29.62" N, 2° 28' 8.91" W | |
01772717181 | LONDON | 53° 46' 42.06" N, 2° 41' 54.77" W | |
01843844501 | LONDON | 51° 22' 33.21" N, 1° 18' 15.96" E | |
01908393703 | LONDON | 52° 3' 49.44" N, 0° 45' 27.94" W | |
01908679505 | LONDON | 52° 3' 49.44" N, 0° 45' 27.94" W | |
01914284111 | 54° 58' 53.48" N, 1° 29' 56.95" W | ||
01923840157 | LONDON | 51° 36' 0.55" N, 0° 24' 34.88" W | |
01923842240 | LONDON | 51° 36' 3.80" N, 0° 24' 34.23" W | |
01932823685 | 51° 22' 19.99" N, 0° 27' 30.27" W | ||
02070027822 | LONDON | 51° 31' 1.62" N, 0° 6' 10.73" W | |
02071007197 | LONDON | 51° 32' 16.14" N, 0° 8' 25.30" W | |
02072353345 | LONDON | 51° 29' 55.71" N, 0° 9' 25.90" W | |
02072536238 | 51° 31' 23.57" N, 0° 6' 4.46" W | ||
02072784304 | LONDON | 51° 31' 25.74" N, 0° 6' 37.13" W | |
02074260409 | LONDON | 51° 29' 59.65" N, 0° 0' 43.49" W | |
02074347305 | LONDON | 51° 30' 48.12" N, 0° 8' 12.14" W | |
02075207620 | LONDON | 51° 31' 25.74" N, 0° 6' 37.13" W | |
02076224683 | LONDON | 51° 28' 36.79" N, 0° 7' 49.90" W | |
02076375776 | LONDON | 51° 32' 3.61" N, 0° 16' 4.19" W | |
02077130214 | 51° 31' 25.74" N, 0° 6' 37.13" W | ||
02077235100 | LONDON | 51° 30' 52.63" N, 0° 9' 40.67" W | |
02078282082 | LONDON | 51° 29' 35.96" N, 0° 8' 51.48" W | |
02079243210 | LONDON | 51° 27' 49.33" N, 0° 10' 2.58" W | |
02082954255 | LONDON | 51° 23' 26.69" N, 0° 2' 35.83" E | |
02083092964 | LONDON | 51° 24' 55.69" N, 0° 6' 54.94" E | |
02083135000 | LONDON | 51° 24' 23.20" N, 0° 1' 51.26" E | |
02083649911 | LONDON | 51° 38' 59.97" N, 0° 10' 32.58" W | |
02084405838 | LONDON | 51° 39' 1.96" N, 0° 8' 56.89" W | |
02084665267 | LONDON | 51° 25' 0.54" N, 0° 1' 1.64" E | |
02085820261 | LONDON | 51° 34' 31.63" N, 0° 23' 48.80" W | |
02086617323 | LONDON | 51° 21' 52.84" N, 0° 11' 39.43" W | |
02087433977 | LONDON | 51° 30' 10.83" N, 0° 14' 2.93" W | |
02087701809 | LONDON | 51° 21' 52.78" N, 0° 11' 43.99" W |