Projets : Différence entre versions

De fablabo
Aller à : navigation, rechercher
Ligne 2 : Ligne 2 :
  
  
[[DYR]] Session de fabrication à Dakar en Avril 2012
 
  
  
[[GPSPointer]]
+
 
 +
{{#ask:[[Category:Projets]]
 +
| limit=30
 +
| sort=Date de modification
 +
| order=descending
 +
| ?
 +
| ?Description
 +
| ?Image
 +
|format=debug |template=ListeProjets |headers=hide |link=all  |offset= }}

Version du 24 octobre 2014 à 15:48

ici les Projets développés dans et autour du thème du fablab



Debug Output by SQLStore

Ask query

[[Catégorie:Projets]]

SQL Query

SELECT DISTINCT
  t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey , t4.o_sortkey
FROM
  `mw_smw_object_ids` AS t2
INNER JOIN
  `mw_smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN
  `mw_t1` AS t1 ON t0.o_id=t1.id
INNER JOIN
  `mw_smw_fpt_mdat` AS t4 ON t2.smw_id=t4.s_id
WHERE
  t2.smw_iw!=':smw' AND t2.smw_iw!=':smw-delete' AND t2.smw_iw!=':smw-redi'
ORDER BY
  t4.o_sortkey DESC
LIMIT
  35
OFFSET
  0

SQL Explain

IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1ALLPRIMARY2Using temporary; Using filesort
1SIMPLEt0refs_id,o_ido_id5fablabo.t1.id9
1SIMPLEt4refs_ids_id4fablabo.t0.s_id1
1SIMPLEt2eq_refPRIMARY,smw_id,smw_iwPRIMARY4fablabo.t0.s_id1Using where

Auxilliary Tables Used

  • Temporary table t1
      Recursively computed hierarchy for element(s) ('137').

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None