Semantic search
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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_fpt_inst` AS t2
INNER JOIN
`mw_smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=8504
AND (
(t4.o_hash='Completed') AND t4.p_id=8387)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
100
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | index_merge | s_id, p_id, s_id_2, o_hash | o_hash,p_id | 258,262 | 44 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | revspacenl.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | revspacenl.t4.s_id | 1 | Using where |
Query-Depth:1
Metal Flame
16 July 2012 15:28:05
Completed, primary suspect User:Gori
Microscoopmount
24 February 2020 17:23:38
Completed, primary suspect User:Bas
MiniSTM32F103ZE
11 May 2020 13:20:25
Completed, primary suspect User:Bertrik Sikken
Montrose coax
24 October 2018 19:41:27
Completed, primary suspect Thomas
Mumble
16 February 2021 16:47:57
Completed, primary suspect User:F0x
NANDbender
12 October 2019 19:27:55
Completed, primary suspect Pinoaffe, User:Glu
Nieuwe indeling SparkShack
6 January 2016 13:18:37
Completed, primary suspect Semafoor
Nyaomi Arcade Cabinet
4 April 2014 11:48:01
Completed, primary suspect TheOnlyJoey, smeding
Space Sound System
27 July 2014 13:35:14
Completed, primary suspect Gmc
Ooni
6 November 2016 15:18:37
Completed, primary suspect Folkert
Opentilt
29 August 2016 18:03:01
Completed, primary suspect Juerd
OperameBox
19 January 2021 21:15:24
Completed, primary suspect Cmpxchg
Opruimwoede
5 April 2021 12:19:41
Completed, primary suspect User:Bas
P2000T
1 November 2017 16:22:05
Completed, primary suspect Mahjongg
Lego Light
28 September 2018 06:22:19
Completed, primary suspect Pinoaffe
Plasmasnijder
10 December 2017 19:30:11
Completed, primary suspect User:Gori
Plasmasnijder
26 October 2016 14:18:40
Completed, primary suspect User:Gori
Popcorn machine
4 February 2018 16:02:02
Completed, primary suspect User:Gori
PowerLight
13 May 2024 13:50:21
Completed, primary suspect User:Bertrik Sikken
PowerMeter
19 June 2016 00:24:41
Completed, primary suspect User:Bas
Powerbank
21 June 2017 00:17:08
Completed, primary suspect User:Mux, User:Bas
Praatpaal aankopen
10 January 2020 21:37:17
Completed, primary suspect User:Bas
Frees
13 April 2022 16:14:30
Completed, primary suspect User:Supakeen
MQTT2Pushover
27 May 2020 16:45:38
Completed, primary suspect Hvwees
RAK831
13 February 2020 20:50:21
Completed, primary suspect User:Maxell
RC522Hacking
11 May 2020 13:17:42
Completed, primary suspect User:Bertrik Sikken
Radio controlled Bicycle back light
18 December 2018 23:02:53
Completed, primary suspect Mahjongg
Rainbow stickers
28 March 2019 10:09:09
Completed, primary suspect User:Kinroy
Reflow Oven
7 May 2022 17:19:15
Completed, primary suspect User:Crashjuh
RemoteResetArduino
20 August 2013 20:10:07
Completed, primary suspect User:FooBar
repair PET2001 (AKA CBM2032)
12 April 2022 16:04:29
Completed, primary suspect Mahjongg
Restaurant
23 November 2019 03:49:13
Completed, primary suspect User:Bas
RetroPlayer
11 September 2017 17:01:04
Completed, primary suspect User:Crashjuh, User:Jelly, User:Mux
RevRadio
11 May 2020 13:19:02
Completed, primary suspect User:Bertrik Sikken, User:Maxell
MacOS in Qemu-KVM, RevSpace App
19 April 2019 11:58:42
Abandoned, Completed, primary suspect User:Peetz0r
Revfan
1 October 2022 19:25:35
Completed, primary suspect Juerd, thomas
Revspace Shirt
13 January 2019 01:32:57
Completed, primary suspect User:Bas
Rondreizende meukdoos
19 April 2021 08:03:19
Completed, primary suspect User:Bas
SE30
23 October 2016 14:03:26
Completed, primary suspect User:Bas
STM32
18 December 2022 12:01:58
Completed, primary suspect User:Bertrik Sikken
Secure iButton
11 September 2016 03:37:37
Completed, primary suspect User:Bertrik Sikken
sensor-data-bridge
10 March 2024 22:17:25
Completed, primary suspect User:Bertrik Sikken
Skip
9 February 2020 16:48:23
Completed, primary suspect Juerd
Skipknop
3 December 2022 13:27:42
Completed, primary suspect User:Kartoffel
Sleutelkastje
29 July 2018 12:58:06
Completed, primary suspect Juerd, User:Bas
Snoepautomaat #2
11 January 2014 21:43:42
Completed, primary suspect Hammercat
Snuffelaar
23 September 2023 04:17:16
Completed, primary suspect User:Bas
SoilHumiditySensor
27 June 2019 20:03:23
Completed, primary suspect User:Bertrik Sikken
Solarshed
8 August 2022 17:56:39
Completed, primary suspect User:Bas
Soldeerspons
11 September 2018 21:28:17
Completed, primary suspect Juerd, Sebastius
Space, a no fly zone
15 February 2016 16:55:34
Completed, primary suspect User:Glu
Space2 Teardown
9 May 2017 10:55:45
Completed, primary suspect User:Bas
Space³
20 June 2018 05:49:22
Completed, primary suspect User:Hans de Goede, User:Gori, User:FooBar, WinSCaP, User:Maxell, User:Bas
Space³Ventilatie
26 January 2018 01:28:08
Completed, primary suspect User:Morphje, User:Mux
SpaceSoundSystem
23 April 2022 14:28:24
Completed, primary suspect User:FooBar
Spacebike
28 July 2019 14:13:13
Completed, primary suspect User:Mux, User:Bas
SpaceLoop 3
13 January 2019 01:38:46
Completed, primary suspect User:Bas
Spaceloop v2
24 September 2016 12:38:01
Completed, primary suspect User:Juerd
Spacesucker
7 January 2015 19:10:23
Completed, primary suspect User:Glu
SparkShack
25 July 2016 16:15:24
Completed, primary suspect Gori,Benadski, Semafoor and many others ...
Spectrum Analyzer Trolley
3 August 2020 13:10:34
Completed, primary suspect User:Crashjuh
Spectrum polish off
16 January 2016 21:07:11
Completed, primary suspect Mahjongg
STM macro keyboard
11 November 2021 14:39:53
Completed, primary suspect Colomax
StofAnanas
1 February 2023 12:50:12
Completed, primary suspect User:Bertrik Sikken
Stofradar
13 December 2022 13:53:39
Completed, primary suspect User:Bertrik Sikken
Symfonos Amp Mini
12 May 2021 17:12:16
Completed, primary suspect User:Bas
TMC2130
29 February 2020 18:57:55
Completed, primary suspect Sttc
TTNHABBridge
21 April 2022 15:25:48
Completed, primary suspect User:Bertrik Sikken
TZXDuino Pico
14 July 2023 18:00:00
Completed, primary suspect Mahjongg
Telefoon
5 May 2024 19:10:41
Completed, primary suspect User:Eloy
The eye of the Internet
27 October 2016 20:08:29
Completed, primary suspect User:Gori
Thinkpad Graveren
22 January 2018 21:01:42
Completed, primary suspect User:Bas
TransparantQR
27 April 2022 20:07:55
Completed, primary suspect Cmpxchg
Treinonderdelen
28 November 2023 11:47:49
Completed, primary suspect User:Bas
Trimble Acutime 2000
23 February 2019 12:02:30
Completed, primary suspect Thomas
VINDRIKTNING
28 July 2022 12:10:57
Completed, primary suspect User:Bertrik Sikken
Verhuizing
5 March 2017 12:14:05
Completed, primary suspect User:Jelly, Deuce
Verhuizing
5 October 2016 20:16:58
Completed, primary suspect Bestuur
Vloer
16 April 2018 10:12:57
Completed, primary suspect User:F0x, WinSCaP, Juerd, User:Maxell, User:Bas
Vogelhuisje met webcam
26 January 2014 16:58:19
Completed, primary suspect Folkert
Watermetermeter
14 October 2020 16:45:36
Completed, primary suspect User:FooBar
Werkbank
31 March 2021 11:34:48
Completed, primary suspect Juerd, pinoaffe
Wifiskip
9 February 2020 16:47:45
Completed, primary suspect User:Bas
Wiki Infotag
20 June 2018 05:50:14
Completed, primary suspect User:Bas
WikiMigration
3 March 2012 19:31:20
Completed, primary suspect Many
Restaurant
6 September 2016 18:23:42
Completed, primary suspect User:Bas
Rotating XY Table for microscope
1 May 2021 08:03:30
Completed, primary suspect Cmpxchg
ZX81+35 ZX81 clone
5 April 2022 18:18:32
Completed, primary suspect Mahjongg
ZigbeeCoordinator
14 March 2019 20:48:36
Completed, primary suspect User:Bertrik Sikken
ZON X-81 PSG for ZX81+35
5 April 2022 18:22:22
Completed, primary suspect Mahjongg
Zonwering
8 August 2022 17:58:10
Completed, primary suspect User:Bas
Zweepdraaibank
23 September 2019 16:20:16
Completed, primary suspect User:Molenaar