Uit Hack42
Debug output SQLStore
ASK Query
[[Categorie:Activiteit]] [[Event StartDate::≤19 april 2018]] [[Event StartDate::≥19 april 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<='2458227.5') AND t4.p_id=22038)
AND (
(t6.o_sortkey>='2444348.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
55
OFFSET
0
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<='2458227.5') AND t4.p_id=22038)
AND (
(t6.o_sortkey>='2444348.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
55
OFFSET
0
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 | 656 | 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
NoneAnnual 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
Feest om te vieren dat we SHA2017 hebben overleefd
16 sep 2017 13:37 - 17 sep 2017 13:37
Contact: Stitch
[[image:{{{Picture}}}|150x150px|link=Photoshoot - 20170826001]]
Een sessie voor portretfotografie met gasten
26 aug 2017 13:00 - 26 aug 2017 17:00
Contact: Dvanzuijlekom