SELECT rp.regatta_id FROM regatta_page rp JOIN regatta r ON r.regatta_id = rp.regatta_id WHERE (rp.regatta_id = 0 OR rp.short_url = '') AND r.is_active = 1no regatta found