SELECT R.Season, MatchDate, DateRestricted, Venue, OpponentName, (coalesce(c.shortname, opponentname)) AS ShortName, [Round], Scorers, Attendance, AwayFans, Referee, R.CompCode, CASE WHEN R.CompCode = 'FRN' THEN 'Friendly' WHEN R.CompCode = 'TEST' THEN 'Testimonial' WHEN R.CompCode = 'BEN' THEN 'Benefit Match' ELSE CompName END AS CompName, Comment, StageCode, ExtraTime, PenaltyShootOut, SecondLeg, SwindonKitID, CASE WHEN Venue = 'Home' THEN 'Swindon Town' ELSE OpponentName END AS HomeTeamName, CASE WHEN Venue = 'Home' THEN OpponentName ELSE 'Swindon Town' END AS AwayTeamName, CASE WHEN Venue = 'Home' THEN 'Swindon Town' ELSE (coalesce(c.shortname, opponentname)) END AS HomeShortTeamName, CASE WHEN Venue = 'Home' THEN (coalesce(c.shortname, opponentname)) ELSE 'Swindon Town' END AS AwayShortTeamName, CASE WHEN Venue = 'Home' THEN SwindonScore ELSE OpponentScore END AS HomeScore, CASE WHEN Venue = 'Home' THEN OpponentScore ELSE SwindonScore END AS AwayScore, CASE WHEN Venue = 'Home' THEN SwindonHTScore ELSE OpponentHTScore END AS HomeHTScore, CASE WHEN Venue = 'Home' THEN OpponentHTScore ELSE SwindonHTScore END AS AwayHTScore, CASE WHEN Venue = 'Home' THEN SwindonFTScore ELSE OpponentFTScore END AS HomeFTScore, CASE WHEN Venue = 'Home' THEN OpponentFTScore ELSE SwindonFTScore END AS AwayFTScore, CASE WHEN Venue = 'Home' THEN SwindonAggScore ELSE OpponentAggScore END AS HomeAggScore, CASE WHEN Venue = 'Home' THEN OpponentAggScore ELSE SwindonAggScore END AS AwayAggScore, CASE WHEN Venue = 'Home' THEN SwindonPSOScore ELSE OpponentPSOScore END AS HomePSOScore, CASE WHEN Venue = 'Home' THEN OpponentPSOScore ELSE SwindonPSOScore END AS AwayPSOScore, CASE WHEN Venue = 'Home' THEN SwindonKit ELSE OpponentKit END AS HomeKit, CASE WHEN Venue = 'Home' THEN OpponentKit ELSE SwindonKit END AS AwayKit, CASE WHEN Venue = 'Home' THEN SwindonPrimaryColour ELSE OpponentPrimaryColour END AS HomePrimaryColour, CASE WHEN Venue = 'Home' THEN OpponentPrimaryColour ELSE SwindonPrimaryColour END AS AwayPrimaryColour, CASE WHEN Venue = 'Home' THEN SwindonSecondaryColour ELSE OpponentSecondaryColour END AS HomeSecondaryColour, CASE WHEN Venue = 'Home' THEN OpponentSecondaryColour ELSE SwindonSecondaryColour END AS AwaySecondaryColour, CASE WHEN Venue = 'Home' THEN SwindonTerceryColour ELSE OpponentTerceryColour END AS HomeTerceryColour, CASE WHEN Venue = 'Home' THEN OpponentTerceryColour ELSE SwindonTerceryColour END AS AwayTerceryColour, CASE WHEN Venue = 'Home' THEN SwindonNumberColour ELSE OpponentNumberColour END AS HomeNumberColour, CASE WHEN Venue = 'Home' THEN OpponentNumberColour ELSE SwindonNumberColour END AS AwayNumberColour, CASE WHEN Venue = 'Home' THEN SwindonShadeColour ELSE OpponentShadeColour END AS HomeShadeColour, CASE WHEN Venue = 'Home' THEN OpponentShadeColour ELSE SwindonShadeColour END AS AwayShadeColour FROM Competitions CO, Results R LEFT OUTER JOIN Clubs C ON (R.OpponentName = C.PreviousClubName) WHERE ResultID = 19960124 AND R.Season = CO.Season AND R.CompCode = CO.CompCode Swindon-Town-FC.co.uk - York City - Swindon Town, Saturday, January 13, 1996

Endsleigh Insurance League Division Two
Saturday, January 13, 1996

York City Swindon Town
G.Naylor (59'), A.McMillan (85')
HT: 0-0
Attendance:  3,613    



 
With both of their kits clashing, Swindon have to get special dispensation from sponsors Castrol to wear their Burmah adorned third shirt from the previous campaign - and the Town play like they did that season, losing 2-0 to a struggling York side.




Lineups
1
Dean KIELY  
                 
Fraser DIGBY
1
2
Andy MCMILLAN
               
Ian CULVERHOUSE
2
3
Paddy ATKINSON
 73'
              
  Paul BODIN
3
4
Steve BUSHELL
                 
Martin LING
4
5
Steve TUTILL
                82'
Eddie MURRAY
5
6
Paul ATKIN
                68'
Wayne O'SULLIVAN
6
7
Graeme MURTY  
                 
Mark ROBINSON
7

8
Adrian RANDALL
                 
Paul ALLEN
8

9
Paul BARNES
                 
Peter THORNE
9
10
Glenn NAYLOR
               
Wayne ALLISON
10
11
Darren WILLIAMS
 82'
             88'
  Kevin HORLOCK
11
Substitutes
12
Wayne HALL

73' 
           
82' 
Ty GOODEN
12
13
Scott JORDAN

82' 
           
88' 
Alex SMITH
13
14
Nigel PEPPER
              
68' 
Steve FINNEY
14













Results on Saturday, January 13, 1996: League Table

 
  Bradford City 1 - 3 Brighton and Hove Albion  
  Bristol City 3 - 2 Crewe Alexandra  
  Burnley 4 - 3 Stockport County  
  Carlisle United 1 - 1 Chesterfield  
  Hull City 1 - 4 Rotherham United  
  Oxford United 2 - 1 Brentford  
  Peterborough United 4 - 5 AFC Bournemouth   
  Swansea City 2 - 2 Bristol Rovers  
  Walsall 3 - 0 Shrewsbury Town  
  Wrexham 1 - 1 Blackpool  
  Wycombe Wanderers 1 - 1 Notts County  
  York City 2 - 0 Swindon Town  

Table as at Saturday, January 13, 1996:

  TEAM P W D L F A GS Pts 
1 Swindon Town 24 13 8 3 39 17 39 47 
2 Crewe Alexandra 23 13 5 5 44 26 44 44 
3 Blackpool 23 11 7 5 35 24 35 40 
4 Notts County 22 11 7 4 34 19 34 40 
5 Burnley 23 10 8 5 39 30 39 38 
6 Chesterfield 23 10 7 6 35 25 35 37 
7 Bradford City 24 11 4 9 35 37 35 37 
8 Shrewsbury Town 25 11 4 10 34 33 34 37 
9 Wrexham 23 8 11 4 35 26 35 35 
10 Wycombe Wanderers 23 8 11 4 31 23 31 35 
11 AFC Bournemouth 25 10 5 10 30 35 30 35 
12 Oxford United 23 9 7 7 31 24 31 34 
13 Stockport County 25 8 9 8 32 28 32 33 
14 Walsall 23 8 8 7 27 18 27 32 
15 Bristol Rovers 24 8 7 9 27 35 27 31 
16 Bristol City 24 7 9 8 25 32 25 30 
17 Peterborough United 23 6 8 9 32 37 32 26 
18 Rotherham United 24 6 7 11 29 39 29 25 
19 York City 23 7 4 12 27 37 27 25 
20 Carlisle United 25 5 9 11 30 39 30 24 
21 Brighton and Hove Albion 24 6 4 14 22 38 22 22 
22 Swansea City 24 4 9 11 24 41 24 21 
23 Brentford 23 5 6 12 19 31 19 21 
24 Hull City 23 2 8 13 18 40 18 14 

Key: Promotion Play-offs Relegation