Table des matières

Catalogue de requêtes génériques

Block Dashboard (Elément de tableau de bord)

Liste des groupes

SELECT 

g.id AS gid,
c.shortname as cs,
cc1.name as cc1,
cc2.name as cc2,
c.fullname as cn,
g.name as g,
g.timecreated AS gc,
g.timemodified AS gm,
COUNT(*) as gms

FROM 

{course} c,
{course_categories} cc1,
{course_categories} cc2,
{groups} g,
{groups_members} gm

WHERE 

  cc1.id = c.category AND
  cc2.id = cc1.parent AND
  c.id = g.courseid AND
  g.id = gm.groupid

GROUP BY 

  g.id

ORDER BY 

  cc2.name,cc1.name,c.fullname,g.name

Configuration

Tzo4OiJzdGRDbGFzcyI6MTA1OntzOjU6InRpdGxlIjtzOjE3OiJMaXN0ZSBkZXMgZ3JvdXBlcyI7czoxMzoiaW5ibG9ja2xheW91dCI7czoxOiIwIjtzOjY6InRhcmdldCI7czo2OiJtb29kbGUiO3M6ODoic2hvd2RhdGEiO3M6MToiMSI7czo5OiJzaG93Z3JhcGgiO3M6MToiMSI7czoxMToic2hvd251bXN1bXMiO3M6MToiMSI7czo5OiJzaG93cXVlcnkiO3M6MToiMCI7czoxNzoic2hvd2ZpbHRlcnF1ZXJpZXMiO3M6MToiMCI7czo1OiJxdWVyeSI7czo0OTI6IlNFTEVDVA0KICBnLmlkIEFTIGdpZCwNCiAgYy5zaG9ydG5hbWUgYXMgY3MsDQogIGNjMS5uYW1lIGFzIGNjMSwNCiAgY2MyLm5hbWUgYXMgY2MyLA0KICBjLmZ1bGxuYW1lIGFzIGNuLA0KICBnLm5hbWUgYXMgZywNCiAgZy50aW1lY3JlYXRlZCBBUyBnYywNCiAgZy50aW1lbW9kaWZpZWQgQVMgZ20sDQogIENPVU5UKCopIGFzIGdtcw0KRlJPTQ0KICB7Y291cnNlfSBjLA0KICB7Y291cnNlX2NhdGVnb3JpZXN9IGNjMSwNCiAge2NvdXJzZV9jYXRlZ29yaWVzfSBjYzIsDQogIHtncm91cHN9IGcsDQogIHtncm91cHNfbWVtYmVyc30gZ20NCldIRVJFDQogICAgY2MxLmlkID0gYy5jYXRlZ29yeSBBTkQNCiAgICBjYzIuaWQgPSBjYzEucGFyZW50IEFORA0KICAgIGMuaWQgPSBnLmNvdXJzZWlkIEFORA0KICAgIGcuaWQgPSBnbS5ncm91cGlkDQpHUk9VUCBCWQ0KICAgIGcuaWQNCk9SREVSIEJZDQogICAgY2MyLm5hbWUsY2MxLm5hbWUsYy5mdWxsbmFtZSxnLm5hbWUNCiI7czoxNToicXVlcnlyb3RhdGVjb2xzIjtzOjA6IiI7czoxNjoicXVlcnlyb3RhdGVwaXZvdCI7czowOiIiO3M6MTg6InF1ZXJ5cm90YXRlbmV3a2V5cyI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyMSI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWwxIjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlMSI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzMSI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyMiI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWwyIjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlMiI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzMiI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyMyI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWwzIjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlMyI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzMyI7czowOiIiO3M6MTI6InNxbHBhcmFtdmFyNCI7czowOiIiO3M6MTQ6InNxbHBhcmFtbGFiZWw0IjtzOjA6IiI7czoxMzoic3FscGFyYW10eXBlNCI7czo2OiJjaG9pY2UiO3M6MTU6InNxbHBhcmFtdmFsdWVzNCI7czowOiIiO3M6OToidGFibGV0eXBlIjtzOjY6ImxpbmVhciI7czoxMjoib3V0cHV0ZmllbGRzIjtzOjI1OiJjYzI7Y2MxO2NzO2NuO2c7Z2M7Z207Z21zIjtzOjExOiJmaWVsZGxhYmVscyI7czo2OToiQ2F0w6lnb3JpZTtTb3VzLWNhdMOpZ29yaWU7Q29kZTtDb3VycztHcm91cGU7Q3LDqcOpO01vZGlmacOpO0VmZmVjdGlmIjtzOjEzOiJvdXRwdXRmb3JtYXRzIjtzOjIzOiIlczslczslczslczslczslRDslRDslZCI7czo4OiJwYWdlc2l6ZSI7czowOiIiO3M6MTU6InVzZWxvY2FsY2FjaGluZyI7czoxOiIxIjtzOjEwOiJjYWNoaW5ndHRsIjtzOjA6IiI7czoxMjoiY2xlYW5kaXNwbGF5IjtzOjE6IjEiO3M6MjI6ImNsZWFuZGlzcGxheXVwdG9jb2x1bW4iO3M6MDoiIjtzOjg6InNvcnRhYmxlIjtzOjE6IjEiO3M6MTU6InNwbGl0c3Vtc29uc29ydCI7czowOiIiO3M6MTI6InZlcnRpY2Fsa2V5cyI7czowOiIiO3M6ODoiaG9yaXprZXkiO3M6MDoiIjtzOjE1OiJ2ZXJ0aWNhbGZvcm1hdHMiO3M6MDoiIjtzOjExOiJob3JpemZvcm1hdCI7czowOiIiO3M6Nzoic3BsaXRvbiI7czowOiIiO3M6OToiaG9yaXpzdW1zIjtzOjE6IjAiO3M6ODoidmVydHN1bXMiO3M6MToiMCI7czoxNDoidmVydGljYWxsYWJlbHMiO3M6MDoiIjtzOjEwOiJob3JpemxhYmVsIjtzOjA6IiI7czoxMToicGFyZW50c2VyaWUiO3M6MDoiIjtzOjEwOiJ0cmVlb3V0cHV0IjtzOjA6IiI7czoxNzoidHJlZW91dHB1dGZvcm1hdHMiO3M6MDoiIjtzOjc6ImZpbHRlcnMiO3M6MDoiIjtzOjEyOiJmaWx0ZXJsYWJlbHMiO3M6MDoiIjtzOjE0OiJmaWx0ZXJkZWZhdWx0cyI7czowOiIiO3M6MTM6ImZpbHRlcm9wdGlvbnMiO3M6MDoiIjtzOjc6Im51bXN1bXMiO3M6MDoiIjtzOjEzOiJudW1zdW1mb3JtYXRzIjtzOjA6IiI7czoxMjoibnVtc3VtbGFiZWxzIjtzOjA6IiI7czo5OiJncmFwaHR5cGUiO3M6NDoibGluZSI7czoxMDoieGF4aXNmaWVsZCI7czowOiIiO3M6MTA6InhheGlzbGFiZWwiO3M6MDoiIjtzOjc6InlzZXJpZXMiO3M6MDoiIjtzOjE0OiJ5c2VyaWVzZm9ybWF0cyI7czowOiIiO3M6MTI6InNlcmllc2xhYmVscyI7czowOiIiO3M6NDoieW1pbiI7czowOiIiO3M6NDoieW1heCI7czowOiIiO3M6MTE6InRpY2tzcGFjaW5nIjtzOjA6IiI7czoxMDoieWF4aXNsYWJlbCI7czowOiIiO3M6MTA6ImdyYXBod2lkdGgiO3M6MzoiNDUwIjtzOjExOiJncmFwaGhlaWdodCI7czozOiIyNTAiO3M6MTA6InNob3dsZWdlbmQiO3M6MToiMCI7czo3OiJtYXB0eXBlIjtzOjc6IlJPQURNQVAiO3M6NDoiem9vbSI7czoxOiI2IjtzOjEwOiJkYXRhdGl0bGVzIjtzOjA6IiI7czoxMzoiZGF0YWxvY2F0aW9ucyI7czowOiIiO3M6OToiZGF0YXR5cGVzIjtzOjA6IiI7czozOiJsYXQiO3M6MToiMCI7czozOiJsbmciO3M6MToiMCI7czoxMzoic2hvd2xvd2VyYmFuZCI7czoxOiIxIjtzOjEzOiJ1cHBlcmJhbmR1bml0IjtzOjU6Ik1PTlRIIjtzOjEzOiJsb3dlcmJhbmR1bml0IjtzOjQ6IllFQVIiO3M6MTg6InRpbWVsaW5lZXZlbnR0aXRsZSI7czowOiIiO3M6MTg6InRpbWVsaW5lZXZlbnRzdGFydCI7czowOiIiO3M6MTY6InRpbWVsaW5lZXZlbnRlbmQiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWV2ZW50bGluayI7czowOiIiO3M6MTc6InRpbWVsaW5lZXZlbnRkZXNjIjtzOjA6IiI7czoxNDoidGltZWxpbmVjb2xvcnMiO3M6MDoiIjtzOjE4OiJ0aW1lbGluZWNvbG9yZmllbGQiO3M6MDoiIjtzOjE3OiJ0aW1lbGluZWNvbG9ya2V5cyI7czowOiIiO3M6ODoiY3Jvbm1vZGUiO3M6OToibm9yZWZyZXNoIjtzOjg6ImNyb25ob3VyIjtzOjA6IiI7czo3OiJjcm9ubWluIjtzOjA6IiI7czoxMzoiY3JvbmZyZXF1ZW5jeSI7czo1OiJkYWlseSI7czo4OiJtYWtlZmlsZSI7czoxOiIxIjtzOjEwOiJmaWxlb3V0cHV0IjtzOjA6IiI7czoxNzoiZmlsZW91dHB1dGZvcm1hdHMiO3M6MDoiIjtzOjEwOiJmaWxlZm9ybWF0IjtzOjM6IkNTViI7czoxNToiZmlsZXNxbG91dHRhYmxlIjtzOjA6IiI7czoxMjoiZmlsZWxvY2F0aW9uIjtzOjA6IiI7czoyMToiZmlsZXBhdGhhZG1pbm92ZXJyaWRlIjtzOjA6IiI7czo4OiJzYXZldmlldyI7czoyMzoiRW5yZWdpc3RyZXIgZXQgYWZmaWNoZXIiO3M6OToic3FscGFyYW1zIjtOO3M6OToiaXNydW5uaW5nIjtpOjA7czo4OiJsYXN0Y3JvbiI7aTowO3M6MTM6ImV4cG9ydGNoYXJzZXQiO3M6NDoidXRmOCI7fQ==

Crédits

Revenir au catalogue de requêtes génériques - Index du composant - Revenir à l'index des plugins - Revenir au catalogue