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

Delete

Add sorting condition

ResultCodeDebugExtra

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

{{#ask: [[Category:Projects]]
[[Category:Pages with broken file links]]
 |?Description
 |?State of Project
 |?Members
 |format=broadtable
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=Projects that are probably missing a project image
}}

Results 1 – 47 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Projects]]\n[[Category:Pages with broken file links]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0206",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Category:Projects]] [[Category:Pages with broken file links]]

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_fpt_inst` AS t2
INNER JOIN
`smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='2082'
   AND (t4.o_id='2093')
  )
  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
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	ref	s_id,o_id,s_id_2,o_id_2	o_id_2	5	const	48	Using index; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id,o_id,s_id_2,o_id_2	s_id_2	9	ackspace_wikidb.t4.s_id,const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ackspace_wikidb.t4.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:0

Errors and Warnings

None

Projects that are probably missing a project image	Description	State of Project	Members
2ABU6-G1	Minew BLE/Wifi Gateway	Active	User:xopr Prodigity Da Syntax
ACK's LED	a LED which is always in the mood	Stalled	User:xopr Da Syntax
ACKserver	Dell 1855 rackmount servers and a NetApp FAS 3050c with 3 disk cabinets	Stalled	Computer1up
ACKspace defrag	A collection of projects and events that help keep the space tidy.	Active	Prodigity
Acksess 2.0	New Acksess system	Active	Adnub
AcksessManager	System and software to manage Acksess 2.0 door controller	Active	Adnub
Ackspace inventory	Tools and materials and where to find them	Active	Adnub
Atmel experiments	Diverse experimenten met Atmel chipjes	Stalled	Coolepascal
Buying stuff together	Buy more, pay less!	Completed	User:xopr
CNC guide	Ondersteunend materiaal ter gebruik van de CNC	Stalled Impossible	Prodigity
Cursus basis elektronica	Workshop basale elektronica	Completed	Vicarious Coolepascal LuckY PsychiC Eracoon Prodigity
Doorbell	Creating a better doorbell	Completed	PsychiC
Doorbell IRC bot	A doorbell / IRC interface	Completed	Prodigity
E-ink tags	Hacking & having fun with old e-ink pricetags from a German supermarket (probably REWE)	Active	Computer1up
ESL			User:xopr
GForge	a project management tool/site	Stalled	Eagle00789
IX2412	IXON IXrouter3 4G "cloud" modem	Active	User:xopr
LDAP	LDAP server for central logins using passwords or keypairs	Active	Stuiterveer
LED sleeve	ART-net controlled cylindrical-ish display	Completed	User:xopr
Laser cutter	Laser snijder.	Planned	Wirexbox
Library	This is the inventory of the library from the putgraaf. Since then, the books have moved four times Just an index of our Library	Completed	Eagle00789
Line Following Robot	Hackchallenge Line Following Robot	Planned	Jetse User:xopr Coolepascal
LoRa	Sonething something Long Range	Active	User:xopr Stuiterveer
Lounge connect	This is the setup of the old (putgraaf's) _slACKspace. The new version is slightly less complex (but still needs documentation) Je wilt iets doen in de lounge?	Completed	Danny Witberg
MADI transceiver	This project descibes a MADI transceiver in VHDL	Completed	Danny Witberg
MQTT	Space empty? Power off!	Active	User:xopr
Mixxar	USB sound mixer to change app volumes within Windows and Linux	Stalled	Stuiterveer Computer1up Da Syntax
NAS	"This is data!"	Completed	Danny Witberg Computer1up PsychiC Da Syntax
Nanoboard 3000	Getting the Altium NanoBoard 300 up and running again.	Active	Prodigity
OpenBSD Firewall / PF	building a gateway on openbsd	Completed	Vicarious PsychiC
Organische rasterafbeelding		Active	Wolkje
Rolpoort bediening	Control the gate using your cellphone	Completed	Prodigity Da Syntax
Skype Ninja mode	Skype Ninja Mode	Completed	Prodigity
SpaceAPI	HackerSpace Status API	Completed	Stuiterveer User:xopr Vicarious Coolepascal Prodigity Da Syntax
SpaceAPIBot	Displays the open/close state for hackerspaces within Telegram.	Completed	Stuiterveer
SpacePets	Have some pets in space	Completed	Eagle00789
SpaceStateIndicator	Arduino Space State indicator for home	Active	Coolepascal
Starlink: Battle for Atlas	Reverse engineering the chip communication	Planned	Stuiterveer
Stoplichter	Hey 't is groen! Hey, nou is ie weer roze.	Active	Stuiterveer User:xopr
SuperMario Contest	SuperMario Geek Contest	Stalled	Coolepascal
Telephone system:Number lookup	Caller ID lookup	Active	User:xopr
ToolbarKiller	Continuering van dit reeds bestaande project	Stalled	Eagle00789
VLC mosaic config		Active	Stuiterveer User:xopr
WiFi to 433/IR bridge	Building a WiFi to 433MHz and ir bridge for cheap domotics	Stalled	Da Syntax
WiPhone		Active	Vicarious Stuiterveer User:xopr
XBMC remote control script for streams	Automate stuff	Completed	User:xopr
Zarck	Your greatest challenge lies ahead-and downwards; finish the game!	Completed	User:xopr

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools