SELECT COUNT(p.id) FROM fg_system s LEFT JOIN fg_player p ON p.id=s.id_owner SELECT COUNT(*) FROM fg_system s LEFT JOIN fg_player p ON p.id=s.id_owner