FAIL

Table 'haloorie_members.member' doesn't exist

SELECT a.id,a.title,UNIX_TIMESTAMP(GREATEST(a.created,a.updated)) AS timestamp,CONCAT(c.FirstName,' ',c.LastName) as creator,DATE_FORMAT(a.created,'%e %b %Y %H:%i') AS created,CONCAT(u.FirstName,' ',u.LastName) as updater,DATE_FORMAT(a.updated,'%e %b %Y %H:%i') AS updated,'A' AS code FROM article a LEFT JOIN haloorie_members.member c ON c.Id=a.creator LEFT JOIN haloorie_members.member u ON u.Id=a.updater WHERE (a.start IS NULL OR a.startDATE_ADD(NOW(),INTERVAL -1 DAY)) AND a.deleted=0 AND a.active=1 UNION ALL SELECT e.id,e.name AS title,UNIX_TIMESTAMP(e.date) AS timestamp,'' AS creator,'' AS created,'' AS updater,'' AS updated,(SELECT IF(e.html,'R',(SELECT IF(e.flyer,'E1',(SELECT IF (e.final,'E2','E0')))))) as code FROM events e where club = 'HALO' AND draft=0 AND (e.html != 0 OR (e.date >= NOW() AND (e.flyer != 0 OR e.final != 0 OR DATEDIFF(e.date,NOW())<30))) UNION ALL SELECT s.id,CONCAT(DATE_FORMAT(s.edate,'%e %b %Y'),' - ',s.event) as title,UNIX_TIMESTAMP(s.updated) AS timestamp,CONCAT(c.FirstName,' ',c.LastName) as creator,'' AS created,CONCAT(u.FirstName,' ',u.LastName) as updater,DATE_FORMAT(s.updated,'%e %b %Y %H:%i') AS updated,'S' AS code FROM carshare s LEFT JOIN haloorie_members.member c ON c.Id=s.owner LEFT JOIN haloorie_members.member u ON u.Id=s.updater WHERE s.edate >= NOW() ORDER BY timestamp DESC