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=100
 |sort=
 |order=asc
 |mainlabel=
}}

Results 101 – 150 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.0081",
    "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, t0.smw_sort
FROM
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=8504)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
100

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	const	464		Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	revspacenl.t1.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
ESP-Now	ESP-Now	Completed	Kartoffel,bertrik
Earth	Earth	In progress	F0x
Efteling	Efteling	In progress	Samantie
Eink-word-clock-watch	E-ink wordclock watch	In progress	Jelly
ElectronicLoad	ElectronicLoad	Completed	Bertrik Sikken
ElectronicaComponentenAutomaat	Electronica componenten automaat	Completed	Hammercat
Embla	Embla	Completed	Folkert
EncodingLora	EncodingLora	Stalled	Bertrik Sikken
Engraving Xiaomi Mijia Wiha screwdriver	Xiaomi schroevendraaierset graveren	Completed	Juerd
EpsonHX20	Epson HX20	Abandoned	Bas
Esp32cam	ESP32-CAM	In progress	Bertrik Sikken Noopwafel
Esp32ink	ESP32Ink	Abandoned	Bas
EspAudioSensor	ESP audio sensor	In progress	Bertrik Sikken
EspGardenGrid	Esp Garden Grid	Initializing	AlexanderB
EspNowAudio	EspNowAudio	Initializing	Bertrik Sikken
EspNowSkip	EspNowSkip	Completed	Bertrik Sikken Jelly
EspWifiTracker	EspWifiTracker	Stalled	Bertrik Sikken
Espsensorgrid	ESP Sensor Grid	Completed	Bas
EthernetExtensions	EthernetExtensions	Initializing	Cmpxchg
ExtraSpace	ExtraSpace	Initializing
Eye Wash	Eye Wash	Completed	PeterC
FMCWRadar	FMCWRadar	In progress	Bertrik Sikken
Facehugger	Facehugger	In progress	Damnlie
Fijnstofsensor	Fijnstofsensor	In progress	Maxell
Flighttracker	Flighttracker	In progress	Jelly
Flipdot	FlipDot	Completed	Bas
Fluke 8842A	Fluke 8842A	Completed	Semafoor
Foundry	Foundry	In progress	Semafoor Gori
Fridayfoundations	Friday Foundations	Completed	Bas
FromDirtToSpace	FromDirtToSpace	In progress	Molenaar Ranzbak Gori
FrontDoorDisplay	FrontDoorDisplay	Abandoned	Bertrik Sikken
FumeHood	FumeHood	In progress	PeterC Mux Peterbjornx
FumeHoodConstruction	FumeHoodConstruction	In progress	PeterC Mux Thomas
Fundraiser keuken	Fundraiser Keuken	Completed	Bas
FundraiserOven	Fundraiser Oven	Completed	Bas
FundraiserSite	FundraiserSite	Stalled	GMC
GL-iNet	GL-iNet	Completed	FooBar
GL-iNet GL-MT300N	GL-iNet GL-MT300N	In progress	Crashjuh
GLiNet-Squeezebox	GLiNet-Squeezebox	In progress	FooBar
GNSS TimeReceiver	GNSS Reradiator	In progress	Cmpxchg
Galaksija	Galaksija	Stalled	Mahjongg
Geigercounter	Geiger counter	Completed	Thomas Gori
Geluidz0r	Geluidz0r	Stalled	Peetz0r
Geodesic dome	Geodesic dome	In progress	Morphje
GhettoBlast	GhettoBlast	In progress	Juerd
Gigaohmvoltmeter	Gigaohm Voltmeter	Completed	Thomas
GloveCar	GloveCar	Completed	Cross
Glu-MCU	Glu-MCU	In progress	Glu
God of Technology	God of Technology	Completed	Gori
GorbaDisplay	GorbaDisplay	Initializing	Bertrik Sikken Eloy

Semantic search

Query log

Navigation menu

Search