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 = 30617SELECT 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 =30617 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