genotyping_protocolsxlocations

SELECT materialized_genoview.genotyping_protocol_id,

    materialized_phenoview.location_id

   FROM (materialized_genoview

     JOIN materialized_phenoview USING (accession_id))

  GROUP BY materialized_genoview.genotyping_protocol_id, materialized_phenoview.location_id;