A set of small changes: LEFT JOIN => JOIN. After sign up, redirect. Added pin page to email. Links in new tab.