Skip to content

Instantly share code, notes, and snippets.

@EstebanFuentealba

EstebanFuentealba/bd_futbol.sql

Last active September 5, 2017 14:57
Show Gist options
  • Save EstebanFuentealba/5148353 to your computer and use it in GitHub Desktop.
Save EstebanFuentealba/5148353 to your computer and use it in GitHub Desktop.
Download ZIP
Consulta SQL tabla posiciones de ANFP
Raw
bd_futbol.sql
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 13-03-2013 a las 01:22:41
-- Versión del servidor: 5.5.24-log
-- Versión de PHP: 5.3.13
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 */;
--
-- Base de datos: `bbcl_futbol`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_arbitro`
--
CREATE TABLE IF NOT EXISTS `m_arbitro` (
`arbitro_id` int(11) NOT NULL AUTO_INCREMENT,
`arbitro_nombre` varchar(200) DEFAULT NULL,
PRIMARY KEY (`arbitro_id`),
UNIQUE KEY `ak_key_2` (`arbitro_nombre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
--
-- Volcado de datos para la tabla `m_arbitro`
--
INSERT INTO `m_arbitro` (`arbitro_id`, `arbitro_nombre`) VALUES
(10, 'Angelo Hermosilla'),
(4, 'Carlos Ulloa'),
(11, 'Cesar Deischler'),
(9, 'Christian Rojas'),
(26, 'Claudio Aranda'),
(1, 'Claudio Puga'),
(5, 'Cristián Andaur'),
(14, 'Cristián Droguett'),
(19, 'David Figueroa'),
(2, 'Eduardo Gamboa'),
(7, 'Enrique Osses'),
(17, 'Felipe González'),
(18, 'Francisco Gilabert'),
(12, 'Franco Arrué'),
(15, 'Héctor Arcos'),
(22, 'Héctor Jona'),
(25, 'Jorge Osorio'),
(21, 'José Cabero'),
(3, 'José Campusano'),
(23, 'Julio Bascuñán'),
(8, 'Manuel Acosta'),
(20, 'Marcelo Ponce'),
(24, 'Patricio Blanca'),
(27, 'Patricio Polic'),
(13, 'Piero Maza'),
(6, 'Rafael Troncoso');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_campeonato`
--
CREATE TABLE IF NOT EXISTS `m_campeonato` (
`campeonato_id` int(11) NOT NULL AUTO_INCREMENT,
`fase_anterior_campeonato_id` int(11) DEFAULT NULL,
`campeonato_nombre` varchar(100) DEFAULT NULL,
`campeonato_periodo` varchar(10) DEFAULT NULL,
`campeonato_activo` enum('s','n') DEFAULT NULL,
PRIMARY KEY (`campeonato_id`),
KEY `fk_reference_18` (`fase_anterior_campeonato_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Volcado de datos para la tabla `m_campeonato`
--
INSERT INTO `m_campeonato` (`campeonato_id`, `fase_anterior_campeonato_id`, `campeonato_nombre`, `campeonato_periodo`, `campeonato_activo`) VALUES
(1, NULL, 'Campeonato Petrobras Apertura 2013', '1', 's'),
(2, NULL, 'Campeonato Primera B Apertura 2013', '1', 's'),
(3, NULL, 'Ninguno (Amistoso)', '', 's');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_campeonato_equipo`
--
CREATE TABLE IF NOT EXISTS `m_campeonato_equipo` (
`campeonato_id` int(11) DEFAULT NULL,
`campeonato_equipo_id` int(11) NOT NULL AUTO_INCREMENT,
`equipo_id` int(11) DEFAULT NULL,
`n_partidos_jugados` int(11) DEFAULT '0',
`n_partidos_ganados` int(11) DEFAULT '0',
`n_partidos_empatados` int(11) DEFAULT '0',
`n_diferencia_goles` int(11) DEFAULT '0',
`n_puntos` int(11) DEFAULT '0',
`grupo` enum('grupo_a','grupo_b','grupo_c','grupo_d','grupo_e','grupo_f','grupo_g','grupo_h','grupo_i','grupo_j','grupo_k') DEFAULT NULL,
PRIMARY KEY (`campeonato_equipo_id`),
KEY `fk_reference_10` (`campeonato_id`),
KEY `fk_reference_9` (`equipo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
--
-- Volcado de datos para la tabla `m_campeonato_equipo`
--
INSERT INTO `m_campeonato_equipo` (`campeonato_id`, `campeonato_equipo_id`, `equipo_id`, `n_partidos_jugados`, `n_partidos_ganados`, `n_partidos_empatados`, `n_diferencia_goles`, `n_puntos`, `grupo`) VALUES
(1, 1, 132, 6, 3, 0, 5, 10, NULL),
(1, 2, 220, 6, 0, 0, -3, 3, NULL),
(1, 3, 221, 6, 3, 0, 8, 12, NULL),
(1, 4, 232, 6, 2, 0, -1, 7, NULL),
(1, 5, 241, 6, 3, 0, 0, 10, NULL),
(1, 6, 307, 6, 4, 0, 8, 13, NULL),
(1, 7, 316, 6, 1, 0, -4, 6, NULL),
(1, 8, 577, 6, 1, 0, -5, 5, NULL),
(1, 9, 583, 6, 4, 0, 8, 13, NULL),
(1, 10, 658, 6, 1, 0, -6, 5, NULL),
(1, 11, 659, 6, 4, 0, 6, 13, NULL),
(1, 12, 747, 6, 0, 0, -7, 1, NULL),
(1, 13, 750, 6, 3, 0, 5, 12, NULL),
(1, 14, 794, 6, 1, 0, -6, 4, NULL),
(1, 15, 813, 6, 1, 0, -2, 5, NULL),
(1, 16, 820, 6, 2, 0, 3, 9, NULL),
(1, 17, 991, 6, 1, 0, -7, 6, NULL),
(1, 18, 1008, 6, 4, 0, -1, 12, NULL),
(2, 19, 228, 0, 0, 0, 0, 0, NULL),
(2, 20, 285, 0, 0, 0, 0, 0, NULL),
(2, 21, 612, 0, 0, 0, 0, 0, NULL),
(2, 22, 657, 0, 0, 0, 0, 0, NULL),
(2, 23, 667, 0, 0, 0, 0, 0, NULL),
(2, 24, 686, 0, 0, 0, 0, 0, NULL),
(2, 25, 795, 0, 0, 0, 0, 0, NULL),
(2, 26, 908, 0, 0, 0, 0, 0, NULL),
(2, 27, 1358, 0, 0, 0, 0, 0, NULL),
(2, 28, 2249, 0, 0, 0, 0, 0, NULL),
(2, 29, 2465, 0, 0, 0, 0, 0, NULL),
(2, 30, 2466, 0, 0, 0, 0, 0, NULL),
(2, 31, 2469, 0, 0, 0, 0, 0, NULL),
(2, 32, 5812, 0, 0, 0, 0, 0, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_country`
--
CREATE TABLE IF NOT EXISTS `m_country` (
`country_id` int(11) NOT NULL AUTO_INCREMENT,
`country_name` varchar(50) DEFAULT NULL,
`country_alpha_2` varchar(2) DEFAULT NULL,
`country_alpha_3` varchar(3) DEFAULT NULL,
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=250 ;
--
-- Volcado de datos para la tabla `m_country`
--
INSERT INTO `m_country` (`country_id`, `country_name`, `country_alpha_2`, `country_alpha_3`) VALUES
(1, 'Afganistán', 'af', 'afg'),
(2, 'Islas de Aland', 'ax', 'ala'),
(3, 'Albania', 'al', 'alb'),
(4, 'Algeria', 'dz', 'dza'),
(5, 'Samoa Americana', 'as', 'asm'),
(6, 'Andorra', 'ad', 'and'),
(7, 'Angola', 'ao', 'ago'),
(8, 'Anguilla', 'ai', 'aia'),
(9, 'Antarctica', 'aq', ''),
(10, 'Antigua y Barbuda', 'ag', 'atg'),
(11, 'Argentina', 'ar', 'arg'),
(12, 'Armenia', 'am', 'arm'),
(13, 'Aruba', 'aw', 'abw'),
(14, 'Australia', 'au', 'aus'),
(15, 'Austria', 'at', 'aut'),
(16, 'Azerbaijan', 'az', 'aze'),
(17, 'Bahamas', 'bs', 'bhs'),
(18, 'Bahrain', 'bh', 'bhr'),
(19, 'Bangladesh', 'bd', 'bgd'),
(20, 'Barbados', 'bb', 'brb'),
(21, 'Belarus', 'by', 'blr'),
(22, 'Belgium', 'be', 'bel'),
(23, 'Belize', 'bz', 'blz'),
(24, 'Benin', 'bj', 'ben'),
(25, 'Bermuda', 'bm', 'bmu'),
(26, 'Bhutan', 'bt', 'btn'),
(27, 'Bolivia', 'bo', 'bol'),
(28, 'Bonaire, Sint Eustatius and Saba', 'bq', 'bes'),
(29, 'Bosnia and Herzegovina', 'ba', 'bih'),
(30, 'Botswana', 'bw', 'bwa'),
(31, 'Bouvet Island', 'bv', ''),
(32, 'Brasil', 'br', 'bra'),
(33, 'British Indian Ocean Territory', 'io', ''),
(34, 'Brunei Darussalam', 'bn', 'brn'),
(35, 'Bulgaria', 'bg', 'bgr'),
(36, 'Burkina Faso', 'bf', 'bfa'),
(37, 'Burundi', 'bi', 'bdi'),
(38, 'Cambodia', 'kh', 'khm'),
(39, 'Cameroon', 'cm', 'cmr'),
(40, 'Canada', 'ca', 'can'),
(41, 'Cape Verde', 'cv', 'cpv'),
(42, 'Cayman Islands', 'ky', 'cym'),
(43, 'Central African Republic', 'cf', 'caf'),
(44, 'Chad', 'td', 'tcd'),
(45, 'Chile', 'cl', 'chl'),
(46, 'China', 'cn', 'chn'),
(47, 'Christmas Island', 'cx', ''),
(48, 'Cocos (Keeling) Islands', 'cc', ''),
(49, 'Colombia', 'co', 'col'),
(50, 'Comoros', 'km', 'com'),
(51, 'Congo', 'cg', 'cog'),
(52, 'Congo, The Democratic Republic of the', 'cd', 'cod'),
(53, 'Cook Islands', 'ck', 'cok'),
(54, 'Costa Rica', 'cr', 'cri'),
(55, 'Cote d''Ivoire', 'ci', 'civ'),
(56, 'Croatia', 'hr', 'hrv'),
(57, 'Cuba', 'cu', 'cub'),
(58, 'Curacao', 'cw', 'cuw'),
(59, 'Cyprus', 'cy', 'cyp'),
(60, 'Czech Republic', 'cz', 'cze'),
(61, 'Denmark', 'dk', 'dnk'),
(62, 'Djibouti', 'dj', 'dji'),
(63, 'Dominica', 'dm', 'dma'),
(64, 'Dominican Republic', 'do', 'dom'),
(65, 'Ecuador', 'ec', 'ecu'),
(66, 'Egypt', 'eg', 'egy'),
(67, 'El Salvador', 'sv', 'slv'),
(68, 'Equatorial Guinea', 'gq', 'gnq'),
(69, 'Eritrea', 'er', 'eri'),
(70, 'Estonia', 'ee', 'est'),
(71, 'Ethiopia', 'et', 'eth'),
(72, 'Falkland Islands (Malvinas)', 'fk', 'flk'),
(73, 'Faroe Islands', 'fo', 'fro'),
(74, 'Fiji', 'fj', 'fji'),
(75, 'Finland', 'fi', 'fin'),
(76, 'France', 'fr', 'fra'),
(77, 'French Guiana', 'gf', 'guf'),
(78, 'French Polynesia', 'pf', 'pyf'),
(79, 'French Southern Territories', 'tf', ''),
(80, 'Gabon', 'ga', 'gab'),
(81, 'Gambia', 'gm', 'gmb'),
(82, 'Georgia', 'ge', 'geo'),
(83, 'Germany', 'de', 'deu'),
(84, 'Ghana', 'gh', 'gha'),
(85, 'Gibraltar', 'gi', 'gib'),
(86, 'Greece', 'gr', 'grc'),
(87, 'Greenland', 'gl', 'grl'),
(88, 'Grenada', 'gd', 'grd'),
(89, 'Guadeloupe', 'gp', 'glp'),
(90, 'Guam', 'gu', 'gum'),
(91, 'Guatemala', 'gt', 'gtm'),
(92, 'Guernsey', 'gg', 'ggy'),
(93, 'Guinea', 'gn', 'gin'),
(94, 'Guinea-Bissau', 'gw', 'gnb'),
(95, 'Guyana', 'gy', 'guy'),
(96, 'Haiti', 'ht', 'hti'),
(97, 'Heard Island and McDonald Islands', 'hm', ''),
(98, 'Holy See (Vatican City State)', 'va', 'vat'),
(99, 'Honduras', 'hn', 'hnd'),
(100, 'Hong Kong', 'hk', 'hkg'),
(101, 'Hungary', 'hu', 'hun'),
(102, 'Iceland', 'is', 'isl'),
(103, 'India', 'in', 'ind'),
(104, 'Indonesia', 'id', 'idn'),
(105, 'Iran, Islamic Republic of', 'ir', 'irn'),
(106, 'Iraq', 'iq', 'irq'),
(107, 'Ireland', 'ie', 'irl'),
(108, 'Isle of Man', 'im', 'imn'),
(109, 'Israel', 'il', 'isr'),
(110, 'Italy', 'it', 'ita'),
(111, 'Jamaica', 'jm', 'jam'),
(112, 'Japan', 'jp', 'jpn'),
(113, 'Jersey', 'je', 'jey'),
(114, 'Jordan', 'jo', 'jor'),
(115, 'Kazakhstan', 'kz', 'kaz'),
(116, 'Kenya', 'ke', 'ken'),
(117, 'Kiribati', 'ki', 'kir'),
(118, 'Korea, Democratic People''s Republic of', 'kp', 'prk'),
(119, 'Korea, Republic of', 'kr', 'kor'),
(120, 'Kuwait', 'kw', 'kwt'),
(121, 'Kyrgyzstan', 'kg', 'kgz'),
(122, 'Lao People''s Democratic Republic', 'la', 'lao'),
(123, 'Latvia', 'lv', 'lva'),
(124, 'Lebanon', 'lb', 'lbn'),
(125, 'Lesotho', 'ls', 'lso'),
(126, 'Liberia', 'lr', 'lbr'),
(127, 'Libyan Arab Jamahiriya', 'ly', 'lby'),
(128, 'Liechtenstein', 'li', 'lie'),
(129, 'Lithuania', 'lt', 'ltu'),
(130, 'Luxembourg', 'lu', 'lux'),
(131, 'Macao', 'mo', 'mac'),
(132, 'Macedonia, The former Yugoslav Republic of', 'mk', 'mkd'),
(133, 'Madagascar', 'mg', 'mdg'),
(134, 'Malawi', 'mw', 'mwi'),
(135, 'Malaysia', 'my', 'mys'),
(136, 'Maldives', 'mv', 'mdv'),
(137, 'Mali', 'ml', 'mli'),
(138, 'Malta', 'mt', 'mlt'),
(139, 'Marshall Islands', 'mh', 'mhl'),
(140, 'Martinique', 'mq', 'mtq'),
(141, 'Mauritania', 'mr', 'mrt'),
(142, 'Mauritius', 'mu', 'mus'),
(143, 'Mayotte', 'yt', 'myt'),
(144, 'Mexico', 'mx', 'mex'),
(145, 'Micronesia, Federated States of', 'fm', 'fsm'),
(146, 'Moldova, Republic of', 'md', 'mda'),
(147, 'Monaco', 'mc', 'mco'),
(148, 'Mongolia', 'mn', 'mng'),
(149, 'Montenegro', 'me', 'mne'),
(150, 'Montserrat', 'ms', 'msr'),
(151, 'Morocco', 'ma', 'mar'),
(152, 'Mozambique', 'mz', 'moz'),
(153, 'Myanmar', 'mm', 'mmr'),
(154, 'Namibia', 'na', 'nam'),
(155, 'Nauru', 'nr', 'nru'),
(156, 'Nepal', 'np', 'npl'),
(157, 'Netherlands', 'nl', 'nld'),
(158, 'New Caledonia', 'nc', 'ncl'),
(159, 'New Zealand', 'nz', 'nzl'),
(160, 'Nicaragua', 'ni', 'nic'),
(161, 'Niger', 'ne', 'ner'),
(162, 'Nigeria', 'ng', 'nga'),
(163, 'Niue', 'nu', 'niu'),
(164, 'Norfolk Island', 'nf', 'nfk'),
(165, 'Northern Mariana Islands', 'mp', 'mnp'),
(166, 'Norway', 'no', 'nor'),
(167, 'Oman', 'om', 'omn'),
(168, 'Pakistan', 'pk', 'pak'),
(169, 'Palau', 'pw', 'plw'),
(170, 'Palestinian Territory, Occupied', 'ps', 'pse'),
(171, 'Panama', 'pa', 'pan'),
(172, 'Papua New Guinea', 'pg', 'png'),
(173, 'Paraguay', 'py', 'pry'),
(174, 'Peru', 'pe', 'per'),
(175, 'Philippines', 'ph', 'phl'),
(176, 'Pitcairn', 'pn', 'pcn'),
(177, 'Poland', 'pl', 'pol'),
(178, 'Portugal', 'pt', 'prt'),
(179, 'Puerto Rico', 'pr', 'pri'),
(180, 'Qatar', 'qa', 'qat'),
(181, 'Reunion', 're', 'reu'),
(182, 'Romania', 'ro', 'rou'),
(183, 'Russian Federation', 'ru', 'rus'),
(184, 'Rwanda', 'rw', 'rwa'),
(185, 'Saint Barthelemy', 'bl', 'blm'),
(186, 'Saint Helena, Ascension and Tristan Da Cunha', 'sh', 'shn'),
(187, 'Saint Kitts and Nevis', 'kn', 'kna'),
(188, 'Saint Lucia', 'lc', 'lca'),
(189, 'Saint Martin (French Part)', 'mf', 'maf'),
(190, 'Saint Pierre and Miquelon', 'pm', 'spm'),
(191, 'Saint Vincent and The Grenadines', 'vc', 'vct'),
(192, 'Samoa', 'ws', 'wsm'),
(193, 'San Marino', 'sm', 'smr'),
(194, 'Sao Tome and Principe', 'st', 'stp'),
(195, 'Saudi Arabia', 'sa', 'sau'),
(196, 'Senegal', 'sn', 'sen'),
(197, 'Serbia', 'rs', 'srb'),
(198, 'Seychelles', 'sc', 'syc'),
(199, 'Sierra Leone', 'sl', 'sle'),
(200, 'Singapore', 'sg', 'sgp'),
(201, 'Sint Maarten (Dutch Part)', 'sx', 'sxm'),
(202, 'Slovakia', 'sk', 'svk'),
(203, 'Slovenia', 'si', 'svn'),
(204, 'Solomon Islands', 'sb', 'slb'),
(205, 'Somalia', 'so', 'som'),
(206, 'South Africa', 'za', 'zaf'),
(207, 'South Georgia and The South Sandwich Islands', 'gs', ''),
(208, 'South Sudan', 'ss', 'ssd'),
(209, 'Spain', 'es', 'esp'),
(210, 'Sri Lanka', 'lk', 'lka'),
(211, 'Sudan', 'sd', 'sdn'),
(212, 'Suriname', 'sr', 'sur'),
(213, 'Svalbard and Jan Mayen', 'sj', 'sjm'),
(214, 'Swaziland', 'sz', 'swz'),
(215, 'Sweden', 'se', 'swe'),
(216, 'Switzerland', 'ch', 'che'),
(217, 'Syrian Arab Republic', 'sy', 'syr'),
(218, 'Taiwan, Province of China', 'tw', ''),
(219, 'Tajikistan', 'tj', 'tjk'),
(220, 'Tanzania, United Republic of', 'tz', 'tza'),
(221, 'Thailand', 'th', 'tha'),
(222, 'Timor-Leste', 'tl', 'tls'),
(223, 'Togo', 'tg', 'tgo'),
(224, 'Tokelau', 'tk', 'tkl'),
(225, 'Tonga', 'to', 'ton'),
(226, 'Trinidad and Tobago', 'tt', 'tto'),
(227, 'Tunisia', 'tn', 'tun'),
(228, 'Turkey', 'tr', 'tur'),
(229, 'Turkmenistan', 'tm', 'tkm'),
(230, 'Turks and Caicos Islands', 'tc', 'tca'),
(231, 'Tuvalu', 'tv', 'tuv'),
(232, 'Uganda', 'ug', 'uga'),
(233, 'Ukrania', 'ua', 'ukr'),
(234, 'United Arab Emirates', 'ae', 'are'),
(235, 'United Kingdom', 'gb', 'gbr'),
(236, 'Estados Unidos', 'us', 'usa'),
(237, 'United States Minor Outlying Islands', 'um', ''),
(238, 'Uruguay', 'uy', 'ury'),
(239, 'Uzbekistan', 'uz', 'uzb'),
(240, 'Vanuatu', 'vu', 'vut'),
(241, 'Venezuela, Bolivarian Republic of', 've', 'ven'),
(242, 'Viet Nam', 'vn', 'vnm'),
(243, 'Virgin Islands, British', 'vg', 'vgb'),
(244, 'Virgin Islands, U.S.', 'vi', 'vir'),
(245, 'Wallis and Futuna', 'wf', 'wlf'),
(246, 'Western Sahara', 'eh', 'esh'),
(247, 'Yemen', 'ye', 'yem'),
(248, 'Zambia', 'zm', 'zmb'),
(249, 'Zimbabwe', 'zw', 'zwe');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_equipo`
--
CREATE TABLE IF NOT EXISTS `m_equipo` (
`equipo_id` int(11) NOT NULL AUTO_INCREMENT,
`estadio_id` int(11) DEFAULT NULL,
`country_id` int(11) DEFAULT NULL,
`equipo_nombre` varchar(200) DEFAULT NULL,
`equipo_escudo_path` varchar(255) DEFAULT NULL,
`equipo_type` enum('seleccion','club') DEFAULT NULL,
`equipo_ciudad` varchar(100) DEFAULT NULL,
`equipo_image_path` varchar(255) DEFAULT NULL,
`equipo_status` enum('s','n') DEFAULT NULL,
PRIMARY KEY (`equipo_id`),
UNIQUE KEY `ak_key_2` (`equipo_nombre`),
KEY `fk_reference_15` (`country_id`),
KEY `fk_reference_3` (`estadio_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5813 ;
--
-- Volcado de datos para la tabla `m_equipo`
--
INSERT INTO `m_equipo` (`equipo_id`, `estadio_id`, `country_id`, `equipo_nombre`, `equipo_escudo_path`, `equipo_type`, `equipo_ciudad`, `equipo_image_path`, `equipo_status`) VALUES
(132, NULL, 45, 'u de chile', '/uploads/escudos/universidad_chile_p.gif', 'club', NULL, NULL, 's'),
(220, NULL, 45, 'palestino', '/uploads/escudos/palestino_p.gif', 'club', NULL, NULL, 's'),
(221, 18, 45, 'cobreloa', '/uploads/escudos/cobreloa_p.gif', 'club', NULL, NULL, 's'),
(228, NULL, 45, 'deportes concepcion', '/uploads/escudos/concepcion_p.gif', 'club', NULL, NULL, 's'),
(232, 8, 45, 's wanderers', '/uploads/escudos/614092c662d4fd9748196f1d0a2f1906.gif', 'club', NULL, NULL, 's'),
(241, 4, 45, 'colo colo', '/uploads/escudos/1d9c487d4d78f012e34704b1cf81137d.gif', 'club', NULL, '/uploads/equipo/escudo/32d0ebac6fb682fb0535b9fde61ece1b.jpg', 's'),
(285, NULL, 45, 'coquimbo unido', '/uploads/escudos/coquimbo_p.gif', 'club', NULL, NULL, 's'),
(307, NULL, 45, 'universidad catolica', '/uploads/escudos/catolica_p.gif', 'club', NULL, NULL, 's'),
(316, NULL, 45, 'rangers', '/uploads/escudos/rangers_talca_p.gif', 'club', NULL, NULL, 's'),
(577, 15, 45, 'huachipato', '/uploads/escudos/huachipato_p.gif', 'club', NULL, NULL, 's'),
(583, 5, 45, 'unión española', '/uploads/escudos/bfb728ffca7e12dd276c3921a33faf89.gif', 'club', NULL, NULL, 's'),
(612, NULL, 45, 'magallanes', '/uploads/escudos/Magallanes_p.gif', 'club', NULL, NULL, 's'),
(657, NULL, 45, 'santiago morning', '/uploads/escudos/santiago_morning_p.gif', 'club', NULL, NULL, 's'),
(658, NULL, 45, 'audax italiano', '/uploads/escudos/audax_p.gif', 'club', NULL, NULL, 's'),
(659, NULL, 45, 'o''higgins', '/uploads/escudos/ohiggins_p.gif', 'club', NULL, NULL, 's'),
(667, NULL, 45, 'unión san felipe', '/uploads/escudos/UnionSanFelipe_p.gif', 'club', NULL, NULL, 's'),
(686, NULL, 45, 'san luis', '/uploads/escudos/sanluis_p.gif', 'club', NULL, NULL, 's'),
(747, 13, 45, 'cobresal', '/uploads/escudos/ba5777752fc7731eff6b75728556a29a.gif', 'club', NULL, NULL, 's'),
(750, NULL, 45, 'everton', '/uploads/escudos/everton_p.gif', 'club', NULL, NULL, 's'),
(794, NULL, 45, 'iquique', '/uploads/escudos/iquique_p.gif', 'club', NULL, NULL, 's'),
(795, NULL, 45, 'la serena', '/uploads/escudos/la_serena_p.gif', 'club', NULL, NULL, 's'),
(813, NULL, 45, 'antofagasta', '/uploads/escudos/antofagasta_p.gif', 'club', NULL, NULL, 's'),
(820, NULL, 45, 'ñublense', '/uploads/escudos/nublense_p.gif', 'club', NULL, NULL, 's'),
(908, NULL, 45, 'lota schwager', '/uploads/escudos/lota_schewager_p.gif', 'club', NULL, NULL, 's'),
(991, NULL, 45, 'SM arica', '/uploads/escudos/Arica_p.gif', 'club', NULL, NULL, 's'),
(1008, NULL, 45, 'unión la calera', '/uploads/escudos/union_la_calera_p.gif', 'club', NULL, NULL, 's'),
(1358, NULL, 45, 'u de concepción', '/uploads/escudos/un_concepcion_p.gif', 'club', NULL, NULL, 's'),
(2249, NULL, 45, 'dep. copiapó', '/uploads/escudos/copiapo_p.gif', 'club', NULL, NULL, 's'),
(2465, NULL, 45, 'barnechea', '/uploads/escudos/barnechea_p.gif', 'club', NULL, NULL, 's'),
(2466, 30, 45, 'Naval', '/uploads/escudos/d53997fc6d995bbe8ebd07105c0637b4.gif', 'club', 'Talcahuano', '/uploads/equipo/escudo/fe921d55202e59474d1c6b5d68d950bc.jpg', 's'),
(2469, NULL, 45, 'curicó unido', '/uploads/escudos/curico_p.gif', 'club', NULL, NULL, 's'),
(5812, NULL, 45, 'unión temuco', '/uploads/escudos/union_temuco_p.gif', 'club', NULL, NULL, 's');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_estadio`
--
CREATE TABLE IF NOT EXISTS `m_estadio` (
`estadio_id` int(11) NOT NULL AUTO_INCREMENT,
`estadio_nombre` varchar(200) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`estadio_capacidad` int(11) DEFAULT NULL,
PRIMARY KEY (`estadio_id`),
UNIQUE KEY `ak_key_2` (`estadio_nombre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Volcado de datos para la tabla `m_estadio`
--
INSERT INTO `m_estadio` (`estadio_id`, `estadio_nombre`, `created_at`, `estadio_capacidad`) VALUES
(1, 'Bicentenario Chinquihue', '2013-03-02 06:05:41', 0),
(2, 'Roberto Bravo', '2013-03-02 06:05:47', 0),
(3, 'El Parque', '2013-03-02 06:05:53', 0),
(4, 'Monumental', '2013-03-02 06:06:00', 0),
(5, 'Santa Laura- U. Sek', '2013-03-02 06:06:06', 0),
(6, 'Chillán Viejo', '2013-03-02 06:06:12', 0),
(7, 'Bicentenario Francisco Sánchez', '2013-03-02 06:06:22', 0),
(8, 'Bicentenario Lucio Fariña', '2013-03-05 20:22:05', 1),
(9, 'Bicentenario Luis Valenzuela', '2013-03-02 06:06:34', 0),
(10, 'Bicentenario La Granja', '2013-03-02 06:06:40', 0),
(11, 'Collao', '2013-03-02 06:06:48', 0),
(12, 'San Carlos', '2013-03-02 06:06:55', 0),
(13, 'El Cobre', '2013-03-02 06:07:13', 0),
(15, 'CAP', '2013-03-02 06:07:28', 0),
(16, 'Bicentenario Carlos Dittborn', '2013-03-02 06:07:33', 0),
(17, 'Nicolás Chahuán', '2013-03-02 06:07:40', 0),
(18, 'Tierra de Campeones', '2013-03-02 06:07:46', 0),
(20, 'El Teniente', '2013-03-02 06:08:13', 0),
(21, 'Municipal de Calama', '2013-03-02 06:08:20', 0),
(22, 'Bicentenario Nelson Oyarzún', '2013-03-02 06:08:32', 0),
(23, 'Fiscal de Talca', '2013-03-02 06:08:40', 0),
(24, 'TesterxD', '2013-03-02 12:16:35', 45000),
(27, 'Parque Juan López', '2013-03-04 23:51:50', NULL),
(29, 'Bicentenario La Florida', '2013-03-04 23:52:05', NULL),
(30, 'El Morro', '2012-03-06 02:36:06', NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_fecha`
--
CREATE TABLE IF NOT EXISTS `m_fecha` (
`fecha_id` int(11) NOT NULL AUTO_INCREMENT,
`arbitro_id` int(11) DEFAULT NULL,
`m_config_id` int(11) DEFAULT NULL,
`equipo_local_id` int(11) DEFAULT NULL,
`equipo_visita_id` int(11) DEFAULT NULL,
`fecha_estado` enum('pendiente','por comenzar','1er tiempo','entre tiempo','2do tiempo','finalizado','alargue','penales','suspendido') DEFAULT 'pendiente',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`fecha_realizacion` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`fecha_goles_visita` int(11) DEFAULT NULL,
`fecha_goles_local` int(11) DEFAULT NULL,
`fecha_n` int(11) DEFAULT NULL,
PRIMARY KEY (`fecha_id`),
KEY `fk_reference_13` (`equipo_local_id`),
KEY `fk_reference_14` (`equipo_visita_id`),
KEY `fk_reference_16` (`m_config_id`),
KEY `fk_reference_6` (`arbitro_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;
--
-- Volcado de datos para la tabla `m_fecha`
--
INSERT INTO `m_fecha` (`fecha_id`, `arbitro_id`, `m_config_id`, `equipo_local_id`, `equipo_visita_id`, `fecha_estado`, `created_at`, `fecha_realizacion`, `fecha_goles_visita`, `fecha_goles_local`, `fecha_n`) VALUES
(1, 2, 1, 132, 658, 'finalizado', '0000-00-00 00:00:00', '2013-02-01 13:00:00', 0, 1, 2),
(2, 2, 2, 659, 307, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 20:45:12', 1, 0, 1),
(3, 3, 3, 747, 583, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 20:48:42', 2, 1, 1),
(4, 4, 4, 221, 241, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 20:49:48', 2, 5, 1),
(5, 5, 5, 794, 220, 'finalizado', '0000-00-00 00:00:00', '2013-01-26 13:00:00', 0, 0, 1),
(6, 6, 6, 820, 750, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 20:53:16', 1, 1, 1),
(7, 7, 7, 1008, 813, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 20:54:16', 1, 2, 1),
(8, 8, 8, 577, 991, 'finalizado', '0000-00-00 00:00:00', '2013-01-25 13:00:00', 0, 0, 1),
(9, 9, 9, 316, 658, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 20:55:52', 1, 1, 1),
(10, 23, 10, 241, 1008, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:49:09', 0, 2, 2),
(11, 6, 11, 221, 794, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:50:13', 1, 4, 2),
(12, 4, 12, 820, 813, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:51:14', 2, 0, 2),
(13, 24, 13, 991, 747, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:52:25', 1, 3, 2),
(14, 25, 14, 583, 316, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:53:40', 2, 1, 2),
(15, 1, 15, 659, 232, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:55:07', 0, 2, 2),
(16, 8, 16, 307, 220, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 22:56:02', 1, 1, 2),
(17, 7, 17, 750, 577, 'finalizado', '0000-00-00 00:00:00', '2013-03-11 10:56:00', 0, 3, 2),
(18, 23, 18, 316, 307, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:05:59', 3, 0, 3),
(20, 3, 20, 813, 221, 'finalizado', '0000-00-00 00:00:00', '2013-02-10 07:30:00', 0, 0, 3),
(21, 1, 21, 220, 820, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:09:44', 1, 0, 3),
(22, 26, 22, 747, 750, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:13:17', 1, 0, 3),
(23, 25, 23, 232, 1008, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:17:58', 4, 3, 3),
(24, 5, 24, 132, 583, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:19:41', 3, 0, 3),
(25, 27, 25, 794, 241, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:21:50', 1, 2, 3),
(26, 2, 26, 577, 659, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:22:41', 2, 0, 3),
(27, 4, 27, 658, 991, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:23:32', 1, 1, 3),
(28, 23, 28, 241, 232, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:25:31', 0, 1, 4),
(29, 9, 29, 747, 316, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:26:14', 2, 2, 4),
(30, 26, 30, 221, 577, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:26:57', 3, 3, 4),
(31, 6, 31, 991, 820, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:29:39', 4, 0, 4),
(32, 27, 32, 307, 813, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:30:51', 2, 4, 4),
(33, 1, 33, 1008, 794, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:32:13', 0, 1, 4),
(34, 4, 34, 750, 132, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:33:18', 1, 1, 4),
(35, 2, 35, 583, 658, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:36:32', 0, 4, 4),
(36, 25, 36, 659, 220, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 13:37:18', 2, 3, 4),
(37, 25, 37, 132, 991, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:33:53', 1, 6, 5),
(38, 3, 38, 813, 750, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:35:55', 2, 1, 5),
(39, 9, 39, 307, 1008, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:37:12', 0, 4, 5),
(40, 6, 40, 794, 232, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:38:00', 2, 0, 5),
(41, 23, 41, 577, 583, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:38:46', 1, 0, 5),
(42, 7, 42, 220, 241, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:39:36', 2, 1, 5),
(43, 27, 43, 316, 221, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:40:22', 2, 2, 5),
(44, 26, 44, 658, 747, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:41:09', 2, 3, 5),
(45, 24, 45, 820, 659, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 14:41:49', 1, 1, 5),
(46, 27, 46, 232, 220, 'finalizado', '0000-00-00 00:00:00', '2013-03-03 12:00:00', 0, 0, 6),
(47, 24, 47, 241, 813, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 16:26:55', 3, 3, 6),
(48, 3, 48, 1008, 316, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 16:27:40', 0, 2, 6),
(49, 4, 49, 221, 307, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 16:28:34', 2, 4, 6),
(50, 9, 50, 991, 750, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:17:31', 2, 2, 6),
(51, 7, 51, 577, 794, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:18:33', 1, 2, 6),
(52, 1, 52, 659, 658, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:19:14', 1, 3, 6),
(53, 2, 53, 747, 132, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:20:09', 3, 1, 6),
(54, 5, 54, 583, 820, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:21:02', 2, 2, 6),
(55, 25, 55, 307, 232, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:33:42', 3, 2, 7),
(56, 2, 56, 813, 659, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:36:18', 3, 1, 7),
(57, 6, 57, 316, 241, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:37:43', 0, 1, 7),
(58, 24, 58, 991, 583, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:38:36', 1, 0, 7),
(59, 26, 59, 658, 577, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:39:11', 1, 0, 7),
(60, 8, 60, 132, 794, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:39:48', 0, 2, 7),
(61, 5, 61, 220, 1008, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:40:30', 0, 1, 7),
(62, 23, 62, 750, 221, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:41:06', 1, 0, 7),
(63, 7, 63, 820, 747, 'finalizado', '0000-00-00 00:00:00', '2013-03-12 19:41:44', 1, 2, 7),
(64, 0, 64, 241, 820, 'pendiente', '2013-03-12 19:58:52', '2013-03-17 10:30:00', 0, 0, 8),
(65, 0, 65, 220, 747, 'pendiente', '2013-03-12 20:02:07', '2013-03-17 08:00:00', 0, 0, 8),
(66, 0, 66, 794, 316, 'pendiente', '2013-03-12 20:02:47', '2013-03-17 08:00:00', 0, 0, 8),
(67, 0, 67, 221, 658, 'pendiente', '2013-03-12 20:03:14', '2013-03-17 08:00:00', 0, 0, 8),
(68, 0, 68, 583, 750, 'pendiente', '2013-03-12 20:04:23', '2013-03-16 13:00:00', 0, 0, 8),
(69, 0, 69, 577, 307, 'pendiente', '2013-03-12 20:05:17', '2013-03-16 10:30:00', 0, 0, 8),
(70, 0, 70, 1008, 132, 'pendiente', '2013-03-12 20:05:48', '2013-03-16 08:00:00', 0, 0, 8),
(71, 0, 71, 659, 991, 'pendiente', '2013-03-12 20:06:20', '2013-03-15 14:00:00', 0, 0, 8),
(72, 0, 72, 232, 813, 'pendiente', '2013-03-12 20:06:48', '2013-03-15 11:30:00', 0, 0, 8),
(73, 0, 73, 658, 241, 'pendiente', '2013-03-12 20:07:52', '2013-03-29 10:00:00', 0, 0, 9),
(74, 0, 74, 813, 220, 'pendiente', '2013-03-12 20:08:22', '2013-03-31 08:00:00', 0, 0, 9),
(75, 0, 75, 747, 307, 'pendiente', '2013-03-12 20:08:55', '2013-03-31 07:30:00', 0, 0, 9),
(76, 0, 76, 991, 1008, 'pendiente', '2013-03-12 20:09:27', '2013-03-30 14:00:00', 0, 0, 9),
(77, 0, 77, 820, 577, 'pendiente', '2013-03-12 20:09:52', '2013-03-30 12:30:00', 0, 0, 9),
(78, 0, 78, 132, 221, 'pendiente', '2013-03-12 20:10:27', '2013-03-30 10:00:00', 0, 0, 9),
(79, 0, 79, 750, 659, 'pendiente', '2013-03-12 20:10:52', '2013-03-30 07:30:00', 0, 0, 9),
(80, 0, 80, 583, 794, 'pendiente', '2013-03-12 20:11:36', '2013-03-30 16:00:00', 0, 0, 9),
(81, 0, 81, 316, 232, 'pendiente', '2013-03-12 20:11:59', '2013-03-29 12:00:00', 0, 0, 9),
(82, 0, 82, 241, 750, 'pendiente', '2013-03-12 20:12:33', '2013-04-07 10:00:00', 0, 0, 10),
(83, 0, 83, 221, 820, 'pendiente', '2013-03-12 20:13:01', '2013-04-07 08:00:00', 0, 0, 10),
(84, 0, 84, 577, 132, 'pendiente', '2013-03-12 20:13:26', '2013-04-07 07:30:00', 0, 0, 10),
(85, 0, 85, 794, 813, 'pendiente', '2013-03-12 20:13:53', '2013-04-06 14:00:00', 0, 0, 10),
(86, 0, 86, 659, 747, 'pendiente', '2013-03-12 20:14:32', '2013-04-06 12:30:00', 0, 0, 10),
(87, 0, 87, 307, 583, 'pendiente', '2013-03-12 20:15:07', '2013-04-06 10:30:00', 0, 0, 10),
(88, 0, 88, 232, 991, 'pendiente', '2013-03-12 20:15:33', '2013-04-06 07:30:00', 0, 0, 10),
(89, 0, 89, 220, 316, 'pendiente', '2013-03-12 20:15:55', '2013-04-06 16:00:00', 0, 0, 10),
(90, 0, 90, 1008, 658, 'pendiente', '2013-03-12 20:16:24', '2013-04-05 12:00:00', 0, 0, 10),
(91, 1, 91, 232, 132, 'finalizado', '2013-03-12 20:47:38', '2013-02-27 10:00:00', 1, 2, 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_jugador`
--
CREATE TABLE IF NOT EXISTS `m_jugador` (
`jugador_id` int(11) NOT NULL AUTO_INCREMENT,
`jugador_nombres` varchar(200) DEFAULT NULL,
`jugador_posicion` enum('arquero','defensor','defensor-volante','volante','volante-delantero','delantero') DEFAULT NULL,
`jugador_estado` enum('activo','suspendido','lesionado','retirado') DEFAULT NULL,
`jugador_n` int(11) DEFAULT NULL,
`jugador_image_path` varchar(255) DEFAULT NULL,
`jugador_apellido` varchar(200) DEFAULT NULL,
`jugador_nacionalidad` varchar(200) DEFAULT NULL,
PRIMARY KEY (`jugador_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=93736 ;
--
-- Volcado de datos para la tabla `m_jugador`
--
INSERT INTO `m_jugador` (`jugador_id`, `jugador_nombres`, `jugador_posicion`, `jugador_estado`, `jugador_n`, `jugador_image_path`, `jugador_apellido`, `jugador_nacionalidad`) VALUES
(104, 'mauro roman', 'arquero', 'activo', NULL, NULL, 'astrada', 'argentina'),
(250, 'juan ramon', 'defensor', 'activo', NULL, NULL, 'fernandez', 'argentina'),
(295, 'diego', 'volante', 'activo', NULL, NULL, 'scotti', 'uruguay'),
(368, 'rodrigo ezequiel', 'volante', 'activo', NULL, NULL, 'diaz', 'argentina'),
(396, 'cristian emilio', 'defensor', 'activo', NULL, NULL, 'grabinski', 'argentina'),
(400, 'guillermo andres', 'volante', 'activo', NULL, NULL, 'marino', 'argentina'),
(401, 'luciano ramon', 'arquero', 'activo', NULL, NULL, 'palos', 'argentina'),
(402, 'nicolas', 'delantero', 'activo', NULL, NULL, 'pavlovich', 'argentina'),
(519, 'cristian fernando', 'arquero', 'activo', NULL, NULL, 'muÑoz', 'argentina'),
(578, 'leandro', 'volante', 'activo', NULL, NULL, 'gracian', 'argentina'),
(587, 'juan ernesto', 'volante', 'activo', NULL, NULL, 'casado', 'argentina'),
(1742, 'sixto raimundo', 'volante-delantero', 'activo', NULL, NULL, 'peralta', 'argentina'),
(2783, 'sergio hector', 'delantero', 'activo', NULL, NULL, 'comba', 'argentina'),
(2793, 'pablo ignacio', 'delantero', 'activo', NULL, NULL, 'calandria', 'argentina'),
(3978, 'gustavo tulio', 'arquero', 'activo', NULL, NULL, 'dalsasso', 'argentina'),
(3994, 'miguel angel', 'volante', 'activo', NULL, NULL, 'romero', 'argentina'),
(4243, 'carlos jose', 'arquero', 'activo', NULL, NULL, 'kletnicki', 'argentina'),
(5100, 'mariano esteban', 'defensor', 'activo', NULL, NULL, 'uglessich', 'argentina'),
(5290, 'luis angel', 'delantero', 'activo', NULL, NULL, 'salmeron', 'argentina'),
(6613, 'cristian javier', 'volante', 'activo', NULL, NULL, 'devallis', 'argentina'),
(7307, 'ezequiel luis', 'arquero', 'activo', NULL, NULL, 'medran', 'argentina'),
(7573, 'miguel angel', 'volante', 'activo', NULL, NULL, 'gonzalez', 'argentina'),
(9292, 'juan ignacio', 'delantero', 'activo', NULL, NULL, 'acosta cabrera', 'paraguay'),
(9797, 'luciano sebastian', 'defensor', 'activo', NULL, NULL, 'goux', 'argentina'),
(13931, 'jorge ignacio', 'arquero', 'activo', NULL, NULL, 'manduca', 'argentina'),
(14479, 'mario daniel', 'delantero', 'activo', NULL, NULL, 'pierani', 'argentina'),
(14593, 'cristian hernan', 'volante', 'activo', NULL, NULL, 'rivainera', 'argentina'),
(15094, 'lucas raul', 'arquero', 'activo', NULL, NULL, 'giovini', 'argentina'),
(16064, 'diego alejandro', 'delantero', 'activo', NULL, NULL, 'ruiz', 'argentina'),
(17841, 'francisco', 'defensor', 'activo', NULL, NULL, 'portillo', 'argentina'),
(18686, 'javier anibal', 'delantero', 'activo', NULL, NULL, 'elizondo', 'argentina'),
(19044, 'jose ernesto', 'volante', 'activo', NULL, NULL, 'galvan', 'argentina'),
(19127, 'milovan petar', 'volante', 'activo', NULL, NULL, 'mirosevic', 'chile'),
(19480, 'diego alejandro', 'defensor', 'activo', NULL, NULL, 'reynoso', 'argentina'),
(21243, 'javier antonio', 'delantero', 'activo', NULL, NULL, 'grbec', 'argentina'),
(21260, 'ariel damian', 'delantero', 'activo', NULL, NULL, 'colzera', 'argentina'),
(23688, 'rafael andres', 'defensor', 'activo', NULL, NULL, 'olarra', 'chile'),
(24218, 'gustavo ruben', 'volante', 'activo', NULL, NULL, 'lorenzetti', 'argentina'),
(24219, 'gonzalo martin', 'delantero', 'activo', NULL, NULL, 'de porras', 'argentina'),
(24231, 'rodrigo david', 'volante', 'activo', NULL, NULL, 'melendez', 'chile'),
(24643, 'julio alberto', 'defensor', 'activo', NULL, NULL, 'barroso', 'argentina'),
(25795, 'rene martin', 'volante', 'activo', NULL, NULL, 'lima', 'argentina'),
(25926, 'federico matias', 'defensor', 'activo', NULL, NULL, 'leon', 'argentina'),
(26054, 'benjamin ignacio', 'defensor-volante', 'activo', NULL, NULL, 'ruiz', 'chile'),
(26056, 'jorge sebastian', 'defensor-volante', 'activo', NULL, NULL, 'aguilar', 'chile'),
(26057, 'roberto andres', 'defensor-volante', 'activo', NULL, NULL, 'cereceda', 'chile'),
(26058, 'nestor ruben', 'volante', 'activo', NULL, NULL, 'contreras', 'chile'),
(26065, 'leonardo esteban', 'delantero', 'activo', NULL, NULL, 'monje', 'chile'),
(26066, 'octavio ernesto', 'volante', 'activo', NULL, NULL, 'pozo', 'chile'),
(26076, 'luis alberto', 'defensor', 'activo', NULL, NULL, 'fuentes', 'chile'),
(26084, 'jonathan josue', 'volante', 'activo', NULL, NULL, 'cisternas', 'chile'),
(26087, 'juan luis', 'volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(26103, 'diego alejandro', 'defensor', 'activo', NULL, NULL, 'silva', 'chile'),
(26118, 'eduardo', 'arquero', 'activo', NULL, NULL, 'lobos', 'chile'),
(26120, 'miguel angel', 'defensor', 'activo', NULL, NULL, 'aceval', 'chile'),
(26123, 'luis arturo', 'defensor', 'activo', NULL, NULL, 'mena', 'chile'),
(26126, 'gonzalo antonio', 'volante-delantero', 'activo', NULL, NULL, 'fierro', 'chile'),
(26127, 'braulio antonio', 'volante', 'activo', NULL, NULL, 'leal', 'chile'),
(26129, 'fernando andres', 'volante', 'activo', NULL, NULL, 'meneses', 'chile'),
(26132, 'moises fermin', 'defensor-volante', 'activo', NULL, NULL, 'villarroel', 'chile'),
(26133, 'marco antonio', 'volante', 'activo', NULL, NULL, 'villaseca', 'chile'),
(26134, 'mario antonio', 'delantero', 'activo', NULL, NULL, 'caceres', 'chile'),
(26151, 'manuel alejandro', 'volante', 'activo', NULL, NULL, 'garcia', 'chile'),
(26155, 'victor alexis', 'defensor', 'activo', NULL, NULL, 'osorio', 'chile'),
(26160, 'ali', 'defensor-volante', 'activo', NULL, NULL, 'manoucheiri', 'chile'),
(26166, 'cristian gonzalo', 'defensor', 'activo', NULL, NULL, 'oviedo', 'chile'),
(26167, 'cristian eduardo', 'defensor', 'activo', NULL, NULL, 'reynero', 'chile'),
(26172, 'alejandro', 'defensor-volante', 'activo', NULL, NULL, 'figueroa', 'chile'),
(26179, 'patricio gonzalo', 'defensor', 'activo', NULL, NULL, 'peralta', 'chile'),
(26187, 'mario esteban', 'defensor', 'activo', NULL, NULL, 'berrios', 'chile'),
(26189, 'fernando', 'defensor', 'activo', NULL, NULL, 'lopez', 'chile'),
(26190, 'adrian alejandro', 'defensor', 'activo', NULL, NULL, 'rojas', 'chile'),
(26205, 'roberto jesus', 'delantero', 'activo', NULL, NULL, 'castillo', 'chile'),
(26212, 'leandro javier', 'volante', 'activo', NULL, NULL, 'delgado', 'chile'),
(26217, 'angel rodrigo', 'volante', 'activo', NULL, NULL, 'carreÑo', 'chile'),
(26221, 'victor manuel', 'defensor', 'activo', NULL, NULL, 'oyarzun', 'chile'),
(26231, 'juan antonio', 'arquero', 'activo', NULL, NULL, 'martinez', 'chile'),
(26232, 'juan luis', 'arquero', 'activo', NULL, NULL, 'mora', 'chile'),
(26233, 'nicolas miroslav', 'arquero', 'activo', NULL, NULL, 'peric', 'chile'),
(26242, 'juan jose', 'volante', 'activo', NULL, NULL, 'albornoz', 'chile'),
(26253, 'rodrigo felipe', 'arquero', 'activo', NULL, NULL, 'naranjo', 'chile'),
(26254, 'francisco javier', 'arquero', 'activo', NULL, NULL, 'prieto', 'chile'),
(26258, 'jose raul', 'defensor-volante', 'activo', NULL, NULL, 'contreras', 'chile'),
(26265, 'christian del transito', 'defensor-volante', 'activo', NULL, NULL, 'galvez', 'chile'),
(26268, 'jorge andres', 'volante', 'activo', NULL, NULL, 'ormeÑo', 'chile'),
(26293, 'cristian eduardo', 'delantero', 'activo', NULL, NULL, 'canio', 'chile'),
(26309, 'sebastian', 'defensor', 'activo', NULL, NULL, 'miranda', 'chile'),
(26317, 'roberto daniel', 'volante', 'activo', NULL, NULL, 'ordenes', 'chile'),
(26337, 'victor nicolas', 'defensor', 'activo', NULL, NULL, 'suarez', 'chile'),
(26340, 'juan carlos', 'volante', 'activo', NULL, NULL, 'espinoza', 'chile'),
(26345, 'eduardo antonio', 'volante', 'activo', NULL, NULL, 'pinto', 'chile'),
(26351, 'paulo andres', 'arquero', 'activo', NULL, NULL, 'garces', 'chile'),
(26353, 'cristian andres', 'defensor', 'activo', NULL, NULL, 'alvarez', 'chile'),
(26355, 'claudio andres', 'defensor', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(26356, 'manuel alejandro', 'defensor', 'activo', NULL, NULL, 'ormazabal', 'chile'),
(26360, 'albert alejandro', 'defensor', 'activo', NULL, NULL, 'acevedo', 'chile'),
(26365, 'mauricio', 'defensor-volante', 'activo', NULL, NULL, 'segovia', 'chile'),
(26367, 'ivan', 'volante', 'activo', NULL, NULL, 'vazquez', 'chile'),
(26369, 'gonzalo andres', 'volante', 'activo', NULL, NULL, 'villagra', 'chile'),
(26372, 'jhonny', 'arquero', 'activo', NULL, NULL, 'herrera', 'chile'),
(26379, 'jose manuel', 'defensor', 'activo', NULL, NULL, 'rojas', 'chile'),
(26381, 'carlos alberto', 'defensor-volante', 'activo', NULL, NULL, 'garrido', 'chile'),
(26384, 'christian jorge', 'volante', 'activo', NULL, NULL, 'martinez', 'chile'),
(26385, 'cristian marcelo', 'volante', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(26398, 'andres patricio', 'defensor-volante', 'activo', NULL, NULL, 'oroz', 'chile'),
(26402, 'fernando esteban', 'defensor', 'activo', NULL, NULL, 'solis', 'chile'),
(26404, 'luis pedro', 'volante', 'activo', NULL, NULL, 'figueroa', 'chile'),
(26849, 'sebastian ignacio', 'delantero', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(26862, 'rodrigo ignacio', 'defensor-volante', 'activo', NULL, NULL, 'valenzuela', 'chile'),
(26949, 'alejandro ulises', 'volante-delantero', 'activo', NULL, NULL, 'carrasco', 'chile'),
(26965, 'jorge cristian', 'volante', 'activo', NULL, NULL, 'acuÑa', 'chile'),
(26967, 'francisco esteban', 'volante', 'activo', NULL, NULL, 'arrue', 'chile'),
(26974, 'alex cristian', 'defensor', 'activo', NULL, NULL, 'von schwedler', 'chile'),
(27401, 'juan claudio', 'defensor', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(28165, 'gamadiel adrian', 'volante', 'activo', NULL, NULL, 'garcia', 'chile'),
(28657, 'esteban eduardo', 'defensor-volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(28775, 'daniel enrique', 'delantero', 'activo', NULL, NULL, 'arismendi', 'venezuela'),
(28873, 'francisco ronaldo', 'volante', 'activo', NULL, NULL, 'silva', 'uruguay'),
(29285, 'alvaro damian', 'delantero', 'activo', NULL, NULL, 'navarro', 'uruguay'),
(29581, 'joel antonio', 'delantero', 'activo', NULL, NULL, 'soto', 'chile'),
(29582, 'boris alexis', 'defensor-volante', 'activo', NULL, NULL, 'rieloff', 'chile'),
(29606, 'mauricio antonio', 'defensor', 'activo', NULL, NULL, 'arias', 'chile'),
(29616, 'cesar alexis', 'delantero', 'activo', NULL, NULL, 'cortes', 'chile'),
(29622, 'alvaro andres', 'defensor-volante', 'activo', NULL, NULL, 'ormeÑo', 'chile'),
(29627, 'daniel felipe', 'volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(29628, 'victor alejandro', 'delantero', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(29635, 'jorge andres', 'defensor', 'activo', NULL, NULL, 'alvarado', 'chile'),
(29636, 'claudio', 'arquero', 'activo', NULL, NULL, 'villalobos', 'chile'),
(29637, 'sebastian eduardo', 'volante', 'activo', NULL, NULL, 'paez', 'chile'),
(29638, 'patricio alejandro', 'volante-delantero', 'activo', NULL, NULL, 'rubina', 'chile'),
(29640, 'mauricio javier', 'volante', 'activo', NULL, NULL, 'salazar', 'chile'),
(29710, 'alejandro gonzalo', 'volante', 'activo', NULL, '', 'vazquez', 'chile'),
(29857, 'juan cruz', 'defensor', 'activo', NULL, NULL, 'gill', 'argentina'),
(29915, 'miguel angel', 'defensor-volante', 'activo', NULL, NULL, 'ayala', 'chile'),
(30112, 'hugo gabriel', 'defensor', 'activo', NULL, NULL, 'bascuÑan', 'chile'),
(30381, 'carlos eber', 'delantero', 'activo', NULL, NULL, 'bueno', 'uruguay'),
(30526, 'carlos', 'volante', 'activo', NULL, NULL, 'espinoza', 'chile'),
(30532, 'gabriel alejandro', 'volante', 'activo', NULL, NULL, 'vilchez', 'chile'),
(30533, 'roberto', 'arquero', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(30537, 'gabriel eduardo', 'volante', 'activo', NULL, NULL, 'sandoval', 'chile'),
(30539, 'sergio alex', 'volante', 'activo', NULL, NULL, 'vargas', 'chile'),
(30542, 'juan andres', 'volante', 'activo', NULL, NULL, 'toloza', 'chile'),
(30548, 'cristian', 'volante', 'activo', NULL, NULL, 'vilches', 'chile'),
(30555, 'francisco javier', 'volante', 'activo', NULL, NULL, 'sanchez', 'chile'),
(30559, 'mauricio', 'defensor', 'activo', NULL, NULL, 'zenteno', 'chile'),
(30560, 'nicolas', 'volante-delantero', 'activo', NULL, NULL, 'nuÑez', 'chile'),
(30723, 'mathias damian', 'volante', 'activo', NULL, NULL, 'riquero', 'uruguay'),
(30808, 'rodrigo fabian', 'defensor', 'activo', NULL, NULL, 'riquelme', 'paraguay'),
(30997, 'diego', 'delantero', 'activo', NULL, NULL, 'de gregorio', 'chile'),
(31251, 'jose felix', 'defensor', 'activo', NULL, NULL, 'pedrozo', 'paraguay'),
(31326, 'jose pedro', 'volante', 'activo', NULL, NULL, 'fuenzalida', 'chile'),
(31375, 'christian venancio', 'delantero', 'activo', NULL, NULL, 'bogado', 'paraguay'),
(31405, 'miguel angel', 'delantero', 'activo', NULL, NULL, 'cuellar', 'paraguay'),
(31440, 'ezequiel', 'defensor', 'activo', NULL, NULL, 'luna', 'argentina'),
(31491, 'omar jesus', 'defensor', 'activo', NULL, NULL, 'riquelme', 'chile'),
(31587, 'alejandro', 'defensor', 'activo', NULL, NULL, 'gaete', 'chile'),
(31594, 'angel orlando', 'volante', 'activo', NULL, NULL, 'rojas', 'chile'),
(31688, 'fernando carlos', 'delantero', 'activo', NULL, NULL, 'curcio', 'uruguay'),
(31803, 'pablo daniel', 'delantero', 'activo', NULL, NULL, 'pereira', 'uruguay'),
(31881, 'matias', 'volante', 'activo', NULL, NULL, 'abelairas', 'argentina'),
(32008, 'richard hans', 'delantero', 'activo', NULL, NULL, 'olivares', 'chile'),
(32964, 'matias nicolas', 'delantero', 'activo', NULL, NULL, 'arrua', 'argentina'),
(32969, 'juan gonzalo', 'delantero', 'activo', NULL, NULL, 'lorca', 'chile'),
(33060, 'juan fernando', 'defensor', 'activo', NULL, NULL, 'grabowski', 'argentina'),
(33241, 'emiliano daniel', 'volante-delantero', 'activo', NULL, NULL, 'romero', 'argentina'),
(33256, 'martin miguel', 'volante', 'activo', NULL, NULL, 'cortes', 'argentina'),
(33759, 'lucas', 'delantero', 'activo', NULL, NULL, 'simon', 'argentina'),
(33920, 'miguel hernan', 'arquero', 'activo', NULL, NULL, 'jimenez', 'chile'),
(33932, 'alejandro miguel', 'arquero', 'activo', NULL, NULL, 'sanchez', 'argentina'),
(34414, 'diego leonardo', 'delantero', 'activo', NULL, NULL, 'martinez', 'argentina'),
(34555, 'ramon eduardo', 'volante', 'activo', NULL, NULL, 'fernandez', 'argentina'),
(34670, 'mauro', 'delantero', 'activo', NULL, NULL, 'olivi', 'argentina'),
(35267, 'felipe andres', 'defensor', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(35300, 'leandro gabriel', 'volante', 'activo', NULL, NULL, 'torres', 'argentina'),
(35456, 'nicolas ignacio', 'volante', 'activo', NULL, NULL, 'crovetto', 'chile'),
(35457, 'jorge', 'volante', 'activo', NULL, NULL, 'munizaga', 'chile'),
(35459, 'jose samuel', 'delantero', 'activo', NULL, NULL, 'teuber', 'chile'),
(35501, 'felipe', 'arquero', 'activo', NULL, NULL, 'nuÑez', 'chile'),
(35509, 'luis antonio', 'arquero', 'activo', NULL, NULL, 'marin', 'chile'),
(35831, 'felipe ignacio', 'delantero', 'activo', NULL, NULL, 'flores', 'chile'),
(36137, 'carlos patricio', 'volante', 'activo', NULL, NULL, 'cisternas', 'chile'),
(36143, 'diego gonzalo', 'delantero', 'activo', NULL, NULL, 'chaves', 'uruguay'),
(36175, 'rodrigo', 'defensor', 'activo', NULL, NULL, 'moya', 'chile'),
(36512, 'mauricio eduardo', 'volante', 'activo', NULL, NULL, 'lagos', 'chile'),
(36883, 'sergio antonio', 'volante', 'activo', NULL, NULL, 'nuÑez', 'chile'),
(36896, 'frank patricio', 'defensor', 'activo', NULL, NULL, 'carilao', 'chile'),
(36902, 'rodrigo andres', 'defensor', 'activo', NULL, NULL, 'ramirez', 'chile'),
(36904, 'gabriel alejandro', 'delantero', 'activo', NULL, NULL, 'vargas', 'chile'),
(36909, 'carlos ariel', 'arquero', 'activo', NULL, NULL, 'torres', 'chile'),
(36922, 'cristian andres', 'defensor', 'activo', NULL, NULL, 'basaure', 'chile'),
(36931, 'felipe andres', 'defensor', 'activo', NULL, NULL, 'miranda', 'chile'),
(36964, 'renato andres', 'delantero', 'activo', NULL, NULL, 'ramos', 'chile'),
(36986, 'dagoberto alexis', 'volante', 'activo', NULL, NULL, 'curimilla', 'chile'),
(36988, 'hector', 'volante', 'activo', NULL, NULL, 'berrios', 'chile'),
(36991, 'pablo cesar', 'arquero', 'activo', NULL, NULL, 'reinoso', 'chile'),
(36993, 'adolfo leonardo', 'defensor', 'activo', NULL, NULL, 'ruiz', 'chile'),
(36998, 'michael andres', 'delantero', 'activo', NULL, NULL, 'silva', 'chile'),
(37118, 'jose nicolas', 'delantero', 'activo', NULL, NULL, 'vizcarra', 'argentina'),
(37130, 'juan guillermo', 'defensor', 'activo', NULL, NULL, 'dominguez', 'colombia'),
(37212, 'lizandro alexis', 'defensor', 'activo', NULL, NULL, 'henriquez', 'chile'),
(37415, 'cristian', 'defensor', 'activo', NULL, NULL, 'olguin', 'chile'),
(38042, 'fernando javier', 'arquero', 'activo', NULL, NULL, 'hurtado', 'chile'),
(38064, 'fabian gustavo', 'arquero', 'activo', NULL, NULL, 'moyano', 'argentina'),
(38065, 'enzo hernan', 'volante', 'activo', NULL, NULL, 'gutierrez', 'argentina'),
(38210, 'alejandro', 'delantero', 'activo', NULL, NULL, 'maureira', 'chile'),
(38223, 'patricio javier', 'defensor-volante', 'activo', NULL, NULL, 'gutierrez', 'chile'),
(38224, 'luis anthony', 'defensor', 'activo', NULL, NULL, 'alegria', 'chile'),
(38225, 'cristian manuel', 'volante', 'activo', NULL, NULL, 'rojas', 'chile'),
(38226, 'giovanny marcelo', 'volante', 'activo', NULL, NULL, 'narvaez', 'chile'),
(38245, 'diego', 'delantero', 'activo', NULL, NULL, 'cuellar', 'chile'),
(38249, 'ronnie', 'delantero', 'activo', NULL, NULL, 'fernandez', 'chile'),
(38279, 'fernando alejandro', 'volante', 'activo', NULL, NULL, 'manriquez', 'chile'),
(38287, 'marco', 'volante', 'activo', NULL, NULL, 'rodriguez', 'chile'),
(38290, 'carlos felipe', 'defensor', 'activo', NULL, NULL, 'herrera', 'chile'),
(38291, 'fernando mario', 'arquero', 'activo', NULL, NULL, 'burgos', 'chile'),
(38306, 'felipe alejandro', 'defensor', 'activo', NULL, NULL, 'salinas', 'chile'),
(38310, 'sergio antonio', 'volante', 'activo', NULL, NULL, 'moreno', 'paraguay'),
(38324, 'baltazar del carmen', 'defensor', 'activo', NULL, NULL, 'astorga', 'chile'),
(38331, 'jose antonio', 'defensor', 'activo', NULL, NULL, 'rojas', 'chile'),
(38338, 'victor hugo', 'volante', 'activo', NULL, NULL, 'sarabia', 'chile'),
(38349, 'alexis alejandro', 'defensor', 'activo', NULL, NULL, 'salazar', 'chile'),
(38367, 'roberto andres', 'defensor', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(38372, 'eric', 'volante', 'activo', NULL, NULL, 'olivares', 'chile'),
(38374, 'manuel arturo', 'delantero', 'activo', NULL, NULL, 'villalobos', 'chile'),
(38388, 'leonel jonathan', 'volante', 'activo', NULL, NULL, 'mena', 'chile'),
(38392, 'cristian', 'arquero', 'activo', NULL, NULL, 'limenza', 'paraguay'),
(38397, 'jorge luis', 'arquero', 'activo', NULL, NULL, 'deschamps', 'chile'),
(38410, 'jorge luis', 'defensor', 'activo', NULL, NULL, 'sotomayor', 'argentina'),
(38422, 'christopher', 'defensor', 'activo', NULL, NULL, 'diaz', 'chile'),
(38526, 'nelson arnaldo', 'defensor', 'activo', NULL, NULL, 'rebolledo', 'chile'),
(38532, 'jorge', 'volante', 'activo', NULL, NULL, 'schwager', 'chile'),
(38770, 'edson raul', 'delantero', 'activo', NULL, NULL, 'puch', 'chile'),
(38773, 'jaime andres', 'delantero', 'activo', NULL, NULL, 'grondona', 'chile'),
(38851, 'juan pablo ezequiel', 'delantero', 'activo', NULL, NULL, 'gomez', 'argentina'),
(38984, 'rodrigo', 'defensor', 'activo', NULL, NULL, 'brito', 'chile'),
(38986, 'rodrigo horacio', 'defensor', 'activo', NULL, NULL, 'jara', 'chile'),
(39248, 'marcelo andres', 'volante', 'activo', NULL, NULL, 'scatolaro', 'chile'),
(39607, 'eric orlando', 'defensor', 'activo', NULL, NULL, 'godoy', 'chile'),
(39610, 'yerko', 'defensor', 'activo', NULL, NULL, 'opazo', 'chile'),
(39614, 'nicolas esteban', 'delantero', 'activo', NULL, NULL, 'medina', 'chile'),
(39617, 'matias leonardo', 'volante-delantero', 'activo', NULL, NULL, 'vidangozzi', 'chile'),
(39845, 'jose miguel', 'defensor', 'activo', NULL, NULL, 'iriarte', 'chile'),
(39864, 'roberto marcos', 'delantero', 'activo', NULL, NULL, 'dovetta', 'argentina'),
(40036, 'erick cristobal', 'volante', 'activo', NULL, NULL, 'pino', 'chile'),
(40094, 'juan pablo', 'delantero', 'activo', NULL, NULL, 'vivanco', 'mexico'),
(40095, 'claudio andres', 'delantero', 'activo', NULL, NULL, 'latorre', 'chile'),
(40208, 'eduardo marcelo', 'volante', 'activo', NULL, NULL, 'aguirre', 'argentina'),
(40254, 'gerardo elias', 'volante', 'activo', NULL, NULL, 'cortes', 'chile'),
(40292, 'victor ismael', 'delantero', 'activo', NULL, NULL, 'sosa', 'argentina'),
(40327, 'mauricio jose', 'volante', 'activo', NULL, NULL, 'yedro', 'argentina'),
(40354, 'sebastian adolfo', 'delantero', 'activo', NULL, NULL, 'ereros', 'argentina'),
(40385, 'ever milton', 'delantero', 'activo', NULL, NULL, 'cantero', 'paraguay'),
(40504, 'luis ignacio', 'arquero', 'activo', NULL, NULL, 'aseff', 'argentina'),
(40535, 'sebastian leonel', 'arquero', 'activo', NULL, NULL, 'cuerdo', 'argentina'),
(40653, 'andres roberto', 'defensor', 'activo', NULL, NULL, 'imperiale', 'argentina'),
(41723, 'sebastian', 'volante-delantero', 'activo', NULL, NULL, 'varas', 'chile'),
(41972, 'bryan', 'delantero', 'activo', NULL, NULL, 'rodriguez', 'uruguay'),
(42110, 'emiliano gabriel', 'volante', 'activo', NULL, NULL, 'vecchio', 'argentina'),
(42126, 'claudio', 'defensor-volante', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(42533, 'diego', 'defensor', 'activo', NULL, NULL, 'rosende', 'chile'),
(42770, 'diego', 'defensor', 'activo', NULL, NULL, 'olate', 'chile'),
(43042, 'mario', 'defensor', 'activo', NULL, NULL, 'pardo', 'chile'),
(44072, 'leandro ivan', 'volante', 'activo', NULL, NULL, 'benegas', 'argentina'),
(44270, 'eduardo alejandro', 'volante', 'activo', NULL, NULL, 'lopez', 'argentina'),
(44357, 'fernando emmanuel', 'volante', 'activo', NULL, NULL, 'de la fuente', 'argentina'),
(44444, 'charles mariano', 'volante-delantero', 'activo', NULL, NULL, 'aranguiz', 'chile'),
(44449, 'carlos alberto', 'volante', 'activo', NULL, NULL, 'lopez', 'chile'),
(44451, 'hugo andres', 'volante', 'activo', NULL, NULL, 'diaz', 'chile'),
(44458, 'david andres', 'arquero', 'activo', NULL, NULL, 'reyes', 'chile'),
(45437, 'pedro alex', 'arquero', 'activo', NULL, NULL, 'carrizo', 'chile'),
(45504, 'jaime sebastian', 'volante', 'activo', NULL, NULL, 'barrientos', 'chile'),
(45685, 'nicolas patricio', 'defensor', 'activo', NULL, NULL, 'ortiz', 'chile'),
(45719, 'juan manuel', 'defensor', 'activo', NULL, NULL, 'marital', 'argentina'),
(46031, 'francisco javier', 'delantero', 'activo', NULL, NULL, 'ibaÑez', 'chile'),
(46500, 'jorge sebastian', 'delantero', 'activo', NULL, NULL, 'saez', 'argentina'),
(46501, 'nicolas emanuel', 'volante', 'activo', NULL, NULL, 'crocce', 'argentina'),
(46571, 'enzo', 'volante', 'activo', NULL, NULL, 'cabrera', 'chile'),
(47565, 'miguel antonio', 'volante', 'activo', NULL, NULL, 'murillo', 'colombia'),
(47984, 'pablo cezar', 'defensor', 'activo', NULL, NULL, 'magalhaes', 'chile'),
(48020, 'cristian rolando', 'delantero', 'activo', NULL, NULL, 'ledesma', 'paraguay'),
(48187, 'maximiliano', 'volante', 'activo', NULL, NULL, 'bajter', 'uruguay'),
(48573, 'carlos humberto', 'delantero', 'activo', NULL, NULL, 'escobar', 'chile'),
(48574, 'jean paul jesus', 'delantero', 'activo', NULL, NULL, 'pineda', 'chile'),
(48578, 'paulo cesar', 'delantero', 'activo', NULL, NULL, 'cardenas', 'chile'),
(48705, 'sebastian alberto', 'arquero', 'activo', NULL, NULL, 'lopez', 'argentina'),
(48716, 'lucas emanuel', 'volante', 'activo', NULL, NULL, 'acosta', 'argentina'),
(48774, 'christian', 'defensor', 'activo', NULL, NULL, 'sepulveda', 'chile'),
(48837, 'isaias ignacio', 'volante', 'activo', NULL, NULL, 'peralta', 'chile'),
(48838, 'fernando patricio', 'volante', 'activo', NULL, NULL, 'cordero', 'chile'),
(48916, 'mauricio alejandro', 'delantero', 'activo', NULL, NULL, 'gomez', 'chile'),
(49132, 'diego', 'delantero', 'activo', NULL, NULL, 'nadaya', 'argentina'),
(49305, 'luis gabriel', 'volante', 'activo', NULL, NULL, 'valenzuela', 'chile'),
(49680, 'javier alejandro', 'volante', 'activo', NULL, NULL, 'capelli', 'argentina'),
(49763, 'nicolas ignacio', 'delantero', 'activo', NULL, NULL, 'millan', 'chile'),
(49764, 'raul alejandro', 'arquero', 'activo', NULL, NULL, 'olivares', 'chile'),
(49765, 'richard andres', 'arquero', 'activo', NULL, NULL, 'leyton', 'chile'),
(49799, 'tomas', 'volante', 'activo', NULL, NULL, 'costa', 'argentina'),
(49841, 'rober antonio', 'defensor', 'activo', NULL, NULL, 'servin', 'paraguay'),
(50070, 'juan eduardo', 'defensor', 'activo', NULL, NULL, 'carvajal', 'chile'),
(50072, 'felipe antonio', 'delantero', 'activo', NULL, NULL, 'peÑaloza', 'chile'),
(50073, 'rene alexis', 'defensor-volante', 'activo', NULL, NULL, 'bugueÑo', 'chile'),
(50258, 'jorge', 'defensor-volante', 'activo', NULL, NULL, 'ampuero', 'chile'),
(51154, 'diego', 'delantero', 'activo', NULL, NULL, 'churin', 'argentina'),
(51174, 'juan pablo', 'volante', 'activo', NULL, NULL, 'miÑo', 'argentina'),
(51425, 'juan rodrigo', 'volante', 'activo', NULL, NULL, 'rojas', 'paraguay'),
(51433, 'nelson alejandro', 'defensor', 'activo', NULL, NULL, 'saavedra', 'chile'),
(51434, 'luis', 'volante', 'activo', NULL, NULL, 'pavez', 'chile'),
(51556, 'alexis maximiliano', 'defensor', 'activo', NULL, NULL, 'machuca', 'argentina'),
(51642, 'david antonio', 'delantero', 'activo', NULL, NULL, 'llanos', 'chile'),
(51646, 'felipe antonio', 'defensor', 'activo', NULL, NULL, 'hernandez', 'chile'),
(51916, 'marcos sebastian', 'delantero', 'activo', NULL, NULL, 'pol', 'argentina'),
(52683, 'cristopher benjamin', 'arquero', 'activo', NULL, NULL, 'toselli', 'chile'),
(52684, 'cristian fernando', 'defensor', 'activo', NULL, NULL, 'suarez', 'chile'),
(52686, 'hans alexis', 'defensor', 'activo', NULL, NULL, 'martinez', 'chile'),
(53285, 'sebastian francisco', 'defensor', 'activo', NULL, NULL, 'montesinos', 'chile'),
(53288, 'edgar alexander', 'delantero', 'activo', NULL, NULL, 'melo', 'chile'),
(53335, 'emmanuel sebastian', 'arquero', 'activo', NULL, NULL, 'vargas', 'chile'),
(53338, 'alfonso cristian', 'defensor', 'activo', NULL, NULL, 'parot', 'chile'),
(53339, 'pablo ignacio', 'volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(53340, 'johan patricio', 'volante', 'activo', NULL, NULL, 'fuentes', 'chile'),
(53519, 'claudio nicolas', 'defensor', 'activo', NULL, NULL, 'calderon', 'chile'),
(53523, 'gerson sebastian', 'delantero', 'activo', NULL, NULL, 'martinez', 'chile'),
(53526, 'pedro emiliano', 'delantero', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(53528, 'daniel', 'volante', 'activo', NULL, NULL, 'briceÑo', 'chile'),
(53582, 'pablo cesar', 'defensor', 'activo', NULL, NULL, 'otarola', 'chile'),
(53913, 'juan carlos', 'volante', 'activo', NULL, NULL, 'maldonado', 'argentina'),
(53922, 'nestor gabriel', 'delantero', 'activo', NULL, NULL, 'martinena', 'argentina'),
(53926, 'axel milton', 'defensor', 'activo', NULL, NULL, 'muller', 'argentina'),
(53939, 'facundo gabriel', 'volante-delantero', 'activo', NULL, NULL, 'coria', 'argentina'),
(54197, 'roberto carlos', 'volante', 'activo', NULL, NULL, 'avalos', 'chile'),
(54235, 'mauricio', 'defensor-volante', 'activo', NULL, NULL, 'prieto', 'uruguay'),
(54498, 'marco antonio', 'volante', 'activo', NULL, NULL, 'medel', 'chile'),
(54552, 'francisco javier', 'volante', 'activo', NULL, NULL, 'piÑa', 'chile'),
(54555, 'marcos patricio', 'delantero', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(54750, 'gervasio daniel', 'defensor-volante', 'activo', NULL, NULL, 'nuÑez', 'argentina'),
(54874, 'henry matias', 'volante', 'activo', NULL, NULL, 'mier', 'uruguay'),
(54914, 'ignacio javier', 'arquero', 'activo', NULL, NULL, 'hasbun', 'chile'),
(54916, 'miguel andres', 'defensor', 'activo', NULL, NULL, 'escalona', 'chile'),
(54919, 'esteban andres', 'defensor-volante', 'activo', NULL, NULL, 'pavez', 'chile'),
(54921, 'sebastian andres', 'volante', 'activo', NULL, NULL, 'ubilla', 'chile'),
(54928, 'carlos alfredo', 'defensor', 'activo', NULL, NULL, 'labrin', 'chile'),
(54933, 'carlos alberto', 'delantero', 'activo', NULL, NULL, 'perez', 'chile'),
(55170, 'luis', 'volante', 'activo', NULL, NULL, 'jimenez', 'chile'),
(55172, 'luis roberto', 'defensor', 'activo', NULL, NULL, 'quijanes', 'chile'),
(55178, 'boris mauricio', 'defensor', 'activo', NULL, NULL, 'aravena', 'chile'),
(55179, 'jorge daniel', 'defensor', 'activo', NULL, NULL, 'aquino', 'paraguay'),
(55184, 'michael fabian', 'volante', 'activo', NULL, NULL, 'rios', 'chile'),
(55186, 'wladimir elias', 'defensor-volante', 'activo', NULL, NULL, 'lopez', 'chile'),
(55191, 'juan elias', 'defensor', 'activo', NULL, NULL, 'riquelme', 'chile'),
(55198, 'wilson eduardo', 'volante', 'activo', NULL, NULL, 'piÑones', 'chile'),
(55265, 'luis rodrigo', 'arquero', 'activo', NULL, NULL, 'santelices', 'chile'),
(55267, 'diego armando', 'defensor', 'activo', NULL, NULL, 'diaz', 'chile'),
(55709, 'osman alexis', 'volante', 'activo', NULL, NULL, 'huerta', 'chile'),
(55739, 'alexis', 'volante', 'activo', NULL, NULL, 'delgado', 'chile'),
(55941, 'andres antonio', 'arquero', 'activo', NULL, NULL, 'parada', 'chile'),
(55974, 'david daniel', 'defensor', 'activo', NULL, NULL, 'fernandez', 'chile'),
(55977, 'rodrigo sebastian', 'volante', 'activo', NULL, NULL, 'celsi', 'chile'),
(56007, 'oscar', 'delantero', 'activo', NULL, NULL, 'salinas', 'chile'),
(56061, 'carlos', 'volante-delantero', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(56195, 'fracisco', 'volante', 'activo', NULL, NULL, 'bahamondes', 'chile'),
(56278, 'diego alonso', 'defensor-volante', 'activo', NULL, NULL, 'diaz', 'chile'),
(56410, 'fabrizio', 'volante', 'activo', NULL, NULL, 'cortes', 'chile'),
(56587, 'carlos alberto', 'arquero', 'activo', NULL, NULL, 'lemus', 'chile'),
(56588, 'marcelo alejandro', 'volante', 'activo', NULL, NULL, 'bolton', 'chile'),
(56600, 'bryan ricardo', 'volante', 'activo', NULL, NULL, 'danessi', 'chile'),
(57565, 'diego', 'arquero', 'activo', NULL, NULL, 'sanchez', 'chile'),
(58513, 'joseph anibal', 'delantero', 'activo', NULL, NULL, 'carvallo', 'chile'),
(58612, 'diego alfonso', 'delantero', 'activo', NULL, NULL, 'barrios suarez', 'paraguay'),
(59235, 'jose eliseo', 'defensor', 'activo', NULL, NULL, 'fleita', 'paraguay'),
(59422, 'leandro', 'delantero', 'activo', NULL, NULL, 'ledesma', 'argentina'),
(60287, 'boris alexis', 'volante', 'activo', NULL, NULL, 'sagredo', 'chile'),
(60490, 'esteban andres', 'volante', 'activo', NULL, NULL, 'carvajal', 'chile'),
(61161, 'emilio ezequiel', 'volante-delantero', 'activo', NULL, NULL, 'hernandez', 'chile'),
(61166, 'patricio', 'volante', 'activo', NULL, NULL, 'lagos', 'chile'),
(61168, 'mauricio', 'arquero', 'activo', NULL, NULL, 'viana caamaÑo', 'chile'),
(61171, 'juan rene', 'defensor', 'activo', NULL, NULL, 'abarca', 'chile'),
(62461, 'nery', 'arquero', 'activo', NULL, NULL, 'veloso', 'chile'),
(62614, 'angelo', 'volante', 'activo', NULL, NULL, 'delgado', 'chile'),
(62617, 'gonzalo', 'defensor', 'activo', NULL, NULL, 'laurer', 'chile'),
(64259, 'marko andres', 'defensor', 'activo', NULL, NULL, 'biskupovic', 'chile'),
(64262, 'matias martin', 'delantero', 'activo', NULL, NULL, 'rubio', 'chile'),
(64266, 'jose hernan', 'volante', 'activo', NULL, NULL, 'barrera', 'chile'),
(64268, 'jose luis', 'arquero', 'activo', NULL, NULL, 'aguilera', 'chile'),
(64271, 'hernan francisco', 'defensor', 'activo', NULL, NULL, 'ponce', 'chile'),
(64274, 'felipe reinaldo', 'defensor', 'activo', NULL, NULL, 'rojas', 'chile'),
(64285, 'ricardo', 'defensor', 'activo', NULL, NULL, 'garrido', 'chile'),
(64291, 'jonathan', 'delantero', 'activo', NULL, NULL, 'dominguez', 'argentina'),
(64530, 'pablo', 'volante', 'activo', NULL, NULL, 'meneses', 'chile'),
(64537, 'ronald damian', 'delantero', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(64538, 'jose david', 'defensor', 'activo', NULL, NULL, 'portillo', 'paraguay'),
(64542, 'diego ignacio', 'volante', 'activo', NULL, NULL, 'martinez', 'chile'),
(64550, 'guillermo', 'arquero', 'activo', NULL, NULL, 'orellana', 'chile'),
(64554, 'jose ignacio', 'arquero', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(64601, 'braulio', 'volante', 'activo', NULL, NULL, 'baeza', 'chile'),
(64610, 'esteban andres', 'volante', 'activo', NULL, NULL, 'bravo', 'chile'),
(64649, 'eduardo anibal', 'delantero', 'activo', NULL, NULL, 'domeneghini', 'argentina'),
(64861, 'brayan camilo', 'delantero', 'activo', NULL, NULL, 'reyes', 'colombia'),
(64868, 'arnaldo andres', 'arquero', 'activo', NULL, NULL, 'gimenez', 'paraguay'),
(64878, 'roberto', 'volante', 'activo', NULL, NULL, 'reyes', 'chile'),
(64880, 'agustin', 'defensor', 'activo', NULL, NULL, 'parra', 'chile'),
(64881, 'eugenio esteban', 'defensor', 'activo', NULL, NULL, 'mena', 'chile'),
(64888, 'jose luis', 'arquero', 'activo', NULL, NULL, 'gamonal', 'chile'),
(64891, 'sebastian', 'volante', 'activo', NULL, NULL, 'dominguez', 'chile'),
(64892, 'cristian andre', 'volante', 'activo', NULL, NULL, 'jelvez', 'chile'),
(64993, 'juan antonio', 'delantero', 'activo', NULL, NULL, 'cabral', 'paraguay'),
(65193, 'rafael', 'volante', 'activo', NULL, NULL, 'caroca', 'chile'),
(65826, 'fernando tomas', 'volante', 'activo', NULL, NULL, 'lazcano', 'chile'),
(65950, 'renald yoriel', 'delantero', 'activo', NULL, NULL, 'addles', 'panama'),
(66871, 'miguel angel', 'volante-delantero', 'activo', NULL, NULL, 'orellana', 'chile'),
(66879, 'christian alberto', 'volante', 'activo', NULL, NULL, 'cuevas', 'peru'),
(66926, 'sebastian', 'defensor-volante', 'activo', NULL, NULL, 'villegas', 'chile'),
(67185, 'sebastian', 'defensor', 'activo', NULL, NULL, 'luna', 'argentina'),
(67532, 'javier', 'volante', 'activo', NULL, NULL, 'vatter', 'argentina'),
(68293, 'renato patricio', 'volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(68505, 'manuel', 'defensor', 'activo', NULL, NULL, 'faundez', 'chile'),
(68676, 'francisco javier', 'delantero', 'activo', NULL, NULL, 'pizarro', 'chile'),
(68677, 'yashir armando', 'volante-delantero', 'activo', NULL, NULL, 'pinto', 'chile'),
(68740, 'diego osvaldo', 'volante', 'activo', NULL, NULL, 'brizuela', 'paraguay'),
(69172, 'sebastian', 'delantero', 'activo', NULL, NULL, 'jaime', 'argentina'),
(69405, 'matias ezequiel', 'volante', 'activo', NULL, NULL, 'banco', 'argentina'),
(69967, 'adolfo justino', 'delantero', 'activo', NULL, NULL, 'lima', 'uruguay'),
(70221, 'sebastian', 'arquero', 'activo', NULL, NULL, 'barraza', 'chile'),
(70222, 'leshter', 'defensor', 'activo', NULL, NULL, 'labarca', 'chile'),
(70225, 'carlos', 'delantero', 'activo', NULL, NULL, 'soza', 'chile'),
(70227, 'matias alberto', 'delantero', 'activo', NULL, NULL, 'sanchez', 'chile'),
(70228, 'elias victor', 'arquero', 'activo', NULL, NULL, 'hartard', 'chile'),
(70254, 'cristian ezequiel', 'volante', 'activo', NULL, NULL, 'canuhe', 'argentina'),
(71096, 'matias jesus', 'defensor-volante', 'activo', NULL, NULL, 'celis', 'chile'),
(71463, 'federico matias', 'volante', 'activo', NULL, NULL, 'scoppa', 'argentina'),
(71480, 'leonardo', 'volante', 'activo', NULL, NULL, 'valencia', 'chile'),
(71481, 'jose', 'delantero', 'activo', NULL, NULL, 'duran', 'chile'),
(71515, 'maximiliano', 'defensor-volante', 'activo', NULL, NULL, 'ceratto', 'argentina'),
(71576, 'humberto', 'delantero', 'activo', NULL, NULL, 'albiÑana', 'argentina'),
(71672, 'maximiliano', 'delantero', 'activo', NULL, NULL, 'alaniz', 'argentina'),
(71802, 'jonathan', 'delantero', 'activo', NULL, NULL, 'guerazar', 'argentina'),
(72014, 'juan carlos martin', 'arquero', 'activo', NULL, NULL, 'caballero', 'espana'),
(72224, 'nicolas', 'delantero', 'activo', NULL, NULL, 'trecco', 'argentina'),
(72270, 'patricio felipe', 'volante', 'activo', NULL, NULL, 'jerez', 'chile'),
(72273, 'felipe andres', 'volante', 'activo', NULL, NULL, 'argel', 'chile'),
(72274, 'franz', 'defensor', 'activo', NULL, NULL, 'schultz', 'chile'),
(72275, 'oscar', 'defensor', 'activo', NULL, NULL, 'opazo', 'chile'),
(72281, 'cristian rodrigo', 'volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(72282, 'jose luis', 'delantero', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(72291, 'jose miguel', 'arquero', 'activo', NULL, NULL, 'acevedo', 'chile'),
(72292, 'boris', 'defensor', 'activo', NULL, NULL, 'sandoval', 'chile'),
(72296, 'marco', 'defensor', 'activo', NULL, NULL, 'hidalgo', 'chile'),
(72342, 'octavio jibran', 'arquero', 'activo', NULL, NULL, 'colmenares', 'mexico'),
(72343, 'adrian alonso', 'delantero', 'activo', NULL, NULL, 'faundez', 'chile'),
(72344, 'bryan alfonso', 'volante', 'activo', NULL, NULL, 'cortes', 'chile'),
(72418, 'misael aldair', 'volante', 'activo', NULL, NULL, 'davila', 'chile'),
(72421, 'francisco fernando', 'delantero', 'activo', NULL, NULL, 'castro', 'chile'),
(72423, 'abraham', 'defensor', 'activo', NULL, NULL, 'gomez', 'chile'),
(72727, 'javier', 'defensor', 'activo', NULL, NULL, 'lemari', 'chile'),
(72802, 'nicolas', 'defensor', 'activo', NULL, NULL, 'berardo', 'argentina'),
(72883, 'carlos esteban', 'delantero', 'activo', NULL, NULL, 'ross', 'chile'),
(73051, 'camilo', 'volante', 'activo', NULL, NULL, 'farias', 'chile'),
(73105, 'pedro', 'defensor', 'activo', NULL, NULL, 'cortes', 'chile'),
(73111, 'gonzalo', 'delantero', 'activo', NULL, NULL, 'soto', 'chile'),
(73193, 'luis alberto', 'volante', 'activo', NULL, NULL, 'acuÑa', 'argentina'),
(73222, 'lorenzo enrique', 'volante', 'activo', NULL, NULL, 'reyes', 'chile'),
(73487, 'isaac', 'delantero', 'activo', NULL, NULL, 'diaz', 'chile'),
(73612, 'marcos ignacio', 'defensor', 'activo', NULL, NULL, 'velazquez', 'chile'),
(73618, 'diego ignacio', 'volante', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(73912, 'rodrigo osvaldo', 'volante', 'activo', NULL, NULL, 'veliz', 'chile'),
(73913, 'christian rodrigo', 'volante', 'activo', NULL, NULL, 'duran', 'chile'),
(73916, 'bladimir arnaldo', 'defensor', 'activo', NULL, NULL, 'fernandez', 'chile'),
(73917, 'andy leandro', 'volante', 'activo', NULL, NULL, 'lacroaix', 'chile'),
(74017, 'gonzalo', 'volante', 'activo', NULL, NULL, 'barriga', 'chile'),
(74221, 'diego alonso', 'volante', 'activo', NULL, NULL, 'sepulveda', 'chile'),
(74636, 'bernardo rodrigo', 'arquero', 'activo', NULL, NULL, 'contreras', 'chile'),
(74830, 'gerardo', 'volante', 'activo', NULL, NULL, 'martinez', 'argentina'),
(74972, 'alvaro sebastian', 'delantero', 'activo', NULL, NULL, 'ramos', 'chile'),
(75151, 'sebastian emanuel', 'delantero', 'activo', NULL, NULL, 'gonzalez', 'argentina'),
(75739, 'leonel', 'volante', 'activo', NULL, NULL, 'guzman', 'chile'),
(75762, 'leonardo benjamin', 'arquero', 'activo', NULL, NULL, 'rayo', 'chile'),
(75763, 'enzo pablo', 'defensor', 'activo', NULL, NULL, 'andia', 'chile'),
(75764, 'matias', 'defensor', 'activo', NULL, NULL, 'navarrete', 'chile'),
(75767, 'claudio elias', 'volante', 'activo', NULL, NULL, 'sepulveda', 'chile'),
(75769, 'santiago', 'volante', 'activo', NULL, NULL, 'dittborn', 'chile'),
(75770, 'cesar', 'volante', 'activo', NULL, NULL, 'valenzuela', 'chile'),
(75777, 'franck', 'delantero', 'activo', NULL, NULL, 'fernandez', 'chile'),
(75799, 'enzo francesco', 'defensor', 'activo', NULL, NULL, 'guerrero', 'chile'),
(76200, 'federico matias', 'delantero', 'activo', NULL, NULL, 'falcone', 'argentina'),
(76281, 'andres', 'volante', 'activo', NULL, NULL, 'robles', 'chile'),
(76392, 'michael', 'volante', 'activo', NULL, NULL, 'lepe', 'chile'),
(76422, 'rodrigo pablo', 'delantero', 'activo', NULL, NULL, 'gattas', 'chile'),
(76891, 'jonathan', 'volante', 'activo', NULL, NULL, 'rebolledo', 'chile'),
(77123, 'claudio andres', 'defensor', 'activo', NULL, NULL, 'jopia', 'chile'),
(77223, 'matias alberto', 'volante', 'activo', NULL, NULL, 'grandis', 'argentina'),
(77316, 'mariano roman', 'volante', 'activo', NULL, NULL, 'berriex', 'argentina'),
(77384, 'freddy eugenio', 'volante', 'activo', NULL, NULL, 'munizaga', 'chile'),
(77411, 'jonathan jesus', 'delantero', 'activo', NULL, NULL, 'bauman', 'argentina'),
(77419, 'david jonathan', 'delantero', 'activo', NULL, NULL, 'escalante', 'argentina'),
(77470, 'sergio ezequiel', 'defensor', 'activo', NULL, NULL, 'velazquez', 'argentina'),
(77539, 'miguel alejandro', 'defensor', 'activo', NULL, NULL, 'sanhueza', 'chile'),
(78341, 'jose antonio', 'delantero', 'activo', NULL, NULL, 'huentelaf', 'chile'),
(78540, 'gerardo', 'volante', 'activo', NULL, NULL, 'navarrete', 'chile'),
(79013, 'matias', 'defensor', 'activo', NULL, NULL, 'blazquez', 'chile'),
(79014, 'nicolas', 'volante', 'activo', NULL, NULL, 'peÑailillo', 'chile'),
(79015, 'franco', 'delantero', 'activo', NULL, NULL, 'ragusa', 'chile'),
(79017, 'claudio andres', 'volante', 'activo', NULL, NULL, 'meneses', 'chile'),
(79022, 'juan andres', 'volante', 'activo', NULL, NULL, 'silva', 'chile'),
(79028, 'nelson', 'defensor', 'activo', NULL, NULL, 'vera', 'chile'),
(79029, 'giacumis', 'volante', 'activo', NULL, NULL, 'kodogiannis', 'chile'),
(79030, 'hector', 'delantero', 'activo', NULL, NULL, 'nuÑez', 'chile'),
(79032, 'luis ignacio', 'defensor', 'activo', NULL, NULL, 'casanova', 'chile'),
(79033, 'juan pablo', 'delantero', 'activo', NULL, NULL, 'carrasco', 'chile'),
(79079, 'matias', 'delantero', 'activo', NULL, NULL, 'donoso', 'chile'),
(79214, 'javier', 'volante', 'activo', NULL, NULL, 'serafini', 'paraguay'),
(79301, 'sebastian', 'delantero', 'activo', NULL, NULL, 'zuÑiga', 'chile'),
(79304, 'patricio antonio', 'volante', 'activo', NULL, NULL, 'troncoso', 'chile'),
(80150, 'sandro estefano', 'delantero', 'activo', NULL, NULL, 'berrios', 'chile'),
(80231, 'luis alberto', 'volante', 'activo', NULL, NULL, 'cabrera', 'chile'),
(80234, 'ignacio segundo', 'delantero', 'activo', NULL, NULL, 'rivera', 'chile'),
(80235, 'francisco javier', 'delantero', 'activo', NULL, NULL, 'sepulveda', 'chile'),
(80553, 'tomas', 'volante', 'activo', NULL, NULL, 'lanzini', 'argentina'),
(80730, 'alejandro alfredo', 'defensor', 'activo', NULL, NULL, 'delfino', 'argentina'),
(80750, 'pablo alejandro', 'volante', 'activo', NULL, NULL, 'parra', 'chile'),
(81137, 'maksim', 'delantero', 'activo', NULL, NULL, 'molokoedov', 'rusia'),
(81215, 'maximiliano alejandro', 'delantero', 'activo', NULL, NULL, 'pizarro', 'chile'),
(81682, 'diego matias', 'arquero', 'activo', NULL, NULL, 'fuentes', 'chile'),
(81832, 'juan pablo', 'volante', 'activo', NULL, NULL, 'passaglia', 'argentina'),
(82168, 'gonzalo', 'arquero', 'activo', NULL, NULL, 'mottura', 'argentina'),
(82189, 'lucas joaquin', 'volante', 'activo', NULL, NULL, 'parodi', 'argentina'),
(82492, 'carlos leonardo', 'delantero', 'activo', NULL, NULL, 'ponce', 'chile'),
(82495, 'sergio', 'defensor', 'activo', NULL, NULL, 'catalan', 'chile'),
(82543, 'alejandro samuel', 'volante', 'activo', NULL, NULL, 'marquez', 'chile'),
(82836, 'juan', 'defensor', 'activo', NULL, NULL, 'andrade', 'chile'),
(82882, 'andres alejandro', 'delantero', 'activo', NULL, NULL, 'vilches', 'chile'),
(83026, 'benjamin fernando', 'defensor-volante', 'activo', NULL, NULL, 'vidal', 'chile'),
(83188, 'eduardo sebastian', 'volante', 'activo', NULL, NULL, 'otarola', 'chile'),
(83223, 'jose antonio', 'arquero', 'activo', NULL, NULL, 'quezada', 'chile'),
(83224, 'alvaro', 'volante', 'activo', NULL, NULL, 'cesped', 'chile'),
(83317, 'matias ignacio', 'defensor', 'activo', NULL, NULL, 'arraigada', 'chile'),
(83318, 'juan carlos', 'volante', 'activo', NULL, NULL, 'lueiza', 'chile'),
(83319, 'felipe', 'delantero', 'activo', NULL, NULL, 'araya', 'chile'),
(83506, 'gabriel oscar', 'volante', 'activo', NULL, NULL, 'moyano', 'argentina'),
(83719, 'javier', 'volante', 'activo', NULL, NULL, 'bustos', 'chile'),
(84673, 'felipe andres', 'volante', 'activo', NULL, NULL, 'mora', 'chile'),
(84676, 'jefferson alexis', 'volante', 'activo', NULL, NULL, 'castillo', 'chile'),
(84678, 'nahuel alexander', 'delantero', 'activo', NULL, NULL, 'donadel', 'argentina'),
(84679, 'felipe', 'delantero', 'activo', NULL, NULL, 'reynero', 'chile'),
(84685, 'alejandro', 'volante', 'activo', NULL, NULL, 'flores', 'chile'),
(84688, 'sebastian', 'volante', 'activo', NULL, NULL, 'rivera', 'chile'),
(84705, 'sebastian', 'defensor', 'activo', NULL, NULL, 'diana', 'uruguay'),
(84783, 'mirko andres', 'volante', 'activo', NULL, NULL, 'opazo', 'chile'),
(84784, 'cesar ignacio', 'volante', 'activo', NULL, NULL, 'pinares', 'chile'),
(85030, 'diego alexis', 'defensor', 'activo', NULL, NULL, 'opazo', 'chile'),
(85032, 'sebastian ignacio', 'defensor', 'activo', NULL, NULL, 'silva', 'chile'),
(85308, 'michael jordan', 'defensor', 'activo', NULL, NULL, 'contreras', 'chile'),
(85311, 'mario anibal', 'volante', 'activo', NULL, NULL, 'sandoval', 'chile'),
(85314, 'andres esteban', 'defensor', 'activo', NULL, NULL, 'reyes', 'chile'),
(85315, 'juan francisco', 'defensor', 'activo', NULL, NULL, 'cornejo', 'chile'),
(85316, 'jorge israel', 'volante', 'activo', NULL, NULL, 'romo', 'chile'),
(85392, 'joao', 'volante', 'activo', NULL, NULL, 'ortiz', 'chile'),
(85423, 'francisco javier', 'defensor', 'activo', NULL, NULL, 'tapia', 'chile'),
(85425, 'luis armando', 'volante', 'activo', NULL, NULL, 'aguirre', 'chile'),
(85514, 'jorge', 'delantero', 'activo', NULL, NULL, 'tapia', 'chile'),
(85515, 'eduardo ignacio', 'volante', 'activo', NULL, NULL, 'leal', 'chile'),
(85640, 'francisco patricio', 'defensor', 'activo', NULL, NULL, 'ugarte', 'chile'),
(85641, 'rodrigo alejandro', 'arquero', 'activo', NULL, NULL, 'paillaqueo', 'chile'),
(85644, 'carlos alberto', 'delantero', 'activo', NULL, NULL, 'escudero', 'chile'),
(85810, 'sebastian ignacio', 'volante', 'activo', NULL, NULL, 'leyton', 'chile'),
(85812, 'giovanni', 'defensor', 'activo', NULL, NULL, 'campusano', 'chile'),
(85846, 'nicolas alexander', 'volante', 'activo', NULL, NULL, 'maturana', 'chile'),
(85938, 'carlos alberto', 'volante', 'activo', NULL, NULL, 'opazo', 'chile'),
(85989, 'cristian alejandro', 'volante', 'activo', NULL, NULL, 'cuevas', 'chile'),
(86874, 'anyelo', 'volante', 'activo', NULL, NULL, 'zagal', 'chile'),
(87083, 'jason alejandro', 'volante', 'activo', NULL, NULL, 'silva', 'chile'),
(87323, 'nicolas manuel', 'delantero', 'activo', NULL, NULL, 'lopez macri', 'argentina'),
(87476, 'pablo', 'volante', 'activo', NULL, NULL, 'tapia', 'chile'),
(87477, 'cristian', 'volante', 'activo', NULL, NULL, 'retamal', 'chile'),
(87777, 'manuel', 'defensor', 'activo', NULL, NULL, 'bravo', 'chile'),
(87793, 'oscar ignacio', 'volante', 'activo', NULL, NULL, 'hernandez', 'chile'),
(87894, 'cesar ezequiel', 'arquero', 'activo', NULL, NULL, 'horst', 'argentina'),
(88095, 'jonathan', 'volante', 'activo', NULL, NULL, 'figueroa', 'chile'),
(88124, 'damian', 'volante', 'activo', NULL, NULL, 'paris', 'argentina'),
(88290, 'ronald', 'volante', 'activo', NULL, NULL, 'de la fuente', 'chile'),
(88365, 'sebastian', 'volante', 'activo', NULL, NULL, 'martinez', 'chile'),
(88366, 'dante hernan', 'volante', 'activo', NULL, NULL, 'martinez', 'chile'),
(88378, 'diego alfonso', 'volante', 'activo', NULL, NULL, 'valdez', 'chile'),
(88529, 'nicolas', 'volante', 'activo', NULL, NULL, 'vargas', 'chile'),
(88574, 'igor', 'defensor', 'activo', NULL, NULL, 'lichnovsky', 'chile'),
(88653, 'mauricio', 'volante', 'activo', NULL, NULL, 'ahumada', 'chile'),
(89129, 'pablo', 'defensor', 'activo', NULL, NULL, 'olivares', 'chile'),
(89135, 'jonathan alejandro', 'arquero', 'activo', NULL, NULL, 'salvador', 'chile'),
(89453, 'pablo andres', 'volante', 'activo', NULL, NULL, 'tamburrini', 'chile'),
(89455, 'rodrigo andres', 'delantero', 'activo', NULL, NULL, 'gaete', 'chile'),
(89456, 'nelson alejandro', 'volante', 'activo', NULL, NULL, 'sepulveda', 'chile'),
(89457, 'alejandro', 'arquero', 'activo', NULL, NULL, 'becerra', 'chile'),
(89459, 'jayson', 'defensor', 'activo', NULL, NULL, 'mena', 'chile'),
(89461, 'nicolas ramon', 'defensor', 'activo', NULL, NULL, 'mancilla', 'chile'),
(89489, 'luciano', 'defensor', 'activo', NULL, NULL, 'gaete', 'chile'),
(89496, 'sebastian', 'volante', 'activo', NULL, NULL, 'rojas', 'chile'),
(89497, 'luis', 'delantero', 'activo', NULL, NULL, 'pacheco', 'chile'),
(89499, 'jaime', 'defensor', 'activo', NULL, NULL, 'jerez', 'chile'),
(89504, 'joel', 'delantero', 'activo', NULL, NULL, 'abrigo', 'chile'),
(89510, 'bryan', 'volante', 'activo', NULL, NULL, 'llanos', 'chile'),
(89514, 'jean david', 'delantero', 'activo', NULL, NULL, 'meneses', 'chile'),
(89517, 'roberto', 'defensor', 'activo', NULL, NULL, 'herrera', 'chile'),
(89518, 'moises', 'volante', 'activo', NULL, NULL, 'vazquez', 'chile'),
(89519, 'juan', 'volante', 'activo', NULL, NULL, 'gutierrez', 'chile'),
(89521, 'patricio', 'delantero', 'activo', NULL, NULL, 'rubio', 'chile'),
(89523, 'maximiliano', 'defensor', 'activo', NULL, NULL, 'gonzalez', 'chile'),
(89837, 'marcelo', 'volante', 'activo', NULL, NULL, 'jorquera', 'chile'),
(89840, 'orlando salvador', 'defensor', 'activo', NULL, NULL, 'gutierrez', 'chile'),
(89841, 'oscar', 'delantero', 'activo', NULL, NULL, 'ortega', 'argentina'),
(89898, 'emerson luis', 'delantero', 'activo', NULL, NULL, 'jorquera', 'chile'),
(90044, 'richard francisco', 'defensor', 'activo', NULL, NULL, 'catrileo', 'chile'),
(90045, 'alvaro fabian', 'delantero', 'activo', NULL, NULL, 'lopez', 'chile'),
(90127, 'rodrigo daniel', 'volante', 'activo', NULL, NULL, 'baez', 'paraguay'),
(90131, 'luis', 'volante', 'activo', NULL, NULL, 'fernandez', 'paraguay'),
(90298, 'pablo patricio', 'defensor', 'activo', NULL, NULL, 'acum', 'chile'),
(90301, 'david', 'delantero', 'activo', NULL, NULL, 'perez', 'chile'),
(90312, 'joaquin', 'arquero', 'activo', NULL, NULL, 'muÑoz', 'chile'),
(90314, 'javier', 'volante', 'activo', NULL, NULL, 'perez', 'chile'),
(90315, 'francisco alberto', 'volante', 'activo', NULL, NULL, 'gaete', 'chile'),
(90316, 'eduardo andres', 'volante', 'activo', NULL, NULL, 'vidal', 'chile'),
(90317, 'matias rodrigo', 'delantero', 'activo', NULL, NULL, 'campos lopez', 'chile'),
(90320, 'cristian', 'volante', 'activo', NULL, NULL, 'pavez', 'chile'),
(90322, 'alex antonio', 'delantero', 'activo', NULL, NULL, 'pinar', 'chile'),
(90334, 'rodrigo andres', 'volante', 'activo', NULL, NULL, 'ureÑa', 'chile'),
(90337, 'luciano', 'volante', 'activo', NULL, NULL, 'araya', 'argentina'),
(90344, 'matias', 'volante', 'activo', NULL, NULL, 'gutierrez', 'chile'),
(91039, 'gonzalo andres', 'volante', 'activo', NULL, NULL, 'rivas', 'chile'),
(91041, 'abraham', 'delantero', 'activo', NULL, NULL, 'vargas', 'chile'),
(91042, 'gino', 'defensor', 'activo', NULL, NULL, 'alucema', 'chile'),
(91043, 'daniel', 'defensor', 'activo', NULL, NULL, 'silva', 'chile'),
(91156, 'axel', 'volante', 'activo', NULL, NULL, 'silva', 'chile'),
(91201, 'bryan', 'volante', 'activo', NULL, NULL, 'cubillos', 'chile'),
(91256, 'alvaro', 'volante', 'activo', NULL, NULL, 'iriarte', 'chile'),
(91314, 'marcos rodrigues', 'delantero', 'activo', NULL, NULL, 'weimar', 'brasil'),
(91498, 'ricardo david', 'arquero', 'activo', NULL, NULL, 'toledo', 'chile'),
(91598, 'roberto jesus', 'delantero', 'activo', NULL, NULL, 'saldias', 'chile'),
(91751, 'juan ignacio', 'delantero', 'activo', NULL, NULL, 'duma', 'argentina'),
(92055, 'felipe andres', 'volante', 'activo', NULL, NULL, 'palacios', 'chile'),
(92097, 'john antonio', 'volante', 'activo', NULL, NULL, 'santander', 'chile'),
(92299, 'jimmy', 'volante', 'activo', NULL, NULL, 'cisternas', 'chile'),
(92351, 'bryan andres', 'defensor', 'activo', NULL, NULL, 'ormeÑo', 'chile'),
(92566, 'ignacio', 'volante', 'activo', NULL, NULL, 'capitani', 'argentina');
INSERT INTO `m_jugador` (`jugador_id`, `jugador_nombres`, `jugador_posicion`, `jugador_estado`, `jugador_n`, `jugador_image_path`, `jugador_apellido`, `jugador_nacionalidad`) VALUES
(92835, 'franco', 'volante', 'activo', NULL, NULL, 'bechtholdt', 'argentina'),
(93008, 'francisco manuel', 'volante', 'activo', NULL, NULL, 'levipan', 'chile'),
(93009, 'luis', 'delantero', 'activo', NULL, NULL, 'cabezas', 'chile'),
(93014, 'diego andres', 'volante', 'activo', NULL, NULL, 'pezoa', 'chile'),
(93061, 'gonzalo', 'delantero', 'activo', NULL, NULL, 'reyes', 'chile'),
(93065, 'carlos', 'volante', 'activo', NULL, NULL, 'guajardo', 'chile'),
(93360, 'francisco jose', 'defensor', 'activo', NULL, NULL, 'bellingi', 'argentina'),
(93400, 'diego alfredo', 'delantero', 'activo', NULL, NULL, 'vallejos', 'chile'),
(93401, 'ruben ignacio', 'delantero', 'activo', NULL, NULL, 'farfan', 'chile'),
(93402, 'marco', 'volante', 'activo', NULL, NULL, 'bolado', 'chile'),
(93403, 'alvaro alejandro', 'volante', 'activo', NULL, NULL, 'delgado', 'chile'),
(93404, 'marcos', 'defensor', 'activo', NULL, NULL, 'contreras', 'chile'),
(93405, 'marcelo alejandro', 'volante', 'activo', NULL, NULL, 'morales', 'chile'),
(93406, 'andres ignacio', 'arquero', 'activo', NULL, NULL, 'gutierrez', 'chile'),
(93544, 'santiago rodolfo', 'delantero', 'activo', NULL, NULL, 'cesanelli', 'argentina'),
(93564, 'leandro', 'volante', 'activo', NULL, NULL, 'sirino', 'uruguay'),
(93569, 'diego', 'volante', 'activo', NULL, NULL, 'borquez', 'chile'),
(93601, 'fabian alejandro', 'volante', 'activo', NULL, NULL, 'beas', 'chile'),
(93728, 'gomes crisostomo', 'defensor', 'activo', NULL, NULL, 'vanderson', 'brasil'),
(93729, 'cristobal jesus', 'delantero', 'activo', NULL, NULL, 'lopez', 'chile'),
(93730, 'sebastian mathias andres', 'delantero', 'activo', NULL, NULL, 'alcalde', 'chile'),
(93731, 'rodrigo ignacio', 'delantero', 'activo', NULL, NULL, 'diaz', 'chile'),
(93732, 'enrique', 'delantero', 'activo', NULL, NULL, 'carvajal', 'chile'),
(93733, 'mikel', 'volante', 'activo', NULL, NULL, 'arguinarena', 'chile'),
(93734, 'salvatore', 'delantero', 'activo', NULL, NULL, 'abarca', 'chile'),
(93735, 'leonel gustavo', 'delantero', 'activo', NULL, NULL, 'lopez', 'argentina');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_marcador_config`
--
CREATE TABLE IF NOT EXISTS `m_marcador_config` (
`m_config_id` int(11) NOT NULL AUTO_INCREMENT,
`m_config_destacar_especial` enum('s','n') DEFAULT NULL,
`m_config_mostrar_inicio` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`m_config_mostrar_termino` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`m_config_mostrar_portada` enum('s','n') DEFAULT NULL,
`m_config_mostrar_status` enum('s','n') DEFAULT NULL,
PRIMARY KEY (`m_config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;
--
-- Volcado de datos para la tabla `m_marcador_config`
--
INSERT INTO `m_marcador_config` (`m_config_id`, `m_config_destacar_especial`, `m_config_mostrar_inicio`, `m_config_mostrar_termino`, `m_config_mostrar_portada`, `m_config_mostrar_status`) VALUES
(1, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(2, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(3, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(4, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(5, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(6, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(7, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(8, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(9, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(10, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(11, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(12, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(13, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(14, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(15, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(16, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(17, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(18, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(19, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(20, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(21, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(22, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(23, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(24, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(25, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(26, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(27, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(28, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(29, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(30, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(31, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(32, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(33, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(34, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(35, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(36, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(37, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(38, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(39, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(40, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(41, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(42, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(43, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(44, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(45, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(46, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(47, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(48, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(49, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(50, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(51, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(52, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(53, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(54, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(55, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(56, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(57, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(58, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(59, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(60, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(61, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(62, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(63, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(64, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(65, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(66, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(67, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(68, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(69, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(70, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(71, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(72, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(73, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(74, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(75, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(76, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(77, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(78, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(79, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(80, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(81, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(82, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(83, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(84, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(85, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(86, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(87, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(88, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(89, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(90, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n'),
(91, 'n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'n', 'n');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_plantel`
--
CREATE TABLE IF NOT EXISTS `m_plantel` (
`jugador_id` int(11) DEFAULT NULL,
`equipo_id` int(11) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`jugador_n` int(11) NOT NULL,
KEY `fk_reference_1` (`jugador_id`),
KEY `fk_reference_17` (`equipo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `m_plantel`
--
INSERT INTO `m_plantel` (`jugador_id`, `equipo_id`, `created_at`, `jugador_n`) VALUES
(26351, 132, '2013-03-04 22:58:24', 0),
(26372, 132, '2013-03-07 22:14:44', 12),
(26360, 132, '2013-03-04 22:58:24', 0),
(26057, 132, '2013-03-04 22:58:24', 0),
(85308, 132, '2013-03-04 22:58:24', 0),
(88574, 132, '2013-03-04 22:58:24', 0),
(47984, 132, '2013-03-04 22:58:24', 0),
(64881, 132, '2013-03-04 22:58:24', 0),
(36175, 132, '2013-03-04 22:58:24', 0),
(26379, 132, '2013-03-04 22:58:24', 0),
(77470, 132, '2013-03-04 22:58:24', 0),
(44444, 132, '2013-03-04 22:58:24', 0),
(34555, 132, '2013-03-04 22:58:24', 0),
(38065, 132, '2013-03-04 22:58:24', 0),
(24218, 132, '2013-03-04 22:58:24', 0),
(400, 132, '2013-03-04 22:58:24', 0),
(88365, 132, '2013-03-04 22:58:24', 0),
(85846, 132, '2013-03-04 22:58:24', 0),
(54921, 132, '2013-03-04 22:58:24', 0),
(90334, 132, '2013-03-04 22:58:24', 0),
(29616, 132, '2013-03-04 22:58:24', 0),
(73487, 132, '2013-03-04 22:58:24', 0),
(91751, 132, '2013-03-04 22:58:24', 0),
(35501, 220, '2013-03-04 22:58:24', 0),
(83223, 220, '2013-03-04 22:58:24', 0),
(54916, 220, '2013-03-04 22:58:24', 0),
(64285, 220, '2013-03-04 22:58:24', 0),
(30808, 220, '2013-03-04 22:58:24', 0),
(42533, 220, '2013-03-04 22:58:24', 0),
(26337, 220, '2013-03-04 22:58:24', 0),
(54197, 220, '2013-03-04 22:58:24', 0),
(26949, 220, '2013-03-04 22:58:24', 0),
(60490, 220, '2013-03-04 22:58:24', 0),
(38388, 220, '2013-03-04 22:58:24', 0),
(93405, 220, '2013-03-04 22:58:24', 0),
(87083, 220, '2013-03-04 22:58:24', 0),
(89453, 220, '2013-03-04 22:58:24', 0),
(71480, 220, '2013-03-04 22:58:24', 0),
(75770, 220, '2013-03-04 22:58:24', 0),
(36143, 220, '2013-03-04 22:58:24', 0),
(26849, 220, '2013-03-04 22:58:24', 0),
(38773, 220, '2013-03-04 22:58:24', 0),
(71802, 220, '2013-03-04 22:58:24', 0),
(33759, 220, '2013-03-04 22:58:24', 0),
(72291, 221, '2013-03-04 22:58:24', 0),
(401, 221, '2013-03-04 22:58:24', 0),
(90044, 221, '2013-03-04 22:58:24', 0),
(19480, 221, '2013-03-04 22:58:24', 0),
(77539, 221, '2013-03-04 22:58:24', 0),
(26103, 221, '2013-03-04 22:58:24', 0),
(52684, 221, '2013-03-04 22:58:24', 0),
(72344, 221, '2013-03-04 22:58:24', 0),
(75769, 221, '2013-03-04 22:58:24', 0),
(53339, 221, '2013-03-04 22:58:24', 0),
(578, 221, '2013-03-04 22:58:24', 0),
(25795, 221, '2013-03-04 22:58:24', 0),
(92055, 221, '2013-03-04 22:58:24', 0),
(79304, 221, '2013-03-04 22:58:24', 0),
(29710, 221, '2013-03-04 22:58:24', 0),
(31405, 221, '2013-03-04 22:58:24', 0),
(90045, 221, '2013-03-04 22:58:24', 0),
(68676, 221, '2013-03-04 22:58:24', 0),
(51916, 221, '2013-03-04 22:58:24', 0),
(4243, 228, '2013-03-04 22:58:24', 0),
(89135, 228, '2013-03-04 22:58:24', 0),
(55179, 228, '2013-03-04 22:58:24', 0),
(55178, 228, '2013-03-04 22:58:24', 0),
(29915, 228, '2013-03-04 22:58:24', 0),
(55974, 228, '2013-03-04 22:58:24', 0),
(26160, 228, '2013-03-04 22:58:24', 0),
(26356, 228, '2013-03-04 22:58:24', 0),
(83719, 228, '2013-03-04 22:58:24', 0),
(56600, 228, '2013-03-04 22:58:24', 0),
(38226, 228, '2013-03-04 22:58:24', 0),
(67532, 228, '2013-03-04 22:58:24', 0),
(26205, 228, '2013-03-04 22:58:24', 0),
(24219, 228, '2013-03-04 22:58:24', 0),
(64291, 228, '2013-03-04 22:58:24', 0),
(53288, 228, '2013-03-04 22:58:24', 0),
(50072, 228, '2013-03-04 22:58:24', 0),
(64262, 228, '2013-03-04 22:58:24', 0),
(44458, 232, '2013-03-04 22:58:24', 0),
(61168, 232, '2013-03-04 22:58:24', 0),
(39607, 232, '2013-03-04 22:58:24', 0),
(31440, 232, '2013-03-04 22:58:24', 0),
(72275, 232, '2013-03-04 22:58:24', 0),
(64880, 232, '2013-03-04 22:58:24', 0),
(54235, 232, '2013-03-04 22:58:24', 0),
(72292, 232, '2013-03-04 22:58:24', 0),
(72274, 232, '2013-03-04 22:58:24', 0),
(26132, 232, '2013-03-04 22:58:24', 0),
(93569, 232, '2013-03-04 22:58:24', 0),
(84676, 232, '2013-03-04 22:58:24', 0),
(92299, 232, '2013-03-04 22:58:24', 0),
(79029, 232, '2013-03-04 22:58:24', 0),
(26268, 232, '2013-03-04 22:58:24', 0),
(76281, 232, '2013-03-04 22:58:24', 0),
(35300, 232, '2013-03-04 22:58:24', 0),
(21260, 232, '2013-03-04 22:58:24', 0),
(79079, 232, '2013-03-04 22:58:24', 0),
(38249, 232, '2013-03-04 22:58:24', 0),
(87323, 232, '2013-03-04 22:58:24', 0),
(91598, 232, '2013-03-04 22:58:24', 0),
(5290, 232, '2013-03-04 22:58:24', 0),
(26118, 241, '2013-03-04 22:58:24', 0),
(26254, 241, '2013-03-04 22:58:24', 0),
(37130, 241, '2013-03-04 22:58:24', 0),
(26123, 241, '2013-03-04 22:58:24', 0),
(54919, 241, '2013-03-04 22:58:24', 0),
(29582, 241, '2013-03-04 22:58:24', 0),
(90127, 241, '2013-03-04 22:58:24', 0),
(65193, 241, '2013-03-04 22:58:24', 0),
(53939, 241, '2013-03-04 22:58:24', 0),
(44357, 241, '2013-03-04 22:58:24', 0),
(26212, 241, '2013-03-04 22:58:24', 0),
(26126, 241, '2013-03-04 22:58:24', 0),
(31326, 241, '2013-03-04 22:58:24', 0),
(90344, 241, '2013-03-04 22:58:24', 0),
(61161, 241, '2013-03-04 22:58:24', 0),
(56061, 241, '2013-03-04 22:58:24', 0),
(84783, 241, '2013-03-04 22:58:24', 0),
(42110, 241, '2013-03-04 22:58:24', 0),
(39617, 241, '2013-03-04 22:58:24', 0),
(30548, 241, '2013-03-04 22:58:24', 0),
(35831, 241, '2013-03-04 22:58:24', 0),
(53523, 241, '2013-03-04 22:58:24', 0),
(34670, 241, '2013-03-04 22:58:24', 0),
(49765, 285, '2013-03-04 22:58:24', 0),
(75762, 285, '2013-03-04 22:58:24', 0),
(87777, 285, '2013-03-04 22:58:24', 0),
(26076, 285, '2013-03-04 22:58:24', 0),
(33060, 285, '2013-03-04 22:58:24', 0),
(75799, 285, '2013-03-04 22:58:24', 0),
(26179, 285, '2013-03-04 22:58:24', 0),
(31491, 285, '2013-03-04 22:58:24', 0),
(93728, 285, '2013-03-04 22:58:24', 0),
(85425, 285, '2013-03-04 22:58:24', 0),
(30526, 285, '2013-03-04 22:58:24', 0),
(19044, 285, '2013-03-04 22:58:24', 0),
(51174, 285, '2013-03-04 22:58:24', 0),
(26385, 285, '2013-03-04 22:58:24', 0),
(36883, 285, '2013-03-04 22:58:24', 0),
(30532, 285, '2013-03-04 22:58:24', 0),
(83319, 285, '2013-03-04 22:58:24', 0),
(14479, 285, '2013-03-04 22:58:24', 0),
(81215, 285, '2013-03-04 22:58:24', 0),
(56007, 285, '2013-03-04 22:58:24', 0),
(85514, 285, '2013-03-04 22:58:24', 0),
(91314, 285, '2013-03-04 22:58:24', 0),
(93406, 307, '2013-03-04 22:58:24', 0),
(52683, 307, '2013-03-04 22:58:24', 0),
(26353, 307, '2013-03-04 22:58:24', 0),
(75763, 307, '2013-03-04 22:58:24', 0),
(64259, 307, '2013-03-04 22:58:24', 0),
(52686, 307, '2013-03-04 22:58:24', 0),
(92351, 307, '2013-03-04 22:58:24', 0),
(53338, 307, '2013-03-04 22:58:24', 0),
(26862, 307, '2013-03-04 22:58:24', 0),
(48838, 307, '2013-03-04 22:58:24', 0),
(49799, 307, '2013-03-04 22:58:24', 0),
(26129, 307, '2013-03-04 22:58:24', 0),
(54874, 307, '2013-03-04 22:58:24', 0),
(19127, 307, '2013-03-04 22:58:24', 0),
(1742, 307, '2013-03-04 22:58:24', 0),
(55184, 307, '2013-03-04 22:58:24', 0),
(75767, 307, '2013-03-04 22:58:24', 0),
(30381, 307, '2013-03-04 22:58:24', 0),
(75777, 307, '2013-03-04 22:58:24', 0),
(74972, 307, '2013-03-04 22:58:24', 0),
(40292, 307, '2013-03-04 22:58:24', 0),
(26232, 316, '2013-03-04 22:58:24', 0),
(26233, 316, '2013-03-04 22:58:24', 0),
(68505, 316, '2013-03-04 22:58:24', 0),
(26381, 316, '2013-03-04 22:58:24', 0),
(67185, 316, '2013-03-04 22:58:24', 0),
(54750, 316, '2013-03-04 22:58:24', 0),
(26190, 316, '2013-03-04 22:58:24', 0),
(85423, 316, '2013-03-04 22:58:24', 0),
(26965, 316, '2013-03-04 22:58:24', 0),
(49680, 316, '2013-03-04 22:58:24', 0),
(587, 316, '2013-03-04 22:58:24', 0),
(6613, 316, '2013-03-04 22:58:24', 0),
(44451, 316, '2013-03-04 22:58:24', 0),
(73051, 316, '2013-03-04 22:58:24', 0),
(44449, 316, '2013-03-04 22:58:24', 0),
(87477, 316, '2013-03-04 22:58:24', 0),
(39248, 316, '2013-03-04 22:58:24', 0),
(79022, 316, '2013-03-04 22:58:24', 0),
(41723, 316, '2013-03-04 22:58:24', 0),
(26133, 316, '2013-03-04 22:58:24', 0),
(86874, 316, '2013-03-04 22:58:24', 0),
(32969, 316, '2013-03-04 22:58:24', 0),
(34414, 316, '2013-03-04 22:58:24', 0),
(37118, 316, '2013-03-04 22:58:24', 0),
(33920, 577, '2013-03-04 22:58:24', 0),
(62461, 577, '2013-03-04 22:58:24', 0),
(61171, 577, '2013-03-04 22:58:24', 0),
(26120, 577, '2013-03-04 22:58:24', 0),
(26258, 577, '2013-03-04 22:58:24', 0),
(54928, 577, '2013-03-04 22:58:24', 0),
(42126, 577, '2013-03-04 22:58:24', 0),
(26355, 577, '2013-03-04 22:58:24', 0),
(26967, 577, '2013-03-04 22:58:24', 0),
(35456, 577, '2013-03-04 22:58:24', 0),
(26340, 577, '2013-03-04 22:58:24', 0),
(29627, 577, '2013-03-04 22:58:24', 0),
(30560, 577, '2013-03-04 22:58:24', 0),
(26066, 577, '2013-03-04 22:58:24', 0),
(73222, 577, '2013-03-04 22:58:24', 0),
(30537, 577, '2013-03-04 22:58:24', 0),
(40327, 577, '2013-03-04 22:58:24', 0),
(76200, 577, '2013-03-04 22:58:24', 0),
(51642, 577, '2013-03-04 22:58:24', 0),
(84679, 577, '2013-03-04 22:58:24', 0),
(41972, 577, '2013-03-04 22:58:24', 0),
(49764, 583, '2013-03-04 22:58:24', 0),
(57565, 583, '2013-03-04 22:58:24', 0),
(50258, 583, '2013-03-04 22:58:24', 0),
(72802, 583, '2013-03-04 22:58:24', 0),
(79032, 583, '2013-03-04 22:58:24', 0),
(89461, 583, '2013-03-04 22:58:24', 0),
(75764, 583, '2013-03-04 22:58:24', 0),
(31881, 583, '2013-03-04 22:58:24', 0),
(66879, 583, '2013-03-04 22:58:24', 0),
(36986, 583, '2013-03-04 22:58:24', 0),
(87793, 583, '2013-03-04 22:58:24', 0),
(88366, 583, '2013-03-04 22:58:24', 0),
(51434, 583, '2013-03-04 22:58:24', 0),
(295, 583, '2013-03-04 22:58:24', 0),
(26369, 583, '2013-03-04 22:58:24', 0),
(72421, 583, '2013-03-04 22:58:24', 0),
(84678, 583, '2013-03-04 22:58:24', 0),
(76422, 583, '2013-03-04 22:58:24', 0),
(69172, 583, '2013-03-04 22:58:24', 0),
(89521, 583, '2013-03-04 22:58:24', 0),
(54914, 612, '2013-03-04 22:58:24', 0),
(85641, 612, '2013-03-04 22:58:24', 0),
(26265, 612, '2013-03-04 22:58:24', 0),
(72727, 612, '2013-03-04 22:58:24', 0),
(36931, 612, '2013-03-04 22:58:24', 0),
(68740, 612, '2013-03-04 22:58:24', 0),
(46571, 612, '2013-03-04 22:58:24', 0),
(36137, 612, '2013-03-04 22:58:24', 0),
(90131, 612, '2013-03-04 22:58:24', 0),
(38310, 612, '2013-03-04 22:58:24', 0),
(83506, 612, '2013-03-04 22:58:24', 0),
(85938, 612, '2013-03-04 22:58:24', 0),
(93014, 612, '2013-03-04 22:58:24', 0),
(3994, 612, '2013-03-04 22:58:24', 0),
(87476, 612, '2013-03-04 22:58:24', 0),
(89504, 612, '2013-03-04 22:58:24', 0),
(71672, 612, '2013-03-04 22:58:24', 0),
(48578, 612, '2013-03-04 22:58:24', 0),
(38210, 612, '2013-03-04 22:58:24', 0),
(38392, 657, '2013-03-04 22:58:24', 0),
(36909, 657, '2013-03-04 22:58:24', 0),
(93360, 657, '2013-03-04 22:58:24', 0),
(36896, 657, '2013-03-04 22:58:24', 0),
(71096, 657, '2013-03-04 22:58:24', 0),
(89489, 657, '2013-03-04 22:58:24', 0),
(89499, 657, '2013-03-04 22:58:24', 0),
(91043, 657, '2013-03-04 22:58:24', 0),
(26402, 657, '2013-03-04 22:58:24', 0),
(84784, 657, '2013-03-04 22:58:24', 0),
(77411, 657, '2013-03-04 22:58:24', 0),
(79033, 657, '2013-03-04 22:58:24', 0),
(77419, 657, '2013-03-04 22:58:24', 0),
(81137, 657, '2013-03-04 22:58:24', 0),
(93061, 657, '2013-03-04 22:58:24', 0),
(35459, 657, '2013-03-04 22:58:24', 0),
(90312, 658, '2013-03-04 22:58:24', 0),
(33932, 658, '2013-03-04 22:58:24', 0),
(29606, 658, '2013-03-04 22:58:24', 0),
(85315, 658, '2013-03-04 22:58:24', 0),
(23688, 658, '2013-03-04 22:58:24', 0),
(26166, 658, '2013-03-04 22:58:24', 0),
(51433, 658, '2013-03-04 22:58:24', 0),
(70254, 658, '2013-03-04 22:58:24', 0),
(55739, 658, '2013-03-04 22:58:24', 0),
(90315, 658, '2013-03-04 22:58:24', 0),
(28165, 658, '2013-03-04 22:58:24', 0),
(64892, 658, '2013-03-04 22:58:24', 0),
(26384, 658, '2013-03-04 22:58:24', 0),
(54498, 658, '2013-03-04 22:58:24', 0),
(84673, 658, '2013-03-04 22:58:24', 0),
(47565, 658, '2013-03-04 22:58:24', 0),
(90314, 658, '2013-03-04 22:58:24', 0),
(30555, 658, '2013-03-04 22:58:24', 0),
(88378, 658, '2013-03-04 22:58:24', 0),
(26367, 658, '2013-03-04 22:58:24', 0),
(64861, 658, '2013-03-04 22:58:24', 0),
(46500, 658, '2013-03-04 22:58:24', 0),
(93400, 658, '2013-03-04 22:58:24', 0),
(30533, 659, '2013-03-04 22:58:24', 0),
(35509, 659, '2013-03-04 22:58:24', 0),
(24643, 659, '2013-03-04 22:58:24', 0),
(50073, 659, '2013-03-04 22:58:24', 0),
(39610, 659, '2013-03-04 22:58:24', 0),
(38526, 659, '2013-03-04 22:58:24', 0),
(5100, 659, '2013-03-04 22:58:24', 0),
(83026, 659, '2013-03-04 22:58:24', 0),
(48716, 659, '2013-03-04 22:58:24', 0),
(74017, 659, '2013-03-04 22:58:24', 0),
(85989, 659, '2013-03-04 22:58:24', 0),
(26404, 659, '2013-03-04 22:58:24', 0),
(55709, 659, '2013-03-04 22:58:24', 0),
(26127, 659, '2013-03-04 22:58:24', 0),
(44270, 659, '2013-03-04 22:58:24', 0),
(79017, 659, '2013-03-04 22:58:24', 0),
(26317, 659, '2013-03-04 22:58:24', 0),
(51425, 659, '2013-03-04 22:58:24', 0),
(60287, 659, '2013-03-04 22:58:24', 0),
(2793, 659, '2013-03-04 22:58:24', 0),
(48573, 659, '2013-03-04 22:58:24', 0),
(64268, 667, '2013-03-04 22:58:24', 0),
(56587, 667, '2013-03-04 22:58:24', 0),
(82836, 667, '2013-03-04 22:58:24', 0),
(73916, 667, '2013-03-04 22:58:24', 0),
(48774, 667, '2013-03-04 22:58:24', 0),
(38410, 667, '2013-03-04 22:58:24', 0),
(90337, 667, '2013-03-04 22:58:24', 0),
(69405, 667, '2013-03-04 22:58:24', 0),
(88095, 667, '2013-03-04 22:58:24', 0),
(72281, 667, '2013-03-04 22:58:24', 0),
(7573, 667, '2013-03-04 22:58:24', 0),
(64530, 667, '2013-03-04 22:58:24', 0),
(29637, 667, '2013-03-04 22:58:24', 0),
(93564, 667, '2013-03-04 22:58:24', 0),
(54555, 667, '2013-03-04 22:58:24', 0),
(40095, 667, '2013-03-04 22:58:24', 0),
(93729, 667, '2013-03-04 22:58:24', 0),
(54933, 667, '2013-03-04 22:58:24', 0),
(79301, 667, '2013-03-04 22:58:24', 0),
(70221, 686, '2013-03-04 22:58:24', 0),
(70228, 686, '2013-03-04 22:58:24', 0),
(85032, 686, '2013-03-04 22:58:24', 0),
(85640, 686, '2013-03-04 22:58:24', 0),
(92566, 686, '2013-03-04 22:58:24', 0),
(83224, 686, '2013-03-04 22:58:24', 0),
(91256, 686, '2013-03-04 22:58:24', 0),
(24231, 686, '2013-03-04 22:58:24', 0),
(83188, 686, '2013-03-04 22:58:24', 0),
(91039, 686, '2013-03-04 22:58:24', 0),
(90316, 686, '2013-03-04 22:58:24', 0),
(71576, 686, '2013-03-04 22:58:24', 0),
(93730, 686, '2013-03-04 22:58:24', 0),
(90317, 686, '2013-03-04 22:58:24', 0),
(93731, 686, '2013-03-04 22:58:24', 0),
(59422, 686, '2013-03-04 22:58:24', 0),
(89514, 686, '2013-03-04 22:58:24', 0),
(40535, 747, '2013-03-04 22:58:24', 0),
(38397, 747, '2013-03-04 22:58:24', 0),
(7307, 747, '2013-03-04 22:58:24', 0),
(38224, 747, '2013-03-04 22:58:24', 0),
(83317, 747, '2013-03-04 22:58:24', 0),
(50070, 747, '2013-03-04 22:58:24', 0),
(27401, 747, '2013-03-04 22:58:24', 0),
(38223, 747, '2013-03-04 22:58:24', 0),
(38290, 747, '2013-03-04 22:58:24', 0),
(36902, 747, '2013-03-04 22:58:24', 0),
(38349, 747, '2013-03-04 22:58:24', 0),
(38306, 747, '2013-03-04 22:58:24', 0),
(53340, 747, '2013-03-04 22:58:24', 0),
(72270, 747, '2013-03-04 22:58:24', 0),
(83318, 747, '2013-03-04 22:58:24', 0),
(74830, 747, '2013-03-04 22:58:24', 0),
(82189, 747, '2013-03-04 22:58:24', 0),
(64878, 747, '2013-03-04 22:58:24', 0),
(89456, 747, '2013-03-04 22:58:24', 0),
(40385, 747, '2013-03-04 22:58:24', 0),
(72343, 747, '2013-03-04 22:58:24', 0),
(53922, 747, '2013-03-04 22:58:24', 0),
(49132, 747, '2013-03-04 22:58:24', 0),
(29285, 747, '2013-03-04 22:58:24', 0),
(48574, 747, '2013-03-04 22:58:24', 0),
(3978, 750, '2013-03-04 22:58:24', 0),
(64554, 750, '2013-03-04 22:58:24', 0),
(91042, 750, '2013-03-04 22:58:24', 0),
(71515, 750, '2013-03-04 22:58:24', 0),
(9797, 750, '2013-03-04 22:58:24', 0),
(89840, 750, '2013-03-04 22:58:24', 0),
(26309, 750, '2013-03-04 22:58:24', 0),
(49841, 750, '2013-03-04 22:58:24', 0),
(73612, 750, '2013-03-04 22:58:24', 0),
(26974, 750, '2013-03-04 22:58:24', 0),
(56195, 750, '2013-03-04 22:58:24', 0),
(79014, 750, '2013-03-04 22:58:24', 0),
(31594, 750, '2013-03-04 22:58:24', 0),
(33241, 750, '2013-03-04 22:58:24', 0),
(85316, 750, '2013-03-04 22:58:24', 0),
(28873, 750, '2013-03-04 22:58:24', 0),
(89518, 750, '2013-03-04 22:58:24', 0),
(58612, 750, '2013-03-04 22:58:24', 0),
(26134, 750, '2013-03-04 22:58:24', 0),
(72282, 750, '2013-03-04 22:58:24', 0),
(82492, 750, '2013-03-04 22:58:24', 0),
(79015, 750, '2013-03-04 22:58:24', 0),
(26253, 794, '2013-03-04 22:58:24', 0),
(53335, 794, '2013-03-04 22:58:24', 0),
(38984, 794, '2013-03-04 22:58:24', 0),
(93404, 794, '2013-03-04 22:58:24', 0),
(250, 794, '2013-03-04 22:58:24', 0),
(396, 794, '2013-03-04 22:58:24', 0),
(25926, 794, '2013-03-04 22:58:24', 0),
(29622, 794, '2013-03-04 22:58:24', 0),
(45685, 794, '2013-03-04 22:58:24', 0),
(30559, 794, '2013-03-04 22:58:24', 0),
(91201, 794, '2013-03-04 22:58:24', 0),
(72418, 794, '2013-03-04 22:58:24', 0),
(93403, 794, '2013-03-04 22:58:24', 0),
(368, 794, '2013-03-04 22:58:24', 0),
(38279, 794, '2013-03-04 22:58:24', 0),
(76891, 794, '2013-03-04 22:58:24', 0),
(38338, 794, '2013-03-04 22:58:24', 0),
(31375, 794, '2013-03-04 22:58:24', 0),
(40354, 794, '2013-03-04 22:58:24', 0),
(89455, 794, '2013-03-04 22:58:24', 0),
(26065, 794, '2013-03-04 22:58:24', 0),
(38770, 794, '2013-03-04 22:58:24', 0),
(91041, 794, '2013-03-04 22:58:24', 0),
(38374, 794, '2013-03-04 22:58:24', 0),
(72014, 795, '2013-03-04 22:58:24', 0),
(74636, 795, '2013-03-04 22:58:24', 0),
(29636, 795, '2013-03-04 22:58:24', 0),
(36922, 795, '2013-03-04 22:58:24', 0),
(85812, 795, '2013-03-04 22:58:24', 0),
(73105, 795, '2013-03-04 22:58:24', 0),
(89517, 795, '2013-03-04 22:58:24', 0),
(77123, 795, '2013-03-04 22:58:24', 0),
(37415, 795, '2013-03-04 22:58:24', 0),
(84685, 795, '2013-03-04 22:58:24', 0),
(85810, 795, '2013-03-04 22:58:24', 0),
(14593, 795, '2013-03-04 22:58:24', 0),
(29640, 795, '2013-03-04 22:58:24', 0),
(92097, 795, '2013-03-04 22:58:24', 0),
(30539, 795, '2013-03-04 22:58:24', 0),
(93732, 795, '2013-03-04 22:58:24', 0),
(38245, 795, '2013-03-04 22:58:24', 0),
(64649, 795, '2013-03-04 22:58:24', 0),
(402, 795, '2013-03-04 22:58:24', 0),
(40094, 795, '2013-03-04 22:58:24', 0),
(38042, 813, '2013-03-04 22:58:24', 0),
(48705, 813, '2013-03-04 22:58:24', 0),
(38324, 813, '2013-03-04 22:58:24', 0),
(80730, 813, '2013-03-04 22:58:24', 0),
(28657, 813, '2013-03-04 22:58:24', 0),
(26398, 813, '2013-03-04 22:58:24', 0),
(26221, 813, '2013-03-04 22:58:24', 0),
(64538, 813, '2013-03-04 22:58:24', 0),
(93402, 813, '2013-03-04 22:58:24', 0),
(80231, 813, '2013-03-04 22:58:24', 0),
(26087, 813, '2013-03-04 22:58:24', 0),
(72270, 813, '2013-03-04 22:58:24', 0),
(53913, 813, '2013-03-04 22:58:24', 0),
(64542, 813, '2013-03-04 22:58:24', 0),
(40036, 813, '2013-03-04 22:58:24', 0),
(38225, 813, '2013-03-04 22:58:24', 0),
(29638, 813, '2013-03-04 22:58:24', 0),
(49305, 813, '2013-03-04 22:58:24', 0),
(28775, 813, '2013-03-04 22:58:24', 0),
(26293, 813, '2013-03-04 22:58:24', 0),
(18686, 813, '2013-03-04 22:58:24', 0),
(85644, 813, '2013-03-04 22:58:24', 0),
(64537, 813, '2013-03-04 22:58:24', 0),
(32008, 813, '2013-03-04 22:58:24', 0),
(80234, 813, '2013-03-04 22:58:24', 0),
(80235, 813, '2013-03-04 22:58:24', 0),
(36998, 813, '2013-03-04 22:58:24', 0),
(81682, 820, '2013-03-04 22:58:24', 0),
(15094, 820, '2013-03-04 22:58:24', 0),
(53285, 820, '2013-03-04 22:58:24', 0),
(89129, 820, '2013-03-04 22:58:24', 0),
(85314, 820, '2013-03-04 22:58:24', 0),
(38331, 820, '2013-03-04 22:58:24', 0),
(26054, 820, '2013-03-04 22:58:24', 0),
(72273, 820, '2013-03-04 22:58:24', 0),
(26084, 820, '2013-03-04 22:58:24', 0),
(46501, 820, '2013-03-04 22:58:24', 0),
(89519, 820, '2013-03-04 22:58:24', 0),
(89837, 820, '2013-03-04 22:58:24', 0),
(80553, 820, '2013-03-04 22:58:24', 0),
(80750, 820, '2013-03-04 22:58:24', 0),
(30723, 820, '2013-03-04 22:58:24', 0),
(48916, 820, '2013-03-04 22:58:24', 0),
(21243, 820, '2013-03-04 22:58:24', 0),
(69967, 820, '2013-03-04 22:58:24', 0),
(38064, 908, '2013-03-04 22:58:24', 0),
(56278, 908, '2013-03-04 22:58:24', 0),
(72423, 908, '2013-03-04 22:58:24', 0),
(37212, 908, '2013-03-04 22:58:24', 0),
(39845, 908, '2013-03-04 22:58:24', 0),
(45719, 908, '2013-03-04 22:58:24', 0),
(55172, 908, '2013-03-04 22:58:24', 0),
(62614, 908, '2013-03-04 22:58:24', 0),
(73913, 908, '2013-03-04 22:58:24', 0),
(26151, 908, '2013-03-04 22:58:24', 0),
(55170, 908, '2013-03-04 22:58:24', 0),
(36512, 908, '2013-03-04 22:58:24', 0),
(35457, 908, '2013-03-04 22:58:24', 0),
(66871, 908, '2013-03-04 22:58:24', 0),
(68677, 908, '2013-03-04 22:58:24', 0),
(79214, 908, '2013-03-04 22:58:24', 0),
(73912, 908, '2013-03-04 22:58:24', 0),
(9292, 908, '2013-03-04 22:58:24', 0),
(80150, 908, '2013-03-04 22:58:24', 0),
(29628, 908, '2013-03-04 22:58:24', 0),
(78341, 908, '2013-03-04 22:58:24', 0),
(45437, 991, '2013-03-04 22:58:24', 0),
(82168, 991, '2013-03-04 22:58:24', 0),
(36991, 991, '2013-03-04 22:58:24', 0),
(26189, 991, '2013-03-04 22:58:24', 0),
(85030, 991, '2013-03-04 22:58:24', 0),
(31251, 991, '2013-03-04 22:58:24', 0),
(26167, 991, '2013-03-04 22:58:24', 0),
(26365, 991, '2013-03-04 22:58:24', 0),
(73193, 991, '2013-03-04 22:58:24', 0),
(53528, 991, '2013-03-04 22:58:24', 0),
(26058, 991, '2013-03-04 22:58:24', 0),
(40254, 991, '2013-03-04 22:58:24', 0),
(88290, 991, '2013-03-04 22:58:24', 0),
(48837, 991, '2013-03-04 22:58:24', 0),
(54552, 991, '2013-03-04 22:58:24', 0),
(84688, 991, '2013-03-04 22:58:24', 0),
(71463, 991, '2013-03-04 22:58:24', 0),
(30542, 991, '2013-03-04 22:58:24', 0),
(46031, 991, '2013-03-04 22:58:24', 0),
(36964, 991, '2013-03-04 22:58:24', 0),
(72224, 991, '2013-03-04 22:58:24', 0),
(89457, 1008, '2013-03-04 22:58:24', 0),
(64868, 1008, '2013-03-04 22:58:24', 0),
(90298, 1008, '2013-03-04 22:58:24', 0),
(26056, 1008, '2013-03-04 22:58:24', 0),
(30112, 1008, '2013-03-04 22:58:24', 0),
(26187, 1008, '2013-03-04 22:58:24', 0),
(43042, 1008, '2013-03-04 22:58:24', 0),
(64271, 1008, '2013-03-04 22:58:24', 0),
(79028, 1008, '2013-03-04 22:58:24', 0),
(48187, 1008, '2013-03-04 22:58:24', 0),
(64266, 1008, '2013-03-04 22:58:24', 0),
(93601, 1008, '2013-03-04 22:58:24', 0),
(44072, 1008, '2013-03-04 22:58:24', 0),
(64610, 1008, '2013-03-04 22:58:24', 0),
(26217, 1008, '2013-03-04 22:58:24', 0),
(65826, 1008, '2013-03-04 22:58:24', 0),
(85392, 1008, '2013-03-04 22:58:24', 0),
(38532, 1008, '2013-03-04 22:58:24', 0),
(65950, 1008, '2013-03-04 22:58:24', 0),
(93401, 1008, '2013-03-04 22:58:24', 0),
(75151, 1008, '2013-03-04 22:58:24', 0),
(29581, 1008, '2013-03-04 22:58:24', 0),
(519, 1358, '2013-03-04 22:58:24', 0),
(64550, 1358, '2013-03-04 22:58:24', 0),
(55267, 1358, '2013-03-04 22:58:24', 0),
(31587, 1358, '2013-03-04 22:58:24', 0),
(72296, 1358, '2013-03-04 22:58:24', 0),
(40653, 1358, '2013-03-04 22:58:24', 0),
(51556, 1358, '2013-03-04 22:58:24', 0),
(89459, 1358, '2013-03-04 22:58:24', 0),
(35267, 1358, '2013-03-04 22:58:24', 0),
(17841, 1358, '2013-03-04 22:58:24', 0),
(40208, 1358, '2013-03-04 22:58:24', 0),
(36988, 1358, '2013-03-04 22:58:24', 0),
(68293, 1358, '2013-03-04 22:58:24', 0),
(76392, 1358, '2013-03-04 22:58:24', 0),
(78540, 1358, '2013-03-04 22:58:24', 0),
(64993, 1358, '2013-03-04 22:58:24', 0),
(58513, 1358, '2013-03-04 22:58:24', 0),
(53526, 1358, '2013-03-04 22:58:24', 0),
(16064, 1358, '2013-03-04 22:58:24', 0),
(36904, 1358, '2013-03-04 22:58:24', 0),
(38291, 2249, '2013-03-04 22:58:24', 0),
(87894, 2249, '2013-03-04 22:58:24', 0),
(91498, 2249, '2013-03-04 22:58:24', 0),
(70222, 2249, '2013-03-04 22:58:24', 0),
(38367, 2249, '2013-03-04 22:58:24', 0),
(42770, 2249, '2013-03-04 22:58:24', 0),
(26155, 2249, '2013-03-04 22:58:24', 0),
(55191, 2249, '2013-03-04 22:58:24', 0),
(64274, 2249, '2013-03-04 22:58:24', 0),
(66926, 2249, '2013-03-04 22:58:24', 0),
(88653, 2249, '2013-03-04 22:58:24', 0),
(56588, 2249, '2013-03-04 22:58:24', 0),
(33256, 2249, '2013-03-04 22:58:24', 0),
(77384, 2249, '2013-03-04 22:58:24', 0),
(90320, 2249, '2013-03-04 22:58:24', 0),
(55198, 2249, '2013-03-04 22:58:24', 0),
(2783, 2249, '2013-03-04 22:58:24', 0),
(72883, 2249, '2013-03-04 22:58:24', 0),
(70227, 2249, '2013-03-04 22:58:24', 0),
(70225, 2249, '2013-03-04 22:58:24', 0),
(72342, 2465, '2013-03-04 22:58:24', 0),
(13931, 2465, '2013-03-04 22:58:24', 0),
(55941, 2465, '2013-03-04 22:58:24', 0),
(79013, 2465, '2013-03-04 22:58:24', 0),
(62617, 2465, '2013-03-04 22:58:24', 0),
(53926, 2465, '2013-03-04 22:58:24', 0),
(93733, 2465, '2013-03-04 22:58:24', 0),
(55977, 2465, '2013-03-04 22:58:24', 0),
(75739, 2465, '2013-03-04 22:58:24', 0),
(85515, 2465, '2013-03-04 22:58:24', 0),
(93008, 2465, '2013-03-04 22:58:24', 0),
(81832, 2465, '2013-03-04 22:58:24', 0),
(38287, 2465, '2013-03-04 22:58:24', 0),
(85311, 2465, '2013-03-04 22:58:24', 0),
(91156, 2465, '2013-03-04 22:58:24', 0),
(88529, 2465, '2013-03-04 22:58:24', 0),
(93734, 2465, '2013-03-04 22:58:24', 0),
(93544, 2465, '2013-03-04 22:58:24', 0),
(38851, 2465, '2013-03-04 22:58:24', 0),
(89898, 2465, '2013-03-04 22:58:24', 0),
(82882, 2465, '2013-03-04 22:58:24', 0),
(40504, 2466, '2013-03-04 22:58:24', 0),
(59235, 2466, '2013-03-04 22:58:24', 0),
(38986, 2466, '2013-03-04 22:58:24', 0),
(55186, 2466, '2013-03-04 22:58:24', 0),
(36993, 2466, '2013-03-04 22:58:24', 0),
(45504, 2466, '2013-03-04 22:58:24', 0),
(56410, 2466, '2013-03-04 22:58:24', 0),
(73917, 2466, '2013-03-04 22:58:24', 0),
(61166, 2466, '2013-03-04 22:58:24', 0),
(88124, 2466, '2013-03-04 22:58:24', 0),
(89496, 2466, '2013-03-04 22:58:24', 0),
(74221, 2466, '2013-03-04 22:58:24', 0),
(93009, 2466, '2013-03-04 22:58:24', 0),
(31688, 2466, '2013-03-04 22:58:24', 0),
(48020, 2466, '2013-03-04 22:58:24', 0),
(39614, 2466, '2013-03-04 22:58:24', 0),
(89497, 2466, '2013-03-04 22:58:24', 0),
(90322, 2466, '2013-03-04 22:58:24', 0),
(73111, 2466, '2013-03-04 22:58:24', 0),
(26231, 2469, '2013-03-04 22:58:24', 0),
(55265, 2469, '2013-03-04 22:58:24', 0),
(82495, 2469, '2013-03-04 22:58:24', 0),
(38422, 2469, '2013-03-04 22:58:24', 0),
(89523, 2469, '2013-03-04 22:58:24', 0),
(51646, 2469, '2013-03-04 22:58:24', 0),
(53582, 2469, '2013-03-04 22:58:24', 0),
(26242, 2469, '2013-03-04 22:58:24', 0),
(92835, 2469, '2013-03-04 22:58:24', 0),
(77223, 2469, '2013-03-04 22:58:24', 0),
(93065, 2469, '2013-03-04 22:58:24', 0),
(38372, 2469, '2013-03-04 22:58:24', 0),
(26345, 2469, '2013-03-04 22:58:24', 0),
(32964, 2469, '2013-03-04 22:58:24', 0),
(51154, 2469, '2013-03-04 22:58:24', 0),
(39864, 2469, '2013-03-04 22:58:24', 0),
(93735, 2469, '2013-03-04 22:58:24', 0),
(90301, 2469, '2013-03-04 22:58:24', 0),
(104, 5812, '2013-03-04 22:58:24', 0),
(64888, 5812, '2013-03-04 22:58:24', 0),
(29635, 5812, '2013-03-04 22:58:24', 0),
(53519, 5812, '2013-03-04 22:58:24', 0),
(84705, 5812, '2013-03-04 22:58:24', 0),
(26172, 5812, '2013-03-04 22:58:24', 0),
(29857, 5812, '2013-03-04 22:58:24', 0),
(64601, 5812, '2013-03-04 22:58:24', 0),
(77316, 5812, '2013-03-04 22:58:24', 0),
(64891, 5812, '2013-03-04 22:58:24', 0),
(73618, 5812, '2013-03-04 22:58:24', 0),
(89510, 5812, '2013-03-04 22:58:24', 0),
(82543, 5812, '2013-03-04 22:58:24', 0),
(30997, 5812, '2013-03-04 22:58:24', 0),
(71481, 5812, '2013-03-04 22:58:24', 0),
(49763, 5812, '2013-03-04 22:58:24', 0),
(79030, 5812, '2013-03-04 22:58:24', 0),
(89841, 5812, '2013-03-04 22:58:24', 0),
(31803, 5812, '2013-03-04 22:58:24', 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_relato`
--
CREATE TABLE IF NOT EXISTS `m_relato` (
`relato_id` int(11) NOT NULL AUTO_INCREMENT,
`fecha_id` int(11) DEFAULT NULL,
`relato_minuto` int(11) DEFAULT NULL,
`relato_metadata_key` enum('nomina','comentario','pitazo','tirolibre','gol','corner','lesionado','penal','cambio') DEFAULT NULL,
`relato_descripcion` text,
PRIMARY KEY (`relato_id`),
KEY `fk_reference_12` (`fecha_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_relato_metadata`
--
CREATE TABLE IF NOT EXISTS `m_relato_metadata` (
`relato_metadata_id` int(11) NOT NULL,
`relato_id` int(11) DEFAULT NULL,
`relato_metadata_key` varchar(100) DEFAULT NULL,
`relato_metadata_value` varchar(200) DEFAULT NULL,
PRIMARY KEY (`relato_metadata_id`),
KEY `fk_reference_11` (`relato_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Restricciones para tablas volcadas
--
--
-- Filtros para la tabla `m_campeonato`
--
ALTER TABLE `m_campeonato`
ADD CONSTRAINT `fk_reference_18` FOREIGN KEY (`fase_anterior_campeonato_id`) REFERENCES `m_campeonato` (`campeonato_id`);
--
-- Filtros para la tabla `m_campeonato_equipo`
--
ALTER TABLE `m_campeonato_equipo`
ADD CONSTRAINT `fk_reference_10` FOREIGN KEY (`campeonato_id`) REFERENCES `m_campeonato` (`campeonato_id`),
ADD CONSTRAINT `fk_reference_9` FOREIGN KEY (`equipo_id`) REFERENCES `m_equipo` (`equipo_id`);
--
-- Filtros para la tabla `m_equipo`
--
ALTER TABLE `m_equipo`
ADD CONSTRAINT `fk_reference_15` FOREIGN KEY (`country_id`) REFERENCES `m_country` (`country_id`),
ADD CONSTRAINT `fk_reference_3` FOREIGN KEY (`estadio_id`) REFERENCES `m_estadio` (`estadio_id`);
--
-- Filtros para la tabla `m_fecha`
--
ALTER TABLE `m_fecha`
ADD CONSTRAINT `fk_reference_13` FOREIGN KEY (`equipo_local_id`) REFERENCES `m_equipo` (`equipo_id`),
ADD CONSTRAINT `fk_reference_14` FOREIGN KEY (`equipo_visita_id`) REFERENCES `m_equipo` (`equipo_id`),
ADD CONSTRAINT `fk_reference_16` FOREIGN KEY (`m_config_id`) REFERENCES `m_marcador_config` (`m_config_id`) ON DELETE CASCADE;
--
-- Filtros para la tabla `m_plantel`
--
ALTER TABLE `m_plantel`
ADD CONSTRAINT `fk_reference_1` FOREIGN KEY (`jugador_id`) REFERENCES `m_jugador` (`jugador_id`),
ADD CONSTRAINT `fk_reference_17` FOREIGN KEY (`equipo_id`) REFERENCES `m_equipo` (`equipo_id`);
--
-- Filtros para la tabla `m_relato`
--
ALTER TABLE `m_relato`
ADD CONSTRAINT `fk_reference_12` FOREIGN KEY (`fecha_id`) REFERENCES `m_fecha` (`fecha_id`);
--
-- Filtros para la tabla `m_relato_metadata`
--
ALTER TABLE `m_relato_metadata`
ADD CONSTRAINT `fk_reference_11` FOREIGN KEY (`relato_id`) REFERENCES `m_relato` (`relato_id`);
/*!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 */;
Raw
query_anfp_tabla_.sql
-- TABLA DE POSICIONES
SELECT equipo_nombre,
PTS,
PJ,
PG,
PE,
(PJ - (PG+PE)) AS 'PP',
GF,
GC,
(GF - GC) AS 'DIFF',
grupo,
campeonato_id
FROM
(
SELECT E.equipo_nombre,
((partidos_ganados * 3) + partidos_empatados) AS 'PTS',
partidos_jugados AS 'PJ',
partidos_ganados AS 'PG',
partidos_empatados AS 'PE',
(
(
SELECT IFNULL(SUM(fecha_goles_local),0)
FROM m_fecha
WHERE equipo_local_id=E.equipo_id
)
+
(
SELECT IFNULL(SUM(fecha_goles_visita),0)
FROM m_fecha
WHERE equipo_visita_id = E.equipo_id
)
) as GF,
(
(
SELECT IFNULL(SUM(fecha_goles_visita),0)
FROM m_fecha
WHERE equipo_local_id=E.equipo_id
)
+
(
SELECT IFNULL(SUM(fecha_goles_local),0)
FROM m_fecha
WHERE equipo_visita_id = E.equipo_id
)
) as GC,
T3.grupo,
T3.campeonato_id
FROM
(
SELECT (T0.p_ganados + T1.p_ganados) AS 'partidos_ganados',
T0.equipo_local_id AS 'equipo_id',
T2.partidos_jugados,
TX.partidos_empatados,
CE.grupo,
CE.campeonato_id
FROM
(
SELECT SUM(CASE
WHEN (F.fecha_goles_local > F.fecha_goles_visita) THEN
1
ELSE
0
END) AS 'p_ganados',
F.equipo_local_id
FROM m_fecha F
WHERE fecha_estado ='finalizado'
GROUP BY F.equipo_local_id
) AS T0
INNER JOIN (
SELECT SUM(CASE
WHEN (F.fecha_goles_visita > F.fecha_goles_local) THEN
1
ELSE
0
END) AS 'p_ganados',
F.equipo_visita_id
FROM m_fecha F
WHERE fecha_estado ='finalizado'
GROUP BY F.equipo_visita_id
) AS T1
ON T0.equipo_local_id = T1.equipo_visita_id
LEFT JOIN (
SELECT (T3.p_empatados + T4.p_empatados) AS 'partidos_empatados',
T3.equipo_local_id AS 'equipo_id'
FROM
(
SELECT SUM(CASE
WHEN (F.fecha_goles_local = F.fecha_goles_visita) THEN
1
ELSE
0
END) AS 'p_empatados',
F.equipo_local_id
FROM m_fecha F
WHERE fecha_estado ='finalizado'
GROUP BY F.equipo_local_id
) AS T3
INNER JOIN (
SELECT SUM(CASE
WHEN (F.fecha_goles_visita = F.fecha_goles_local) THEN
1
ELSE
0
END) AS 'p_empatados',
F.equipo_visita_id
FROM m_fecha F
WHERE fecha_estado ='finalizado'
GROUP BY F.equipo_visita_id
) AS T4
ON T3.equipo_local_id = T4.equipo_visita_id
) AS TX
ON T0.equipo_local_id = TX.equipo_id
INNER JOIN (
SELECT (T0.p_jugados_local + T1.p_jugados_visita) AS 'partidos_jugados',
T0.equipo_local_id
FROM
(
SELECT count(*) AS 'p_jugados_local',
F.equipo_local_id
FROM m_fecha F
WHERE fecha_estado ='finalizado'
GROUP BY F.equipo_local_id
) AS T0
INNER JOIN (
SELECT count(*) AS 'p_jugados_visita',
F.equipo_visita_id
FROM m_fecha F
WHERE fecha_estado ='finalizado'
GROUP BY F.equipo_visita_id
) AS T1
ON T0.equipo_local_id = T1.equipo_visita_id
GROUP BY T0.equipo_local_id
) AS T2
ON T0.equipo_local_id = T2.equipo_local_id AND T1.equipo_visita_id = T2.equipo_local_id
INNER JOIN m_campeonato_equipo CE
ON CE.equipo_id = T2.equipo_local_id
GROUP BY T0.equipo_local_id,
CE.campeonato_id,
CE.grupo
) AS T3
INNER JOIN m_equipo E
ON T3.equipo_id = E.equipo_id
INNER JOIN m_campeonato_equipo __CE
ON E.equipo_id = __CE.equipo_id
INNER JOIN m_campeonato C
ON __CE.campeonato_id = C.campeonato_id
-- PARAMETRO ( EL CAMPEONATO ID A ORDENAR )
WHERE C.campeonato_id = 4
) AS SERVIDOR_CESAR_MORIRA
GROUP BY equipo_nombre,grupo
ORDER BY grupo ASC,
PTS DESC,
DIFF DESC,
GF DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment