Call Today:
Show Missing Entries with Mysql 'WHERE NOT EXISTS'
SELECT DISTINCT ( `sul4t_jsn_users`.`id` ),
`sul4t_jsn_users`.`firstname`,
`sul4t_jsn_users`.`lastname`
FROM `sul4t_jsn_users`
JOIN `sul4t_newcardsame`
ON `sul4t_newcardsame`.`memberName` = `sul4t_jsn_users`.`id`
JOIN `sul4t_newcardmultiple`
ON `sul4t_newcardmultiple`.`memberName` = `sul4t_jsn_users`.`id`
JOIN `sul4t_newcard_sundays2016`
ON `sul4t_newcard_sundays2016`.`id` = `sul4t_newcardsame`.`weekEnding2016` AND `sul4t_newcard_sundays2016`.`id` = `sul4t_newcardmultiple`.`weekEndingMultiple2016`
WHERE NOT EXISTS (
SELECT `memberName` FROM `sul4t_newcardsame` WHERE `sul4t_newcardsame`.`memberName` = `sul4t_jsn_users`.`id` AND `sul4t_newcardsame`.`weekEnding2016` = '1' AND `sul4t_newcardmultiple`.`memberName` = `sul4t_jsn_users`.`id` AND `sul4t_newcardmultiple`.`weekEndingMultiple2016` = '1')
ORDER BY `lastname` ASC