Debug output SQLStore
ASK Query
[[Categorie:Activiteit]] [[Event Contact::Gebruiker:JanBee]]
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=22090
AND (t4.p_id=22039 AND t4.o_id=2079)
)
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
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 53 | | Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | deckart_hack42wiki.t4.s_id, const | 1 | | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | deckart_hack42wiki.t4.s_id | 1 | | Using where |
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
![Bezoek van Pixelbar](/mediawiki/images/thumb/6/6e/LogoPixelbar.png/174px-LogoPixelbar.png)
Bezoek Pixelbar 23 maart 2024
23 maart 2024 14:00:00
![Fysica v.d. Fotografie](/mediawiki/images/thumb/6/60/LensDiagram.gif/208px-LensDiagram.gif)
Fysica van de Fotografie
13 januari 1337 13:37:00
JL![Een Graphical User Interface bouwen met Free-Pascal en de Lazarus IDE](/mediawiki/images/thumb/c/c5/GUI-Foucault.jpg/138px-GUI-Foucault.jpg)
GUI bouwen met Lazarus / Free Pascal
24 mei 2024 20:00:00
![Presentatie van mijn plannen](/mediawiki/images/thumb/a/a5/Huge_Ass_Lasercutter_Picture.jpg/104px-Huge_Ass_Lasercutter_Picture.jpg)
Afbouwen Grote Lasercutter
2 april 2019 20:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Het_dak_gaat_eraf_19_september_2020
19 september 2020 09:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Het_dak_gaat_eraf_20_september_2020
20 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Het_dak_gaat_eraf_5_september_2020
5 september 2020 09:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Het_dak_gaat_eraf_6_september_2020
6 september 2020 10:00:00
![Instructie Metaalbewerking](/mediawiki/images/thumb/f/f7/ZaagDoorn.jpg/294px-ZaagDoorn.jpg)
Instructie Metaalbewerking Machinaal
29 juni 2018 19:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdinsdag_11_augustus_2020
11 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdinsdag_18_augustus_2020
18 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdinsdag_25_augustus_2020
25 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdinsdag_28_juli_2020
28 juli 2020 00:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdinsdag_4_augustus_2020
4 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdonderdag_10_september_2020
10 september 2020 19:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdonderdag_17_september_2020
17 september 2020 19:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdonderdag_3_september_2020
3 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusdonderdag_30_juli_2020
30 juli 2020 20:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusvrijdag_11_september_2020
11 september 2020 19:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Klusvrijdag_17_juli_2020
17 juli 2020 18:30:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusvrijdag_18_september_2020
18 september 2020 19:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Klusvrijdag_31_juli_2020
31 juli 2020 00:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluswoensdag_16_september_2020
16 september 2020 16:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluswoensdag_19_augustus_2020
19 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluswoensdag_19_augustus_2020
2 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluswoensdag_26_augustus_2020
26 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluswoensdag_9_september_2020
9 september 2020 16:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_1_augustus_2020
1 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_12_september_2020
12 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_15_augustus_2020
15 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_19_september_2020
19 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_22_augustus_2020
22 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_25_juli_2020
25 juli 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_26_september_2020
26 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_29_augustus_2020
29 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_3_oktober_2020
3 oktober 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszaterdag_8_augustus_2020
8 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszondag_2_augustus_2020
2 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszondag_20_september_2020
20 september 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszondag_23_augustus_2020
23 augustus 2020 10:00:00
![Cruquiusweg klussen](/mediawiki/images/thumb/0/08/Maken_Pand4.1_Picture.jpg/100px-Maken_Pand4.1_Picture.jpg)
Kluszondag_30_augustus_2020
30 augustus 2020 10:00:00
![Vlooienmarkt radio / elektronica spul](/mediawiki/images/thumb/9/9a/Rvlmrkt.jpg/133px-Rvlmrkt.jpg)
Radio Vlooienmarkt Rosmalen
21 maart 2015 09:00:00
![Vlooienmarkt elektonica](/mediawiki/images/thumb/8/8b/5578headershort.jpg/424px-5578headershort.jpg)
Radio Vlooienmarkt Rosmalen
15 maart 2014 10:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopdinsdag_14_juli_2020
14 juli 2020 19:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopdinsdag_21_juli_2020
21 juli 2020 00:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopdonderdag_16_juli_2020
16 juli 2020 20:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopdonderdag_23_juli_2020
23 juli 2020 20:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopzaterdag_11_juli_2020
11 juli 2020 10:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopzaterdag_18_juli_2020
18 juli 2020 00:00:00
![Cruquiusweg slopen](/mediawiki/images/thumb/c/c1/Slopen_Pand4p0_Picture.jpg/150px-Slopen_Pand4p0_Picture.jpg)
Sloopweekend 1
12 juni 2020 10:30:00