Authors Who Read Themselves

Authors Who Read Themselves

Find every author who viewed at least one of their own articles. Return the author identifier (author_id) and name the result column id, sorted in ascending order. In Views, author_id and viewer_id identify the same people: an author viewed their own article when their identifier appears in both fields.

Row order matters

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid