Locked History Actions

Diff for "FLISOL2006/SistemaRegistro"

Differences between revisions 3 and 4
⇤ ← Revision 3 as of 2006-03-11 01:54:56 →
Size: 529
Editor: IgorTamara
Comment:
← Revision 4 as of 2006-03-11 01:55:38 → ⇥
Size: 554
Editor: IgorTamara
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
[[QueryDb(SELECT nombre FROM paises)]] [[QueryDb(SELECT nombre FROM paises ORDER BY nombre)]]
Line 7: Line 7:
[[QueryDb(SELECT c.nombre,c.wikiname,count(co.id) AS solicitudes FROM ciudades c, computadores co WHERE co.ciudad=c.id group by c.wikiname,c.nombre ORDER BY solicitudes DESC)]] [[QueryDb(SELECT c.nombre,c.wikiname,count(co.id) AS solicitudes FROM ciudades c, computadores co WHERE co.ciudad=c.id group by c.wikiname,c.nombre ORDER BY solicitudes DESC,c.nombre)]]

Países en el sistema

QueryDb(SELECT nombre FROM paises ORDER BY nombre)

Ciudades registradas en el Sistema

QueryDb(SELECT p.nombre,count(c.id) AS ciudades FROM paises p, departamentos d, ciudades c WHERE p.id=d.pais AND d.id=c.departamento GROUP BY p.nombre ORDER BY ciudades DESC,p.nombre)

Inscripciones por ciudad

QueryDb(SELECT c.nombre,c.wikiname,count(co.id) AS solicitudes FROM ciudades c, computadores co WHERE co.ciudad=c.id group by c.wikiname,c.nombre ORDER BY solicitudes DESC,c.nombre)

last edited 2010-02-05 03:59:44 by localhost