Heckle Sports

Sports Whats your favorite sport?
About Us We want to be your one stop sports spot.
Forum Speak what is on your mind.
Contact Us Come drop us a line.

Sign In

News Updates

Updates go here

Ads go here

Eastern Conference

Atlantic

Boston Celtics
roster schedule
New Jersey Nets
roster schedule
New York Knicks
roster schedule
Philadelphia 76ers
roster schedule
Toronto Raptors
roster schedule

Central

Chicago Bulls
roster schedule
Cleveland Cavaliers
roster schedule
Detroit Pistons
roster schedule
Indiana Pacers
roster schedule
Milwaukee Bucks
roster schedule

South East

Atlanta Hawks
roster schedule
Charlotte Bobcats
roster schedule
Miami Heat
roster schedule
Orlando Magic
roster schedule
Washington Wizards
roster schedule

Western Conference

South West

Dallas Mavericks
roster schedule
Houston Rockets
roster schedule
Memphis Grizzlies
roster schedule
New Orleans Hornets
roster schedule
San Antonio Spurs
roster schedule

North West

Denver Nuggets
roster schedule
Minnesota Timberwolves
roster schedule
Portland Trail Blazers
roster schedule
Oklahoma City Thunder
roster schedule
Utah Jazz
roster schedule

Pacific

Golden State Warriors
roster schedule
Los Angeles Clippers
roster schedule
Los Angeles Lakers
roster schedule
Phoenix Suns
roster schedule
Sacramento Kings
roster schedule

(default) 14 queries took 360 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `teams`	7	7	0
2	DESCRIBE `sports`	2	2	0
3	DESCRIBE `divisions`	2	2	0
4	DESCRIBE `team_xml_datas`	3	3	0
5	DESCRIBE `game_xml_datas`	3	3	0
6	DESCRIBE `team_icons`	4	4	0
7	DESCRIBE `games`	7	7	0
8	DESCRIBE `players`	11	11	0
9	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 11 GROUP BY `Team`.`id`	5	5	210
10	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 12 GROUP BY `Team`.`id`	5	5	60
11	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 13 GROUP BY `Team`.`id`	5	5	20
12	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 9 GROUP BY `Team`.`id`	5	5	40
13	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 10 GROUP BY `Team`.`id`	5	5	20
14	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 14 GROUP BY `Team`.`id`	5	5	10

(default) 14 queries took 360 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `teams`

DESCRIBE `sports`

DESCRIBE `divisions`

DESCRIBE `team_xml_datas`

DESCRIBE `game_xml_datas`

DESCRIBE `team_icons`

DESCRIBE `games`

DESCRIBE `players`

SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 11 GROUP BY `Team`.`id`

210