Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

SELECT LENGTH(NomP) as Nombre, NomP, Prenom FROM `personne_contact` ORDER BY Nombre DESC

Permet de compter le nombre de connections effectués par chaque personne de la BDD sur l'extranet
SELECT COUNT(iduser) AS Connection, NomP, Prenom, sigle, nom FROM log_session L JOIN personne_contact PC ON L.iduser=PC.idper JOIN personnel P ON PC.idper=P.id_pers JOIN contact C ON C.idcon=P.id_org WHERE timestamp LIKE "%2014%" AND P.etat=1 GROUP BY NomP ASC WITH ROLLUP

SELECT COUNT(iduser) AS Connection, NomP, Prenom, sigle, nom FROM log_session L JOIN personne_contact PC ON L.iduser=PC.idper JOIN personnel P ON PC.idper=P.id_pers JOIN contact C ON C.idcon=P.id_org WHERE timestamp LIKE "%2014%" AND P.etat=1 GROUP BY NomP ASC WITH ROLLUP

SELECT idper as session, idper, Prenom, NomP FROM `log_session` L JOIN personne_contact PC ON L.iduser=PC.idper WHERE idper IN (SELECT DISTINCT (iduser) FROM `log_session` WHERE timestamp LIKE "%2014-%") AND timestamp LIKE "%2014-%" ORDER BY idper ASC

SELECT u.name name, FROM_UNIXTIME(u.login) AS login, FROM_UNIXTIME(u.access) AS access, FROM_UNIXTIME(u.created) AS created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) AS first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail ='mail@domain.tld'

SELECT count(u.name) as compteur, u.name name, u.login login, u.access access, u.created created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail ='mail@domain.tld' ORDER BY `first_seen_timestamp` ASC

SELECT count(u.name) as compteur, u.name name, u.mail email, FROM_UNIXTIME(u.login) login, FROM_UNIXTIME(u.access) access, FROM_UNIXTIME(u.created) created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail IN (SELECT mail FROM `users` WHERE mail <> '') GROUP BY u.mail ASC WITH ROLLUP

SELECT count(u.name) as compteur, u.name name, u.mail email, FROM_UNIXTIME(u.login) login, FROM_UNIXTIME(u.access) access, FROM_UNIXTIME(u.created) created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail IN (SELECT mail FROM `users` WHERE mail <> '') GROUP BY u.mail ASC ORDER BY `first_seen_timestamp` ASC

Categorie-s

• mySQL