sql>select * from kvk where (lower(bedrijfsnaam) like '%stichting opengeo%');
+----------+-------------------+----------------+----------+--------+---------------+
| kvk      | bedrijfsnaam      | adres          | postcode | plaats | type          |
+==========+===================+================+==========+========+===============+
| 20147376 | Stichting OpenGeo | Spinellihof 44 | 4463GP   | Goes   | Rechtspersoon |
+----------+-------------------+----------------+----------+--------+---------------+
1 tuple
Timer    2301.067 msec 1 rows
sql>select count(*) from kvk;
+---------+
| L3      |
+=========+
| 1203851 |
+---------+
1 tuple
Timer       1.731 msec 1 rows
sql>select count(*) from (select count(postcode) from kvk group by postcode) as "q";
+--------+
| L5     |
+========+
| 246115 |
+--------+
1 tuple
Timer    5555.939 msec 1 rows

…wat een belachelijk slechte performance ook weer.