SELECT jt.name as name, count(jo.id) as num from job_type_offer jto left join job_offer jo on (jto.job_offer_id=jo.id) left join job_type jt on (jto.job_type_id=jt.id) group by jto.job_type_id failed (Table 'rsforum_jobOffers.job_type_offer' doesn't exist)