SELECT c.id, c.sport_id, s.name AS sport_name, c.club_id, c.is_guest, cl.name AS club_name,
c.name, c.gender, cl.image, c.short as short_name, comp.event_id
FROM teams AS c
INNER JOIN sports AS s ON c.sport_id = s.id
INNER JOIN clubs AS cl ON cl.id = c.club_id
INNER JOIN team_rankings AS tr ON tr.team_id = c.id
INNER JOIN competitions as comp on tr.comp_id=comp.id
WHERE c.id = 25443SELECT p.id, p.id AS person_id, p.fname, p.lname, p.image, p.gender, p.type, p.position, p.other, tp.team_id, per.role, tp.number
FROM `teams` AS t
INNER JOIN team_rankings AS tr ON tr.team_id = t.id
INNER JOIN competitions AS c ON c.id = tr.comp_id
INNER JOIN team_players tp ON t.id = tp.team_id
INNER JOIN people_event_role AS per ON per.event = c.event_id
inner join people as p on p.id=tp.player_id
AND tp.player_id = per.person
WHERE t.id =25443 group by p.id, role
order by role
Notice: Trying to get property 'event_id' of non-object in /home/furkispo/stranice/eusa/pages/team/team.php on line 22
SELECT e.*, s.image as sport_logo FROM events as e
LEFT JOIN sports as s on s.id=e.sport_id
WHERE e.id =
Fatal error: Uncaught Error: Call to a member function execute() on bool in /home/furkispo/stranice/eusa/includes/classes/dbobject.class.php:24
Stack trace:
#0 /home/furkispo/stranice/eusa/includes/classes/event.class.php(44): DatabaseObject::find_by_sql()
#1 /home/furkispo/stranice/eusa/pages/team/team.php(22): Event::getSingle()
#2 /home/furkispo/stranice/eusa/includes/classes/functions.php(177): require_once('/home/furkispo/...')
#3 /home/furkispo/stranice/eusa/index.php(10): render_page()
#4 {main}
thrown in /home/furkispo/stranice/eusa/includes/classes/dbobject.class.php on line 24