Bases psychopédagogiques des technologies éducatives/Liste de participants tetris

Voici deux listes:

Personnes inscrites au cours

AL-FALLOUJI MOHAMED
BAEHLER MARGOT
FAN LESHAN
FOLLONIER VALERIE
FRITZ MATTIA
GAUTHIER DAMIEN
GIACHINO LUCA
KARANISA EIRINI
MAOLE KAMANDA YEELEN
MATROSOVA MARIA
MELLINO SABRINA
MOUATTA MOHAMED-SALIM
RATTU PAOLA
ROLLIER AXELLE
SCHERRER FELICIE
TRAVNJAK JASMINA
YILMAZ GUNEY

Personnes ayant participé en utilisant le widget

Debug output SQLStore

ASK Query

[[REPORTING:+]] [[Agent::+]] [[Page wiki::+]] [[Catégorie principale::Catégorie:Bases psychopédagogiques des technologies éducatives]]

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_object_ids` AS t2
INNER JOIN
  `smw_di_wikipage` AS t3 ON t2.smw_id=t3.s_id
INNER JOIN
  `smw_di_wikipage` AS t6 ON t2.smw_id=t6.s_id
INNER JOIN
  `smw_di_wikipage` AS t9 ON t2.smw_id=t9.s_id) ON t0.smw_id=t2.smw_id
WHERE
  (t2.smw_namespace=6602
   AND (t3.p_id=19979)
   AND (t6.p_id=19980)
   AND (t9.p_id=19985 AND t9.o_id=20050)
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  505
OFFSET
  0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t9	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id	5	const	659		Using where; Using temporary; Using filesort
1	SIMPLE	t6	ref	s_id, p_id, s_id_2, s_id_3	s_id	8	fmediawiki_135.t9.s_id, const	1		Using index
1	SIMPLE	t2	eq_ref	PRIMARY, smw_id, smw_namespace	PRIMARY	4	fmediawiki_135.t9.s_id	1		Using where
1	SIMPLE	t3	ref	s_id, p_id, s_id_2, s_id_3	s_id	8	fmediawiki_135.t9.s_id, const	1		Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	fmediawiki_135.t9.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:5
Query-Depth:1

Errors and Warnings

None