Error in query: SELECT DISTINCT t3.Ensembl_Gene_ID,t3.Associated_Gene_Name, COUNT(DISTINCT t4.id) as LSDB_Genes
, COUNT(DISTINCT t6.id) as LSDB_Variants
, COUNT(DISTINCT t5.Variation_Name) AS clinVar_hits
, t3.*
FROM ensembl_gene_all_biomart_20140710 as t3
left join gb_exome.mito5_genes as t4 on ( t4.id = t3.Associated_Gene_Name)
left join gb_exome.mito5_variants as t6 on ( t6.chromosome = t3.chr and t6.position_g_start between t3.Gene_Start and t3.Gene_End)
left join clinvar_variation_latest as t5 on ( Assembly ='GRCh37' AND t5.GeneSymbol = t3.Associated_Gene_Name)
where
(t3.Ensembl_Gene_ID in ('POLG') OR t3.Ensembl_Transcript_ID in ('POLG') OR t3.Ensembl_Protein_ID in ('POLG') OR t3.Associated_Gene_Name in ('POLG') OR t3.Associated_Transcript_Name in ('POLG') )
group by Ensembl_Gene_ID
order by t3.chr, t3.Gene_Start
; . Query execution was interrupted, maximum statement execution time exceeded