Jump to content

Archived

This topic is now archived and is closed to further replies.

MargateSteve

Soccer Results Matrix

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

 
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.

Share this post


Link to post
Share on other sites

@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.

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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>

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

@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 */;

Share this post


Link to post
Share on other sites

@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.

Share this post


Link to post
Share on other sites

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  

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

@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.

Share this post


Link to post
Share on other sites

@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:

 

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.

Share this post


Link to post
Share on other sites

@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:

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.