jCricket Player Bowling Stats

SELECT
jcp.first_name,
jcp.last_name,
jcbo.runs as runs,
jcbo.wickets as wickets,
FORMAT( ( jcbo.runs / jcbo.wickets ),1) as average,
FORMAT( ( jcbo.runs / jcbo.overs   ),1) as economy,
jcf.id as fix_id,
jcf.fix_type,

jcf.a_team_id as away_id,
jcf.h_team_id as home_id,

(SELECT jct.name FROM jos_jcricket_teams jct
WHERE jct.id = jcf.h_team_id LIMIT 1) as home_team,

(SELECT jct.name FROM jos_jcricket_teams jct
WHERE jct.id = jcf.a_team_id LIMIT 1) as away_team

FROM  jos_jcricket_bowling jcbo

LEFT JOIN jos_jcricket_players jcp ON jcp.id = jcbo.player_id
LEFT JOIN jos_jcricket_fixtures jcf ON jcf.id = jcbo.fixture_id

WHERE jcbo.player_id = '20'  ################################### Player ID
AND jcp.enabled = '1'
AND YEAR(jcf.fixture_date) BETWEEN Year('2013-03-01') AND Year('2013-09-30')
#AND jcf.fix_type = '2'

ORDER BY wickets DESC, average ASC;