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
55
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
29 May 2024 08:35:10
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
RevSpace App, MacOS in Qemu-KVM
19 April 2019 11:58:42
Completed, Abandoned, 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