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