Start

WordPress napaka podatkovne zbirke: [Table 's8inka.wp_bsjla_leagues' doesn't exist]
select distinct l.uniId, u.uniName, u.uniShortName, sl.seasonId from wp_bsjla_nationalunis u join wp_bsjla_leagues l on l.uniId = u.uniId join wp_bsjla_seasonleagues sl on sl.leagueId = l.leagueId join wp_bsjla_seasonsubleagues subl on subl.seasonLeagueId = sl.seasonLeagueId where subl.seasonSubleagueId = '1';

WordPress napaka podatkovne zbirke: [Table 's8inka.wp_bsjla_seasonsubleagues' doesn't exist]
select sslg.seasonSubleagueId, sslg.subleagueName, sslg.subleagueCustomName, sslg.location, sslg.clubIdOrganizer, c.clubShortName, s.seasonId, s.seasonName, l.leagueId, l.leagueShortName, lower(sslg.subleagueSex) subleagueSex from wp_bsjla_seasonsubleagues sslg join wp_bsjla_seasonleagues sl on sl.seasonLeagueId = sslg.seasonLeagueId join wp_bsjla_seasons s on s.seasonId = sl.seasonId join wp_bsjla_leagues l on l.leagueId = sl.leagueId left outer join wp_bsjla_clubs c on c.clubId = sslg.clubIdOrganizer where sslg.seasonLeagueId = 'sntl' order by sslg.subleagueSex, sslg.seasonSubleagueId, sslg.subleagueName;

WordPress napaka podatkovne zbirke: [Table 's8inka.wp_bsjla_seasons' doesn't exist]
select seasonId, seasonName, datStart, datEnd, case when current_date() between datStart and datEnd then '1' else '0' end isCurrent from wp_bsjla_seasons order by seasonId desc;

WordPress napaka podatkovne zbirke: [Table 's8inka.wp_bsjla_seasonsubleagues' doesn't exist]
select subl.subleagueName, l.leagueName, l.leagueShortName, l.leagueId, subl.location, subl.clubIdOrganizer, c.clubShortName from wp_bsjla_seasonsubleagues subl join wp_bsjla_seasonleagues sl on sl.seasonLeagueId = subl.seasonLeagueId join wp_bsjla_leagues l on l.leagueId = sl.leagueId left outer join wp_bsjla_clubs c on c.clubId = subl.clubIdOrganizer where subl.seasonSubleagueId = '1'

WordPress napaka podatkovne zbirke: [Table 's8inka.wp_bsjla_seasonsubleaguematches' doesn't exist]
select personId, name, lastName, personSex, playerName, playerImageUrl, leagueId, seasonId, teams, matchGamesWon, matchGamesLost, matchGamesWon+matchGamesLost matchGamesSum, matchGamesWon-matchGamesLost matchGamesDiff, matchGamesWon/(matchGamesWon + matchGamesLost) matchGamesQuot, gameSetsWon, gameSetsLost, gameSetsWon-gameSetsLost gameSetsDiff, gameSetsWon/(gameSetsWon + gameSetsLost) gameSetsQuot, gamePointsWon, gamePointsLost, gamePointsWon-gamePointsLost gamePointsDiff, gamePointsWon/(gamePointsWon + gamePointsLost) gamePointsQuot, yellowCards, redCards from ( select personId, name, lastName, personSex, playerName, playerImageUrl, leagueId, seasonId, cast(Group_Concat(distinct concat(teamId, '=', seasonSubleagueId, '|', teamName) order by teamId separator ',') as char) teams, Sum(matchGamesHome) matchGamesWon, Sum(matchGamesGuest) matchGamesLost, Sum(gameSetsHome) gameSetsWon, Sum(gameSetsGuest) gameSetsLost, Sum(gamePointsHome) gamePointsWon, Sum(gamePointsGuest) gamePointsLost, Sum(yellowCards) yellowCards, Sum(redCards) redCards from ( select gp.personId, p.sex personSex, p.name, p.lastName, concat(p.name, ' ', p.lastName) playerName, p.personImageUrl playerImageUrl, sl.leagueId, sl.seasonId, subl.seasonSubleagueId, m.teamIdHome teamId, t.teamShortName teamName, case when gameWin = '1' then 1 else 0 end matchGamesHome, case when gameWin = '1' then 0 else 1 end matchGamesGuest, g.gameSets1 gameSetsHome, g.gameSets2 gameSetsGuest, g.gamePoints1 gamePointsHome, g.gamePoints2 gamePointsGuest, g.yellowCards1 yellowCards, g.redCards1 redCards from wp_bsjla_seasonsubleaguematches m join wp_bsjla_cmpgames g on g.matchId = m.matchId join wp_bsjla_cmpgameplayers gp on gp.gameId = g.gameId and gp.gamePlayerPos = 1 join wp_bsjla_seasonsubleagues subl on subl.seasonSubleagueId = m.seasonSubleagueId join wp_bsjla_seasonleagueteams t on t.teamId = m.teamIdHome join wp_bsjla_seasonleagues sl on sl.seasonLeagueId = subl.seasonLeagueId join wp_bsjla_leagues l on l.leagueId = sl.leagueId join wp_bsjla_persons p on p.personId = gp.personId union all select gp.personId, p.sex personSex, p.name, p.lastName, concat(p.name, ' ', p.lastName) playerName, p.personImageUrl playerImageUrl, sl.leagueId, sl.seasonId, subl.seasonSubleagueId, m.teamIdGuest teamId, t.teamShortName teamName, case when gameWin = '1' then 0 else 1 end matchGamesHome, case when gameWin = '1' then 1 else 0 end matchGamesGuest, g.gameSets2 gameSetsHome, g.gameSets1 gameSetsGuest, g.gamePoints2 gamePointsHome, g.gamePoints1 gamePointsGuest, g.yellowCards2 yellowCards, g.redCards2 redCards from wp_bsjla_seasonsubleaguematches m join wp_bsjla_cmpgames g on g.matchId = m.matchId join wp_bsjla_cmpgameplayers gp on gp.gameId = g.gameId and gp.gamePlayerPos = 2 join wp_bsjla_seasonsubleagues subl on subl.seasonSubleagueId = m.seasonSubleagueId join wp_bsjla_seasonleagueteams t on t.teamId = m.teamIdGuest join wp_bsjla_seasonleagues sl on sl.seasonLeagueId = subl.seasonLeagueId join wp_bsjla_leagues l on l.leagueId = sl.leagueId join wp_bsjla_persons p on p.personId = gp.personId ) x where leagueId = 'sntl' and seasonId = '' and personSex = 'M' group by personId order by personSex, lastName, name, personId ) y order by matchGamesQuot desc, matchGamesDiff desc, matchGamesWon + matchGamesLost desc, gameSetsQuot desc, gamePointsQuot desc;

WordPress napaka podatkovne zbirke: [Table 's8inka.wp_bsjla_seasonsubleagues' doesn't exist]
select * from wp_bsjla_seasonsubleagues where seasonLeagueId = 'sntl' and subleagueSex = 'M' order by subleagueSex, subleagueName;

Seznam igralk v ligi
Spol: Liga:
# Igralka Ekipa Odigrano Tekme Razlika Kvocient Nizi Razlika Točke Razlika Kartoni
Preskoči na orodno vrstico