Skip to main content

Table 7 Table 7

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;