select
`profile`.`name` AS `Name`,
`survivor`.`id` AS `PlayerID`,
replace(replace(replace(substring_index(`survivor`.`state`, ',', 1),'[',''),']',''),'"','') AS `Current Weapon`,
truncate(left(((SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(`survivor`.`worldspace`, ',[', -1),']]',1),',',1))/100),6),1) AS `y`,
TRUNCATE(LEFT(((15360-(cast(substring_index(substring_index(substring_index(substring_index(`survivor`.`worldspace`,',[',-1),']]',1),',',2),',',-1) as decimal(16,1))))/100),6),1) AS `x`,
`survivor`.`worldspace` AS `Position`,
floor(substring_index(substring_index(`survivor`.`medical`, ',[],', 1),',',-(1))) AS `Blood`,
concat(' Z: ',
cast(`profile`.`total_zombie_kills` as char (20) charset utf8),
' Pl: ',
cast((`profile`.`total_bandit_kills` + `profile`.`total_survivor_kills`)
as char (20) charset utf8)) AS `Kills`
from
(`survivor`
join `profile` ON ((`survivor`.`unique_id` = `profile`.`unique_id`)))
where
((`survivor`.`is_dead` = 0)
and (`survivor`.`last_updated` >= (now() - interval 30 day)))
order by (truncate(left(substring_index(substring_index(substring_index(`survivor`.`worldspace`, ',[', -(1)),']]',1),',',1),6),1)
+ truncate(left(substring_index(substring_index(substring_index(substring_index(`survivor`.`worldspace`, ',[', -(1)),']]',1),',',2),',',-(1)),6),1)) desc