SELECT `C`.`endereco`, COUNT(CC.id_curriculo) AS contatos, COUNT(CI.id_curriculo_instrucao) AS instrucao, COUNT(CE.id_curriculo_extracurricular) AS extracurricular, COUNT(CI?.id_curriculo_idioma) AS idiomas, COUNT(CA.id_curriculo_area) AS areas, COUNT(CE?.id_curriculo_experiencia) AS experiencias, COUNT(CE?.id_curriculo_extra) AS extras
FROM (`superh`.`curriculo` C)
LEFT JOIN `superh`.`curriculo_contato` CC ON `CC`.`id_curriculo` = `C`.`id_curriculo`
LEFT JOIN `superh`.`curriculo_instrucao` CI ON `CI`.`id_curriculo` = `C`.`id_curriculo`
LEFT JOIN `superh`.`curriculo_extracurricular` CE ON `CE`.`id_curriculo` = `C`.`id_curriculo`
LEFT JOIN `superh`.`curriculo_idioma` CI? ON `CI?`.`id_curriculo` = `C`.`id_curriculo`
LEFT JOIN `superh`.`curriculo_area` CA ON `CA`.`id_curriculo` = `C`.`id_curriculo`
LEFT JOIN `superh`.`curriculo_experiencia` CE? ON `CE?`.`id_curriculo` = `C`.`id_curriculo`
LEFT JOIN `superh`.`curriculo_extra` CE? ON `CE?`.`id_curriculo` = `C`.`id_curriculo`
WHERE `C`.`id_curriculo` =  ?