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
0
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
!revbank
23 January 2022 05:02:22
Completed, primary suspect Juerd
35C3 Tickets
14 October 2019 18:51:15
Completed, primary suspect User:FooBar
36C3 Streams kijken
24 February 2020 17:21:16
Completed, primary suspect User:Bas
36C3 Tickets
17 December 2019 13:03:51
Completed, primary suspect Bestuur
4G IoT
28 October 2018 19:18:17
Completed, primary suspect Juerd
A4PaperDispenser
18 November 2018 00:09:00
Completed, primary suspect User:Bertrik Sikken, User:Bas
ACS730 Hall-Effect Current Probe
6 June 2021 14:38:14
Completed, primary suspect User:Kartoffel
Analoge Cams
27 April 2017 19:20:13
Completed, primary suspect User:Peetz0r, User:Bas
Another JBC
30 January 2020 08:41:35
Completed, primary suspect User:Bas
Arcade console repair classes
11 November 2019 10:14:10
Completed, primary suspect Mahjongg
Assembling a RhoCoCo home computer
9 April 2019 18:12:01
Completed, primary suspect Mahjongg
Augurken
13 January 2016 23:04:07
Completed, primary suspect
Building up the ZX81+38
24 May 2023 17:53:49
Completed, primary suspect Mahjongg
BuildStatusTrafficLight
7 January 2019 17:54:16
Completed, primary suspect User:Bertrik Sikken
CCCamp19 Tickets
14 August 2019 20:56:13
Completed, primary suspect User:FooBar, User:Bas
CJMCU-811
29 July 2019 07:09:35
Completed, primary suspect User:Bertrik Sikken
CL 260 3D Printer
20 June 2018 05:49:42
Completed, primary suspect User:Bas
CO2MeterHacking
19 February 2018 12:33:30
Completed, primary suspect User:Bertrik Sikken
CPC464 Restart
16 January 2016 20:59:13
Completed, primary suspect Mahjongg
Chaotic circuits
26 November 2012 16:09:51
Completed, primary suspect User:Gori
Cloud shirt
10 July 2021 15:45:28
Completed, primary suspect Zawadi
De Weer
14 January 2024 11:53:12
Completed, primary suspect Colomax
FishFeeder
17 January 2024 19:36:12
Completed, primary suspect Colomax
ComicChat
27 May 2021 00:58:28
Completed, primary suspect User:Bas
CrawlSpaceSensor
4 April 2022 16:03:37
Completed, primary suspect User:Bertrik Sikken
Cyberstof kopen
24 May 2020 14:38:40
Completed, primary suspect User:Bas
DeBASS
13 January 2019 01:37:21
Completed, primary suspect User:Bas
Debian Handbook
10 November 2014 11:02:56
Completed, primary suspect User:FooBar
Decennium
13 March 2020 11:20:06
Completed, primary suspect User:F0x, Juerd, User:Bas
DecodingLora
11 May 2020 13:17:12
Completed, primary suspect User:Bertrik Sikken
Deep-fried candy bars
7 September 2020 15:14:03
Completed, primary suspect User:Noor, User:Bas
Deurding
9 July 2015 08:39:31
Completed, primary suspect User:Robv
Led Dodecahedron
15 January 2018 02:11:17
Completed, primary suspect User:F0x
Door sign
6 July 2018 15:52:20
Completed, primary suspect User:Thomas, User:Gori
Opt-in voor nickname bij online doorduino-meldingen
25 January 2022 22:55:17
Completed, primary suspect Bestuur
Doorduino1
13 January 2013 22:53:52
Completed, primary suspect Gmc
Doorduino 2
23 April 2016 21:43:36
Completed, primary suspect Hansg
Doorduino3
24 February 2023 15:09:28
Completed, primary suspect User:Bas
Drumleds
25 May 2017 13:58:28
Completed, primary suspect User:Merethan
Dust Sensor
1 January 2021 12:15:51
Completed, primary suspect User:Bertrik Sikken
ESP-Now
3 December 2022 13:27:00
Completed, primary suspect Kartoffel,bertrik
ElectronicLoad
28 November 2021 22:05:04
Completed, primary suspect User:Bertrik Sikken
Electronica componenten automaat
18 July 2018 01:15:37
Completed, primary suspect Hammercat
Embla
21 January 2018 20:11:50
Completed, primary suspect Folkert
Xiaomi schroevendraaierset graveren
3 February 2018 22:35:17
Completed, primary suspect Juerd
EspNowSkip
3 December 2022 13:36:35
Completed, primary suspect User:Bertrik Sikken, User:Jelly
ESP Sensor Grid
12 August 2018 22:08:23
Completed, primary suspect User:Bas
Eye Wash
6 November 2016 15:16:50
Completed, primary suspect User:PeterC
Fluke 8842A
2 May 2017 20:06:09
Completed, primary suspect User:Semafoor
Friday Foundations
24 February 2020 17:20:56
Completed, primary suspect User:Bas