Mitglieder

	Realname	Nickname
Akuli	Luca	Akuli
Bola	Torsten	Bola
Byteturtle		Byte
CoolFrog	Christian Staab	CoolFrog
CyberTA	Thomas Kuhn	CyberTA
Dampfkadse		Dampfkadse
DerZombiiie		Riley
DerZombiiie/GPGkey
Dg3hda	Hendrik Dietrich	Dg3hda
Elektronik133	Jonas	Elektronik133
Ember	Ember	Ember
Florian DG5MHF	Florian Wimmer	Florian DG5MHF
Fraxinas	Andreas Frisch	Fraxinas
Fraxinas/GPGkey
FrodoZet	Jochen Roehrig	FrodoZet
Helpusobi	Timon Richter	Helpusobi
JanT	Jan T.	JanT
Kaenguru	Michael P.	Kaenguru
Koregan	Andreas Weitz	Koregan
Kuebi		Kübi
Leon	Leon Appel	Leon
Leyonardo	Herbert Leypold	Leyonardo
Lufti	Tim	Lufti
MaesterK	Karsten	MaesterK
Nick	Nick Nöther	Nick
Oliver	Oliver	Oliver
Pagaty	Christian G.	Pagaty
Panky9	Florian Pankerl	Panky9
Panky9/GPGkey
Patrick	Patrick	Mastodon
Polygon	Ally	Polygon
Purplegecko	Justin Frisch	Purplegecko
SalomeArkane	Jasmin Dietrich	SalomeArkane
Schaffenbeeb	Schaffenbeeb	Schaffenbeeb
Stev96	Steven	Stev96
Thesponge		Thesponge
U63725	Andre	U63725
VinRisen360	Paul Freudenberger	VinRisen360
Volker62	Volker Kämpf	Volker62
Yohko	Jana P.	Yohko
Zoredh	Olaf	Zoredh

Debug output SQLStore

ASK Query

[[Kategorie:Mitglieder]]

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, idst4.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_fpt_inst` AS t1
INNER JOIN
  `t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
INNER JOIN
  (`smw_di_wikipage` AS t4
INNER JOIN
  `smw_object_ids` AS idst4 ON idst4.smw_id=t4.o_id) ON t0.smw_id=t4.s_id
WHERE
  (t4.p_id=528)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  idst4.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	t2	ALL	PRIMARY				2		Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	mediawiki.t2.id	15		Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	mediawiki.t1.s_id	1		Using where
1	SIMPLE	t4	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	s_id_3	8	mediawiki.t1.s_id, const	1		Using where; Using index
1	SIMPLE	idst4	eq_ref	PRIMARY, smw_id	PRIMARY	4	mediawiki.t4.o_id	1

Auxilliary Tables

• Temporary table t2
    Recursively computed hierarchy for element(s) (519).
    SELECT s_id FROM `smw_fpt_subc` WHERE o_id=519 LIMIT 1

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None