Error:
SELECT CONCAT(`Lastname`, ' ', `FirstName`) AS `name`, `r`.`pos`, `nr`, `DOB` AS `dob`, `weight`, `height`, `hand`,
`t`.`id` AS `cid`, `t`.`team` AS `club`, `t`.`clubcode` AS `code`, IF(`r`.`pos`='S', 1, 0) AS `isStaff`
FROM `v2_nat_roster` AS `r`
INNER JOIN `m_userprofiles` AS `u`
ON `r`.`player_id`=`u`.`LicenceNumber` AND `r`.`cat`='u18'
LEFT JOIN `v2_teams` AS `t`
ON (`u`.`Club` IS NULL AND `t`.`id`=`u`.`ILClub`) OR (`u`.`Club` IS NOT NULL AND `t`.`id`=`u`.`Club`)
ORDER BY
CASE
WHEN `r`.`pos` = 'G' then 0
WHEN `r`.`pos` = 'D' then 1
WHEN `r`.`pos` = 'S' then 2
ELSE 3 END ASC,
CASE
WHEN `r`.`nr` = 'HC' then 0 WHEN `r`.`nr` = 'AC' then 1 WHEN `r`.`nr` = 'TM' then 2 WHEN `r`.`nr` = 'TD' then 3 WHEN `r`.`nr` = 'PT' then 4 WHEN `r`.`nr` = 'EM' then 5 ELSE `r`.`nr` END ASC