Pasted

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;