~~~~~~~~~~~~~~~~~~~shoa
Posted: Mon May 19, 2008 12:04 pm
i'm fukcin
Code: Select all
+-------------------------------+
| name |
+-------------------------------+
| Shireroth |
| Straylight |
| Discontinuity |
| Sunderspray |
| Yardistan |
| Absentia |
| Western Absentia |
| Mar Sara |
| The Holy Lands |
| Florencia |
| Yardistani Isle |
| Naudia'Diva |
| Kildare |
| Lumina's Light |
| Lesser Attera |
| South Novi Dalmacija |
| North Novi Dalmacija |
| Kitanus Fields |
| Antya |
| Vervollkommnung |
| Schlangen |
| Blackrock |
| Automatica |
| Atterock |
| Raynor Isles |
| Melangia |
| Norfolk |
| Gong Li |
| Old Hallucination |
| Froyalan |
| Fórntida Kærleikalanden |
| Wintergleam |
| Cimmeria |
| Bjorngard |
| The Elw |
| Hyperborea |
| Lesser Zjandaria |
| Eliria and Utasia |
| Opplysta Smørvirket |
| Illumination |
| Smjörkýr |
| Araxion |
| Brookshire |
| Ynnraile |
| Holwinn |
| Goldendown |
| Asantelian |
| Syrelwynn |
| Solecism |
| Highpass |
| Thanatos |
| Amarr |
| Benacia |
| Vorpmadal |
| Elsenar |
| Ran |
| Lower Lunaris |
| Upper Lunaris |
| K'Tzuni |
| Modan-Lach |
| Lywind |
| Crestfall Downs |
| Shimmerspring |
| Dolor |
| Alexandretta |
| Caverden |
| Monty Crisco |
| Woodshire |
+-------------------------------+
68 rows in set (0.01 sec)
Code: Select all
SELECT username, dukeVotes.vote, sum(subjects.money)
FROM people AS dukes
JOIN subdivisions AS duchies ON subdivision = name
JOIN votes AS dukeVotes ON voter = account
JOIN phpbb_users ON account = user_id,
people AS subjects
JOIN subdivisions ON subdivision = name
JOIN votes AS subjectVotes ON voter = account
WHERE (subdivisions.lft BETWEEN duchies.lft AND duchies.rgt) AND
(subjectVotes.vote = dukeVotes.vote) AND
(subjectVotes.bill = 'http://shireroth.kuroshiro.net/forum/viewtopic.php?f=5&t=8221') AND
(dukeVotes.bill = 'http://shireroth.kuroshiro.net/forum/viewtopic.php?f=5&t=8221') AND
(duchies.type = 'Duchy')
GROUP BY dukes.account;