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;

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;