SELECT cola, colb, DATE_FORMAT(date,'%d, %H:%M') FROM guestlog ORDER BY date DESC