enwiki list of blocks expiring today

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)