SQL programs

Data

Name number of modeldbs model articles in each journal

Description

SQL Program 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

Maximum Rows

Maximum Columns