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
10
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
10
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
NoneCompleted Projects | Members | Description | GitHub |
---|---|---|---|
Clock jitter removal in VHDL | Danny Witberg | Jitter removal in clock signals with VHDL implementation | |
Cursus basis elektronica | Vicarious Coolepascal LuckY PsychiC Eracoon Prodigity | Workshop basale elektronica | |
D-Link switches | User:xopr Da Syntax | Arrange a couple of new ethernet switches for the space | |
DE-DP14112 | User:xopr | 3216 Bicolor LED 3mm Dot Matrix Display | https://github.com/ACKspace/ht1632c https://github.com/ACKspace/3216 bicolor |
DMX Arduino | Roelke | DMX besturing met een arduino | |
DSP experiments | Danny Witberg Coolepascal | Digital Signal Processing with a microcontroller and DAC | |
Digital Decoder Mod | Prodigity Da Syntax | Gaining access to the console of the DD and perhaps install doom on it | |
DigitalControlledMeter | Coolepascal | PWM Controlled Meter MSP430 project | |
Doorbell | PsychiC | Creating a better doorbell | |
Doorbell IRC bot | Prodigity | A doorbell / IRC interface | |
Draaideur | Prodigity | DraaiDraaiDraaideur | |
ESP8266 | User:xopr Prodigity Da Syntax | Playing around with cheap wifi modules | |
ESP8266-DS18S20 | User:xopr | Creating a wireless SpaceAPI-like sensor The system-to-be-installed uses Tasmota firmware combined with an MQTT script | |
Epoch clock | Danny Witberg | Our own clock in the space! | |
Flag | Vicarious Prodigity | A flag for our hackerspace | |
Flyer | Ikarus | Flyer | |
Footstool | Vicarious PsychiC Prodigity | Put ACKspace on the cover of a footstool | |
Game:Jump Wheel | Multiple | Synchronize your jump with your coop players and beat the record | https://github.com/ACKspace/JumpWheel https://github.com/ACKspace/MineCart https://github.com/ACKspace/jumppad |
Gameboy VGA adapter | Danny Witberg Prodigity | Adding VGA output to a gameboy classic | |
Geek whip | Vicarious | Make a whip from a bunch of Cat 5 cables |