Hi, | You probably don't want to do that. The DESC only applies to the | one expression it follows. What you want is probably: | explain select datetime,id from trafficlogs order by | datetime desc,id desc limit 20;
This is exactly what I was after - worked a treat! Thanks. Darren ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings