Table 7

SELECT

mc.medline_ta, count(mc.pmid) as num_of_publications

FROM

medline_citation mc

JOIN medline_mesh_heading msh ON

mc.pmid = msh.pmid

JOIN mesh_descriptor md ON

md.descriptor_name = msh.descriptor_name

JOIN mesh_desc_tree_number mdtn ON

md.descriptor_ui = mdtn.descriptor_ui

WHERE

mdtn.tree_number LIKE 'C04.557.337%'

GROUP BY

mc.medline_ta

ORDER BY

count(mc.pmid) desc

FETCH

first 10 rows only;


Oliver et al. BMC Bioinformatics 2004 5:146   doi:10.1186/1471-2105-5-146

Open Data