Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:Projects]] [[Project status::Finished]] OR[[Project status::Abandoned]]OR[[Project status::Production]]
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, t12.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`smw_di_time` AS t12 ON t0.smw_id=t12.s_id
WHERE
(t12.p_id=3302)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t12.o_sortkey DESC
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, t12.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`smw_di_time` AS t12 ON t0.smw_id=t12.s_id
WHERE
(t12.p_id=3302)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t12.o_sortkey DESC
LIMIT
55
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 56 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | bitlair_wiki.t1.id | 1 | Using where | |
1 | SIMPLE | t12 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | bitlair_wiki.t1.id, const | 1 | Using index |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t3.s_id FROM `smw_fpt_inst` AS t3 INNER JOIN `smw_di_blob` AS t5 ON t3.s_id=t5.s_id WHERE t3.o_id=3367 AND ((t5.o_hash='Finished') AND t5.p_id=3306)
INSERT IGNORE INTO `t1` SELECT DISTINCT t7.s_id FROM `smw_di_blob` AS t7 WHERE (t7.o_hash='Abandoned') AND t7.p_id=3306
INSERT IGNORE INTO `t1` SELECT DISTINCT t9.s_id FROM `smw_di_blob` AS t9 WHERE (t9.o_hash='Production') AND t9.p_id=3306
Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
NoneProject name | Project info | Started | Project contact | |
---|---|---|---|---|
Projects/Matrix HS | Matrix homeserver | Matrix homeserver tbv Bitlair members | 15 November 2021 | User:Flimpie |
Projects/LED-Pad | LED-Pad | A simple remote control intended to be used with single colorLED-strips | 15 July 2018 | Polyfloyd |
Projects/Fusion 360 workshop | Fusion 360 workshop | Voorbereidingen voor een mogelijke fusion 360 workshop | 27 January 2018 | Linor |
Projects/Kubusje | Kubusje | Last December, I attended the 34th Chaos Communication Congress in Leipzig, Germany. One thing that really impressed me was a cube comprised of bright LED-panels. It’s awesome and I just had to get one of my own. | 21 January 2018 | Polyfloyd |
Projects/BrainLed | Brainled | Control the ledbanner with Brainfuck | 15 January 2018 | Gopper |
Projects/Wissellijst fundraiser | Wissellijst Fundraiser | Fundraiser | 24 December 2017 | Linor |
Projects/Space3.0 | Space3.0 | Computerweg 20a, Amersfoort | 16 October 2017 | Hobbybob Mro Vuurtorenjeroen AK47 Polyfloyd X6m You?! |
Projects/CBeamMachine | C-Beam Machine | CNC | 2 July 2017 | Linor |
Projects/MoneyHopper | MoneyHopper | I have received a great (20 or so) number of these coin dispensers. You can have one for free, only thing i ask in return is that you share your experiences, ways of controlling this and maybe a picture of the project you created. This to help other people control their Money Hopper too! This info i will share with the person that donated them to me and maybe we get more of these cool goodies in the future. | 14 June 2017 | User:Hobbybob |
Projects/Laserbuis fundraiser | Laserbuis fundraiser | Fundraiser voor nieuwe laserbuis | 22 February 2017 | User:Vuurtorenjeroen |
Projects/Encryption for camera's | Study to encryption of camera footage | A little study of mine to see if I could find a solution for a problem that some journalists have while doing their jobs. | 24 December 2016 | User:NovemberBravo |
Projects/Faux Tubes | Fauxtubes | Een 'neppe' nixietube gemaakt van plexiglas en neopixels. | 21 September 2016 | NovemberBravo Linor |
Projects/MQTT | MQTT | Lijm voor space-events | 16 September 2016 | User:Polyfloyd |
Projects/Koken | Koken | Geïnspireerd door revspace.nl/koken. | 20 August 2016 | Stijn KartoffelKönig |
Projects/Verhuizen | Verhuizen | We moeten samen met DJO verhuizen naar de nieuwe space! | 9 January 2016 | AK47 WilcoBaanHofman Polyfloyd |
Projects/R2-D2 | R2-D2 Astromech | Life size replica | 1 January 2016 | Linor |
Projects/Mendel90 | Mendel90 | Building a mendel90 | 14 September 2012 | Zarya |
Projects/BitBarPi | BitBarPi | A raspberry pi controlled cash register | 1 August 2012 | Zarya |
Projects/Open Domotica | Open Domotica | Let's launch open sourced domotica properly. Currently in pre-alpha phase. | 1 August 2012 | WebSpider Zarya |
Projects/Analog things meter | Analog things meter | A analog meter for things | 8 July 2012 | Nickname |
Projects/Smiley Box | Smiley Box | A smiley box | 8 July 2012 | Mro |
Projects/Power Meter | Power Meter | Bitlair Power meter | 7 July 2012 | Zarya |
Projects/Space Amp | Space Amp | New amp for in the space | 7 July 2012 | Nickname |
Projects/mehduino | MehDuino | A barebone arduino clone | 7 July 2012 | Bobo1on1 |
Projects/KPN Hotspots Autologin | KPN Hotspots Autologin | KPN Hotspots Autologin | 5 May 2012 | Nickname |
Projects/Ethernet over phone cable | Ethernet over phone cable | Run ethernet over a phone cable, using homeplug adapters. | 2 April 2012 | Bobo1on1 |
Projects/Laser cutter | Laser cutter | Big 100W laser cutter | 11 March 2012 | Hobbybob Mro Eightdot |
Projects/SA12 IPC@CHIP | SA12 IPC@Chip | system on a chip | 15 January 2012 | Nickname |
Projects/Bitlight | Bitlight | Bitlair lighting | 23 December 2011 | Bobo1on1 |
Projects/Bitlair TV | Bitlair TV | Glasvezelnetwerk in Amersfoort is open gesteld. Daar willen we gebruik van maken. | 17 November 2011 | Nickname |
Projects/FT-817 Buddy | FT-817 Buddy | Buddy box for the FT-817 radio | 15 November 2011 | Pe5ed |
Projects/SpaceCam | SpaceCam | SpaceCam! | 9 November 2011 | AK47 |
Projects/Phone | Phone | Call +31337 114 666 | 9 November 2011 | AK47 |
Projects/Bionical Bodyparts | Bionical Bodyparts | Bionical Arm + Bionical foot | 19 October 2011 | Nickname |
Projects/Esther.esrac.ele.tue.nl | esther.esrac.ele.tue.nl | Software voor satelliet volg systeem voor esther.esrac.ele.tue.nl | 14 September 2011 | Nickname |
Projects/RouterLab | RouterLab | Router lab for testing advanced routing/networking protocols | 7 September 2011 | AK47 |
Projects/SpaceFED | SpaceFED | Federated hackerspace logons | 1 September 2011 | WilcoBaanHofman AK47 |
Projects/Blinkenlair | Blinkenlair | Blinken @ Amersfoort | 19 August 2011 | Nickname |
Projects/DR2C-YU1LM SDR | DR2C-YU1LM SDR | Monoband SDR HF S/H Sample and Hold Receiver with LO at working frequency - DR2C from 30 KHz to 50 MHz | 22 July 2011 | Zarya |
Projects/Skipbutton | Skipbutton | Skipbutton remote | 1 July 2011 | Bobo1on1 |
Projects/SDR | SDR | SDR (Software Defined Radio) for listening to the Amateur radio bands | 21 June 2011 | Nickname |
Projects/Muzieksysteem | Muzieksysteem | Bitlair muziek- en videospeler | 14 June 2011 | Bobo1on1 Polyfloyd |
Projects/BitBackup | BitBackup | Local and remote backup tool | 1 June 2011 | WilcoBaanHofman |
Projects/Subwoofer | Subwoofer | Nice Bass | 27 May 2011 | Nickname |
Projects/Darknet | Darknet | Darknet for hackerspaces | 23 May 2011 | Nickname |
Projects/BitBank | BitBank | Bar & Bank app | 23 May 2011 | Nickname |
Projects/SpaceNotifier | SpaceNotifier | Space Notifier | 15 May 2011 | Nickname |
Projects/Rafrd | Rafrd | Realtime asynchronous replication daemon | 5 May 2011 | Nickname |
Projects/Drinks and snacks | Drinks and snacks | Drankjes & snacks welke te koop zijn in de space | 1 May 2011 | AK47 Mro |
Projects/ysft | Youtube s/flash/totem/ | Replaces flash player with totem on youtube | 1 April 2011 | Nickname |