| Casa | Fuori casa | Tutto | ||||
| Giocate | 19 | 20 | 39 | |||
| Vinte | 7 | 4 | 11 | |||
| Pareggi | 5 | 5 | 10 | |||
| Sconfitte | 7 | 11 | 18 | |||
| Casa | Fuori casa | Tutto | ||||
| Per Match | Total | Per Match | Total | Per Match | Total | |
| Goal | 1.2 | 22 | 1.2 | 23 | 1.2 | 45 |
| Goal concessi | 1.2 | 22 | 2.1 | 41 | 1.6 | 63 |
| Cartellini gialli | 1.9 | 36 | 1.8 | 35 | 1.8 | 71 |
| Cartellini rossi | 0.1 | 1 | 0 | 0 | 1 | |
| Reti inviolate | 0.3 | 6 | 0.1 | 2 | 0.2 | 8 |
| Calci d'angolo | 0 | 0 | 0 | |||
| Falli | 0 | 0 | 0 | |||
| Fuori gioco | 0 | 0 | 0 | |||
| Tiri | 0 | 0 | 0 | |||
| Tiri in porta | 0 | 0 | 0 | |||
Warning: mysqli_query(): (22003/1690): BIGINT UNSIGNED value is out of range in '`autosty3_wp0314`.`a`.`time_out` - `autosty3_wp0314`.`a`.`time_in` - 1' in /home/autosty3/public_html/sport361.it/wp-includes/wp-db.php on line 2169
Errore sul database di WordPress: [BIGINT UNSIGNED value is out of range in '`autosty3_wp0314`.`a`.`time_out` - `autosty3_wp0314`.`a`.`time_in` - 1']
SELECT
a.player_id,
c.post_title as player_name
, b.meta_value as position
, GROUP_CONCAT(DISTINCT a.club_id) as clubs
, SUM( a.goals ) as sum_goals
, SUM( a.goals_penalty ) as sum_goals_penalty
, SUM( a.goals_own ) as sum_goals_own
, SUM( a.card_y ) as sum_card_y, SUM( a.card_yr ) as sum_card_yr, SUM( a.card_r ) as sum_card_r
, SUM( a.assist ) as sum_assists
, SUM( a.goals_conceded ) as sum_conceded
, SUM( CASE WHEN (a.time_out >= a.time_in AND a.time_out = 46 ) THEN ( a.time_out - a.time_in - 1 ) WHEN (a.time_out >= a.time_in AND a.time_in = 46 ) THEN ( a.time_out - a.time_in + 1 ) WHEN (a.time_out >= a.time_in) THEN ( a.time_out - a.time_in ) ELSE 0 END ) as minutes
, SUM( CASE WHEN (a.appearance > 0) THEN 1 ELSE 0 END ) as played, SUM( CASE WHEN (a.appearance = 1 OR a.appearance = 2) THEN 1 ELSE 0 END ) as started
, SUM( CASE WHEN (a.appearance = 1 AND a.goals_conceded = 0 AND b.meta_value = 'g') THEN 1 ELSE 0 END ) as clean_sheets
FROM wpoe_anwpfl_players a
LEFT JOIN wpoe_postmeta b ON a.player_id = b.post_id AND b.meta_key = '_anwpfl_position'
LEFT JOIN wpoe_posts c ON a.player_id = c.ID
WHERE 1=1
AND a.season_id = 226 AND a.club_id = 21975 AND a.competition_status != "friendly" GROUP BY a.player_id ORDER BY player_name
Warning: mysqli_query(): (22003/1690): BIGINT UNSIGNED value is out of range in '`autosty3_wp0314`.`a`.`time_out` - `autosty3_wp0314`.`a`.`time_in` - 1' in /home/autosty3/public_html/sport361.it/wp-includes/wp-db.php on line 2169
Errore sul database di WordPress: [BIGINT UNSIGNED value is out of range in '`autosty3_wp0314`.`a`.`time_out` - `autosty3_wp0314`.`a`.`time_in` - 1']
SELECT
a.player_id,
c.post_title as player_name
, b.meta_value as position
, GROUP_CONCAT(DISTINCT a.club_id) as clubs
, SUM( a.goals ) as sum_goals
, SUM( a.goals_penalty ) as sum_goals_penalty
, SUM( a.goals_own ) as sum_goals_own
, SUM( a.card_y ) as sum_card_y, SUM( a.card_yr ) as sum_card_yr, SUM( a.card_r ) as sum_card_r
, SUM( a.assist ) as sum_assists
, SUM( a.goals_conceded ) as sum_conceded
, SUM( CASE WHEN (a.time_out >= a.time_in AND a.time_out = 46 ) THEN ( a.time_out - a.time_in - 1 ) WHEN (a.time_out >= a.time_in AND a.time_in = 46 ) THEN ( a.time_out - a.time_in + 1 ) WHEN (a.time_out >= a.time_in) THEN ( a.time_out - a.time_in ) ELSE 0 END ) as minutes
, SUM( CASE WHEN (a.appearance > 0) THEN 1 ELSE 0 END ) as played, SUM( CASE WHEN (a.appearance = 1 OR a.appearance = 2) THEN 1 ELSE 0 END ) as started
, SUM( CASE WHEN (a.appearance = 1 AND a.goals_conceded = 0 AND b.meta_value = 'g') THEN 1 ELSE 0 END ) as clean_sheets
FROM wpoe_anwpfl_players a
LEFT JOIN wpoe_postmeta b ON a.player_id = b.post_id AND b.meta_key = '_anwpfl_position'
LEFT JOIN wpoe_posts c ON a.player_id = c.ID
WHERE 1=1
AND a.season_id = 226 AND a.club_id = 21975 AND a.competition_status != "friendly" GROUP BY a.player_id ORDER BY player_name
