Semantische Suche
Aus LaborWiki
Debug output SQLStore
ASK Query
[[Kategorie:Veranstaltung]] [[Ev start::≥1 Januar 2015]]
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_time` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=15040
AND (
(t4.o_sortkey>='2457023.5') AND t4.p_id=15038)
)
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
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_time` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=15040
AND (
(t4.o_sortkey>='2457023.5') AND t4.p_id=15038)
)
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
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 534 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, o_sortkey, p_id_2, s_id_2 | s_id_2 | 8 | mediawiki.t2.s_id, const | 1 | Using where; Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None- DiVOC: hidden service
- Diskussionsrunde Vereinsorgan Bootstrap (Online Event)
- Docker-Meetup Bochum am 23.2
- Docker-Meetup Bochum am 24.5
- Domain-specific Languages in C++
- ECC'17
- EH20 - Easterhegg
- Einführung in 3D-Druck - Lasst uns was hacken 201819
- Einführung in Go
- Einführung in OpenStreetMap - Spielen mit offenen Karten
- Einführung in Quanten-Computing - Lasst uns was hacken 201819
- Einführung in die Android-App-Entwicklung
- Einführung in die Gesichtserkennung - Lasst uns was hacken 201819
- Einführungsveranstaltung ETIT WS17/18
- Einführungsveranstaltung ITS WS17/18
- Entdecke deine Stadt - Einführung in OpenStreetMap
- Erstes ElixirRuhr Meetup
- Erstsemestervorstellung ITS 2019
- Esil: A hard pill to swallow
- Ethical Social Engineering Barcamp - The Cake Is A Lie
- FOSDEM 2016
- FOSDEM 2020
- FOSDEM 2022
- FOSDEM 2023
- February C++ Meetup in the Ruhr area
- Feinstaubsensor-Workshop
- Freifunk Bochum
- Freifunk Bochum e.V. Mitgliederversammlung 2017
- Freifunk Treffen August 2018
- Freifunk Treffen Januar 2018
- Freifunk Treffen Juli 2017
- Freifunk Treffen Juni 2017
- Freifunk Treffen September 2017
- Freifunk-Treffen August 2017
- Führung durch das Labor (1)
- Führung durch das Labor (2)
- GPN15
- GPN19 Gulaschprogrammiernacht 2019
- GPN20 Gulaschprogrammiernacht
- GPN21 Gulaschprogrammiernacht
- Game Development Workshop 2024
- Gründung der OpenStreetMap-Gruppe Bochum
- Gründungstreffen der Audiogruppe Ruhr
- Hack im Pott 2020
- Hackathon 2015
- HamShack spezial - KiCad Workshop (Online Event)
- HamShack spezial - SDR Workshop
- Innenstadt-Mapathon für OpenStreetMap
- JNPA: "Ich habe doch nichts zu verbergen" - Wie mächtig sind Datensammlungen über mich?
- JNPA: "Mit Code die Welt verbessern" - Was tun mit offenen Daten und offener Software?