SELECT id, title INTO TEMPORARY publication_filtered FROM publication WHERE title ILIKE '%visualization%' AND publication.year > 2019; -- this took about 11 seconds SELECT author.id, author.wos_id, author.full_name INTO TEMPORARY author_filtered FROM author INNER JOIN author_address ON author.id = author_address.author_id WHERE author_address.address_id IN ( SELECT address.id FROM address WHERE address.address ILIKE '%Univ Toronto%' ) GROUP BY author.id, author.wos_id, author.full_name; -- this took about 28 seconds SELECT publication_filtered.title, author_filtered.full_name FROM publication_filtered INNER JOIN author_filtered ON publication_filtered.id = author_filtered.wos_id; -- this took about 0.4 seconds