select c.*, ec.ShortName from committee c left join editConference ec ON c.user = ec.id where c.slug='charles-brennan-lincoln-university-new-zealand' AND YEAR(ec.date) = '2018' and c.status='active'