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
3
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
3
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 |
---|---|
Oktober 2017 | The Semantic MediaWiki Conference [1] was held in Rotterdam 4-6 October, 2017. Lia Veja held a workshop about eHumanities, Tobias Weller presented the semantic annotator bundle |
August 2017 | Lia Veja, Helge Kminek, Kendra Sticht and Christoph Schindler gave a talk about the use of Semantic CorA for objective hermeneutics [1] |
März 2017 | At ISI 2017 in Berlin, 13-15 March, 2017 [1] the poster "Grasping the Materializations of Practices in Digital Humanities. A Semantic Research Environment for Analyzing Exam Grading Practices in German High Schools" by Christoph Schindler, Julian Hocker, Lars Müller, Maria Maleshkova und Tobias Weller was presented. The Satellite Workshop Information Science and the Digital Humanities [1] was held in the context of ISI 2017 [2]. Amongst others Julian Hocker and Christoph Schindler gave a talk on the topic "Facing Epistemological Diversity in Digital Humanities. Designing Virtual Research Environments for Educational Research." |