Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
Debug output SQLStore
ASK Query
[[Concept:Agents]] [[-For page.Has publication source::Ainm.ie]] OR[[-Pub refers to agents::Ainm.ie]]
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
`o2a5_smw_object_ids` AS t0
INNER JOIN
`o2a5_t1` AS t1 ON t0.smw_id=t1.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
55
OFFSET
100
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
`o2a5_smw_object_ids` AS t0
INNER JOIN
`o2a5_t1` AS t1 ON t0.smw_id=t1.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
55
OFFSET
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 104 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | codecs2023.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `o2a5_t1` SELECT DISTINCT t16.o_id FROM `o2a5_smw_di_wikipage` AS t16 INNER JOIN `o2a5_smw_di_wikipage` AS t18 ON t16.s_id=t18.s_id INNER JOIN `o2a5_t4` AS t4 ON t16.o_id=t4.id WHERE t16.p_id=3882814 AND (t18.p_id=5217780 AND t18.o_id=223930)
INSERT IGNORE INTO `o2a5_t1` SELECT DISTINCT t21.o_id FROM `o2a5_smw_di_wikipage` AS t21 WHERE t21.p_id=2554944 AND t21.s_id=223930 - Temporary table t4
INSERT IGNORE INTO `o2a5_t4` SELECT DISTINCT t5.s_id FROM `o2a5_smw_di_wikipage` AS t5 WHERE t5.p_id=3835477 AND t5.o_id=2554929
INSERT IGNORE INTO `o2a5_t4` SELECT DISTINCT t8.o_id FROM `o2a5_smw_di_wikipage` AS t8 INNER JOIN `o2a5_t9` AS t9 ON t8.p_id=t9.id
INSERT IGNORE INTO `o2a5_t4` SELECT DISTINCT t11.o_id FROM `o2a5_smw_di_wikipage` AS t11 INNER JOIN `o2a5_t12` AS t12 ON t11.p_id=t12.id INNER JOIN `o2a5_smw_di_wikipage` AS t13 ON t11.s_id=t13.s_id WHERE (t13.p_id=3835477 AND t13.o_id=2554929) - Temporary table t9
Recursively computed hierarchy for element(s) (2156058).
SELECT s_id FROM `o2a5_smw_fpt_subp` WHERE o_id=2156058 LIMIT 1 - Temporary table t12
Recursively computed hierarchy for element(s) (2659966).
SELECT s_id FROM `o2a5_smw_fpt_subp` WHERE o_id=2659966 LIMIT 1
Query Metrics
Query-Size:6Query-Depth:2
Errors and Warnings
NoneJohn SebrightSebright (John)
(1725–1794)
No short description available
See more Alf SommerfeltSommerfelt (Alf)
(d. 12 October 1965)
No short description available
See more Joseph Cooper WalkerWalker (Joseph Cooper)
(1761–1810)
No short description available
See more John WindeleWindele (John)
(1801–1865)
Irish antiquarian and historian in Cork
See more
(1725–1794)
No short description available
See more Alf SommerfeltSommerfelt (Alf)
(d. 12 October 1965)
No short description available
See more Joseph Cooper WalkerWalker (Joseph Cooper)
(1761–1810)
No short description available
See more John WindeleWindele (John)
(1801–1865)
Irish antiquarian and historian in Cork
See more