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=30
 |order=ascending
 |headers=show
 |mainlabel=Events
}}

Results 31 – 50 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.0129",
    "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
30

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
Hack42 on Tour	Party	Location::ACKspace	4 November 2018	4 November 2018
HackADay Europe Tour 2013	Meeting	Location::ACKspace	20 October 2013	20 October 2013
Hackathon - Hacking heritage	Workshop	Continium, Maastricht, Boschstraat 30a, 6211 AX	7 February 2015	8 February 2015
Hackathon - The future of work	Hackathon	Bureau Europa, Maastricht	27 June 2015	28 June 2015
Hacker Hotel	Conference		11 February 2022	13 February 2022
Hackerspace Nijmegen Opening Party	Party	Elzenstraat 4a, Nijmegen	2 June 2018
Hardware hacking	Workshop	Location::ACKspace	14 September 2011	14 September 2011
Hark24	Conference Party	Hack42, Arnhem	17 October 2015	17 October 2015
HaxoGreen	Conference Festival	Campsite Belvedère, Dudelange, Luxembourg, Earth	28 July 2022	31 July 2022
Heropeningsfeest	Party Workshop	Location::ACKspace	27 October 2012	28 October 2012
Kerstviering 2019	Party	Location::ACKspace	28 December 2019	28 December 2019
Lockpicking	Workshop	Location::ACKspace	28 June 2011	28 June 2011
MCH2022	Conference Festival	The Netherlands"The location is the Scoutinglandgoed in Zeewolde, 55km east of Amsterdam."	22 July 2022	26 July 2022
Maker faire	Festival	Klokgebouw at Strijp-S, Eindhoven	28 September 2019	29 September 2019
Meeting 09-06-2012	Meeting	Location::ACKspace	9 June 2012	9 June 2012
Meeting 10-03-2012	Meeting	Location::ACKspace	10 March 2012	10 March 2012
Meeting 18 Februari 2011	Meeting	Café Pelt	11 February 2011	11 February 2011
Meeting 21 September 2010	Meeting	Skype	21 September 2010	21 September 2010
Meeting 21-9-2011	Meeting	Location::ACKspace	21 September 2011	21 September 2011
Meeting 23-05-2014	Meeting	Location::ACKspace	23 May 2014	23 May 2014

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools