Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be 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

prefix:

Control display of namespace in printouts

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

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

{{#ask: [[Category:Project]]
 |?Project Name
 |?Project Status
 |?Project Contact
 |format=broadtable
 |limit=40
 |offset=40
 |link=all
 |sort=Project Status,Project Name
 |order=ASC,ASC
 |headers=show
 |mainlabel=
}}

Results 41 – 80 previous 40 20 50 100 250 500 next 40

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Project]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0109",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Project]]

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_hash,t6.o_hash
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_blob` AS t4 ON t0.smw_id=t4.s_id
INNER JOIN
`mw_smw_di_blob` AS t6 ON t0.smw_id=t6.s_id
WHERE
(t1.o_id=8504)
   AND (t4.p_id=8387)
   AND (t6.p_id=8502)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC , t6.o_hash ASC
LIMIT
45
OFFSET
40

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	ref	s_id, p_id, s_id_2	p_id	4	const	455	Using temporary; Using filesort
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	t6	ref	s_id, p_id, s_id_2	s_id	8	revspacenl.t4.s_id, const	1
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:1
Query-Depth:0

Errors and Warnings

None

	Project Name	Project Status	Project Contact
Watermeter	Watermeter	Abandoned	Bas
WifiLamp	WifiLamp	Abandoned	Bertrik Sikken
Zwart	Zwart	Abandoned	Boekenwuurm Bas
RevUAV	revUAV	Abandoned	Marcel
!revbank	!revbank	Completed	Juerd
35C3 Tickets	35C3 Tickets	Completed	FooBar
36C3 Streams	36C3 Streams kijken	Completed	Bas
36C3 Tickets	36C3 Tickets	Completed	Bestuur
4G IoT	4G IoT	Completed	Juerd
A4PaperDispenser	A4PaperDispenser	Completed	Bertrik Sikken Bas
ACS Current probe	ACS730 Hall-Effect Current Probe	Completed	Kartoffel
Analogecams	Analoge Cams	Completed	Peetz0r Bas
Another JBC	Another JBC	Completed	Bas
Arcade repair course	Arcade console repair classes	Completed	Mahjongg
Assembling RhoCoCo	Assembling a RhoCoCo home computer	Completed	Mahjongg
Augurken	Augurken	Completed
BuildStatusTrafficLight	BuildStatusTrafficLight	Completed	Bertrik Sikken
Buiding up and testing the ZX81+38 revision 1,9	Building up the ZX81+38	Completed	Mahjongg
CCCamp19tickets	CCCamp19 Tickets	Completed	FooBar Bas
CJMCU-811	CJMCU-811	Completed	Bertrik Sikken
CL260	CL 260 3D Printer	Completed	Bas
CO2MeterHacking	CO2MeterHacking	Completed	Bertrik Sikken
CPC464 Restart	CPC464 Restart	Completed	Mahjongg
ChaoticCircuits	Chaotic circuits	Completed	Gori
Cloud shirt	Cloud shirt	Completed	Zawadi
ComicChat	ComicChat	Completed	Bas
CrawlSpaceSensor	CrawlSpaceSensor	Completed	Bertrik Sikken
Cyberstof	Cyberstof kopen	Completed	Bas
Colomax/buienalarm	De Weer	Completed	Colomax
DeBASS	DeBASS	Completed	Bas
DebianHandbook	Debian Handbook	Completed	FooBar
Decennium	Decennium	Completed	F0x Juerd Bas
DecodingLora	DecodingLora	Completed	Bertrik Sikken
Deep-fried candy bars	Deep-fried candy bars	Completed	Noor Bas
Deurding	Deurding	Completed	Robv
Door sign	Door sign	Completed	Thomas Gori
Doorduino2	Doorduino 2	Completed	Hansg
Doorduino1	Doorduino1	Completed	Gmc
Doorduino3	Doorduino3	Completed	Bas
Drumleds	Drumleds	Completed	Merethan

Semantic search

Query log

Navigation menu

Search