research@x1-analytics-slave [enwiki]>
SELECT notification_timestamp, event_type
FROM echo_notification
JOIN echo_event ON event_id=notification_event
WHERE notification_timestamp = notification_read_timestamp;returns 2653 rows.
with
where notification_timestamp != notification_read_timestamp;
Returns 7958893 rows