Uit Hack42
Debug output SQLStore
ASK Query
[[Categorie:Activiteit]] [[Event StartDate::≤12 juli 2019]] [[Event StartDate::≥12 juli 1980]]
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_fpt_inst` AS t2
INNER JOIN
`smw_di_time` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_time` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=22090
AND (
(t4.o_sortkey<='2458676.5') AND t4.p_id=22038)
AND (
(t6.o_sortkey>='2444432.5') AND t6.p_id=22038)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
105
OFFSET
50
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_fpt_inst` AS t2
INNER JOIN
`smw_di_time` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_time` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=22090
AND (
(t4.o_sortkey<='2458676.5') AND t4.p_id=22038)
AND (
(t6.o_sortkey>='2444432.5') AND t6.p_id=22038)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
105
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, p_id, o_sortkey, p_id_2, s_id_2 | p_id | 4 | const | 766 | Using where; Using temporary | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | deckart_hack42wiki.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | deckart_hack42wiki.t4.s_id | 1 | Using where | |
1 | SIMPLE | t6 | ref | s_id, p_id, o_sortkey, p_id_2, s_id_2 | s_id_2 | 8 | deckart_hack42wiki.t4.s_id, const | 1 | Using where; Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneMaak gave en stoere kerstversiering van computeronderdelen! Junior-editie.
7 dec 2018 10:00
Contact: Moem
Een beklemmend toneelstuk over een dysfunctional family.
30 nov 2018 20:30 - 30 nov 2018 23:00
Contact: Mahjestic
Een beklemmend toneelstuk over een dysfunctional family.
29 nov 2018 20:30 - 29 nov 2018 23:00
Contact: Mahjestic
Een beklemmend toneelstuk over een dysfunctional family.
23 nov 2018 20:30 - 23 nov 2018 23:00
Contact: Mahjestic
Hoe communiceert zo'n oud/nieuw apparaat nou met die app/pc en hoe maken we dat beter, leuker, anders?
23 nov 2018 20:00 - 23 nov 2018 22:00
Contact: BugBlue
Een beklemmend toneelstuk over een dysfunctional family.
22 nov 2018 20:30 - 22 nov 2018 23:00
Contact: Mahjestic
Introductieworkshop EHBO en levensreddende handelingen bij ernstige bloedingen
9 nov 2018 18:00 - 9 nov 2018 23:00
Contact: Jos
Hack42 komt naar je toe deze zomer!
3 nov 2018 09:00 - 4 nov 2018 23:59
mv /media/rabe/vrachtwagen/mate /vrijland/matehok/ && sync && sync
11 sep 2018 13:00 - 11 sep 2018 16:00
Contact: Uylie
Electromagnetic Field is a non-profit UK camping festival.
31 aug 2018 09:00 - 2 sep 2018 23:59
Contact: Hack42
TD Venlo komt op excursie naar Hack42
3 aug 2018 19:30 - 3 aug 2018 23:59
Leer de basics over scalable vector graphics en Inkscape.
20 jul 2018 20:00 - 20 jul 2018 21:42
Contact: CookieMonster
Leer Git met behulp van Post-It's en kittens
22 jun 2018 20:00 - 22 jun 2018 22:00
Contact: Aequitas
Let's meet up again and invite friends to BBQ at Bitlair.
9 jun 2018 15:00 - 9 jun 2018 23:00
Contact: Stitch
Presentatie van een vogelvormige, op LoRa communicerende fijnstofmeter
22 mei 2018 21:00
Contact: Bjornl
Wat is PKI en welk probleem lost het op? En wat gebeurt er als het mis gaat?
11 mei 2018 20:00 - 11 mei 2018 22:00
Contact: Ritger
Hoe websites werken en hoe daar creatief mee om kan gaan.
20 apr 2018 20:00 - 20 apr 2018 21:00
Contact: Stitch
Annual HITB Security Conference: trainingen, conferentie, CTF en expo
12 apr 2018 09:00 - 13 apr 2018 23:59
Contact: Hack42
Luxurious Hacking Experience (lectures, workshops, etc) voor hackers en makers van alle skill levels
16 feb 2018 13:37 - 18 feb 2018 20:00
Contact: Hack42
Sushi is heerlijk. Het is even oefenen, maar je kan het prima zelf maken. Leer hier hoe.
9 feb 2018 17:00
Contact: Moem
A free event for software developers to meet, share ideas and collaborate.
3 feb 2018 00:00 - 4 feb 2018 00:00
Contact: Raboof
Nieuwjaarsborrel en viering achtjarig bestaan Hackerspace RevSpace Leidschendam
27 jan 2018 17:30 - 27 jan 2018 23:59
Contact: Sebastius
...een ruimte waar vanuit men inbreekt in computers
26 jan 2018 20:00 - 26 jan 2018 23:00
Contact: Lurwah
Roads? Where we’re going, we don’t need roads. De Bit Nieuwjaarsborrel in het thema "Back to the Future"
12 jan 2018 01:00 - 13 jan 2018 01:00
Contact: Hack42
Inpakken van cadeautjes en maken van dingen
10 dec 2017 13:00 - 10 dec 2017 18:00
Contact: Spider, Dvanzuijlekom
Walter and his friend Macel have created a computer without a microprocessor. This talk is about that journey and its destination.
8 dec 2017 20:00 - 8 dec 2017 01:00
Contact: Jos
Hack42 Synth Dinges. Bring your own Synth!
11 nov 2017 12:00 - 11 nov 2017 23:00
Bezoek van Albanese hackerspace Openlabs aan Hack42
3 nov 2017 18:00 - 4 nov 2017 14:00
Contact: Yeti
kleine beurs van mensen die op de CVML mailinglijst zitten
28 okt 2017 10:00 - 28 okt 2017 19:00
Internationale conferentie over slotjes! Toegang enkel op uitnodiging.
20 okt 2017 09:00 - 22 okt 2017 23:59
Contact: Jos