Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT DISTINCT(`experience`.`pid`)
FROM `experience` JOIN `character`ON `experience`.pid=`character`.id 
WHERE `character`.`world` = 1
ORDER BY `experience`.`exp` DESC LIMIT 10  ;
[SQL] pobierz, plaintext 

+-----+
| pid |
+-----+
| 301 |
| 302 |
| 303 |
| 304 |
| 305 |
| 306 |
| 307 |
| 308 |
| 309 |
| 310 |
+-----+

[SQL] pobierz, plaintext 
SELECT DISTINCT(`experience`.`pid`),`character`.`name`,`experience`.`exp`, `experience`.`level`
FROM `experience` JOIN `character`ON `experience`.pid=`character`.id 
WHERE `character`.`world` = 1
ORDER BY `experience`.`exp` DESC LIMIT 10  ;
[SQL] pobierz, plaintext 

+-----+------------------+-----------+-------+
| pid | name             | exp       | level |
+-----+------------------+-----------+-------+
| 301 | Eternal Oblivion | 430141690 |   297 |
| 302 | Googi            | 363918727 |   281 |
| 303 | Socha            | 309388706 |   266 |
| 303 | Socha            | 308684925 |   266 |
| 304 | Xumus            | 266759896 |   254 |
| 305 | Squidy           | 251603598 |   249 |
| 305 | Squidy           | 251529017 |   249 |
| 305 | Squidy           | 250876430 |   248 |
| 306 | Band             | 240688909 |   245 |
| 306 | Band             | 240457335 |   245 |
+-----+------------------+-----------+-------+