Miscellany

SELECT Datum,Naam,Plaats,Organisatie,Provincie,Chip,Foto,Internet FROM _evenementen WHERE (Land <> 'X') AND (Uitslag IS NOT NULL) AND (Datum <= Now()) ORDER BY Datum DESC, Organisatie DESC LIMIT 20;

mysql> explain SELECT Datum,Naam,Plaats,Organisatie,Provincie,Chip,Foto,Internet FROM _evenementen WHERE (Land <> 'X') AND (Uitslag IS NOT NULL) AND (Datum <= Now()) ORDER BY Datum DESC, Organisatie DESC LIMIT 20;
+--------------+-------+---------------+-------+---------+------+------+-----------------------------+
| table        | type  | possible_keys | key   | key_len | ref  | rows | Extra                       |
+--------------+-------+---------------+-------+---------+------+------+-----------------------------+
| _evenementen | range | Datum         | Datum |       4 | NULL | 3371 | Using where; Using filesort |
+--------------+-------+---------------+-------+---------+------+------+-----------------------------+
1 row in set (0.00 sec)

mysql>