Soccer Results Matrix

MargateSteve · December 27, 2011

I am trying to create a soccer results matrix from an existing database (tables and current query are at the bottom of the post) and am not sure where to start with it.

It is a bit hard to explain (unless you are a soccer fan where these results matrix's or grids are very common) but will give it a go!

Basically, I need to create a grid where the rows relate to the Home Teams and the columns relate to the Visiting Teams. In the corresponding cell I need to put the score of that game (I will also want to put in the date if the game has not been played but should be able to sort that once I have the basics sorted).

For example, if the result of a game was United 2 City 0, the cell of the United row and the City column should show 2-0. An example of what I am trying to achive can be found at http://en.wikipedia.org/wiki/2009%E2%80%9310_Premier_League#Results.

As I said, I already have an existing database that I want to use and have an idea how it should work but really need a starting point on how to go about it. My guess is that it would need to loop through the Home Teams (alphabetically is standard for these grids) and for each Home Team then loop through the Away Teams and then place the correct result

in that cell for the game where the two teams match. If the Home Team = Away Team then something else needs to be shown (usually an X or preferably a black cell) as a Team cannot play itself.

Any suggestions on how I could start this would be greatly appreciated.

Thanks in advance

Steve

The tables and sample data (these are not the full tables, just the relevant fields)

CREATE TABLE `all_games` (
`all_games_id` int(11) NOT NULL auto_increment,
`date` date default NULL,
`time` time default NULL,
`home_team` int(11) NOT NULL default NULL,
`away_team` int(11) NOT NULL default NULL,
`home_goals` int(11) default NULL,
`away_goals` int(11) default NULL,
  PRIMARY KEY  (`all_games_id`)
) 

INSERT INTO `all_games` VALUES (1, '2009-08-15', '15:00:00', 19, 42, 4, 0);
INSERT INTO `all_games` VALUES (2, '2009-08-18', '19:45:00', 42, 29, 0, 4);
INSERT INTO `all_games` VALUES (3, '2009-08-22', '15:00:00', 42, 30, 2, 1);
INSERT INTO `all_games` VALUES (4, '2009-08-24', '19:45:00', 1, 42, 0, 3);
INSERT INTO `all_games` VALUES (5, '2009-08-29', '15:00:00', 11, 42, 3, 0);


CREATE TABLE `teams` (
  `team_id` int(11) NOT NULL auto_increment,
  `team_name` varchar(45) collate latin1_general_ci default NULL
  PRIMARY KEY  (`team_id`)
)

INSERT INTO `teams` VALUES (1, 'Aveley');
INSERT INTO `teams` VALUES (2, 'Billericay Town');
INSERT INTO `teams` VALUES (3, 'Bury Town');
INSERT INTO `teams` VALUES (4, 'Canvey Island');
INSERT INTO `teams` VALUES (5, 'Carshalton Athletic');

The query I currently use to show the result of the game eg (in pseudo code)...

showdate ' ' HomeTeam ' ' home_goals ' ' AwayTeam ' ' away_goals

would show

Monday, 26th December 2011 United 2 City 0

SELECT *,
DATE_FORMAT(`time`,'%l:%i%p ') AS showtime, 
DATE_FORMAT(`date`,'%W, %D %M %Y') AS showdate, 
HT.team_name as HomeTeam, 
VT.team_name as AwayTeam, 
FROM all_games
JOIN teams as HT ON all_games.home_team = HT.team_id
JOIN teams as VT ON all_games.away_team = VT.team_id 
WHERE all_games.home_team IS NOT NULL

markla · March 14, 2013

Hi Steve,

in my (desperate) search for a PHP/mysql srcipt to create a soccer result matrix. i Stumbeld upon this topic.

I was wondering if you found a working script.

hope to hear from you

regard Marc

Barand · March 14, 2013

I had a similar table to yours (except week numbers instead of dates). These were the final results of the matches. For readability I substituted names for team ids:

+--------+----------+-----------+----------+-----------+
| weekno | hometeam | homegoals | awayteam | awaygoals |
+--------+----------+-----------+----------+-----------+
|      1 | Laker    |         1 | Jardine  |         1 |
|      1 | Cowdrey  |         1 | Grace    |         0 |
|      2 | Grace    |         2 | Cowdrey  |         2 |
|      2 | Jardine  |         1 | Laker    |         3 |
|      3 | Laker    |         2 | Cowdrey  |         4 |
|      3 | Jardine  |         4 | Grace    |         4 |
|      4 | Cowdrey  |         4 | Laker    |         4 |
|      4 | Grace    |         1 | Jardine  |         2 |
|      5 | Cowdrey  |         2 | Jardine  |         0 |
|      5 | Grace    |         0 | Laker    |         3 |
|      6 | Jardine  |         1 | Cowdrey  |         4 |
|      6 | Laker    |         4 | Grace    |         1 |
+--------+----------+-----------+----------+-----------+

The query I used was this (my house names are your teams)

SELECT h.house_name as House,
    COUNT(*) as Played,
    SUM(won) as Won,
    SUM(drawn) as Drawn,
    SUM(lost) as Lost,
    SUM(gdiff) as GDiff,
    SUM(points) as Points
FROM
(
    SELECT hometeam as houseid,
        CASE WHEN homegoals > awaygoals THEN 1 ELSE 0 END as won,
        CASE WHEN homegoals = awaygoals THEN 1 ELSE 0 END as drawn,
        CASE WHEN homegoals < awaygoals THEN 1 ELSE 0 END as lost,
        homegoals - awaygoals as gdiff,
        CASE WHEN homegoals > awaygoals THEN 3
            WHEN homegoals = awaygoals THEN 1
            ELSE 0 END as points
    FROM fixture

    UNION ALL
    
    SELECT awayteam as houseid,
        CASE WHEN homegoals < awaygoals THEN 1 ELSE 0 END as won,
        CASE WHEN homegoals = awaygoals THEN 1 ELSE 0 END as drawn,
        CASE WHEN homegoals > awaygoals THEN 1 ELSE 0 END as lost,
        awaygoals - homegoals as gdiff,
        CASE WHEN homegoals < awaygoals THEN 3
            WHEN homegoals = awaygoals THEN 1
            ELSE 0 END as points
    FROM fixture

) as X
INNER JOIN house h USING (houseid)
GROUP BY h.house_name
ORDER BY Points DESC, GDiff DESC

and the results were

+---------+--------+------+-------+------+-------+--------+
| House   | Played | Won  | Drawn | Lost | GDiff | Points |
+---------+--------+------+-------+------+-------+--------+
| Cowdrey |      6 |    4 |     2 |    0 |     8 |     14 |
| Laker   |      6 |    3 |     2 |    1 |     6 |     11 |
| Jardine |      6 |    1 |     2 |    3 |    -6 |      5 |
| Grace   |      6 |    0 |     2 |    4 |    -8 |      2 |
+---------+--------+------+-------+------+-------+--------+

I'm sure I have posted this before but searches on the forum seem to exclude code content.

Psycho · March 14, 2013

@Barand,

The poster was looking for a matrix where every team is listed down the left to represent where they are the home team, and every team is listed across the top to represent where they are the away team. Then the value of each cell is the score of that particular matchup. I don't think your solution really get that - at least not with additional work. I'm trying to solve this, but I'm sure you'll come up with something before me.

I'm guessing one option is to have two subqueries. One with all teams listed joing out to the games/results tables and retireve the score for the home team in the matchups. Then do another subquery for every team to get the data where they are away. Then JOIN those two subqueries together based on game_id. At least that's my first thought.

Edited March 14, 2013 by Psycho

Barand · March 14, 2013

I thought he wanted the league table above that one

but I'm sure you'll come up with something before me.

I wouldn't bet on it

Psycho · March 14, 2013

OK, using the same table structure as the original poster, this appears to work. But, not sure if it is the most efficient.

SELECT *
FROM
(SELECT homeTeam.team_name as home_team, homeGames.all_games_id, home_goals, homeGames.date, homeGames.time
 FROM teams AS homeTeam
 LEFT JOIN all_games AS homeGames
   ON homeTeam.team_id = homeGames.home_team) AS home
LEFT JOIN
(SELECT awayTeam.team_name as away_team, awayGames.all_games_id, awayGames.away_goals
 FROM teams AS awayTeam
 LEFT JOIN all_games AS awayGames
   ON awayTeam.team_id = awayGames.away_team) AS away

ON home.all_games_id = away.all_games_id

ORDER BY home_team ASC, away_team ASC

Edited March 15, 2013 by Psycho

Barand · March 15, 2013

Had to get a night's sleep first. Here's my offering

$db = new mysqli(HOST,USERNAME,PASSWORD,'jointute');

/**
* column heads
*/
$teams = array();
$sql = "SELECT team_id, team_name FROM teams ORDER BY team_name";
$res = $db->query($sql);
while (list($hid, $hname) = $res->fetch_row()) {
    $teams[$hid] = $hname;
}
$output = '<tr><td> </td><td>' . join('</td><td>', $teams) . "</td></tr>\n";

$blank_scores = array_fill_keys(array_keys($teams),'');

$now = 4;  // current week
$sql = "SELECT team_name, home_team, away_team,
        CASE WHEN date <= CURDATE() 
            THEN CONCAT(home_goals,'-',away_goals)
            ELSE DATE_FORMAT(date, '%b %e') END as score
        FROM all_games
            INNER JOIN teams ON all_games.home_team = teams.team_id
        ORDER BY team_name";
        
$currTeam = '';
$res = $db->query($sql);
while (list($teamname, $home, $away, $score) = $res->fetch_row()) {
    if ($currTeam != $teamname) {
        if ($currTeam) {
            $output .= "<tr><td>$currTeam</td><td>" .
                join('</td><td>', $teamscores) . 
                "</td></tr>\n";
        }
        $currTeam = $teamname;
        $teamscores = $blank_scores;
    }
    $teamscores[$home] = 'X';
    $teamscores[$away] = $score;
}
$output .= "<tr><td>$currTeam</td><td>" .
                join('</td><td>', $teamscores) . 
                "</td></tr>\n";
?>

<table border='1'>
    <?php echo $output ?>
</table>

markla · March 15, 2013

@barand could you please give us a output (printscreen?!?) example of the result that your script produces?

Barand · March 15, 2013

Not without data.

markla · March 16, 2013

@barand is this usefull for you?

this is the data for two seasons

-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- [url=http://www.phpmyadmin.net]http://www.phpmyadmin.net[/url]
--
-- Machine: 127.0.0.1
-- Genereertijd: 16 mrt 2013 om 13:13
-- Serverversie: 5.5.27-log
-- PHP-versie: 5.4.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Databank:
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `cs_match`
--

CREATE TABLE IF NOT EXISTS `cs_match` (
  `cs_match_id` int(4) NOT NULL AUTO_INCREMENT,
  `cs_match_played` enum('Y','N') NOT NULL,
  `cs_season_id` smallint(3) NOT NULL,
  `cs_match_playround` smallint(2) NOT NULL,
  `cs_match_datum` datetime NOT NULL,
  `cs_competitie_id` smallint(3) NOT NULL,
  `cs_team_id_home` smallint(3) NOT NULL,
  `cs_team_id_away` smallint(3) NOT NULL,
  `cs_goalhome` tinyint(2) DEFAULT NULL,
  `cs_goalaway` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`cs_match_id`),
  KEY `playround` (`cs_match_playround`),
  KEY `comp_id` (`cs_competitie_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=614 ;

--
-- Gegevens worden uitgevoerd voor tabel `cs_match`
--

INSERT INTO `cs_match` (`cs_match_id`, `cs_match_played`, `cs_season_id`, `cs_match_playround`, `cs_match_datum`, `cs_competitie_id`, `cs_team_id_home`, `cs_team_id_away`, `cs_goalhome`, `cs_goalaway`) VALUES
(1, 'Y', 106, 1, '2010-08-06 20:45:00', 1, 34, 17, 0, 0),
(2, 'Y', 106, 1, '2010-08-07 19:45:00', 1, 11, 12, 3, 0),
(3, 'Y', 106, 1, '2010-08-07 19:45:00', 1, 46, 44, 3, 0),
(4, 'Y', 106, 1, '2010-08-07 18:45:00', 1, 28, 43, 1, 0),
(5, 'Y', 106, 1, '2010-08-07 20:45:00', 1, 35, 31, 1, 3),
(6, 'Y', 106, 1, '2010-08-08 14:30:00', 1, 16, 4, 2, 2),
(7, 'Y', 106, 1, '2010-08-08 14:30:00', 1, 20, 18, 3, 1),
(8, 'Y', 106, 1, '2010-08-08 16:30:00', 1, 27, 5, 1, 1),
(9, 'Y', 106, 1, '2010-08-08 14:30:00', 1, 42, 3, 3, 1),
(10, 'Y', 106, 2, '2010-08-14 18:45:00', 1, 4, 42, 4, 2),
(11, 'Y', 106, 2, '2010-08-14 19:45:00', 1, 5, 16, 1, 1),
(12, 'Y', 106, 2, '2010-08-14 20:45:00', 1, 17, 35, 0, 0),
(13, 'Y', 106, 2, '2010-08-14 19:45:00', 1, 31, 11, 6, 0),
(14, 'Y', 106, 2, '2010-08-14 19:45:00', 1, 43, 46, 1, 0),
(15, 'Y', 106, 2, '2010-08-15 14:30:00', 1, 3, 34, 1, 3),
(16, 'Y', 106, 2, '2010-08-15 00:00:00', 1, 12, 20, 3, 2),
(17, 'Y', 106, 2, '2010-08-15 14:30:00', 1, 18, 27, 3, 1),
(18, 'Y', 106, 2, '2010-08-15 14:30:00', 1, 44, 28, 3, 5),
(19, 'Y', 106, 3, '2010-08-20 20:45:00', 1, 12, 28, 4, 2),
(20, 'Y', 106, 3, '2010-08-21 20:45:00', 1, 4, 34, 3, 0),
(21, 'Y', 106, 3, '2010-08-21 19:45:00', 1, 16, 11, 2, 1),
(22, 'Y', 106, 3, '2010-08-21 19:45:00', 1, 35, 27, 3, 1),
(23, 'Y', 106, 3, '2010-08-21 18:45:00', 1, 42, 17, 0, 3),
(24, 'Y', 106, 3, '2010-08-22 14:30:00', 1, 18, 44, 3, 0),
(25, 'Y', 106, 3, '2010-08-22 14:30:00', 1, 46, 20, 1, 1),
(26, 'Y', 106, 3, '2010-08-22 16:30:00', 1, 31, 5, 3, 1),
(27, 'Y', 106, 3, '2010-08-22 14:30:00', 1, 43, 3, 2, 3),
(28, 'Y', 106, 4, '2010-08-27 20:45:00', 1, 44, 16, 0, 3),
(29, 'Y', 106, 4, '2010-08-28 19:45:00', 1, 27, 43, 2, 0),
(30, 'Y', 106, 4, '2010-08-28 19:45:00', 1, 28, 35, 2, 2),
(31, 'Y', 106, 4, '2010-08-28 19:45:00', 1, 34, 46, 4, 2),
(32, 'Y', 106, 4, '2010-08-29 14:30:00', 1, 3, 31, 2, 2),
(33, 'Y', 106, 4, '2010-08-29 16:30:00', 1, 5, 12, 1, 1),
(34, 'Y', 106, 4, '2010-08-29 12:30:00', 1, 11, 4, 0, 5),
(35, 'Y', 106, 4, '2010-08-29 14:30:00', 1, 17, 18, 4, 0),
(36, 'Y', 106, 4, '2010-08-29 14:30:00', 1, 20, 42, 4, 0),
(37, 'Y', 106, 5, '2010-09-11 00:00:00', 1, 12, 46, 2, 1),
(38, 'Y', 106, 5, '2010-09-11 19:45:00', 1, 31, 28, 3, 1),
(39, 'Y', 106, 5, '2010-09-11 19:45:00', 1, 35, 42, 2, 1),
(40, 'Y', 106, 5, '2010-09-11 18:45:00', 1, 43, 17, 1, 2),
(41, 'Y', 106, 5, '2010-09-12 14:30:00', 1, 3, 11, 2, 2),
(42, 'Y', 106, 5, '2010-09-11 17:45:00', 1, 4, 44, 2, 0),
(43, 'Y', 106, 5, '2010-09-11 20:45:00', 1, 5, 34, 1, 2),
(44, 'Y', 106, 5, '2010-09-12 16:30:00', 1, 16, 18, 1, 0),
(45, 'Y', 106, 5, '2010-09-12 12:30:00', 1, 27, 20, 2, 0),
(46, 'Y', 106, 6, '2010-09-17 20:45:00', 1, 11, 35, 3, 2),
(47, 'Y', 106, 6, '2010-09-18 19:45:00', 1, 16, 12, 2, 1),
(48, 'Y', 106, 6, '2010-09-18 19:45:00', 1, 42, 27, 0, 0),
(49, 'Y', 106, 6, '2010-09-18 19:45:00', 1, 44, 3, 2, 4),
(50, 'Y', 106, 6, '2010-09-19 14:30:00', 1, 18, 43, 3, 2),
(51, 'Y', 106, 6, '2010-09-19 12:30:00', 1, 20, 4, 1, 2),
(52, 'Y', 106, 6, '2010-09-19 16:30:00', 1, 46, 17, 0, 0),
(53, 'Y', 106, 6, '2010-09-19 14:30:00', 1, 28, 5, 0, 1),
(54, 'Y', 106, 6, '2010-09-19 14:30:00', 1, 34, 31, 0, 0),
(55, 'Y', 106, 7, '2010-09-25 19:45:00', 1, 3, 46, 3, 2),
(56, 'Y', 106, 7, '2010-09-25 19:45:00', 1, 5, 18, 1, 0),
(57, 'Y', 106, 7, '2010-09-25 20:45:00', 1, 17, 4, 2, 2),
(58, 'Y', 106, 7, '2010-09-25 19:45:00', 1, 31, 16, 1, 1),
(59, 'Y', 106, 7, '2010-09-25 18:45:00', 1, 35, 34, 2, 2),
(60, 'Y', 106, 7, '2010-09-26 14:30:00', 1, 12, 42, 0, 2),
(61, 'Y', 106, 7, '2010-09-26 14:30:00', 1, 27, 44, 2, 1),
(62, 'Y', 106, 7, '2010-09-26 14:30:00', 1, 28, 20, 3, 0),
(63, 'Y', 106, 7, '2010-09-26 16:30:00', 1, 43, 11, 1, 0),
(64, 'Y', 106, 8, '2010-10-01 20:45:00', 1, 42, 44, 0, 0),
(65, 'Y', 106, 8, '2010-10-02 19:45:00', 1, 12, 34, 1, 2),
(66, 'Y', 106, 8, '2010-10-02 19:45:00', 1, 27, 28, 2, 0),
(67, 'Y', 106, 8, '2010-10-03 12:30:00', 1, 4, 18, 1, 2),
(68, 'Y', 106, 8, '2010-10-03 14:30:00', 1, 5, 46, 2, 1),
(69, 'Y', 106, 8, '2010-10-03 14:30:00', 1, 11, 20, 1, 1),
(70, 'Y', 106, 8, '2010-10-03 14:30:00', 1, 17, 16, 4, 2),
(71, 'Y', 106, 8, '2010-10-03 16:30:00', 1, 31, 43, 3, 0),
(72, 'Y', 106, 8, '2010-10-03 14:30:00', 1, 35, 3, 0, 0),
(73, 'Y', 106, 9, '2010-10-16 19:45:00', 1, 3, 12, 2, 1),
(74, 'Y', 106, 9, '2010-10-16 18:45:00', 1, 4, 27, 3, 0),
(75, 'Y', 106, 9, '2010-10-16 19:45:00', 1, 18, 11, 2, 2),
(76, 'Y', 106, 9, '2010-10-16 20:45:00', 1, 20, 17, 0, 1),
(77, 'Y', 106, 9, '2010-10-16 19:45:00', 1, 43, 5, 0, 1),
(78, 'Y', 106, 9, '2010-10-17 14:30:00', 1, 16, 35, 1, 0),
(79, 'Y', 106, 9, '2010-10-17 16:30:00', 1, 46, 28, 3, 2),
(80, 'Y', 106, 9, '2010-10-17 14:30:00', 1, 34, 42, 4, 1),
(81, 'Y', 106, 9, '2010-10-17 14:30:00', 1, 44, 31, 2, 4),
(82, 'Y', 106, 10, '2010-10-22 20:45:00', 1, 27, 34, 1, 2),
(83, 'Y', 106, 10, '2010-10-23 19:45:00', 1, 11, 46, 1, 1),
(84, 'Y', 106, 10, '2010-10-23 19:45:00', 1, 28, 16, 3, 2),
(85, 'Y', 106, 10, '2010-10-23 19:45:00', 1, 35, 43, 2, 0),
(86, 'Y', 106, 10, '2010-10-24 14:30:00', 1, 5, 44, 3, 0),
(87, 'Y', 106, 10, '2010-10-24 12:30:00', 1, 12, 4, 2, 2),
(88, 'Y', 106, 10, '2010-10-24 14:30:00', 1, 17, 3, 3, 2),
(89, 'Y', 106, 10, '2010-10-24 14:30:00', 1, 31, 20, 10, 0),
(90, 'Y', 106, 10, '2010-10-24 16:30:00', 1, 42, 18, 1, 4),
(91, 'Y', 106, 11, '2010-10-26 20:00:00', 1, 46, 27, 4, 1),
(92, 'Y', 106, 11, '2010-10-26 20:00:00', 1, 34, 28, 1, 1),
(93, 'Y', 106, 11, '2010-10-27 19:00:00', 1, 4, 35, 2, 1),
(94, 'Y', 106, 11, '2010-10-27 19:00:00', 1, 11, 5, 2, 1),
(95, 'Y', 106, 11, '2010-10-27 19:00:00', 1, 16, 3, 3, 1),
(96, 'Y', 106, 11, '2010-10-27 21:00:00', 1, 18, 12, 1, 0),
(97, 'Y', 106, 11, '2010-10-27 21:00:00', 1, 20, 43, 2, 0),
(98, 'Y', 106, 11, '2010-10-27 21:00:00', 1, 42, 31, 0, 2),
(99, 'Y', 106, 11, '2010-10-27 20:00:00', 1, 44, 17, 1, 3),
(100, 'Y', 106, 12, '2010-10-30 19:45:00', 1, 12, 35, 0, 2),
(101, 'Y', 106, 12, '2010-10-30 19:45:00', 1, 46, 4, 1, 4),
(102, 'Y', 106, 12, '2010-10-30 19:45:00', 1, 27, 11, 2, 0),
(103, 'Y', 106, 12, '2010-10-30 20:45:00', 1, 31, 17, 0, 1),
(104, 'Y', 106, 12, '2010-10-30 18:45:00', 1, 43, 16, 3, 5),
(105, 'Y', 106, 12, '2010-10-31 12:30:00', 1, 3, 18, 1, 0),
(106, 'Y', 106, 12, '2010-10-31 14:30:00', 1, 5, 20, 2, 1),
(107, 'Y', 106, 12, '2010-10-31 12:30:00', 1, 28, 42, 0, 0),
(108, 'Y', 106, 12, '2010-10-31 14:30:00', 1, 34, 44, 2, 2),
(109, 'Y', 106, 13, '2010-11-05 20:45:00', 1, 44, 43, 1, 4),
(110, 'Y', 106, 13, '2010-11-06 20:45:00', 1, 11, 28, 1, 4),
(111, 'Y', 106, 13, '2010-11-06 19:45:00', 1, 16, 27, 2, 1),
(112, 'Y', 106, 13, '2010-11-06 18:45:00', 1, 17, 12, 2, 1),
(113, 'Y', 106, 13, '2010-11-06 19:45:00', 1, 35, 46, 3, 2),
(114, 'Y', 106, 13, '2010-11-07 12:30:00', 1, 4, 3, 0, 1),
(115, 'Y', 106, 13, '2010-11-07 14:30:00', 1, 18, 31, 1, 2),
(116, 'Y', 106, 13, '2010-11-07 14:30:00', 1, 20, 34, 1, 1),
(117, 'Y', 106, 13, '2010-11-07 14:30:00', 1, 42, 5, 1, 1),
(118, 'Y', 106, 14, '2010-11-14 16:30:00', 1, 46, 16, 3, 0),
(119, 'Y', 106, 14, '2010-11-13 20:45:00', 1, 27, 17, 2, 1),
(120, 'Y', 106, 14, '2010-11-13 19:45:00', 1, 31, 12, 4, 2),
(121, 'Y', 106, 14, '2010-11-24 19:00:00', 1, 34, 18, 1, 1),
(122, 'Y', 106, 14, '2010-11-24 20:00:00', 1, 44, 11, 0, 1),
(123, 'Y', 106, 14, '2010-11-14 14:30:00', 1, 5, 4, 2, 0),
(124, 'Y', 106, 14, '2010-11-14 16:30:00', 1, 20, 35, 2, 2),
(125, 'Y', 106, 14, '2010-11-14 14:30:00', 1, 28, 3, 1, 1),
(126, 'Y', 106, 14, '2010-11-14 14:30:00', 1, 43, 42, 1, 5),
(127, 'Y', 106, 15, '2010-11-20 19:45:00', 1, 11, 34, 3, 1),
(128, 'Y', 106, 15, '2010-11-20 18:45:00', 1, 12, 43, 1, 0),
(129, 'Y', 106, 15, '2010-11-20 19:45:00', 1, 17, 5, 1, 2),
(130, 'Y', 106, 15, '2010-11-20 19:45:00', 1, 42, 46, 2, 0),
(131, 'Y', 106, 15, '2010-11-21 14:30:00', 1, 3, 27, 3, 0),
(132, 'Y', 106, 15, '2010-11-20 20:45:00', 1, 4, 31, 0, 0),
(133, 'Y', 106, 15, '2010-11-21 14:30:00', 1, 16, 20, 2, 0),
(134, 'Y', 106, 15, '2010-11-21 16:30:00', 1, 18, 28, 4, 0),
(135, 'Y', 106, 15, '2010-11-21 14:30:00', 1, 35, 44, 5, 0),
(136, 'Y', 106, 16, '2010-11-26 20:45:00', 1, 27, 31, 4, 2),
(137, 'Y', 106, 16, '2010-11-27 18:45:00', 1, 5, 35, 2, 2),
(138, 'Y', 106, 16, '2010-11-27 20:45:00', 1, 28, 17, 2, 4),
(139, 'Y', 106, 16, '2010-11-27 19:45:00', 1, 34, 16, 1, 0),
(140, 'Y', 106, 16, '2010-11-27 19:45:00', 1, 44, 12, 1, 1),
(141, 'Y', 106, 16, '2010-11-28 14:30:00', 1, 11, 42, 1, 1),
(142, 'Y', 106, 16, '2010-11-28 12:30:00', 1, 20, 3, 2, 1),
(143, 'Y', 106, 16, '2010-11-28 14:30:00', 1, 46, 18, 2, 1),
(144, 'Y', 106, 16, '2010-11-28 14:30:00', 1, 43, 4, 0, 2),
(145, 'Y', 106, 17, '2010-12-03 20:45:00', 1, 16, 42, 4, 1),
(146, 'Y', 106, 17, '2010-12-15 20:00:00', 1, 12, 27, 1, 3),
(147, 'Y', 106, 17, '2010-12-04 20:45:00', 1, 17, 11, 2, 0),
(148, 'Y', 106, 17, '2010-12-05 14:30:00', 1, 18, 35, 2, 1),
(149, 'Y', 106, 17, '2010-12-04 19:45:00', 1, 31, 46, 5, 2),
(150, 'Y', 106, 17, '2010-12-05 14:30:00', 1, 3, 5, 0, 2),
(151, 'Y', 106, 17, '2010-12-04 14:30:00', 1, 4, 28, 1, 1),
(152, 'Y', 106, 17, '2010-12-14 20:00:00', 1, 43, 34, 0, 4),
(153, 'Y', 106, 17, '2010-12-05 12:30:00', 1, 44, 20, 1, 1),
(154, 'Y', 106, 18, '2010-12-10 20:45:00', 1, 46, 43, 2, 2),
(155, 'Y', 106, 18, '2010-12-11 20:40:00', 1, 11, 31, 0, 0),
(156, 'Y', 106, 18, '2010-12-11 18:45:00', 1, 27, 18, 3, 1),
(157, 'Y', 106, 18, '2010-12-11 19:45:00', 1, 28, 44, 3, 1),
(158, 'Y', 106, 18, '2010-12-11 19:45:00', 1, 34, 3, 1, 1),
(159, 'Y', 106, 18, '2010-12-12 14:30:00', 1, 16, 5, 2, 0),
(160, 'Y', 106, 18, '2010-12-12 14:30:00', 1, 20, 12, 1, 0),
(161, 'Y', 106, 18, '2010-12-12 14:30:00', 1, 35, 17, 6, 2),
(162, 'Y', 106, 18, '2010-12-12 12:30:00', 1, 42, 4, 0, 1),
(163, 'Y', 106, 19, '2011-01-19 18:40:00', 1, 17, 46, 5, 0),
(164, 'Y', 106, 19, '2010-12-18 20:40:00', 1, 3, 44, 2, 1),
(165, 'Y', 106, 19, '2010-12-18 19:40:00', 1, 12, 16, 2, 2),
(166, 'Y', 106, 19, '2010-12-18 19:40:00', 1, 27, 42, 1, 1),
(167, 'Y', 106, 19, '2010-12-18 18:40:00', 1, 35, 11, 4, 0),
(168, 'Y', 106, 19, '2011-01-19 20:40:00', 1, 4, 20, 2, 0),
(169, 'Y', 106, 19, '2011-01-19 20:40:00', 1, 5, 28, 2, 2),
(170, 'Y', 106, 19, '2010-12-19 14:30:00', 1, 31, 34, 3, 1),
(171, 'Y', 106, 19, '2011-01-19 17:30:00', 1, 43, 18, 1, 2),
(172, 'Y', 106, 20, '2011-01-21 20:40:00', 1, 3, 35, 3, 1),
(173, 'Y', 106, 20, '2011-01-22 20:40:00', 1, 20, 11, 0, 1),
(174, 'Y', 106, 20, '2011-01-22 18:40:00', 1, 46, 5, 0, 0),
(175, 'Y', 106, 20, '2011-01-22 19:40:00', 1, 28, 27, 2, 2),
(176, 'Y', 106, 20, '2011-01-22 19:40:00', 1, 44, 42, 1, 0),
(177, 'Y', 106, 20, '2011-01-23 14:30:00', 1, 16, 17, 1, 2),
(178, 'Y', 106, 20, '2011-01-23 12:30:00', 1, 18, 4, 3, 0),
(179, 'Y', 106, 20, '2011-01-23 14:30:00', 1, 34, 12, 3, 0),
(180, 'Y', 106, 20, '2011-01-23 14:30:00', 1, 43, 31, 0, 3),
(181, 'Y', 106, 21, '2011-01-28 20:40:00', 1, 28, 46, 1, 1),
(182, 'Y', 106, 21, '2011-01-29 19:40:00', 1, 5, 43, 6, 1),
(183, 'Y', 106, 21, '2011-02-01 20:00:00', 1, 11, 18, 0, 0),
(184, 'Y', 106, 21, '2011-01-29 20:40:00', 1, 31, 44, 2, 1),
(185, 'Y', 106, 21, '2011-01-29 18:40:00', 1, 42, 34, 5, 2),
(186, 'Y', 106, 21, '2011-01-30 12:30:00', 1, 12, 3, 1, 5),
(187, 'Y', 106, 21, '2011-01-30 14:30:00', 1, 17, 20, 2, 1),
(188, 'Y', 106, 21, '2011-01-30 14:30:00', 1, 27, 4, 0, 3),
(189, 'Y', 106, 21, '2011-01-30 14:30:00', 1, 35, 16, 1, 4),
(190, 'Y', 106, 22, '2011-02-04 20:45:00', 1, 4, 11, 2, 0),
(191, 'Y', 106, 22, '2011-02-05 19:45:00', 1, 12, 5, 2, 1),
(192, 'Y', 106, 22, '2011-02-05 19:45:00', 1, 31, 3, 0, 1),
(193, 'Y', 106, 22, '2011-02-05 18:45:00', 1, 35, 28, 0, 0),
(194, 'Y', 106, 22, '2011-02-05 20:45:00', 1, 43, 27, 3, 0),
(195, 'Y', 106, 22, '2011-02-06 14:30:00', 1, 16, 44, 7, 1),
(196, 'Y', 106, 22, '2011-02-06 14:30:00', 1, 18, 17, 1, 1),
(197, 'Y', 106, 22, '2011-02-06 14:30:00', 1, 46, 34, 1, 0),
(198, 'Y', 106, 22, '2011-02-06 12:30:00', 1, 42, 20, 1, 1),
(199, 'Y', 106, 23, '2011-02-12 18:45:00', 1, 3, 43, 3, 0),
(200, 'Y', 106, 23, '2011-02-12 20:45:00', 1, 5, 31, 0, 4),
(201, 'Y', 106, 23, '2011-02-12 19:45:00', 1, 17, 42, 1, 0),
(202, 'Y', 106, 23, '2011-02-12 19:45:00', 1, 20, 46, 2, 1),
(203, 'Y', 106, 23, '2011-02-12 19:45:00', 1, 44, 18, 3, 3),
(204, 'Y', 106, 23, '2011-02-13 16:30:00', 1, 11, 16, 1, 1),
(205, 'Y', 106, 23, '2011-02-13 14:30:00', 1, 27, 35, 0, 2),
(206, 'Y', 106, 23, '2011-02-13 14:30:00', 1, 28, 12, 2, 0),
(207, 'Y', 106, 23, '2011-02-13 14:30:00', 1, 34, 4, 2, 2),
(208, 'Y', 106, 24, '2011-02-18 20:45:00', 1, 18, 46, 1, 1),
(209, 'Y', 106, 24, '2011-02-19 18:45:00', 1, 12, 44, 4, 0),
(210, 'Y', 106, 24, '2011-02-20 14:30:00', 1, 17, 28, 1, 1),
(211, 'Y', 106, 24, '2011-02-20 16:30:00', 1, 31, 27, 4, 1),
(212, 'Y', 106, 24, '2011-02-19 19:45:00', 1, 35, 5, 0, 2),
(213, 'Y', 106, 24, '2011-02-20 12:30:00', 1, 3, 20, 2, 2),
(214, 'Y', 106, 24, '2011-02-20 14:30:00', 1, 4, 43, 1, 0),
(215, 'Y', 106, 24, '2011-02-19 19:30:00', 1, 16, 34, 1, 4),
(216, 'Y', 106, 24, '2011-02-20 14:30:00', 1, 42, 11, 2, 0),
(217, 'Y', 106, 25, '2011-02-25 20:45:00', 1, 43, 12, 1, 0),
(218, 'Y', 106, 25, '2011-02-26 19:45:00', 1, 46, 42, 6, 1),
(219, 'Y', 106, 25, '2011-02-26 20:45:00', 1, 27, 3, 3, 2),
(220, 'Y', 106, 25, '2011-02-26 19:45:00', 1, 34, 11, 1, 1),
(221, 'Y', 106, 25, '2011-02-26 18:45:00', 1, 44, 35, 4, 3),
(222, 'Y', 106, 25, '2011-02-27 14:30:00', 1, 5, 17, 2, 1),
(223, 'Y', 106, 25, '2011-02-27 14:30:00', 1, 20, 16, 5, 1),
(224, 'Y', 106, 25, '2011-02-27 16:30:00', 1, 28, 18, 1, 1),
(225, 'Y', 106, 25, '2011-02-27 14:30:00', 1, 31, 4, 0, 0),
(226, 'Y', 106, 26, '2011-03-04 20:45:00', 1, 11, 44, 2, 1),
(227, 'Y', 106, 26, '2011-03-05 19:45:00', 1, 3, 28, 5, 1),
(228, 'Y', 106, 26, '2011-03-05 20:45:00', 1, 12, 31, 2, 3),
(229, 'Y', 106, 26, '2011-03-05 18:45:00', 1, 17, 27, 2, 0),
(230, 'Y', 106, 26, '2011-03-05 19:45:00', 1, 42, 43, 2, 0),
(231, 'Y', 106, 26, '2011-03-06 16:30:00', 1, 4, 5, 4, 0),
(232, 'Y', 106, 26, '2011-03-06 14:30:00', 1, 16, 46, 1, 4),
(233, 'Y', 106, 26, '2011-03-06 14:30:00', 1, 18, 34, 1, 1),
(234, 'Y', 106, 26, '2011-03-06 14:30:00', 1, 35, 20, 0, 1),
(235, 'Y', 106, 27, '2011-03-13 20:45:00', 1, 28, 31, 2, 2),
(236, 'Y', 106, 27, '2011-03-13 14:30:00', 1, 17, 43, 2, 1),
(237, 'Y', 106, 27, '2011-03-12 18:45:00', 1, 46, 12, 4, 1),
(238, 'Y', 106, 27, '2011-03-12 19:45:00', 1, 34, 5, 1, 2),
(239, 'Y', 106, 27, '2011-03-12 20:45:00', 1, 42, 35, 1, 1),
(240, 'Y', 106, 27, '2011-03-13 12:30:00', 1, 11, 3, 1, 0),
(241, 'Y', 106, 27, '2011-03-11 19:45:00', 1, 18, 16, 1, 0),
(242, 'Y', 106, 27, '2011-03-13 14:30:00', 1, 20, 27, 2, 1),
(243, 'Y', 106, 27, '2011-03-13 14:30:00', 1, 44, 4, 1, 3),
(244, 'Y', 106, 28, '2011-03-18 20:45:00', 1, 5, 42, 3, 1),
(245, 'Y', 106, 28, '2011-03-19 18:45:00', 1, 27, 16, 0, 1),
(246, 'Y', 106, 28, '2011-03-19 20:45:00', 1, 28, 11, 1, 0),
(247, 'Y', 106, 28, '2011-03-20 14:30:00', 1, 31, 18, 1, 0),
(248, 'Y', 106, 28, '2011-03-19 19:45:00', 1, 43, 44, 0, 0),
(249, 'Y', 106, 28, '2011-03-20 12:30:00', 1, 3, 4, 3, 2),
(250, 'Y', 106, 28, '2011-03-20 14:30:00', 1, 12, 17, 0, 2),
(251, 'Y', 106, 28, '2011-03-19 19:45:00', 1, 46, 35, 4, 2),
(252, 'Y', 106, 28, '2011-03-20 14:30:00', 1, 34, 20, 3, 0),
(253, 'Y', 106, 29, '2011-04-02 19:45:00', 1, 11, 27, 1, 3),
(254, 'Y', 106, 29, '2011-04-02 18:45:00', 1, 17, 31, 2, 0),
(255, 'Y', 106, 29, '2011-04-02 20:45:00', 1, 20, 5, 0, 1),
(256, 'Y', 106, 29, '2011-04-02 19:45:00', 1, 35, 12, 2, 3),
(257, 'Y', 106, 29, '2011-04-02 19:45:00', 1, 44, 34, 4, 5),
(258, 'Y', 106, 29, '2011-04-03 19:45:00', 1, 4, 46, 3, 0),
(259, 'Y', 106, 29, '2011-04-03 19:45:00', 1, 16, 43, 3, 2),
(260, 'Y', 106, 29, '2011-04-03 12:30:00', 1, 18, 3, 2, 3),
(261, 'Y', 106, 29, '2011-04-03 19:45:00', 1, 42, 28, 2, 1),
(262, 'Y', 106, 30, '2011-04-10 16:45:00', 1, 31, 35, 2, 2),
(263, 'Y', 106, 30, '2011-04-09 19:45:00', 1, 3, 42, 1, 0),
(264, 'Y', 106, 30, '2011-04-09 19:45:00', 1, 12, 11, 0, 0),
(265, 'Y', 106, 30, '2011-04-09 18:45:00', 1, 43, 28, 1, 4),
(266, 'Y', 106, 30, '2011-04-09 20:45:00', 1, 44, 46, 2, 6),
(267, 'Y', 106, 30, '2011-04-10 14:30:00', 1, 4, 16, 2, 0),
(268, 'Y', 106, 30, '2011-04-08 20:45:00', 1, 5, 27, 1, 1),
(269, 'Y', 106, 30, '2011-04-10 14:30:00', 1, 17, 34, 1, 1),
(270, 'Y', 106, 30, '2011-04-10 14:30:00', 1, 18, 20, 0, 4),
(271, 'Y', 106, 31, '2011-04-15 20:45:00', 1, 35, 18, 3, 0),
(272, 'Y', 106, 31, '2011-04-17 14:30:00', 1, 46, 31, 0, 2),
(273, 'Y', 106, 31, '2011-04-16 19:45:00', 1, 27, 12, 1, 2),
(274, 'Y', 106, 31, '2011-04-16 19:45:00', 1, 34, 43, 5, 2),
(275, 'Y', 106, 31, '2011-04-16 18:45:00', 1, 42, 16, 2, 1),
(276, 'Y', 106, 31, '2011-04-16 20:45:00', 1, 5, 3, 3, 1),
(277, 'Y', 106, 31, '2011-04-17 14:30:00', 1, 11, 17, 1, 1),
(278, 'Y', 106, 31, '2011-04-17 16:30:00', 1, 20, 44, 6, 1),
(279, 'Y', 106, 31, '2011-04-17 14:30:00', 1, 28, 4, 1, 2),
(280, 'Y', 106, 32, '2011-04-22 20:45:00', 1, 3, 17, 1, 2),
(281, 'Y', 106, 32, '2011-04-23 19:45:00', 1, 46, 11, 2, 0),
(282, 'Y', 106, 32, '2011-04-23 19:45:00', 1, 34, 27, 5, 1),
(283, 'Y', 106, 32, '2011-04-23 20:45:00', 1, 43, 35, 2, 2),
(284, 'Y', 106, 32, '2011-04-23 18:45:00', 1, 44, 5, 2, 1),
(285, 'Y', 106, 32, '2011-04-24 14:30:00', 1, 4, 12, 4, 1),
(286, 'Y', 106, 32, '2011-04-24 16:30:00', 1, 16, 28, 3, 1),
(287, 'Y', 106, 32, '2011-04-24 14:30:00', 1, 18, 42, 4, 2),
(288, 'Y', 106, 32, '2011-04-24 14:30:00', 1, 20, 31, 3, 1),
(289, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 3, 16, 2, 4),
(290, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 5, 11, 5, 1),
(291, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 12, 18, 3, 1),
(292, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 17, 44, 4, 0),
(293, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 27, 46, 1, 2),
(294, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 28, 34, 5, 0),
(295, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 31, 42, 2, 1),
(296, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 35, 4, 1, 2),
(297, 'Y', 106, 33, '2011-05-01 14:30:00', 1, 43, 20, 3, 2),
(298, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 4, 17, 3, 1),
(299, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 11, 43, 1, 0),
(300, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 16, 31, 0, 0),
(301, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 18, 5, 5, 1),
(302, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 20, 28, 1, 1),
(303, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 46, 3, 3, 0),
(304, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 34, 35, 0, 0),
(305, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 42, 12, 1, 4),
(306, 'Y', 106, 34, '2011-05-15 14:30:00', 1, 44, 27, 0, 1),
(600, 'N', 107, 33, '2012-05-02 00:00:00', 1, 4, 43, 0, 0),
(599, 'N', 107, 33, '2012-05-02 00:00:00', 1, 33, 34, 0, 0),
(598, 'N', 107, 33, '2012-05-02 00:00:00', 1, 11, 12, 0, 0),
(597, 'N', 107, 33, '2012-05-02 00:00:00', 1, 28, 5, 0, 0),
(596, 'N', 107, 33, '2012-05-02 00:00:00', 1, 18, 42, 0, 0),
(595, 'N', 107, 33, '2012-05-02 00:00:00', 1, 16, 27, 0, 0),
(594, 'N', 107, 32, '2012-04-29 00:00:00', 1, 20, 5, 0, 0),
(593, 'N', 107, 32, '2012-04-29 00:00:00', 1, 28, 33, 0, 0),
(592, 'N', 107, 32, '2012-04-29 00:00:00', 1, 17, 4, 0, 0),
(591, 'N', 107, 32, '2012-04-29 00:00:00', 1, 34, 31, 0, 0),
(590, 'N', 107, 32, '2012-04-28 00:00:00', 1, 18, 27, 0, 0),
(589, 'N', 107, 32, '2012-04-28 00:00:00', 1, 43, 3, 0, 0),
(588, 'N', 107, 32, '2012-04-28 00:00:00', 1, 42, 12, 0, 0),
(587, 'N', 107, 32, '2012-04-28 00:00:00', 1, 46, 35, 0, 0),
(586, 'N', 107, 32, '2012-04-27 00:00:00', 1, 16, 11, 0, 0),
(585, 'N', 107, 31, '2012-04-22 00:00:00', 1, 4, 16, 0, 0),
(584, 'N', 107, 31, '2012-04-22 00:00:00', 1, 31, 28, 0, 0),
(583, 'N', 107, 31, '2012-04-22 00:00:00', 1, 5, 43, 0, 0),
(582, 'N', 107, 31, '2012-04-22 00:00:00', 1, 3, 20, 0, 0),
(581, 'N', 107, 31, '2012-04-21 00:00:00', 1, 12, 17, 0, 0),
(580, 'N', 107, 31, '2012-04-21 00:00:00', 1, 33, 18, 0, 0),
(579, 'N', 107, 31, '2012-04-21 00:00:00', 1, 11, 46, 0, 0),
(578, 'N', 107, 31, '2012-04-21 00:00:00', 1, 35, 42, 0, 0),
(577, 'N', 107, 31, '2012-04-20 00:00:00', 1, 27, 34, 0, 0),
(576, 'N', 107, 30, '2012-04-15 00:00:00', 1, 18, 43, 0, 0),
(575, 'N', 107, 30, '2012-04-15 00:00:00', 1, 4, 11, 0, 0),
(574, 'N', 107, 30, '2012-04-15 00:00:00', 1, 42, 3, 0, 0),
(573, 'N', 107, 30, '2012-04-15 00:00:00', 1, 46, 33, 0, 0),
(572, 'N', 107, 30, '2012-04-15 00:00:00', 1, 16, 34, 0, 0),
(571, 'N', 107, 30, '2012-04-14 00:00:00', 1, 20, 12, 0, 0),
(570, 'N', 107, 30, '2012-04-14 00:00:00', 1, 17, 27, 0, 0),
(569, 'N', 107, 30, '2012-04-14 00:00:00', 1, 31, 5, 0, 0),
(568, 'N', 107, 30, '2012-04-13 00:00:00', 1, 28, 35, 0, 0),
(567, 'N', 107, 29, '2012-04-12 00:00:00', 1, 3, 16, 0, 0),
(566, 'N', 107, 29, '2012-04-12 00:00:00', 1, 43, 42, 0, 0),
(565, 'N', 107, 29, '2012-04-12 00:00:00', 1, 11, 18, 0, 0),
(564, 'N', 107, 29, '2012-04-11 00:00:00', 1, 33, 31, 0, 0),
(563, 'N', 107, 29, '2012-04-11 00:00:00', 1, 5, 17, 0, 0),
(562, 'N', 107, 29, '2012-04-11 00:00:00', 1, 34, 20, 0, 0),
(561, 'N', 107, 29, '2012-04-10 00:00:00', 1, 12, 28, 0, 0),
(560, 'N', 107, 29, '2012-04-10 00:00:00', 1, 35, 4, 0, 0),
(559, 'N', 107, 29, '2012-04-10 00:00:00', 1, 27, 46, 0, 0),
(558, 'N', 107, 28, '2012-04-01 00:00:00', 1, 42, 5, 0, 0),
(557, 'N', 107, 28, '2012-04-01 00:00:00', 1, 4, 46, 0, 0),
(556, 'N', 107, 28, '2012-04-01 00:00:00', 1, 33, 3, 0, 0),
(555, 'N', 107, 28, '2012-04-01 00:00:00', 1, 28, 11, 0, 0),
(554, 'N', 107, 28, '2012-03-31 00:00:00', 1, 20, 27, 0, 0),
(553, 'N', 107, 28, '2012-03-31 00:00:00', 1, 17, 34, 0, 0),
(552, 'N', 107, 28, '2012-03-31 00:00:00', 1, 31, 43, 0, 0),
(551, 'N', 107, 28, '2012-03-31 00:00:00', 1, 16, 35, 0, 0),
(550, 'N', 107, 28, '2012-03-30 00:00:00', 1, 18, 12, 0, 0),
(549, 'N', 107, 27, '2012-03-25 00:00:00', 1, 12, 16, 0, 0),
(548, 'N', 107, 27, '2012-03-25 00:00:00', 1, 34, 42, 0, 0),
(547, 'N', 107, 27, '2012-03-25 00:00:00', 1, 11, 20, 0, 0),
(546, 'N', 107, 27, '2012-03-25 00:00:00', 1, 4, 31, 0, 0),
(545, 'N', 107, 27, '2012-03-24 00:00:00', 1, 3, 17, 0, 0),
(544, 'N', 107, 27, '2012-03-24 00:00:00', 1, 35, 43, 0, 0),
(543, 'N', 107, 27, '2012-03-24 00:00:00', 1, 27, 28, 0, 0),
(542, 'N', 107, 27, '2012-03-24 00:00:00', 1, 46, 18, 0, 0),
(541, 'N', 107, 27, '2012-03-23 00:00:00', 1, 5, 33, 0, 0),
(540, 'N', 107, 26, '2012-03-18 00:00:00', 1, 18, 16, 0, 0),
(539, 'N', 107, 26, '2012-03-18 00:00:00', 1, 43, 28, 0, 0),
(538, 'N', 107, 26, '2012-03-18 00:00:00', 1, 17, 20, 0, 0),
(537, 'N', 107, 26, '2012-03-18 00:00:00', 1, 3, 4, 0, 0),
(536, 'N', 107, 26, '2012-03-17 00:00:00', 1, 31, 35, 0, 0),
(535, 'N', 107, 26, '2012-03-17 00:00:00', 1, 12, 34, 0, 0),
(534, 'N', 107, 26, '2012-03-17 00:00:00', 1, 33, 11, 0, 0),
(533, 'N', 107, 26, '2012-03-17 00:00:00', 1, 5, 27, 0, 0),
(532, 'N', 107, 26, '2012-03-16 00:00:00', 1, 42, 46, 0, 0),
(531, 'N', 107, 25, '2012-03-11 00:00:00', 1, 4, 33, 0, 0),
(530, 'N', 107, 25, '2012-03-11 00:00:00', 1, 16, 42, 0, 0),
(529, 'N', 107, 25, '2012-03-11 00:00:00', 1, 11, 5, 0, 0),
(528, 'N', 107, 25, '2012-03-11 00:00:00', 1, 20, 18, 0, 0),
(527, 'N', 107, 25, '2012-03-10 00:00:00', 1, 27, 31, 0, 0),
(526, 'N', 107, 25, '2012-03-10 00:00:00', 1, 46, 3, 0, 0),
(525, 'N', 107, 25, '2012-03-10 00:00:00', 1, 35, 12, 0, 0),
(524, 'N', 107, 25, '2012-03-10 00:00:00', 1, 28, 17, 0, 0),
(523, 'N', 107, 25, '2012-03-09 00:00:00', 1, 34, 43, 0, 0),
(522, 'N', 107, 24, '2012-03-04 00:00:00', 1, 31, 17, 0, 0),
(521, 'N', 107, 24, '2012-03-04 00:00:00', 1, 20, 16, 0, 0),
(520, 'N', 107, 24, '2012-03-04 00:00:00', 1, 42, 11, 0, 0),
(519, 'N', 107, 24, '2012-03-04 00:00:00', 1, 18, 28, 0, 0),
(518, 'N', 107, 24, '2012-03-04 00:00:00', 1, 4, 34, 0, 0),
(517, 'N', 107, 24, '2012-03-03 00:00:00', 1, 5, 46, 0, 0),
(516, 'N', 107, 24, '2012-03-03 00:00:00', 1, 33, 12, 0, 0),
(515, 'N', 107, 24, '2012-03-03 00:00:00', 1, 43, 27, 0, 0),
(514, 'N', 107, 24, '2012-03-03 00:00:00', 1, 3, 35, 0, 0),
(513, 'N', 107, 23, '2012-02-26 00:00:00', 1, 28, 16, 0, 0),
(512, 'N', 107, 23, '2012-02-26 00:00:00', 1, 31, 20, 0, 0),
(511, 'N', 107, 23, '2012-02-26 00:00:00', 1, 17, 18, 0, 0),
(510, 'N', 107, 23, '2012-02-26 00:00:00', 1, 12, 4, 0, 0),
(509, 'N', 107, 23, '2012-02-25 00:00:00', 1, 5, 35, 0, 0),
(508, 'N', 107, 23, '2012-02-25 00:00:00', 1, 34, 11, 0, 0),
(507, 'N', 107, 23, '2012-02-25 00:00:00', 1, 43, 46, 0, 0),
(506, 'N', 107, 23, '2012-02-25 00:00:00', 1, 27, 3, 0, 0),
(505, 'N', 107, 23, '2012-02-24 00:00:00', 1, 33, 42, 0, 0),
(504, 'N', 107, 22, '2012-02-19 00:00:00', 1, 20, 33, 0, 0),
(503, 'N', 107, 22, '2012-02-19 00:00:00', 1, 18, 5, 0, 0),
(502, 'N', 107, 22, '2012-02-19 00:00:00', 1, 4, 28, 0, 0),
(501, 'N', 107, 22, '2012-02-19 00:00:00', 1, 16, 31, 0, 0),
(500, 'N', 107, 22, '2012-02-18 00:00:00', 1, 42, 17, 0, 0),
(499, 'N', 107, 22, '2012-02-18 00:00:00', 1, 11, 43, 0, 0),
(498, 'N', 107, 22, '2012-02-18 00:00:00', 1, 3, 12, 0, 0),
(497, 'N', 107, 22, '2012-02-18 00:00:00', 1, 46, 34, 0, 0),
(496, 'N', 107, 22, '2012-02-17 00:00:00', 1, 35, 27, 0, 0),
(495, 'N', 107, 21, '2012-02-12 00:00:00', 1, 20, 42, 0, 0),
(494, 'N', 107, 21, '2012-02-12 00:00:00', 1, 33, 35, 0, 0),
(493, 'N', 107, 21, '2012-02-12 00:00:00', 1, 31, 11, 0, 0),
(492, 'N', 107, 21, '2012-02-12 00:00:00', 1, 18, 3, 0, 0),
(491, 'N', 107, 21, '2012-02-11 00:00:00', 1, 27, 4, 0, 0),
(490, 'N', 107, 21, '2012-02-11 00:00:00', 1, 34, 28, 0, 0),
(489, 'N', 107, 21, '2012-02-11 00:00:00', 1, 43, 16, 0, 0),
(488, 'N', 107, 21, '2012-02-11 00:00:00', 1, 5, 12, 0, 0),
(487, 'N', 107, 21, '2012-02-10 00:00:00', 1, 17, 46, 0, 0),
(486, 'N', 107, 20, '2012-02-05 00:00:00', 1, 16, 33, 0, 0),
(485, 'N', 107, 20, '2012-02-05 00:00:00', 1, 11, 17, 0, 0),
(484, 'N', 107, 20, '2012-02-05 00:00:00', 1, 28, 20, 0, 0),
(483, 'N', 107, 20, '2012-02-05 00:00:00', 1, 4, 18, 0, 0),
(482, 'N', 107, 20, '2012-02-04 00:00:00', 1, 46, 31, 0, 0),
(481, 'N', 107, 20, '2012-02-04 00:00:00', 1, 12, 43, 0, 0),
(480, 'N', 107, 20, '2012-02-04 00:00:00', 1, 42, 27, 0, 0),
(479, 'N', 107, 20, '2012-02-04 00:00:00', 1, 3, 5, 0, 0),
(478, 'N', 107, 20, '2012-02-03 00:00:00', 1, 35, 34, 0, 0),
(477, 'N', 107, 19, '2012-01-29 00:00:00', 1, 28, 3, 0, 0),
(476, 'N', 107, 19, '2012-01-29 00:00:00', 1, 17, 16, 0, 0),
(475, 'N', 107, 19, '2012-01-29 00:00:00', 1, 33, 43, 0, 0),
(474, 'N', 107, 19, '2012-01-29 00:00:00', 1, 20, 4, 0, 0),
(473, 'N', 107, 19, '2012-01-28 00:00:00', 1, 34, 5, 0, 0),
(472, 'N', 107, 19, '2012-01-28 00:00:00', 1, 46, 12, 0, 0),
(471, 'N', 107, 19, '2012-01-28 00:00:00', 1, 27, 11, 0, 0),
(470, 'N', 107, 19, '2012-01-28 00:00:00', 1, 35, 18, 0, 0),
(469, 'N', 107, 19, '2012-01-27 00:00:00', 1, 31, 42, 0, 0),
(468, 'N', 107, 18, '2012-01-22 00:00:00', 1, 16, 46, 0, 0),
(467, 'N', 107, 18, '2012-01-22 00:00:00', 1, 5, 4, 0, 0),
(466, 'N', 107, 18, '2012-01-22 00:00:00', 1, 43, 20, 0, 0),
(465, 'N', 107, 18, '2012-01-22 00:00:00', 1, 42, 28, 0, 0),
(464, 'N', 107, 18, '2012-01-21 00:00:00', 1, 18, 31, 0, 0),
(463, 'N', 107, 18, '2012-01-21 00:00:00', 1, 12, 27, 0, 0),
(462, 'N', 107, 18, '2012-01-21 00:00:00', 1, 17, 33, 0, 0),
(461, 'N', 107, 18, '2012-01-21 00:00:00', 1, 11, 35, 0, 0),
(460, 'N', 107, 18, '2012-01-20 00:00:00', 1, 3, 34, 0, 0),
(459, 'N', 107, 17, '2011-12-18 00:00:00', 1, 35, 31, 0, 0),
(458, 'N', 107, 17, '2011-12-18 00:00:00', 1, 20, 17, 0, 0),
(457, 'N', 107, 17, '2011-12-18 00:00:00', 1, 27, 5, 0, 0),
(456, 'N', 107, 17, '2011-12-18 00:00:00', 1, 4, 3, 0, 0),
(455, 'N', 107, 17, '2011-12-17 00:00:00', 1, 16, 18, 0, 0),
(454, 'N', 107, 17, '2011-12-17 00:00:00', 1, 28, 43, 0, 0),
(453, 'N', 107, 17, '2011-12-17 00:00:00', 1, 34, 12, 0, 0),
(452, 'N', 107, 17, '2011-12-17 00:00:00', 1, 46, 42, 0, 0),
(451, 'N', 107, 17, '2011-12-16 00:00:00', 1, 11, 33, 0, 0),
(450, 'N', 107, 16, '2011-12-11 00:00:00', 1, 42, 16, 0, 0),
(449, 'N', 107, 16, '2011-12-11 00:00:00', 1, 43, 34, 0, 0),
(448, 'N', 107, 16, '2011-12-11 00:00:00', 1, 33, 4, 0, 0),
(447, 'N', 107, 16, '2011-12-11 00:00:00', 1, 18, 20, 0, 0),
(446, 'N', 107, 16, '2011-12-10 00:00:00', 1, 31, 27, 0, 0),
(445, 'N', 107, 16, '2011-12-10 00:00:00', 1, 12, 35, 0, 0),
(444, 'N', 107, 16, '2011-12-10 00:00:00', 1, 5, 11, 0, 0),
(443, 'N', 107, 16, '2011-12-10 00:00:00', 1, 17, 28, 0, 0),
(442, 'N', 107, 16, '2011-12-09 00:00:00', 1, 3, 46, 0, 0),
(441, 'N', 107, 15, '2011-12-04 00:00:00', 1, 35, 5, 0, 0),
(440, 'N', 107, 15, '2011-12-04 00:00:00', 1, 18, 17, 0, 0),
(439, 'N', 107, 15, '2011-12-04 00:00:00', 1, 42, 33, 0, 0),
(438, 'N', 107, 15, '2011-12-04 00:00:00', 1, 20, 31, 0, 0),
(437, 'N', 107, 15, '2011-12-03 00:00:00', 1, 4, 12, 0, 0),
(436, 'N', 107, 15, '2011-12-03 00:00:00', 1, 11, 34, 0, 0),
(435, 'N', 107, 15, '2011-12-03 00:00:00', 1, 3, 27, 0, 0),
(434, 'N', 107, 15, '2011-12-03 00:00:00', 1, 16, 28, 0, 0),
(433, 'N', 107, 15, '2011-12-02 00:00:00', 1, 46, 43, 0, 0),
(432, 'N', 107, 14, '2011-11-27 00:00:00', 1, 17, 42, 0, 0),
(431, 'N', 107, 14, '2011-11-27 00:00:00', 1, 28, 4, 0, 0),
(430, 'N', 107, 14, '2011-11-27 00:00:00', 1, 12, 3, 0, 0),
(429, 'N', 107, 14, '2011-11-27 00:00:00', 1, 33, 20, 0, 0),
(428, 'N', 107, 14, '2011-11-26 00:00:00', 1, 31, 16, 0, 0),
(427, 'N', 107, 14, '2011-11-26 00:00:00', 1, 34, 46, 0, 0),
(426, 'N', 107, 14, '2011-11-26 00:00:00', 1, 43, 11, 0, 0),
(425, 'N', 107, 14, '2011-11-26 00:00:00', 1, 27, 35, 0, 0),
(424, 'N', 107, 14, '2011-11-25 00:00:00', 1, 5, 18, 0, 0),
(423, 'N', 107, 13, '2011-11-20 00:00:00', 1, 12, 5, 0, 0),
(422, 'N', 107, 13, '2011-11-20 00:00:00', 1, 16, 43, 0, 0),
(421, 'N', 107, 13, '2011-11-20 00:00:00', 1, 42, 20, 0, 0),
(420, 'N', 107, 13, '2011-11-20 00:00:00', 1, 3, 18, 0, 0),
(419, 'N', 107, 13, '2011-11-19 00:00:00', 1, 4, 27, 0, 0),
(418, 'N', 107, 13, '2011-11-19 00:00:00', 1, 46, 17, 0, 0),
(417, 'N', 107, 13, '2011-11-19 00:00:00', 1, 35, 33, 0, 0),
(416, 'N', 107, 13, '2011-11-19 00:00:00', 1, 28, 34, 0, 0),
(415, 'N', 107, 13, '2011-11-19 00:00:00', 1, 11, 31, 0, 0),
(414, 'N', 107, 12, '2011-11-06 00:00:00', 1, 31, 46, 0, 0),
(413, 'N', 107, 12, '2011-11-06 00:00:00', 1, 20, 28, 0, 0),
(412, 'N', 107, 12, '2011-11-06 00:00:00', 1, 5, 3, 0, 0),
(411, 'N', 107, 12, '2011-11-06 00:00:00', 1, 18, 4, 0, 0),
(410, 'N', 107, 12, '2011-11-05 00:00:00', 1, 17, 11, 0, 0),
(409, 'N', 107, 12, '2011-11-05 00:00:00', 1, 33, 16, 0, 0),
(408, 'N', 107, 12, '2011-11-05 00:00:00', 1, 34, 35, 0, 0),
(407, 'N', 107, 12, '2011-11-05 00:00:00', 1, 27, 42, 0, 0),
(406, 'N', 107, 12, '2011-11-04 00:00:00', 1, 43, 12, 0, 0),
(405, 'N', 107, 11, '2011-10-30 00:00:00', 1, 46, 5, 0, 0),
(404, 'N', 107, 11, '2011-10-30 00:00:00', 1, 28, 18, 0, 0),
(403, 'N', 107, 11, '2011-10-30 00:00:00', 1, 16, 20, 0, 0),
(402, 'N', 107, 11, '2011-10-30 00:00:00', 1, 11, 42, 0, 0),
(401, 'N', 107, 11, '2011-10-29 00:00:00', 1, 35, 3, 0, 0),
(400, 'N', 107, 11, '2011-10-29 00:00:00', 1, 17, 31, 0, 0),
(399, 'N', 107, 11, '2011-10-29 00:00:00', 1, 12, 33, 0, 0),
(398, 'N', 107, 11, '2011-10-29 00:00:00', 1, 34, 4, 0, 0),
(397, 'N', 107, 11, '2011-10-28 00:00:00', 1, 27, 43, 0, 0),
(396, 'N', 107, 10, '2011-10-23 00:00:00', 1, 42, 31, 0, 0),
(395, 'N', 107, 10, '2011-10-23 00:00:00', 1, 16, 17, 0, 0),
(394, 'N', 107, 10, '2011-10-23 00:00:00', 1, 5, 34, 0, 0),
(393, 'N', 107, 10, '2011-10-23 00:00:00', 1, 4, 20, 0, 0),
(392, 'N', 107, 10, '2011-10-22 00:00:00', 1, 18, 35, 0, 0),
(391, 'N', 107, 10, '2011-10-22 00:00:00', 1, 3, 28, 0, 0),
(390, 'N', 107, 10, '2011-10-22 00:00:00', 1, 12, 46, 0, 0),
(389, 'N', 107, 10, '2011-10-22 00:00:00', 1, 43, 33, 0, 0),
(388, 'N', 107, 10, '2011-10-21 00:00:00', 1, 11, 27, 0, 0),
(387, 'N', 107, 9, '2011-10-16 00:00:00', 1, 20, 43, 0, 0),
(386, 'N', 107, 9, '2011-10-16 00:00:00', 1, 34, 3, 0, 0),
(385, 'N', 107, 9, '2011-10-16 00:00:00', 1, 35, 11, 0, 0),
(384, 'N', 107, 9, '2011-10-16 00:00:00', 1, 28, 42, 0, 0),
(383, 'N', 107, 9, '2011-10-15 00:00:00', 1, 31, 18, 0, 0),
(382, 'N', 107, 9, '2011-10-15 00:00:00', 1, 33, 17, 0, 0),
(381, 'N', 107, 9, '2011-10-15 00:00:00', 1, 27, 12, 0, 0),
(380, 'N', 107, 9, '2011-10-15 00:00:00', 1, 46, 16, 0, 0),
(379, 'N', 107, 9, '2011-10-15 00:00:00', 1, 4, 5, 0, 0),
(378, 'N', 107, 8, '2011-10-02 00:00:00', 1, 28, 31, 0, 0),
(377, 'N', 107, 8, '2011-10-02 00:00:00', 1, 20, 3, 0, 0),
(376, 'N', 107, 8, '2011-10-02 00:00:00', 1, 43, 5, 0, 0),
(375, 'N', 107, 8, '2011-10-02 00:00:00', 1, 16, 4, 0, 0),
(374, 'N', 107, 8, '2011-10-01 00:00:00', 1, 34, 27, 0, 0),
(373, 'N', 107, 8, '2011-10-01 00:00:00', 1, 42, 35, 0, 0),
(372, 'N', 107, 8, '2011-10-01 00:00:00', 1, 17, 12, 0, 0),
(371, 'N', 107, 8, '2011-10-01 00:00:00', 1, 18, 33, 0, 0),
(370, 'N', 107, 8, '2011-09-30 00:00:00', 1, 46, 11, 0, 0),
(369, 'N', 107, 7, '2011-09-25 00:00:00', 1, 11, 16, 0, 0),
(368, 'N', 107, 7, '2011-09-25 00:00:00', 1, 12, 42, 0, 0),
(367, 'N', 107, 7, '2011-09-25 00:00:00', 1, 33, 28, 0, 0),
(366, 'N', 107, 7, '2011-09-25 00:00:00', 1, 5, 20, 0, 0),
(365, 'N', 107, 7, '2011-09-24 00:00:00', 1, 4, 17, 0, 0),
(364, 'N', 107, 7, '2011-09-24 00:00:00', 1, 27, 18, 0, 0),
(363, 'N', 107, 7, '2011-09-24 00:00:00', 1, 35, 46, 0, 0),
(362, 'N', 107, 7, '2011-09-24 00:00:00', 1, 3, 43, 0, 0),
(361, 'N', 107, 7, '2011-09-24 00:00:00', 1, 31, 34, 0, 0),
(360, 'N', 107, 6, '2011-09-18 00:00:00', 1, 18, 46, 0, 0),
(359, 'N', 107, 6, '2011-09-18 00:00:00', 1, 17, 3, 0, 0),
(358, 'N', 107, 6, '2011-09-18 00:00:00', 1, 33, 5, 0, 0),
(357, 'N', 107, 6, '2011-09-18 00:00:00', 1, 31, 4, 0, 0),
(356, 'N', 107, 6, '2011-09-17 00:00:00', 1, 20, 11, 0, 0),
(355, 'N', 107, 6, '2011-09-17 00:00:00', 1, 42, 34, 0, 0),
(354, 'N', 107, 6, '2011-09-17 00:00:00', 1, 43, 35, 0, 0),
(353, 'N', 107, 6, '2011-09-17 00:00:00', 1, 16, 12, 0, 0),
(352, 'N', 107, 6, '2011-09-16 00:00:00', 1, 28, 27, 0, 0),
(351, 'N', 107, 5, '2011-09-11 00:00:00', 1, 12, 18, 0, 0),
(350, 'N', 107, 5, '2011-09-11 00:00:00', 1, 43, 31, 0, 0),
(349, 'N', 107, 5, '2011-09-11 00:00:00', 1, 27, 20, 0, 0),
(348, 'N', 107, 5, '2011-09-11 00:00:00', 1, 35, 16, 0, 0),
(347, 'N', 107, 5, '2011-09-10 00:00:00', 1, 46, 4, 0, 0),
(346, 'N', 107, 5, '2011-09-10 00:00:00', 1, 5, 42, 0, 0),
(345, 'N', 107, 5, '2011-09-10 00:00:00', 1, 3, 33, 0, 0),
(344, 'N', 107, 5, '2011-09-10 00:00:00', 1, 11, 28, 0, 0),
(343, 'N', 107, 5, '2011-09-10 00:00:00', 1, 34, 17, 0, 0),
(342, 'N', 107, 4, '2011-08-28 00:00:00', 1, 31, 12, 0, 0),
(341, 'N', 107, 4, '2011-08-28 00:00:00', 1, 11, 3, 0, 0),
(340, 'N', 107, 4, '2011-08-28 00:00:00', 1, 16, 5, 0, 0),
(339, 'N', 107, 4, '2011-08-28 00:00:00', 1, 20, 35, 0, 0),
(338, 'N', 107, 4, '2011-08-27 00:00:00', 1, 18, 34, 0, 0),
(337, 'N', 107, 4, '2011-08-27 00:00:00', 1, 28, 46, 0, 0),
(336, 'N', 107, 4, '2011-08-27 00:00:00', 1, 17, 43, 0, 0),
(335, 'N', 107, 4, '2011-08-27 00:00:00', 1, 33, 27, 0, 0),
(334, 'N', 107, 4, '2011-08-26 00:00:00', 1, 4, 42, 0, 0),
(333, 'N', 107, 3, '2011-08-21 00:00:00', 1, 3, 31, 0, 0),
(332, 'N', 107, 3, '2011-08-21 00:00:00', 1, 43, 4, 0, 0),
(331, 'N', 107, 3, '2011-08-21 00:00:00', 1, 5, 28, 0, 0),
(330, 'N', 107, 3, '2011-08-21 00:00:00', 1, 46, 20, 0, 0),
(329, 'N', 107, 3, '2011-08-20 00:00:00', 1, 27, 16, 0, 0),
(328, 'N', 107, 3, '2011-08-20 00:00:00', 1, 12, 11, 0, 0),
(327, 'N', 107, 3, '2011-08-20 00:00:00', 1, 35, 17, 0, 0),
(326, 'N', 107, 3, '2011-08-20 00:00:00', 1, 42, 18, 0, 0),
(325, 'N', 107, 3, '2011-08-19 00:00:00', 1, 34, 33, 0, 0),
(324, 'N', 107, 2, '2011-08-17 00:00:00', 1, 28, 12, 0, 0),
(323, 'N', 107, 2, '2011-08-14 00:00:00', 1, 16, 3, 0, 0),
(322, 'N', 107, 2, '2011-08-14 00:00:00', 1, 4, 35, 0, 0),
(321, 'N', 107, 2, '2011-08-14 00:00:00', 1, 46, 27, 0, 0),
(320, 'N', 107, 2, '2011-08-14 00:00:00', 1, 18, 11, 0, 0),
(319, 'N', 107, 2, '2011-08-13 00:00:00', 1, 20, 34, 0, 0),
(318, 'N', 107, 2, '2011-08-13 00:00:00', 1, 31, 33, 0, 0),
(317, 'N', 107, 2, '2011-08-13 00:00:00', 1, 42, 43, 0, 0),
(316, 'N', 107, 2, '2011-08-13 00:00:00', 1, 17, 5, 0, 0),
(315, 'N', 107, 1, '2011-08-07 00:00:00', 1, 3, 42, 0, 0),
(314, 'N', 107, 1, '2011-08-07 00:00:00', 1, 27, 17, 0, 0),
(313, 'N', 107, 1, '2011-08-07 00:00:00', 1, 5, 31, 0, 0),
(312, 'N', 107, 1, '2011-08-07 00:00:00', 1, 11, 4, 0, 0),
(311, 'N', 107, 1, '2011-08-06 00:00:00', 1, 34, 16, 0, 0),
(310, 'N', 107, 1, '2011-08-06 00:00:00', 1, 33, 46, 0, 0),
(309, 'N', 107, 1, '2011-08-06 00:00:00', 1, 35, 28, 0, 0),
(308, 'N', 107, 1, '2011-08-06 00:00:00', 1, 43, 18, 0, 0),
(307, 'N', 107, 1, '2011-08-05 00:00:00', 1, 12, 20, 0, 0),
(612, 'N', 107, 34, '2012-05-06 00:00:00', 1, 46, 28, 0, 0),
(611, 'N', 107, 34, '2012-05-06 00:00:00', 1, 5, 16, 0, 0),
(610, 'N', 107, 34, '2012-05-06 00:00:00', 1, 43, 17, 0, 0),
(609, 'N', 107, 34, '2012-05-06 00:00:00', 1, 34, 18, 0, 0),
(608, 'N', 107, 34, '2012-05-06 00:00:00', 1, 35, 20, 0, 0),
(607, 'N', 107, 34, '2012-05-06 00:00:00', 1, 12, 31, 0, 0),
(606, 'N', 107, 34, '2012-05-06 00:00:00', 1, 42, 4, 0, 0),
(605, 'N', 107, 34, '2012-05-06 00:00:00', 1, 27, 33, 0, 0),
(604, 'N', 107, 34, '2012-05-06 00:00:00', 1, 3, 11, 0, 0),
(603, 'N', 107, 33, '2012-05-02 00:00:00', 1, 17, 35, 0, 0),
(602, 'N', 107, 33, '2012-05-02 00:00:00', 1, 31, 3, 0, 0),
(601, 'N', 107, 33, '2012-05-02 00:00:00', 1, 20, 46, 0, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Edited March 16, 2013 by ignace
Added code tags

Psycho · March 16, 2013

@barand is this usefull for you?

this is the data for two seasons

So, you have data and you have the code Barand supplied, yet you want HIM to put it together and provide a screen capture of the results? Why don't you ask him to come over and rub your feet while he's at it.

Barand · March 16, 2013

I'm guessing because the table and column names provided do not match those in the original posts.

And there would definitely be a charge + expenses for the foot rub.

It would currently look like this

        Team1  Team 2  Team 3  Team 4  Team 5  
Team 1    X     2-1     3-2     1-2    Apr03  
Team 2   2-2     X     Apr10    4-0     1-1  
Team 3  May01   1-0      X      0-0     2-1  
Team 4   2-2    1-2     3-2      X      4-2  
Team 5   2-1    1-1     0-1     2-2      X

Edited March 16, 2013 by Barand

Psycho · March 16, 2013

I'm guessing because the table and column names provided do not match those in the original posts.

Yeah, I noticed that. But still, this is a "help" forum, not a "do it for me" forum.

markla · March 17, 2013

@Barand thanks for the great help, I realy appreicitate it. Luckely there are still people that want to HELP others instead of reactinga Psychotic way. :happy-04:

.

p.s.

I'm gonna try to understand the script and modify it to my need.

Edited March 17, 2013 by markla

Psycho · March 17, 2013

@Barand thanks for the great help, I realy appreicitate it. Luckely there are still people that want to HELP others instead of reactinga Psychotic way.

Yeah, I'm a terrible person that doesn't want to help people. Of course, that would be overlooking the fact that I did post a solution in this thread earlier and, of course, that would be overlooking the 9,000+ posts I have made in this forum over the years.

Whereas, you were given a solution but were too lazy to implement it or try it yourself to see what it would look like.

markla · March 18, 2013

@Barand YES!!! i've got it working.

Because i'm not a scripting Guru but only an newbie, it took me sometime to understand the working off the script.

I made some little adjustments to it, to make it work with my tables structure, But this was what I was looking for.

You made me one (and a half) happy Guy :happy-04:

many thanks and appreciating to you @Barand ! :thumb-up:

Barand · March 18, 2013

Well done!

Barand · March 18, 2013

I've only just noticed that this thread got hijacked. I hope, Steve, that I managed to kill two birds with one stone.

Psycho · March 18, 2013

I've only just noticed that this thread got hijacked. I hope, Steve, that I managed to kill two birds with one stone.

Steve started this thread in 2011 and it went unanswered (which I thought was surprising). Markla posted here just recently as he/she was looking for a similar solution. Steve has posted in these forums as late as a couple months ago. But, I would guess he's still not looking for a solution to this. Well, if he is, he is certainly persistent.

Barand · March 18, 2013

But, I would guess he's still not looking for a solution to this. Well, if he is, he is certainly persistent.

If he did find a solution it would have been nice if he had posted it here.

MargateSteve · October 17, 2022

On 3/18/2013 at 11:56 PM, Barand said:

If he did find a solution it would have been nice if he had posted it here.

Not sure why but I thought PhpFeaks had shut down! I stumbled across this looking for something else for the same site I am still trying to create!

Simply put, every time I get it close to being what I would consider finished, my eyes get attracted to a better way of doing it (MVC instead of a simple php site, discovering bootstrap, learning SASS, moving everything to AJAX then moving 99% of it back to controller queries and so on) plus a change of job that reduced time to play around with this, grandkids etc.

On 3/18/2013 at 10:21 PM, Psycho said:

Steve started this thread in 2011 and it went unanswered (which I thought was surprising). Markla posted here just recently as he/she was looking for a similar solution. Steve has posted in these forums as late as a couple months ago. But, I would guess he's still not looking for a solution to this. Well, if he is, he is certainly persistent.

I never did as far as I recall. I seem to recall creating the grid as a php array from the db results was looking the best option. As mentioned above, I am still looking into this so will be stumbling across this again soon.

Sign In

Soccer Results Matrix

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information