SELECT a.title, convention, order, description,
gender, en_label, SUM(requests) requests_june, COUNT(*) hours
FROM (
  SELECT title, convention, order, description, gender, en_label
  FROM (
    SELECT title, convention, order, en_description description, en_label,
       FIRST(gender.numeric_id)  WITHIN RECORD gender
    FROM (
      SELECT convention, order, REPLACE(title, '_Jr', ',_Jr') title
      FROM [fh-bigquery:public_dump.convention3]
      ) a
    JOIN [fh-bigquery:wikidata.latest_enesjafrde_v1_a] b
    ON a.title=b.en_wiki
    OMIT RECORD IF NOT SOME(instance_of.numeric_id=5)
  ) GROUP BY 1,2,3,4,5,6
) a
JOIN [fh-bigquery:wikipedia.pagecounts_201606] b
ON a.title=b.title
WHERE language='en'
GROUP BY 1,2,3,4,5,6
ORDER BY convention, order