select * from sitedrive_events WHERE core_datetime > '2012-01-01' and core_datetime < '2012-12-31' order by core_datetime ASC