Consulta algo especial

[quimfv]

Código MySQL:

SELECT p.pe_id,
p.pe_nombre,
SUM(Sbc.tablas) as NTablas,
SUM(Sbc.apariciones) as NApariciones
FROM personas p 
  INNER JOIN 
     (SELECT pe_id,
       if(count(*)>=1,1,0) as tablas,
       count(*) as apariciones 
FROM personaexp GROUP BY pe_id
      UNION ALL
      SELECT pe_id,
      if(count(*)>=1,1,0) as tablas,
      count(*) as apariciones 
FROM personahab GROUP BY pe_id
      UNION ALL
      SELECT pe_id,
      if(count(*)>=1,1,0) as tablas,
      count(*) as apariciones 
FROM personaidi GROUP BY pe_id) as Sbc
    ON p.pe_id=Sbc.pe_id
GROUP BY p.pe_id,p.pe_nombre
ORDER BY NTablas DESC,NApariciones DESC;
 

Era esto....