SELECT c.p_nodeid, count(*) as job_count FROM cronjobs c inner join jobs j on c.p_job = j.pk group by c.p_nodeid order by 1;
![](https://hybrisarchitect.com/wp-content/uploads/2017/05/how-to.jpg)
SELECT c.p_nodeid, count(*) as job_count FROM cronjobs c inner join jobs j on c.p_job = j.pk group by c.p_nodeid order by 1;