Pirate Praveen Tue 31 May 2016 4:21PM
To get a feel of how it compares with other users
mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-30%' and diaspora_handle li
ke '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+--------------------+-------+
| diaspora_handle | c |
+--------------------+-------+
| [email protected] | 29618 |
| [email protected] | 4 |
| [email protected] | 4 |
+--------------------+-------+
3 rows in set (1.88 sec)
mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-29%' and diaspora_handle li
ke '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+------------------------+-------+
| diaspora_handle | c |
+------------------------+-------+
| [email protected] | 3 |
| [email protected] | 28030 |
| [email protected] | 3 |
| [email protected] | 7 |
+------------------------+-------+
4 rows in set (1.79 sec)
mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-28%' and diaspora_handle li
ke '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+-------------------------+-------+
| diaspora_handle | c |
+-------------------------+-------+
| [email protected] | 32 |
| [email protected] | 5 |
| [email protected] | 26431 |
| [email protected] | 3 |
| [email protected] | 3 |
| [email protected] | 3 |
| [email protected] | 3 |
+-------------------------+-------+
7 rows in set (2.03 sec)
mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-27%' and diaspora_handle like '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+----------------------------+------+
| diaspora_handle | c |
+----------------------------+------+
| [email protected] | 2 |
| [email protected] | 9802 |
| [email protected] | 2 |
| [email protected] | 5 |
| [email protected] | 5 |
| [email protected] | 2 |
+----------------------------+------+
6 rows in set (1.84 sec)
mysql> SELECT diaspora_handle, COUNT(*) c FROM photos where created_at like '2016-05-26%' and diaspora_handle like '%poddery.com' GROUP BY diaspora_handle HAVING c > 1;
+------------------------+------+
| diaspora_handle | c |
+------------------------+------+
| [email protected] | 22 |
| [email protected] | 5462 |
| [email protected] | 6 |
| [email protected] | 3 |
+------------------------+------+
4 rows in set (1.63 sec)
Pirate Praveen Wed 1 Jun 2016 8:41AM
Thanks to @mintojoseph for helping track this issue.
Pirate Praveen · Tue 31 May 2016 4:11PM
icu bot is uploading images like crazy, icu account is locked now
compare that with my account