[chronojump] counting social network poll on countPingsAtServer.txt

[Xavier de Blas <xaviblas src gnome org>]

commit c838191db81fe64e8de01f87e5f3a4f2018f19d5
Author: Xavier de Blas <xaviblas gmail com>
Date:   Fri Jul 16 18:37:14 2021 +0200

    counting social network poll on countPingsAtServer.txt

 testing-stuff/countPingsAtServer.txt | 3 +++
 1 file changed, 3 insertions(+)
---
diff --git a/testing-stuff/countPingsAtServer.txt b/testing-stuff/countPingsAtServer.txt
index cad77edab..78f5bfd8b 100644
--- a/testing-stuff/countPingsAtServer.txt
+++ b/testing-stuff/countPingsAtServer.txt
@@ -11,3 +11,6 @@ or:
 SELECT COUNT(*) FROM ping WHERE cjVersion LIKE "%2.0.2%" AND osVersion LIKE "%MacOSX%" GROUP BY machineID;
 SELECT COUNT(*) FROM ping WHERE cjVersion LIKE "%2.0.2%" AND osVersion LIKE "Unix, %" GROUP BY machineID;
 SELECT COUNT(*) FROM ping WHERE cjVersion LIKE "%2.0.2%" AND osVersion LIKE "%Win%" GROUP BY machineID;
+
+
+SELECT count(*) AS conta, socialNetwork FROM socialNetwork GROUP BY socialNetwork ORDER BY conta DESC;