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
505
OFFSET
50
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
505
OFFSET
50
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 |
---|---|---|---|
Quincy - Quartus Network Compiler | Danny Witberg Prodigity | Synthesizing FPGA designs on a VM! | |
Richtlijnen voor het maken van een zelf te etsen printje | Danny Witberg | Dit project gaat over het ontwerpen van een printplaat die je zelf zou kunnen (laten) etsen. | |
Rolpoort bediening | Prodigity Da Syntax | Control the gate using your cellphone | https://github.com/ACKspace/ACKgate |
SIM reader | Vicarious | SIM reader with serial port | |
SMD workshop | Danny Witberg | transcript of the SMD workshop | |
SP/DIF transmitter project | Danny Witberg | This project describes a lightweight SP/DIF transmitter in VHDL | |
Skype Ninja mode | Prodigity | Skype Ninja Mode | |
Space state | User:xopr Vicarious Coolepascal Prodigity | Show the current state (open or closed) of our space | |
SpaceAPI | Stuiterveer User:xopr Vicarious Coolepascal Prodigity Da Syntax | HackerSpace Status API | https://github.com/ACKspace/esp8266-SpaceAPI https://github.com/ACKspace/spaceAPI https://github.com/ACKspace/SpaceAPIBot https://github.com/fixme-lausanne/OpenSpaceDirectory |
SpaceAPIBot | Stuiterveer | Displays the open/close state for hackerspaces within Telegram. | https://github.com/ACKspace/SpaceAPIBot |
SpacePets | Eagle00789 | Have some pets in space | |
SpaceWorkhorse | TheOnlyJoey | The multi-boot workhorse of the hackerspace! | |
Spacenet | Stuiterveer User:xopr | Connect to an encrypted accesspoint using your own credentials in every hackerspace | |
Stamps | Vicarious | Stamps for hackpass / hacker passports | |
Stickers | Vicarious | Stickers with our logo | |
T-shirt | Vicarious | shop needs a version of our vector image uploaded We have a design for a T-shirt | |
Telephone system:autopatch | User:xopr | use a VoIP system to communicate over radio | |
XBMC remote control script for streams | User:xopr | Automate stuff | |
Zarck | User:xopr | Your greatest challenge lies ahead-and downwards; finish the game! | https://github.com/ACKspace/zarck |