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 DESC
LIMIT
8
OFFSET
6
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 DESC
LIMIT
8
OFFSET
6
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
Revspace Maandoverzicht November 2018
30 November 2018 - November is voorbij gevlogen! Het weer wordt kouder, de lucht wordt droger, de ESD vliegt je om de oren in de werkplaats en de space wordt weer wat drukker. '
Revspace Maandoverzicht Oktober 2018
31 October 2018 - Revspace heeft weer een mooie maand achter de rug met een flinke groei in het aantal deelnemers, een hoop nieuwe aanwinsten voor de space en geweldige evenementen!
Revspace Shirts weer te bestellen!
21 October 2018 - Het is weer mogelijk een origineel Revspace "If it smells like chicken" Shirt te bestellen: