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=State of Project
 |order=asc,rand
 |mainlabel=Projects that are probably missing a project image
}}

Results 1 – 46 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.0248",
    "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,t7.o_hash
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
INNER JOIN
`smw_di_blob` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id='2082'
   AND (t4.o_id='2093')
  )
   AND (t7.p_id='2094')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_hash ASC , RAND()
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
1	SIMPLE	t7	ref	s_id,p_id,s_id_2	s_id	8	ackspace_wikidb.t4.s_id,const	1

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

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools