SELECT tl.id AS teamtoolid, tl.division_id, tl.standard_playground, tl.admin, tl.start_points, tl.info, tl.team_id, tl.checked_out, tl.checked_out_time, tl.picture, tl.project_id,
t.id, t.name, t.short_name, t.middle_name, t.description, t.club_id,
u.username, u.email,
c.email AS club_email, c.logo_small, c.country, c.website,
d.name AS division_name, d.shortname AS division_shortname, d.parent_id AS parent_division_id,
plg.name AS playground_name, plg.short_name AS playground_short_name
FROM jos_joomleague_team_joomleague tl
LEFT JOIN jos_joomleague_teams t
ON tl.team_id = t.id
LEFT JOIN jos_users u
ON tl.admin = u.id
LEFT JOIN jos_joomleague_clubs c
ON t.club_id = c.id
LEFT JOIN jos_joomleague_divisions d
ON d.id = tl.division_id
LEFT JOIN jos_joomleague_playgrounds plg
ON plg.id = tl.standard_playground
WHERE tl.project_id = 14
ORDER BY t.name
