Redmine

I assume there might be some id that could be used to unite all these issues.
Couldn't you just create an extra custom field and use it to filter the issues like:

  SELECT COUNT(*) FROM `custom_values` INNER JOIN issues ON issues.id = custom_values.customized_id INNER JOIN issue_statuses ON issues.status_id=issue_statuses.id WHERE `custom_values`.`custom_field_id` = 16 AND issues.id in (SELECT customized_id FROM custom_values WHERE custom_field_id=NEW_CUSTOM_FIELD_ID AND value=SOME_UNIFYING_VALUE) AND `custom_values`.`value` = 'Maior Domus' AND `issue_statuses`.`is_closed` = 1

If not, since you are using the DB directly I think you could add an extra field into table issues like 'aggregation_id' to filter using it:

  SELECT COUNT(*) FROM `custom_values` INNER JOIN issues ON issues.id = custom_values.customized_id INNER JOIN issue_statuses ON issues.status_id=issue_statuses.id WHERE `custom_values`.`custom_field_id` = 16 AND issues.aggregation_id = 1 AND `custom_values`.`value` = 'Maior Domus' AND `issue_statuses`.`is_closed` = 1

Try to use SQL IN or BETWEEN operators

[[https://stackoverflow.com/questions/782915/mysql-or-vs-in-performance]]