|
|
Name
|
Started
|
Sub (on)
|
Goals
|
Yellows
|
Reds
|
| 1 |
Ridgers, Mark |
18 |
0 |
0 |
0 |
0 |
| 2 |
Rooney, Shaun |
20 |
0 |
3 |
7 |
1 |
| 3 |
Tremarco, Carl |
17 |
0 |
0 |
4 |
0 |
| 4 |
Chalmers, Joe |
21 |
0 |
0 |
2 |
0 |
| 5 |
Donaldson, Coll |
16 |
1 |
0 |
2 |
0 |
| 6 |
McCart, Jamie |
10 |
1 |
0 |
2 |
0 |
| 7 |
Polworth, Liam |
22 |
0 |
3 |
5 |
0 |
| 8 |
Beith, Angus |
0 |
0 |
0 |
0 |
0 |
| 8 |
McCauley, Darren |
0 |
3 |
1 |
0 |
0 |
| 9 |
Austin, Nathan |
9 |
6 |
5 |
0 |
0 |
| 10 |
Doran, Aaron |
17 |
2 |
5 |
1 |
0 |
| 11 |
Walsh, Tom |
16 |
2 |
5 |
2 |
0 |
| 14 |
Oakley, George |
9 |
5 |
3 |
4 |
0 |
| 15 |
Welsh, Sean |
16 |
1 |
2 |
1 |
0 |
| 16 |
Calder, Riccardo |
1 |
7 |
0 |
0 |
0 |
| 17 |
McDonald, Anthony |
2 |
1 |
0 |
0 |
0 |
| 18 |
Elbouzedi, Zak |
0 |
1 |
0 |
0 |
0 |
| 19 |
White, Jordan |
14 |
8 |
6 |
0 |
0 |
| 21 |
Mackay, Cameron |
3 |
0 |
0 |
0 |
0 |
| 22 |
Mckay, Brad |
21 |
0 |
1 |
5 |
0 |
| 23 |
Mackay, Daniel |
1 |
10 |
1 |
0 |
0 |
| 24 |
Trafford, Charlie |
5 |
7 |
0 |
1 |
0 |
| 25 |
Fon Williams, Owain |
0 |
0 |
0 |
0 |
0 |
| 29 |
McHattie, Kevin |
2 |
0 |
0 |
0 |
0 |
| 30 |
Wilson, Aidan |
0 |
0 |
0 |
0 |
0 |
| 31 |
Johnstone, Logan |
0 |
0 |
0 |
0 |
0 |
| 32 |
McRitchie, Ryan |
0 |
0 |
0 |
0 |
0 |
| 33 |
Mackinnon, Martin |
0 |
0 |
0 |
0 |
0 |
| 34 |
Morrison, Donald |
0 |
0 |
0 |
0 |
0 |
| 35 |
McGregor, Roddy |
0 |
3 |
0 |
1 |
0 |
| 36 |
Nicolson, Harry |
0 |
0 |
0 |
0 |
0 |
| 37 |
Brown, Jack |
0 |
0 |
0 |
0 |
0 |
| 38 |
Chalmers, Kieran |
0 |
0 |
0 |
0 |
0 |
| 39 |
Gunn, Ross |
0 |
0 |
0 |
0 |
0 |
| 40 |
Harper, Cameron |
0 |
0 |
0 |
0 |
0 |
| 41 |
Fyffe, Ryan |
0 |
0 |
0 |
0 |
0 |
| 42 |
Hoban, Daniel |
1 |
0 |
0 |
0 |
0 |
| 43 |
Kennedy, Roddy |
0 |
0 |
0 |
0 |
0 |
| 44 |
Hastings, Gabriel |
0 |
0 |
0 |
0 |
0 |
|
By number |
Alphabetically |
Starting Lineup |
Sub (on) |
Goals |
Yellow cards |
Red cards
|
|
M.MatchGoalsOpponent,1,0)) AS won,
SUM(IF(M.MatchGoals < M.MatchGoalsOpponent,1,0)) AS lost,
SUM(IF(M.MatchGoals = M.MatchGoalsOpponent,1,0)) AS draw,
COUNT(M.MatchID) AS games,
DATE_FORMAT(M.MatchDateTime, '$how_to_print') AS time
FROM tplss_matches M, tplss_appearancesmngr A, tplss_players P
WHERE
M.MatchID = A.AppearanceMatchID AND
A.AppearancePlayerID = P.PlayerID AND
P.PlayerIsManager = 1
" . ( $defaultseasonid ? " AND M.MatchSeasonID = '{$defaultseasonid}' " : " " ) . "
GROUP BY
P.PlayerID
";
$rst = mysql_query($query);
?>
|
|
Name
|
Games
|
Won
|
Drawn
|
Lost
|
Win%
|
".($i++).". |
".$r['lastname'].", ".$r['firstname']." |
".$r['games']." |
".$r['won']." |
".$r['draw']." |
".$r['lost']." |
".( $r['games'] > 0 ? round($r['won'] / $r['games'] * 100,2) : 0 )." |
";
}
?>
|
Coaches and other staff
|
|
No staff added to selected season...
|
|
- Copyright © and Database Copyright 2013 Football DataCo Ltd, The Scottish Premier League Ltd. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any way or by any means, (including photocopying, recording or storing it in any medium by electronic means), without the written permission of the copyright/database copyright owner. Applications for written permission should be addressed c/o Football DataCo Ltd, 30 Gloucester Place, London W1U 8PL.
Notes:
1. All fixtures are subject to change.
2. Fixtures for weeks 34 - 38 will be published at a later date.
- Fixture list reproduced under license from Football Dataco Limited. License No: FDCFAN11/12-119038. All rights reserved.
|