Semantic search
SQLStore debug output
ASK Query
[[State of Project::Completed]]
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Completed') AND t1.p_id='2094')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
30
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Completed') AND t1.p_id='2094')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
30
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ref | s_id,p_id,s_id_2,o_hash | p_id | 262 | const,const | 69 | Using index condition; Using temporary; Using filesort |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | ackspace_wikidb.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None| Completed Projects | Members | Description | GitHub |
|---|---|---|---|
| IRC ACKspace-statusbot | StefandeVries User:xopr | An IRC-bot that provides SpaceAPI (and other) information upon request | https://github.com/ACKspace/ACKbot |
| IoTaps | Da Syntax | Connecting a beertap to the internet | https://github.com/ACKspace/IoTaps |
| Key Panel | Eagle00789 | Have a centralized place for the space keys | |
| Kit BZzZzZttTTTT!!! | Prodigity | Draad lus spel | |
| Korte golf luisteren | Danny Witberg | Luister naar de wondere wereld van de korte golf | |
| LED christmas tree | User:xopr Vicarious | Blinken lights! | |
| LED sleeve | User:xopr | ART-net controlled cylindrical-ish display | |
| LedWall | PsychiC | Fixing an awesome LED-Wall | |
| Library | Eagle00789 | This is the inventory of the library from the putgraaf. Since then, the books have moved four times Just an index of our Library | |
| Logo | Vicarious | A logo for ACKspace | |
| Lounge connect | Danny Witberg | 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? | |
| MADI transceiver | Danny Witberg | This project descibes a MADI transceiver in VHDL | |
| Mac RGB Lamp | Vicarious Coolepascal Roelke Da Syntax | RGB LED light inside empty Mac case | |
| Mead brewing | Prodigity | Brewing mead | |
| Mobile Spacestate Indicator | Vicarious Da Syntax | The new system uses an ESP8266, which is not yet documented Replace the factory car center console lights with a hackerspace state indicator | https://github.com/ACKspace/esp8266-SpaceAPI |
| NACKspace | Everybody | ||
| NAS | Danny Witberg Computer1up PsychiC Da Syntax | "This is data!" | |
| OpenBSD Firewall / PF | Vicarious PsychiC | building a gateway on openbsd | |
| Portable electronics workbench | User:xopr | Workbench on-the-go | |
| Programming multicore microcontrollers | Danny Witberg | This project describes the programming of multicore microcontrollers |
