Public feed #890673

Stuff

public text v1 · immutable
Raw Edit
·published 2008-02-03 23:05 UTC
rendered paste body
mysql> select * FROM gameEvents WHERE event='damaged' and source='hase' and param1='sudoble';
Empty set (1.17 sec)

mysql> select * FROM gameEvents WHERE event='damaged' and source='sudoble' and param1='hase';
Empty set (0.46 sec)

mysql> select * FROM gameEvents WHERE event='damaged' and source='sudoble' and param1='sternchen';
Empty set (0.05 sec)

mysql> select * FROM gameEvents WHERE event='damaged' and source='sternchen' and param1='sudoble';
+----------+---------------------+-----------+---------+---------+--------+
| id       | timedate            | source    | event   | param1  | param2 |
+----------+---------------------+-----------+---------+---------+--------+
| 25575040 | 2008-02-03 08:06:05 | sternchen | damaged | sudoble | 3      |
| 25575049 | 2008-02-03 08:06:08 | sternchen | damaged | sudoble | 1      |
| 25575057 | 2008-02-03 08:06:11 | sternchen | damaged | sudoble | 1      |
| 25575063 | 2008-02-03 08:06:14 | sternchen | damaged | sudoble | 1      |
| 25575066 | 2008-02-03 08:06:16 | sternchen | damaged | sudoble | 1      |
| 25575068 | 2008-02-03 08:06:16 | sternchen | damaged | sudoble | 1      |
| 25575152 | 2008-02-03 08:06:55 | sternchen | damaged | sudoble | 1      |
| 25575156 | 2008-02-03 08:06:57 | sternchen | damaged | sudoble | 2      |
| 25575159 | 2008-02-03 08:06:58 | sternchen | damaged | sudoble | 1      |
| 25575160 | 2008-02-03 08:06:59 | sternchen | damaged | sudoble | 1      |
| 25575162 | 2008-02-03 08:07:00 | sternchen | damaged | sudoble | 2      |
| 25575164 | 2008-02-03 08:07:00 | sternchen | damaged | sudoble | 2      |
| 25575168 | 2008-02-03 08:07:00 | sternchen | damaged | sudoble | 1      |
| 25575175 | 2008-02-03 08:07:02 | sternchen | damaged | sudoble | 1      |
| 25575179 | 2008-02-03 08:07:03 | sternchen | damaged | sudoble | 1      |
| 25575180 | 2008-02-03 08:07:03 | sternchen | damaged | sudoble | 2      |
| 25575182 | 2008-02-03 08:07:04 | sternchen | damaged | sudoble | 3      |
| 25575203 | 2008-02-03 08:07:09 | sternchen | damaged | sudoble | 1      |
| 25575205 | 2008-02-03 08:07:09 | sternchen | damaged | sudoble | 2      |
| 25575215 | 2008-02-03 08:07:13 | sternchen | damaged | sudoble | 2      |
| 25575233 | 2008-02-03 08:07:16 | sternchen | damaged | sudoble | 1      |
+----------+---------------------+-----------+---------+---------+--------+
21 rows in set (0.03 sec)

mysql> select * FROM gameEvents WHERE event='damaged' and source='hase' and param1='sudoble';
Empty set (0.02 sec)