Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT jcbo.player_id as pid,
- COUNT(jcbo.player_id) as games,
- SUM(jcbo.overs) as overs,
- SUM(jcbo.maidens) as maidens,
- SUM(jcbo.runs) as runs,
- SUM(jcbo.wickets) as wickets,
- FORMAT( SUM( jcbo.runs ) / (SUM( jcbo.wickets ) ),1) as average,
- FORMAT( SUM( jcbo.runs ) / (SUM( jcbo.overs ) ),1) as economy,
- jcp.first_name,
- jcp.last_name,
- MAX(jcbo.wickets) as max,
- (SELECT jcbo.fixture_id
- FROM jos_jcricket_bowling jcbo
- JOIN jos_jcricket_fixtures jcf ON jcf.id = jcbo.fixture_id
- WHERE jcbo.player_id = pid
- AND jcp.enabled = '1'
- " . $filter_year . " // AND YEAR(jcf.fixture_date) BETWEEN Year('2013-03-01') AND Year('2013-09-30')
- " . $filter_type . " // AND jcf.fix_type = '1'
- ORDER BY jcbo.wickets DESC LIMIT 1) as fixture
- FROM jos_jcricket_bowling jcbo
- JOIN jos_jcricket_players jcp ON jcp.id = jcbo.player_id
- JOIN jos_jcricket_fixtures jcf ON jcf.id = jcbo.fixture_id
- JOIN jos_jcricket_teams jcth ON jcth.id = jcf.h_team_id
- JOIN jos_jcricket_teams jct ON jct.id = jcf.a_team_id
- WHERE jcbo.team_id = " . $team . " // WHERE jcbo.team_id = '1'
- AND jcp.enabled = '1'
- " . $filter_type . " // AND YEAR(jcf.fixture_date) BETWEEN Year('2013-03-01') AND Year('2013-09-30')
- " . $filter_year . " // AND jcf.fix_type = '1'
- GROUP BY jcbo.player_id
- ORDER BY wickets DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement