SQL programs

Data

Name sorted concept (Topic) usage by all the models

Description

SQL Program select concept.object_name, count(*) from eav_objects model_concept, objects model, objects concept where concept.object_class=39 and concept.object_id=model_concept.value_ and model.object_class=19 and model.private=0 and model.object_id=model_concept.object_id and model_concept.attribute_id=113 group by concept.object_name order by 2 desc

Maximum Rows

Maximum Columns