select
rl.date 'Date / Time',
concat(u.username,' (',u.fullname,' )') 'Created By User',
g.name 'User Group',
r.ref 'Resource ID',
r.view_title_field 'Resource Title'

from
resource_log rl
join resource r on r.ref=rl.resource
left outer join user u on rl.user=u.ref
left outer join usergroup g on u.usergroup=g.ref
where
rl.type='c'
and
rl.date>=date('[from-y]-[from-m]-[from-d]') and rl.date<=adddate(date('[to-y]-[to-m]-[to-d]'),1)
order by rl.date