Semantische Suche
Debug output SQLStore
ASK Query
[[SO type::news]]
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, t4.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(
(t1.o_hash='news') AND t1.p_id=15063)
AND (t4.p_id=15066)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
8
OFFSET
6
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, t4.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(
(t1.o_hash='news') AND t1.p_id=15063)
AND (t4.p_id=15066)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
8
OFFSET
6
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, p_id, p_id_2, s_id_2 | p_id | 4 | const | 25 | 100.00 | Backward index scan; Using temporary |
1 | SIMPLE | t1 | ref | s_id, p_id, s_id_2, o_hash | s_id_2 | 262 | smw-cora_org_wiki.t4.s_id, const | 1 | 16.67 | Using index condition; Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | smw-cora_org_wiki.t4.s_id | 1 | 99.64 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneDatum„Datum <span style="font-size:small;">(Date)</span>“ ist ein <a href="/index.php/Spezial:Datentypen/Date" title="Spezial:Datentypen/Date">Datentyp</a> für Datumswerte. Er wird Attributen mit Hilfe eines von <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a> bereitgestellten, softwareseitig fest definierten Attributs (Spezialattribut), zugeordnet. | News |
---|---|
November 2016 | At the workshop "Neue Perspektiven in der visuellen Bildungsgeschichte" which took place in Berlin, 24-25 November, 2016 [1] Christoph Schindler gave a talk on "Interlinking Pictura" a pilot project with the aim of realizing a VRE for analyzing pictures and other content in historical books. |
September 2016 | The Semantic MediaWiki Conference [1] was held in Frankfurt 28-30 September, 2016 organized by DIPF and Open Semantic Data Association e. V.. The first day comprised a Tutorial Day with several experts teaching specifics of the use of Semantic MediaWiki. On the following two days the conference proceeded with Keynotes, talks and poster presentations on topics related to Semantic MediaWiki its use cases and future potentials. |
Juli 2016 | At the Digital Humanities Conference 11-16 July, 2016 in Kraków [1] Christoph Schindler and Basil Ell presented the paper "Linking Qualitative and Quantitative Research by Thin Descriptions through Semantic Graphs. Experiments in Apparatus Design with Semantic CorA." |