Select Code to Download

SELECT
 events.b_g
...
 events.b_g NOT IN ( SELECT otf.b_g FROM otf )
AND
 events.b_g NOT IN ( SELECT requests.b_g FROM requests)

...
WHERE
...
OR
 events.b_g IN ( SELECT requests.b_g FROM requests )
...

SELECT
 events.b_g,
...

GROUP BY events.b_g, events.vector
ORDER BY events.b_g, events.vector, 'attempts'

...
WHERE
...
OR
      otf.b_g = events.b_g
...