apps

SELECT clients.name AS 'Client', COUNT(*) AS 'count' FROM plugin_mp_ninite_history, clients, computers WHERE computers.clientid=clients.clientid AND plugin_mp_ninite_history.computerid=computers.computerid AND `action` IN (2,3) AND plugin_mp_ninite_history.TIMESTAMP > DATE_ADD(NOW(), INTERVAL -1 DAY) GROUP BY clients.name ORDER BY COUNT DESC LIMIT 6;