wifidog_db=# select node_id, name, last_heartbeat_ip, last_heartbeat_timestamp, network_id, public_email from nodes where lower(name) like lower('Paysdegueret%') order by node_id;
   node_id    |               name               | last_heartbeat_ip |  last_heartbeat_timestamp  |   network_id    |           public_email
--------------+----------------------------------+-------------------+----------------------------+-----------------+-----------------------------------
 00236915578D | Paysdegueret                     | 80.13.158.201     | 2011-07-22 01:51:05.353826 | default-network | baptiste.ridoux@paysdegueret.info
 0023692F38F5 | Paysdegueret                     | 90.16.119.191     | 2011-07-26 15:45:14.566125 | default-network | baptiste.ridoux@paysdegueret.info
 0023692F970F | Paysdegueret                     | 81.50.74.178      | 2011-07-25 14:23:49.71117  | default-network | baptiste.ridoux@paysdegueret.info
 0023692F9850 | Paysdegueret                     | 217.128.144.109   | 2011-07-24 12:17:38.58848  | default-network | baptiste.ridoux@paysdegueret.info
 0023692F9A36 | Paysdegueret_Nouziers#2          | 90.50.29.166      | 2010-07-09 10:56:08.235768 | default-network | baptiste.ridoux@paysdegueret.info
 0023692F9A39 | Paysdegueret_Nouziers2           | 90.45.232.116     | 2011-06-17 16:56:27.610311 | default-network | david.forgeron@paysdegueret.info
 0023692F9C1C | Paysdegueret_Cheniers1           | 90.45.29.17       | 2011-07-26 09:45:06.076704 | default-network | baptiste.ridoux@paysdegueret.info
 0023692F9C67 | Paysdegueret_Bourg_D_Hem         | 90.11.108.136     | 2011-07-25 14:46:11.766556 | default-network | baptiste.ridoux@paysdegueret.info
 687F743E9E57 | Paysdegueret_FreeWifi_#1         | 80.11.103.250     | 2011-07-25 20:35:49.237497 | default-network |
 687F743EA03A | Paysdegueret_FreeWifi#8          | 90.45.90.115      | 2010-12-13 13:38:14.669592 | default-network |
 687F743EA0E2 | PaysdeGueret_Freewifi#16         | 83.193.29.210     | 2011-07-26 14:35:27.85402  | default-network |
 687F743EA115 | Paysdegueret_FreeWifi#5          | 62.34.52.56       | 2011-07-26 06:08:34.903925 | default-network |
 687F743EA14E | Paysdegueret_FreeWifi#4          | 90.60.76.132      | 2011-07-25 22:37:16.456998 | default-network |
 687F743EA17B | Paysdegueret_FreeWifi_Moulinpiot | 90.45.29.17       | 2011-07-26 12:05:00.196305 | default-network |
 687F743EA1AB | PaysdeGueret_FreeWifi            | 90.16.186.113     | 2011-07-26 09:29:04.624189 | default-network |
 687F743EA1F0 | Paysdegueret_FreeWifi#7          | 90.45.123.230     | 2011-07-27 16:28:45.312329 | default-network |
 687F743EA1FF | Paysdegueret_FreeWifi#9          | 86.205.223.106    | 2011-07-27 16:35:12.934347 | default-network |
 687F743EA244 | Paysdegueret_FreeWifi#6          | 90.50.153.171     | 2011-07-23 11:47:22.787448 | default-network |
 687F743EA334 | Paysdegueret_FreeWifi            | 90.16.17.167      | 2010-10-13 11:07:45.220675 | default-network |
 687F743EA346 | Paysdegueret_FreeWifi#3          | 90.45.159.28      | 2011-07-27 16:38:18.282671 | default-network |
 687F743EAB59 | Paysdegueret_FreeWifi#10         | 90.16.250.215     | 2011-07-27 16:35:18.945423 | default-network |
 687F743EAC1F | PaysdeGueret_FreeWifi            | 109.215.46.230    | 2011-07-26 01:26:24.348186 | default-network |
 687F744C857C | Paysdegueret_FreeWifi#12         | 90.38.71.163      | 2010-11-16 13:23:53.222035 | default-network |
 687F744C8C90 | Paysdegueret_FreeWifi#11         | 90.45.97.97       | 2011-07-27 16:34:15.325094 | default-network |
 687F744C8D2F | Paysdegueret_FreeWifi#13         | 90.50.152.39      | 2011-07-27 16:36:25.158638 | default-network |
 687F744C8D59 | Paysdegueret_FreeWifi_Linard     | 90.45.121.117     | 2011-07-25 17:30:08.537944 | default-network |
(26 lignes)