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`='wom' 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

Column 'nr' in field list is ambiguous