Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- maps.name as map, builds.name as build, SUM(votes.vote) AS votes
- FROM
- builds
- INNER JOIN
- maps ON maps.id = builds.map
- LEFT JOIN
- votes ON votes.fk_build = builds.id
- GROUP BY
- build
- ORDER BY
- map
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement