MariaDB [enwiki_p]> SELECT ipb_address AS target, user_name AS blocking_username, ipb_timestamp AS block_time, ipb_expiry AS expiry FROM ipblocks JOIN user ON user_id=ipb_by WHERE ipb_expiry LIKE '20130602%' AND ipb_auto != '1' ORDER BY ipb_timestamp;
+-----------------+-------------------+----------------+----------------+
| target | blocking_username | block_time | expiry |
+-----------------+-------------------+----------------+----------------+
| 168.212.194.2 | Courcelles | 20100602205025 | 20130602205025 |
| 206.82.19.254 | Zzuuzz | 20101025210025 | 20130602234512 |
| 198.180.129.20 | Zzuuzz | 20101025210026 | 20130602234005 |
| 69.147.20.254 | Vsmith | 20111202190129 | 20130602190129 |
| 66.218.148.66 | Vsmith | 20111202222338 | 20130602222338 |
| 117.41.175.51 | Graeme Bartlett | 20130302223022 | 20130602223022 |
| 198.204.227.18 | Graeme Bartlett | 20130302223029 | 20130602223029 |
| 192.8.180.97 | ProcseeBot | 20130402201209 | 20130602201209 |
| 58.215.184.174 | ProcseeBot | 20130402201210 | 20130602201210 |
| 122.115.57.26 | ProcseeBot | 20130402210409 | 20130602210409 |
| 180.253.130.190 | ProcseeBot | 20130402211209 | 20130602211209 |
| 183.89.86.160 | ProcseeBot | 20130402211209 | 20130602211209 |
| 194.110.204.4 | ProcseeBot | 20130402211210 | 20130602211210 |
| 173.178.202.218 | ProcseeBot | 20130402214116 | 20130602214116 |
| 174.44.86.35 | ProcseeBot | 20130402214117 | 20130602214117 |
| 178.124.76.13 | ProcseeBot | 20130402214118 | 20130602214118 |
| 37.112.224.49 | ProcseeBot | 20130402214118 | 20130602214118 |
| 41.42.62.153 | ProcseeBot | 20130402214119 | 20130602214119 |
| 46.98.142.186 | ProcseeBot | 20130402220409 | 20130602220409 |
| 90.18.181.129 | ProcseeBot | 20130402220409 | 20130602220409 |
| 219.229.101.122 | ProcseeBot | 20130402223317 | 20130602223317 |
| 97.67.67.43 | Bagumba | 20130502185809 | 20130602185809 |
| 69.150.242.57 | HJ Mitchell | 20130502190237 | 20130602190237 |
| 163.150.0.0/18 | Scientizzle | 20130502201836 | 20130602201836 |
| 66.244.5.44 | Fred Bauder | 20130502210608 | 20130602210608 |
| 2.124.132.11 | Edgar181 | 20130502210916 | 20130602210916 |
| 209.7.134.33 | Edgar181 | 20130502211005 | 20130602211005 |
| 209.206.234.14 | Gilliam | 20130502212241 | 20130602212241 |
| 187.22.0.0/18 | Kww | 20130502214001 | 20130602214001 |
| 23.25.5.113 | Materialscientist | 20130502224911 | 20130602224911 |
| 216.100.95.53 | Materialscientist | 20130502231154 | 20130602231154 |
| 12.131.205.250 | Materialscientist | 20130502231303 | 20130602231303 |
| 163.6.1.215 | Materialscientist | 20130502231401 | 20130602231401 |
| 72.208.240.212 | DMacks | 20130519194518 | 20130602194518 |
| 75.86.208.174 | Materialscientist | 20130519235110 | 20130602235110 |
| 209.121.191.14 | Gilliam | 20130530205113 | 20130602205113 |
| Solveforce | Toddst1 | 20130530212407 | 20130602212407 |
| 195.83.178.110 | Legoktm | 20130530235453 | 20130602235453 |
| 81.141.177.145 | Favonian | 20130601125527 | 20130602195527 |
| 213.175.160.29 | JohnCD | 20130601132927 | 20130602202927 |
| 173.30.64.84 | Spencer | 20130601150026 | 20130602220026 |
| 93.221.101.196 | Acroterion | 20130601162418 | 20130602232418 |
| 88.134.49.214 | Acroterion | 20130601162506 | 20130602232506 |
| 72.208.237.38 | Legoktm | 20130601213537 | 20130602213537 |
| 46.197.226.94 | Gilliam | 20130602094920 | 20130602214920 |
| 76.24.125.106 | Tom harrison | 20130602170738 | 20130602200738 |
+-----------------+-------------------+----------------+----------------+
46 rows in set (0.03 sec)