Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[EventState::Completed]]
 |?=Events#-
 |?EventKind
 |?EventLocation
 |?EventStart
 |?EventEnd
 |format=table
 |limit=20
 |offset=50
 |order=ascending
 |headers=show
 |mainlabel=Events
}}

Results 51 – 70 previous 20 20 50 100 250 500 next 20

JSON CSV RSS RDF

Query log

{
    "query_string": "[[EventState::Completed]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0264",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[EventState::Completed]]

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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
   (t1.o_hash='Completed') AND t1.p_id='2325')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	s_id,p_id,s_id_2,o_hash	p_id	262	const,const	87	Using index condition; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ackspace_wikidb.t1.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Events	EventKind	EventLocation	EventStart	EventEnd
Meeting 29-03-11	Meeting	Location::ACKspace	29 March 2011	29 March 2011
Meeting 4 September 2010	Meeting	Location::User:xopr	4 September 2010	4 September 2010
Meeting 5 October 2010	Meeting	Location::ACKspace	5 October 2010	5 October 2010
Meeting December 2011	Meeting	Location::ACKspace	8 December 2011	8 December 2011
Meeting Februari 2013	Meeting	Location::ACKspace	15 February 2013	15 February 2013
Meeting January 2015	Meeting	Location::ACKspace	9 January 2015	9 January 2015
Meeting September 2013	Meeting	Location::ACKspace	15 September 2013	15 September 2013
Meeting September 2016	Meeting	Location::ACKspace	3 September 2016	3 September 2016
Movie night	Party Meeting	Location::online	20 March 2021	20 March 2021
Neon workshop	Workshop	Location::ACKspace	29 June 2013	29 June 2013
New Years Food	Party	Wereldrestaurant Kodoo Sittard	24 February 2024	24 February 2024
OHM2013	Conference	The Netherlands	31 July 2013	4 August 2013
OHM2013 KickOff Party	Party	Hack42 Arnhem	14 April 2012	15 April 2012
Official opening party	Party	Location::ACKspace	2 April 2011	2 April 2011
Open Rhein Ruhr	Conference	Oberhausen, Germany	12 November 2011	13 November 2011
OpenHMD (H)Ackathon	Hackathon Meeting	Location::ACKspace	8 July 2017	9 July 2017
Opening TkkrLab	Party	Enschede	28 May 2011	29 May 2011
Opening hackerspace Frack	Party	Frack, Zuiderplein 33, 8911 AN Leeuwarden	24 September 2011	25 September 2011
Polderhack 2013	Conference	Eindhoven	25 October 2013	26 October 2013
Project ACKspace 3.5		Location::ACKspace	28 November 2014	31 December 2014

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools