Query: SELECT `Coach`.`email`, `Coach`.`id` FROM `coaches` AS `Coach` WHERE `Coach`.`user_id`=

Query: SELECT COUNT(*) AS `count` FROM `players` AS `Player` where `Player`.`id` in (select player_id from players_coaches where coach_id in ( select id from coaches where user_id in () ))

Query: SELECT `Player`.`id`, `Player`.`firstname`, `Player`.`lastname`, `Player`.`school`, `Player`.`city`, `Player`.`state`, `Player`.`year`, `Player`.`email`, `Player`.`phone`, `Player`.`satScore`, `Player`.`actScore`, `Player`.`gpa`, `Player`.`contactname1`, `Player`.`contactname2`, `Player`.`contactname3`, `Player`.`contactname4`, `Player`.`contactname5`, `Player`.`contactname6`, `Player`.`relationship1`, `Player`.`relationship2`, `Player`.`relationship3`, `Player`.`relationship4`, `Player`.`relationship5`, `Player`.`relationship6`, `Player`.`phone1`, `Player`.`phone2`, `Player`.`phone3`, `Player`.`phone4`, `Player`.`phone5`, `Player`.`phone6`, `Player`.`email1`, `Player`.`email2`, `Player`.`email3`, `Player`.`email4`, `Player`.`email5`, `Player`.`email6`, `Player`.`middle_school`, `Player`.`high_school`, `Player`.`jr_college`, `Player`.`created`, `Player`.`modified`, `Player`.`gbrid` FROM `players` AS `Player` where `Player`.`id` in (select player_id from players_coaches where coach_id in ( select id from coaches where user_id in () )) ORDER BY `Player`.`lastname` ASC LIMIT 10