brewery-futon Team info: St. Peter/Kbg.
×

sportsmanagementModelTeamInfo::getSeasons 344 data 

SELECT pt.id as ptid, pt.team_id as season_team_id, pt.picture, pt.info, pt.project_id AS projectid,pt.points_finally,pt.neg_points_finally,pt.finaltablerank,pt.champion,pt.matches_finally,pt.won_finally,pt.draws_finally,pt.lost_finally,pt.homegoals_finally,pt.guestgoals_finally,p.name as projectname,p.season_id,p.current_round, pt.division_id,s.name as season,t.id as team_id,st.picture as season_picture,l.name as league, t.extended as teamextended, l.country as leaguecountry,CONCAT_WS( ':', p.id, p.alias ) AS project_slug,CONCAT_WS( ':', t.id, t.alias ) AS team_slug
FROM z2o57_sportsmanagement_project_team AS pt 
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.id = pt.team_id
INNER JOIN z2o57_sportsmanagement_team AS t ON t.id = st.team_id 
INNER JOIN z2o57_sportsmanagement_project AS p ON p.id = pt.project_id 
INNER JOIN z2o57_sportsmanagement_season AS s ON s.id = p.season_id 
INNER JOIN z2o57_sportsmanagement_league AS l ON l.id = p.league_id 
WHERE t.id = 3799
ORDER BY s.name DESC, p.name

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid 

28510

sportsmanagementModelTeamInfo::getSeasons 346 teamid 

3799

sportsmanagementModelTeamInfo::getPlayerCount 556 data 

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 2119 AND pt.id = 28510 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 data 

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 2119 AND pt.id = 28510 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 data 

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 2119 AND pt.id = 28510 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 data 

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 2091 AND pt.id = 28102 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 data 

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 2091 AND pt.id = 28102 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 data 

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 2091 AND pt.id = 28102 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1 AND stp.persontype = 1

Soccer Jugend - Murtal U11 2013/14 Jugend - Murtal U11 2013/14    

Team info - St. Peter/Kbg.

TUS St. Peter/Kbg.
Adress: TUS St. Peter/Kbg.,
Greimhalle Weg ,
Steiermark,
8843 Sankt Peter am Kammersberg,
Austria
 
Club name: TUS St. Peter/Kbg.
Club website: http://www.tusstpeter.at/
Team name: St. Peter/Kbg.
Short name: St. P

Beschreibung Projektteam

Beschreibung Stammdaten Team


Additional info

Tip:

History

Season League League picture Rank Played Points W/D/L Goals Player ∅ Age
2013/14 AustriaST - Jugend Murtal TUS St. Peter/Kbg. 2 17 38 12/2/3 80:33 0 0
2013/14 AustriaST - Jugend Murtal TUS St. Peter/Kbg. 1 10 28 9/1/0 59:10 0 0

Summary history by league

League
Played
W/D/L
Goals
ST - Jugend Murtal
27
21 / 3 / 3
139 : 43

Back

A component for many sports!
Copyright : © Fussball in Europa
Version : 4.21.00 (diddipoeler)
Page load time: [ 1.621353 ] seconds

JSM - Modul Vereins Icons (2)

SG Zeltweg A St. Peter/Kbg. Lobmingtal Oberwölz Wellsystem Fohnsdorf SG FC-Murtal/Scheifling Team MM 2008/Kobenz Stadl SG Judenburg B ESV Knittelfeld
 
 
 

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries