SELECT fixtures.fixture_id, fixtures.date, fixtures.time, fixtures.datetime, fixtures.game, fixtures.result, fixtures.team1_result, fixtures.team2_result, fixtures.penalty_win, fixtures.team1_id, fixtures.team2_id, fixtures.type, fixtures.status, fixtures.events, fixtures.live, fixtures.description, fixtures.highlight, fixtures.`date`, fixtures.`time`, fixtures.`source`, `competitions`.`continent`, `competitions`.`country`, `competitions`.`competition`, `competitions`.`slug`, `competitions`.`competition`, `competitions`.`abbr` FROM fixtures, competitions, fixture_channel, channels WHERE fixtures.type=competitions.competition_id AND fixtures.fixture_id=fixture_channel.fixture_id AND fixture_channel.channel_id=channels.channel_id AND `datetime` BETWEEN ADDTIME(NOW(),'-06:01') AND ADDDATE(NOW(),'+360') AND ((`live`='Live' ) OR (((`live`='Repeat' OR `live`='Delayed') AND (channels.country LIKE '%|United States|%' OR channels.countries LIKE '%|United States|%' OR channels.countries LIKE '%|International|%')))) AND (team1_id = 1294 OR team2_id = 1294) AND approved = 'Y' GROUP BY `datetime` ORDER BY `datetime` LIMIT 6 Pumas UNAM TV Schedules, Fixtures, Results, News, Squad, Videos :: Live Soccer TV

Live Soccer TV

Live Soccer TV App for iOS
Live Soccer TV App for Android

Pumas de la Universidad Nacional Autonoma de Mexico

Fixtures / Results / TV Schedules / Live Streams


*All times are shown in your local time

News

Dream team? Magic Johnson, Mia Hamm, Tony Robbins, among deep-pocketed ...
Fortune
Dream team? Magic Johnson, Mia Hamm, Tony Robbins, among deep-pocketed investors betting big on soccer in L.A.. by; Brian O'Keefe · @FortuneMagazine. October 30, 2014, 3:01 PM EDT. E-mail; Tweet; Facebook; Google Plus; Linkedin. Share icons.

Newsletter Signup »

Email: Why signup?