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=50
 |offset=50
 |sort=Project_Status,Project_Name
 |order=ASC,ASC
 |mainlabel=
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Project]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0107",
    "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
55
OFFSET
50

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
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
DustSensor	Dust Sensor	Completed	Bertrik Sikken
Espsensorgrid	ESP Sensor Grid	Completed	Bas
ESP-Now	ESP-Now	Completed	Kartoffel,bertrik
ElectronicLoad	ElectronicLoad	Completed	Bertrik Sikken
ElectronicaComponentenAutomaat	Electronica componenten automaat	Completed	Hammercat
Embla	Embla	Completed	Folkert
EspNowSkip	EspNowSkip	Completed	Bertrik Sikken Jelly
Eye Wash	Eye Wash	Completed	PeterC
Colomax/fishfeeder	FishFeeder	Completed	Colomax
Fluke 8842A	Fluke 8842A	Completed	Semafoor
Project frees	Frees	Completed	Supakeen
Fridayfoundations	Friday Foundations	Completed	Bas
Fundraiser keuken	Fundraiser Keuken	Completed	Bas
FundraiserOven	Fundraiser Oven	Completed	Bas
GL-iNet	GL-iNet	Completed	FooBar
Geigercounter	Geiger counter	Completed	Thomas Gori
Gigaohmvoltmeter	Gigaohm Voltmeter	Completed	Thomas
GloveCar	GloveCar	Completed	Cross
God of Technology	God of Technology	Completed	Gori
Grafiekjes	Grafiekjes	Completed	Dave o AK47

Semantic search

Query log

Navigation menu

Search