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
55
OFFSET
0
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
55
OFFSET
0
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 | 70 | 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
NoneCompleted Projects | State of Project | Members | Description |
---|---|---|---|
2k15 interhackerspaces xmas swap | Completed | Nobody | |
3D printer | Completed | Stuiterveer User:xopr Vicarious Roelke User:Adnub User:Computer1up | Print gimmicks, tools and toys! |
ACKade | Completed | Stuiterveer Computer1up PsychiC Prodigity Da Syntax | The ACKspace arcade. Game on! |
ACKsess | Completed | Stuiterveer Jetse User:xopr Vicarious Prodigity | Knock knock. This project has been decomissioned and superseeded by Acksess_2.0. It had a good ride. |
ADAT project | Completed | Danny Witberg | This project descibes the ADAT protocol |
Arbitrary Sampling Rate Converter in VHDL | Completed | Danny Witberg | ASRC's: What, how, why? |
Arc eye | Completed | Everybody | a.k.a. Project Lasoog |
Blog | Completed | Everybody 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 a.k.a. Project Lasoog |
Buying stuff together | Completed | User:xopr | Buy more, pay less! |
Christmas tree | Completed | AmazingMike Computer1up Wolkje User:xopr Prodigity Da Syntax | Kerstboom heeft mooie lampjes en versiering nodig |
Clock jitter removal in VHDL | Completed | Danny Witberg | Jitter removal in clock signals with VHDL implementation |
Cursus basis elektronica | Completed | Vicarious Coolepascal LuckY PsychiC Eracoon Prodigity | Workshop basale elektronica |
D-Link switches | Completed | User:xopr Da Syntax | Arrange a couple of new ethernet switches for the space |
DE-DP14112 | Completed | User:xopr | 3216 Bicolor LED 3mm Dot Matrix Display |
DMX Arduino | Completed | Roelke | DMX besturing met een arduino |
DSP experiments | Completed | Danny Witberg Coolepascal | Digital Signal Processing with a microcontroller and DAC |
Digital Decoder Mod | Completed | Prodigity Da Syntax | Gaining access to the console of the DD and perhaps install doom on it |
DigitalControlledMeter | Completed | Coolepascal | PWM Controlled Meter MSP430 project |
Doorbell | Completed | PsychiC | Creating a better doorbell |
Doorbell IRC bot | Completed | Prodigity | A doorbell / IRC interface |
Draaideur | Completed | Prodigity | DraaiDraaiDraaideur |
ESP8266 | Completed | User:xopr Prodigity Da Syntax | Playing around with cheap wifi modules |
ESP8266-DS18S20 | Completed | User:xopr | Creating a wireless SpaceAPI-like sensor The system-to-be-installed uses Tasmota firmware combined with an MQTT script |
Epoch clock | Completed | Danny Witberg | Our own clock in the space! |
Flag | Completed | Vicarious Prodigity | A flag for our hackerspace |
Flyer | Completed | Ikarus | Flyer |
Footstool | Completed | Vicarious PsychiC Prodigity | Put ACKspace on the cover of a footstool |
Game:Jump Wheel | Completed | Multiple | Synchronize your jump with your coop players and beat the record |
Gameboy VGA adapter | Completed | Danny Witberg Prodigity | Adding VGA output to a gameboy classic |
Geek whip | Completed | Vicarious | Make a whip from a bunch of Cat 5 cables |
IRC ACKspace-statusbot | Completed | StefandeVries User:xopr | An IRC-bot that provides SpaceAPI (and other) information upon request |
IoTaps | Completed | Da Syntax | Connecting a beertap to the internet |
Key Panel | Completed | Eagle00789 | Have a centralized place for the space keys |
Kit BZzZzZttTTTT!!! | Completed | Prodigity | Draad lus spel |
Korte golf luisteren | Completed | Danny Witberg | Luister naar de wondere wereld van de korte golf |
LED christmas tree | Completed | User:xopr Vicarious | Blinken lights! |
LED sleeve | Completed | User:xopr | ART-net controlled cylindrical-ish display |
LedWall | Completed | PsychiC | Fixing an awesome LED-Wall |
Library | Completed | 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 | Completed | Vicarious | A logo for ACKspace |
Lounge connect | Completed | 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 | Completed | Danny Witberg | This project descibes a MADI transceiver in VHDL |
Mac RGB Lamp | Completed | Vicarious Coolepascal Roelke Da Syntax | RGB LED light inside empty Mac case |
Mead brewing | Completed | Prodigity | Brewing mead |
Micro sleeve | Completed | User:xopr | ART-net controlled cylindrical-ish μdisplay, it's so cute! |
Mobile Spacestate Indicator | Completed | 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 |
NACKspace | Completed | Everybody | |
NAS | Completed | Danny Witberg Computer1up PsychiC Da Syntax | "This is data!" |
OpenBSD Firewall / PF | Completed | Vicarious PsychiC | building a gateway on openbsd |
Portable electronics workbench | Completed | User:xopr | Workbench on-the-go |