Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:postcode::EC1V 2NX]]
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='7652')
)
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='7652')
)
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_3 | 9 | const,const | 1067 | 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 | |
---|---|---|---|
01132715192 | LONDON | 53° 46' 29.16" N, 1° 34' 16.67" W | |
01133204801 | LONDON | 53° 47' 52.32" N, 1° 32' 40.38" W | |
01133466061 | LONDON | 53° 47' 57.94" N, 1° 33' 3.79" W | |
01133662022 | LONDON | 53° 47' 44.52" N, 1° 33' 31.47" W | |
01142558222 | LONDON | 53° 21' 53.61" N, 1° 29' 9.60" W | |
01142569606 | LONDON | 53° 24' 46.94" N, 1° 24' 44.86" W | |
01142664089 | LONDON | 53° 23' 11.78" N, 1° 29' 46.82" W | |
01142725044 | LONDON | 53° 23' 23.16" N, 1° 29' 10.33" W | |
01142745568 | LONDON | 53° 19' 43.96" N, 1° 29' 2.59" W | |
01158456578 | LONDON | 51° 31' 21.19" N, 0° 5' 14.76" W | |
01158524175 | LONDON | 52° 57' 9.10" N, 1° 9' 0.27" W | |
01159312122 | LONDON | 52° 59' 24.88" N, 1° 1' 54.54" W | |
01159352038 | LONDON | 52° 57' 17.96" N, 1° 9' 20.46" W | |
01159373362 | LONDON | 52° 54' 0.23" N, 1° 5' 51.81" W | |
01159472819 | LONDON | 52° 56' 52.90" N, 1° 9' 19.48" W | |
01159897360 | LONDON | 52° 57' 4.45" N, 1° 8' 42.50" W | |
01162565656 | LONDON | 52° 37' 47.27" N, 1° 8' 0.59" W | |
01162837771 | LONDON | 52° 36' 55.42" N, 1° 8' 32.86" W | |
01173155224 | LONDON | 51° 27' 14.55" N, 2° 35' 31.10" W | |
01173305698 | LONDON | 51° 28' 37.92" N, 2° 35' 34.35" W | |
01179079094 | LONDON | 51° 27' 50.76" N, 2° 31' 47.90" W | |
01179623992 | LONDON | 51° 29' 34.21" N, 2° 37' 4.85" W | |
01179731003 | LONDON | 51° 27' 13.29" N, 2° 37' 4.85" W | |
01179731529 | LONDON | 51° 27' 47.19" N, 2° 36' 33.30" W | |
01179733823 | LONDON | 51° 28' 12.50" N, 2° 36' 52.54" W | |
01183240061 | LONDON | 50° 54' 29.56" N, 1° 25' 8.83" W | |
01189076382 | LONDON | 51° 27' 18.03" N, 0° 56' 5.55" W | |
01189690900 | LONDON | 51° 27' 16.55" N, 0° 53' 36.32" W | |
01189888800 | LONDON | 51° 23' 2.31" N, 0° 58' 23.09" W | |
01200426228 | LONDON | 53° 52' 13.55" N, 2° 23' 31.01" W | |
01202418671 | LONDON | 50° 44' 2.41" N, 1° 48' 12.04" W | |
01202467864 | LONDON | 50° 45' 29.76" N, 1° 52' 0.25" W | |
01202528939 | LONDON | 50° 44' 43.79" N, 1° 52' 41.66" W | |
01202632908 | LONDON | 50° 44' 16.39" N, 2° 1' 38.32" W | |
01202686586 | LONDON | 50° 42' 51.51" N, 1° 59' 8.35" W | |
01202769297 | LONDON | 50° 43' 55.77" N, 1° 53' 26.37" W | |
01202870287 | LONDON | 50° 48' 44.63" N, 1° 54' 10.29" W | |
01202887773 | LONDON | 50° 47' 55.28" N, 1° 59' 7.81" W | |
01202901222 | LONDON | 50° 43' 3.46" N, 1° 59' 0.46" W | |
01204385813 | LONDON | 53° 34' 45.93" N, 2° 25' 51.47" W | |
01204387523 | LONDON | 53° 34' 38.24" N, 2° 25' 57.05" W | |
01204577722 | LONDON | 53° 32' 51.28" N, 2° 24' 21.65" W | |
01204771181 | LONDON | 51° 31' 38.20" N, 0° 5' 19.20" W | |
01204861337 | LONDON | 53° 32' 36.80" N, 2° 22' 6.51" W | |
01206231445 | LONDON | 51° 54' 13.47" N, 0° 58' 11.42" E | |
01206368943 | LONDON | 51° 53' 15.91" N, 0° 53' 40.51" E | |
01206563863 | LONDON | 51° 53' 14.75" N, 0° 54' 0.73" E | |
01206618872 | LONDON | 51° 56' 42.99" N, 0° 58' 31.15" E | |
01208862211 | LONDON | 50° 34' 23.56" N, 4° 54' 52.03" W | |
01209200999 | LONDON | 50° 15' 18.19" N, 5° 14' 19.26" W |