MySQL current date and time

select * from tablename
where tablename.datefield <> '' and tablename.timefield <> ''
and ( tablename.datefield < curdate() or 
( tablename.datefield <= curdate() and tablename.timefield <= curtime() )  )
and tablename.datetime <= now()
order by ablename.datefield desc, tablename.timefield asc;