OrDB
SQL programs
  Data
number of modeldbs model articles in each journal
select journal.value_, count(*) from eav_string journal, eav_objects model_paper, objects model where model.object_class=19 and model.private=0 and model_paper.object_id=model.object_id and model_paper.attribute_id = 155 and model_paper.value_ = journal.object_id and journal.attribute_id=158 group by journal.value_ order by 2 desc
Other categories referring to number of modeldbs model articles in each journal
Revisions: 3
Last Time: 5/9/2007 3:42:48 PM
Reviewer: Tom Morse - MoldelDB admin
Owner: Tom Morse - MoldelDB admin