Mannschaftsinfo: CE Sabadell

Deprecated: Creation of dynamic property PlgSystemjsm_bootstrap::$subject is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/plugins/system/jsm_bootstrap/jsm_bootstrap.php on line 85

Deprecated: Creation of dynamic property PlgSystemjsm_bootstrap::$jinput is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/plugins/system/jsm_bootstrap/jsm_bootstrap.php on line 119

Deprecated: Creation of dynamic property PlgSystemjsm_bootstrap::$option is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/plugins/system/jsm_bootstrap/jsm_bootstrap.php on line 120
Mannschaftsinfo: CE Sabadell

Siegfried Galun, Parkstrasse 64, 8720 Knittelfeld, Austria
Deprecated: base64_encode(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Email.php on line 69

Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein.

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 = 7224
ORDER BY s.name DESC, p.name

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

sportsmanagementModelTeamInfo::getSeasons 346 teamid

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 = 5603 AND pt.id = 79430 AND tp.season_id = 111 AND st.season_id = 111 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 = 5603 AND pt.id = 79430 AND tp.season_id = 111 AND st.season_id = 111 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 = 5603 AND pt.id = 79430 AND st.season_id = 111 AND stp.season_id = 111 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 = 5606 AND pt.id = 79470 AND tp.season_id = 112 AND st.season_id = 112 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 = 5606 AND pt.id = 79470 AND tp.season_id = 112 AND st.season_id = 112 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 = 5606 AND pt.id = 79470 AND st.season_id = 112 AND stp.season_id = 112 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 = 5604 AND pt.id = 79452 AND tp.season_id = 112 AND st.season_id = 112 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 = 5604 AND pt.id = 79452 AND tp.season_id = 112 AND st.season_id = 112 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 = 5604 AND pt.id = 79452 AND st.season_id = 112 AND stp.season_id = 112 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 = 5622 AND pt.id = 79733 AND tp.season_id = 89 AND st.season_id = 89 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 = 5622 AND pt.id = 79733 AND tp.season_id = 89 AND st.season_id = 89 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 = 5622 AND pt.id = 79733 AND st.season_id = 89 AND stp.season_id = 89 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 = 5623 AND pt.id = 79753 AND tp.season_id = 90 AND st.season_id = 90 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 = 5623 AND pt.id = 79753 AND tp.season_id = 90 AND st.season_id = 90 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 = 5623 AND pt.id = 79753 AND st.season_id = 90 AND stp.season_id = 90 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 = 5624 AND pt.id = 79769 AND tp.season_id = 91 AND st.season_id = 91 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 = 5624 AND pt.id = 79769 AND tp.season_id = 91 AND st.season_id = 91 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 = 5624 AND pt.id = 79769 AND st.season_id = 91 AND stp.season_id = 91 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 = 5636 AND pt.id = 79962 AND tp.season_id = 92 AND st.season_id = 92 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 = 5636 AND pt.id = 79962 AND tp.season_id = 92 AND st.season_id = 92 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 = 5636 AND pt.id = 79962 AND st.season_id = 92 AND stp.season_id = 92 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 = 5635 AND pt.id = 79942 AND tp.season_id = 94 AND st.season_id = 94 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 = 5635 AND pt.id = 79942 AND tp.season_id = 94 AND st.season_id = 94 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 = 5635 AND pt.id = 79942 AND st.season_id = 94 AND stp.season_id = 94 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 = 5634 AND pt.id = 79930 AND tp.season_id = 93 AND st.season_id = 93 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 = 5634 AND pt.id = 79930 AND tp.season_id = 93 AND st.season_id = 93 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 = 5634 AND pt.id = 79930 AND st.season_id = 93 AND stp.season_id = 93 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 = 5633 AND pt.id = 79910 AND tp.season_id = 95 AND st.season_id = 95 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 = 5633 AND pt.id = 79910 AND tp.season_id = 95 AND st.season_id = 95 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 = 5633 AND pt.id = 79910 AND st.season_id = 95 AND stp.season_id = 95 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 = 5647 AND pt.id = 80135 AND tp.season_id = 181 AND st.season_id = 181 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 = 5647 AND pt.id = 80135 AND tp.season_id = 181 AND st.season_id = 181 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 = 5647 AND pt.id = 80135 AND st.season_id = 181 AND stp.season_id = 181 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 = 5648 AND pt.id = 80143 AND tp.season_id = 132 AND st.season_id = 132 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 = 5648 AND pt.id = 80143 AND tp.season_id = 132 AND st.season_id = 132 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 = 5648 AND pt.id = 80143 AND st.season_id = 132 AND stp.season_id = 132 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 = 5649 AND pt.id = 80169 AND tp.season_id = 133 AND st.season_id = 133 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 = 5649 AND pt.id = 80169 AND tp.season_id = 133 AND st.season_id = 133 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 = 5649 AND pt.id = 80169 AND st.season_id = 133 AND stp.season_id = 133 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 = 5651 AND pt.id = 80198 AND tp.season_id = 196 AND st.season_id = 196 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 = 5651 AND pt.id = 80198 AND tp.season_id = 196 AND st.season_id = 196 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 = 5651 AND pt.id = 80198 AND st.season_id = 196 AND stp.season_id = 196 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 = 5652 AND pt.id = 80212 AND tp.season_id = 197 AND st.season_id = 197 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 = 5652 AND pt.id = 80212 AND tp.season_id = 197 AND st.season_id = 197 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 = 5652 AND pt.id = 80212 AND st.season_id = 197 AND stp.season_id = 197 AND stp.published = 1 AND stp.persontype = 1

Warning: Undefined array key 5 in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/helpers/ranking.php on line 1213

Warning: Undefined array key 5 in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/helpers/ranking.php on line 1213

Warning: Undefined array key 5 in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/helpers/ranking.php on line 1213

Warning: Undefined array key 5 in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/helpers/ranking.php on line 1213

Warning: Undefined array key 5 in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/helpers/ranking.php on line 1213

Warning: Undefined array key 5 in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/helpers/ranking.php on line 1213

Spanien
		Spanien - Primera Division 1948/49

CE Sabadell

Vereinsname: CE Sabadell

Mannschaftsname: CE Sabadell

Kurzname: CE Sabadell

Tipp:

repeat

Saison	Liga	Ligabild	Platz	Gespielt	Punkte	S/U/N	Tore	Spieler	∅ Alter
1987/88	Primera División		19	38	29	9/11/18	27:48	0	0
1986/87	Primera División		3	10	38	5/3/2	10:9	0	0
1986/87	Primera División		17	34	25	7/11/16	28:50	0	0
1971/72	Primera División		18	34	23	7/9/18	27:52	0	0
1970/71	Primera División		13	30	21	8/5/17	28:49	0	0
1969/70	Primera División		13	30	25	10/5/15	31:37	0	0
1968/69	Primera División		4	29	31	10/11/8	33:34	0	0
1967/68	Primera División		12	29	25	10/5/14	33:50	0	0
1966/67	Primera División		7	29	30	11/8/10	35:33	0	0
1965/66	Primera División		14	29	23	10/3/16	30:43	0	0
1948/49	Primera División		14	26	13	5/3/18	43:81	0	0
1947/48	Primera División		12	26	21	9/3/14	41:62	0	0
1946/47	Primera División		5	26	30	11/8/7	42:36	0	0
1944/45	Primera División		14	26	17	6/5/15	30:67	0	0
1943/44	Primera División		10	26	25	11/3/12	53:60	0	0

Liga

Gespielt

S/U/N

Tore

Primera División

422

129 / 93 / 200

491 : 711

Zurück

Eine Komponente für viele Sportarten!

Copyright : © Fussball in Europa
Version : 4.24.00 (diddipoeler)

Ladezeit der Seite: [ 0.315072 ] Sekunden

jDownloads Latest

WM Endrunde 2026

25.05.2026

Deutschland - 2. Bundesliga 2025/26

25.05.2026

Frankreich - Ligue 1 2025/26

25.05.2026

Deutschland - 1. Bundesliga 2025/26

19.05.2026

England - Championship 2025/26

28.06.2025

England- Premier League 2025/26

20.06.2025

Statistik der Sportart

Fußball

Projekte: 4176
Spielorte: 924
Vereine 2975
Spieler 427
Gruppen 103
Spieltage 110930
Spiele 856918

Nächste Meisterschaftsspiele

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_matches/helper.php on line 638

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_matches/helper.php on line 713

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_matches/helper.php on line 638

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_matches/helper.php on line 713

ST - Oberliga Nord 2025/26 - 25. Spieltag

SPSK

Fr, 29. Mai. 2026

18.30 Uhr

ESV Knittelfeld

ESV Knittelfeld SC St. Peter/Freienstein

SC St. Peter/Freienstein

St. Peter/Fr. 2:3

(2:2)

200

ESVM

Fr, 29. Mai. 2026

18.30 Uhr

ESV St. Michael

St. Michael SV St. Lorenzen/Kn.

SV St. Lorenzen/Kn.

St. Lorenzen 0:2

(0:0)

300

Steirische Frauenlandesliga 2025/26 - 22. Spieltag

SPSTSTR

Sa, 30. Mai. 2026

17.00 Uhr

St. Stefan / R.

St. Stefan / R.

USV Signal Girls Seckau

USV Signal Girls Seckau 6:3

(3:3)

50

ST - Gebietsliga Mur 2025/26 - 25. Spieltag

FCRW

So, 31. Mai. 2026

17.00 Uhr

ESV Knittelfeld Juniors II

ESV Knittelfeld Juniors

Neumarkt II 3:0

(1:0)

ST - Oberliga Nord 2025/26 - 26. Spieltag

BSSL

Fr, 05. Juni. 2026

18.30 Uhr

SV St. Lorenzen/Kn.

St. Lorenzen

ESV Knittelfeld

ESV Knittelfeld -:-

ST - Gebietsliga Mur 2025/26 - 26. Spieltag

SPSM

Sa, 06. Juni. 2026

17.00 Uhr

Stadl

Stadl

ESV Knittelfeld Juniors II

ESV Knittelfeld Juniors -:-

Wir benutzen Cookies

Wir nutzen Cookies auf unserer Website. Einige von ihnen sind essenziell für den Betrieb der Seite, während andere uns helfen, diese Website und die Nutzererfahrung zu verbessern (Tracking Cookies). Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.

Akzeptieren Ablehnen

Weitere Informationen | Impressum