SELECT
catalog.`CATALOG_NAME_ZH`,
sum(job.`TOTAL_RECORD`),
sum( job.`BAD_RECORD`),
rule.`CATALOG_ID_1`,
rule.`CATALOG_ID_2`,
count(rule.`RULE_ID`)
FROM
`t_dq_rule_def` rule
LEFT JOIN
`t_dq_catalog` catalog ON (catalog.`CATALOG_ID` = rule.`CATALOG_ID_1`)
LEFT JOIN
`t_dq_job_instances` job ON (rule.`RULE_ID` = job.`RULE_ID`)
where rule.`CATALOG_ID_1`=1
group by rule.`CATALOG_ID_1`
ORDER BY rule.`RULE_ID`