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_w_seasonsubleagueteams' doesn't exist]
select cast(Group_Concat(distinct concat(t.teamId, '=', subl.subleagueSex, '|', subl.seasonSubleagueId, '|', subl.subleagueName, '|', subl.subleagueShortName, '|', t.teamName, '|', t.teamShortName) order by subl.subleagueSex, t.teamId separator ',') as char) teams, cr.regionName, l.leagueShortName, c.* from wp_bsjla_clubs c left outer join wp_bsjla_w_seasonsubleagueteams t on t.clubId = c.clubId left outer join wp_bsjla_seasonsubleagues subl on subl.seasonSubleagueId = t.seasonSubleagueId left outer join wp_bsjla_seasonleagues sl on sl.seasonLeagueId = subl.seasonLeagueId and sl.seasonId = '' left outer join wp_bsjla_countryregions cr on cr.regionId = c.clubRegionId left outer join wp_bsjla_leagues l on l.leagueId = sl.leagueId where c.uniId = '' and c.clubType = 'K' and c.clubStatus = '0' and l.leagueId = 'sntl' and Coalesce(c.clubDatUnregister, '') = '' group by c.clubId order by c.clubOwnName;

Seznam klubov in njihovih ekip v ligah
Preskoči na orodno vrstico