Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:NewsItem]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`mw_smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=8471)
AND (t4.p_id=8396)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey ASC
LIMIT
10
OFFSET
5
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`mw_smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=8471)
AND (t4.p_id=8396)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey ASC
LIMIT
10
OFFSET
5
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 | 47 | Using where; Using temporary | |
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | revspacenl.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | revspacenl.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
Den Haag wil € 1162,44 van RevSpace
31 January 2012 - Of we even binnen 6 weken willen betalen. Au, die hadden we niet zien aankomen!
Dossier privacygevoelige gegevens gevonden op straat
26 February 2012 - Dossier met meer dan 250.000 privacygevoelige gegevens op straat.
Geslaagde open dag
2 April 2012 - Zo'n 60 bezoekers bezochten afgelopen zaterdag 31 maart 2012 de open dag van RevSpace. Bijna alle hackerspaces namen deel aan deze landelijke open dag, waar in totaal naar verluid zo'n 300 mensen op afkwamen.
RevSpace op TV bij NOS op 3
3 April 2012 - Stukje van 2 minuten over Revelation Space, de hackerspace in Den Haag.
Revspace opent anoniem meldpunt voor lekken
30 August 2012 - Revspace deelnemers hebben een meldpunt geopend waar anoniem melding gemaakt kan worden van lekken in websites