Warning: pg_query(): Query failed: ERROR: syntax error at or near ")"
LINE 6: ...rs AND (plt.key_leagues=gms.key_leagues or plt.key_leagues=)
^ in /home/kisjunet/htdocs/s/wp/wp-content/themes/iafa/classes/pgdb_conn.php on line 57

Error:SELECT DISTINCT(gma.id), pl.fname, gma.action, gma.min, gma.key_players, gma.key_players2,gms.t1, gms.t2
, pl.lname, tm.name, tm.id as tid, pl2.fname as p2n, pl2.lname as p2l
FROM system.actions AS gma
INNER JOIN system.games AS gms ON gms.id=gma.key_games
INNER JOIN system.players AS pl ON pl.id=gma.key_players
INNER JOIN system.players_teams AS plt ON (plt.key_teams=gms.t1 OR plt.key_teams=gms.t2) AND plt.key_players=gma.key_players AND (plt.key_leagues=gms.key_leagues or plt.key_leagues=)
INNER JOIN system.teams AS tm ON tm.id=plt.key_teams
LEFT JOIN system.players AS pl2 ON pl2.id=gma.key_players2
WHERE gma.key_games = 3641 ORDER BY min ASCError:ERROR: syntax error at or near ")"
LINE 6: ...rs AND (plt.key_leagues=gms.key_leagues or plt.key_leagues=)
^

Warning: pg_num_rows() expects parameter 1 to be resource, boolean given in /home/kisjunet/htdocs/s/wp/wp-content/themes/iafa/php/game/timeline.php on line 15

Random People

Warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
LINE 4: ...s=p.id AND (pt.key_leagues='57' OR pt.key_leagues='') LEFT J...
^ in /home/kisjunet/htdocs/s/wp/wp-content/themes/iafa/classes/pgdb_conn.php on line 57

Error:SELECT
sq.name as team,sq.fname, sq.lname,count(st.id) as games,sq.id,sum(st.s_g) as sg, sum(st.s_a) as sa, sum(st.s_y) as sy, sum(st.s_r) as sr, sum(st.s_o) as so, sum(st.mvp) as mvp, sum(st.mvg) as mvg,
(sum(st.mvg)*10*2 + sum(st.mvp)*10+count(st.id)*10+sum(st.s_g)*10 + sum(st.s_a)*5 + sum(st.s_y)*10*-3 + sum(st.s_r)*10*-5 + sum(st.s_o)*10*-2) as pts
FROM (SELECT t.name,p.id, p.fname, p.lname FROM system.players p INNER JOIN system.players_teams as pt ON pt.key_players=p.id AND (pt.key_leagues='57' OR pt.key_leagues='') LEFT JOIN system.teams t ON t.id=pt.key_teams WHERE p.id IN (SELECT s.key_players FROM system.stats s LEFT JOIN system.games g ON g.id=s.key_games WHERE g.id='3641' AND s.key_teams='149' GROUP BY s.key_players)
) as sq
LEFT JOIN system.stats st ON st.key_players=sq.id
LEFT JOIN system.games g2 ON g2.id=st.key_games
WHERE (g2.key_leagues='57' OR g2.key_leagues='')
AND g2.id='3641' AND st.key_teams='149'
GROUP BY sq.id, sq.fname, sq.lname, sq.name
ORDER BY pts DESC
Error:ERROR: invalid input syntax for integer: ""
LINE 4: ...s=p.id AND (pt.key_leagues='57' OR pt.key_leagues='') LEFT J...
^

Warning: pg_num_rows() expects parameter 1 to be resource, boolean given in /home/kisjunet/htdocs/s/wp/wp-content/themes/iafa/php/game/game_players_list.php on line 29

Football Tigers

Warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
LINE 4: ...s=p.id AND (pt.key_leagues='57' OR pt.key_leagues='') LEFT J...
^ in /home/kisjunet/htdocs/s/wp/wp-content/themes/iafa/classes/pgdb_conn.php on line 57

Error:SELECT
sq.name as team,sq.fname, sq.lname,count(st.id) as games,sq.id,sum(st.s_g) as sg, sum(st.s_a) as sa, sum(st.s_y) as sy, sum(st.s_r) as sr, sum(st.s_o) as so, sum(st.mvp) as mvp, sum(st.mvg) as mvg,
(sum(st.mvg)*10*2 + sum(st.mvp)*10+count(st.id)*10+sum(st.s_g)*10 + sum(st.s_a)*5 + sum(st.s_y)*10*-3 + sum(st.s_r)*10*-5 + sum(st.s_o)*10*-2) as pts
FROM (SELECT t.name,p.id, p.fname, p.lname FROM system.players p INNER JOIN system.players_teams as pt ON pt.key_players=p.id AND (pt.key_leagues='57' OR pt.key_leagues='') LEFT JOIN system.teams t ON t.id=pt.key_teams WHERE p.id IN (SELECT s.key_players FROM system.stats s LEFT JOIN system.games g ON g.id=s.key_games WHERE g.id='3641' AND s.key_teams='186' GROUP BY s.key_players)
) as sq
LEFT JOIN system.stats st ON st.key_players=sq.id
LEFT JOIN system.games g2 ON g2.id=st.key_games
WHERE (g2.key_leagues='57' OR g2.key_leagues='')
AND g2.id='3641' AND st.key_teams='186'
GROUP BY sq.id, sq.fname, sq.lname, sq.name
ORDER BY pts DESC
Error:ERROR: invalid input syntax for integer: ""
LINE 4: ...s=p.id AND (pt.key_leagues='57' OR pt.key_leagues='') LEFT J...
^

Warning: pg_num_rows() expects parameter 1 to be resource, boolean given in /home/kisjunet/htdocs/s/wp/wp-content/themes/iafa/php/game/game_players_list.php on line 29