Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Project]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=8504)
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
180
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=8504)
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
180
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 464 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | revspacenl.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneProject Name | Project Status | Project Contact | |
---|---|---|---|
IntelliKeys | IntelliKeys | In progress | Luteijn |
InverseGraffiti | InverseGraffiti | Completed | Stitch |
Jitsi | Jitsi | Completed | F0x |
KITtyBot | KITtyBot | In progress | Trashman |
Kabelsalat | Kabelsalat | Completed | Dave o Jelle Bas |
Karaburan | Karaburan | Initializing | Bertrik Sikken |
KatBeeldje | KatBeeldje | Completed | Folkert |
Keramiek Oven Controller | Keramiek Oven Controller | Initializing | Ash |
Keramiekoven | Keramiek oven | Completed | Gert Kremer Gori |
KinderSupriseChallenge | KinderSupriseChallenge | Abandoned | Crashjuh Jelly Bas |
Kindle repair | Kindle repair en hacking | Completed | Bas |
Klokkie | Klokkie | Abandoned | Pwuts |
Knopje 2 | Knopje 2 | Abandoned | Bas |
Knopje X | Knopje X | Completed | Juerd |
LART | LART | Completed | Anybody with a clue |
LCD screen | LCD screen as second monitor | Completed | Noor |
LED mini-skirt and tiara | LED mini-skirt and tiara | In progress | Noor |
LED skirt | LED skirt | In progress | Noor |
LGT-92 | LGT-92 | Initializing | Bertrik Sikken |
Laadpunt | Laadpunt | In progress | Merethan |
Lang zal die leven | Lang zal die leven | Completed | Juerd |
Lange lichtkrant | Lange Lichtkrant | Abandoned | Maxell Bas |
LaserCutterFundRaiser | LaserCutterFundRaiser | Completed | ? |
LaserCutterUsageCounter | LaserCutterCounter | Stalled | Bertrik Sikken |
Lasercutter2 | Lasercutter2 | Abandoned | Mux |
Lastcall | lastcall | Completed | Qguv |
Lathe | RevLathe | Abandoned | Pwuts |
LedBanner | LedBanner | Completed | Juerd |
Ledcube | Ledcube | Completed | Polyfloyd Boekenwuurm Bas |
Ledlamp | Ledlamp | F0x | |
Ledspace | Ledspace | Initializing | F0x |
LichtKrant | LichtKrant | Completed | Bertrik Sikken |
Lichtknop | Lichtknop | Completed | Juerd |
Lichtkrant Sigma ASC 333 | Lichtkrant Sigma ASC 333 | Completed | Bas |
Lichtz0r | Lichtz0r | Stalled | Peetz0r |
LoRa-E5-mini | LoRa E5 | In progress | Bertrik Sikken |
LoRa-OBD2-Spy | LoRa OBD2 Spy | In progress | Techwolf12 |
LoRaGateway | LoRaGateway | Completed | Bertrik Sikken Dave o Maxell |
LoRaSkip | LoRaSkip | Initializing | Dave o / Maxell |
Logic probe | Logic Probe | Completed | Mahjongg |
LoraBatBox | LoraBatBox | Completed | Bertrik Sikken |
LoraWanDustSensor | LoRaWAN dust Sensor | In progress | Bertrik Sikken |
LoraWanNode | LoraWanNode | Completed | Bertrik Sikken |
Lumos! | Lumos | Completed | Bas |
Luteijn/Beacon | Luteijn/Beacon | In progress | Luteijn |
Luteijn/FieldDay | Luteijn/FieldDay | Initializing | Luteijn |
Luteijn/HAB | Luteijn/HAB | In progress | Luteijn |
Luteijn/IRRemotes | Luteijn/IRRemotes | In progress | Luteijn |
Luteijn/Laptop | Luteijn/Laptop | In progress | Luteijn |
Luteijn/MIDI | Luteijn/MIDI | In progress | Luteijn |