From: Tools for loading MEDLINE into a local relational database
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; |