search

emeraldjava / bhaawp

Wordpress plugin for the Business Houses Athletic Assoication
3 stars 0 forks source link

Top Ten per Division of the League #44

Open emeraldjava opened 10 years ago

emeraldjava commented 10 years ago

Add this sql to an action which dumps the data to a csv file

select leaguedivision,leagueposition,leaguepoints,u.user_nicename,fn.meta_value, ln.meta_value,u.user_email,mobile.meta_value as mobile from wp_bhaa_leaguesummary join wp_users u on u.id=leagueparticipant left JOIN wp_usermeta mobile ON (mobile.user_id=u.id AND mobile.meta_key='bhaa_runner_mobilephone') left JOIN wp_usermeta fn ON (fn.user_id=u.id AND fn.meta_key='first_name') left JOIN wp_usermeta ln ON (ln.user_id=u.id AND ln.meta_key='last_name') where league=3103 and leagueposition<=10 order by leaguedivision,leagueposition

emeraldjava commented 9 years ago

select leaguedivision,leagueposition,leaguepoints,u.user_nicename,fn.meta_value, ln.meta_value,u.user_email,mobile.meta_value as mobile from wp_bhaa_leaguesummary join wp_users u on u.id=leagueparticipant left JOIN wp_usermeta mobile ON (mobile.user_id=u.id AND mobile.meta_key='bhaa_runner_mobilephone') left JOIN wp_usermeta fn ON (fn.user_id=u.id AND fn.meta_key='first_name') left JOIN wp_usermeta ln ON (ln.user_id=u.id AND ln.meta_key='last_name') where league=3786 and leagueposition<=10 order by leaguedivision,leagueposition

emeraldjava commented 9 years ago

with races ran limit of 3

select leaguedivision,leagueposition,leaguepoints,leaguescorecount as racesran,u.user_nicename,fn.meta_value, ln.meta_value,u.user_email,mobile.meta_value as mobile from wp_bhaa_leaguesummary join wp_users u on u.id=leagueparticipant left JOIN wp_usermeta mobile ON (mobile.user_id=u.id AND mobile.meta_key='bhaa_runner_mobilephone') left JOIN wp_usermeta fn ON (fn.user_id=u.id AND fn.meta_key='first_name') left JOIN wp_usermeta ln ON (ln.user_id=u.id AND ln.meta_key='last_name') where league=3786 and leagueposition<=10 and leaguescorecount>=3 order by leaguedivision,leagueposition

emeraldjava commented 8 years ago

select leaguedivision,leagueposition,leaguepoints,leaguescorecount as racesran,u.user_nicename,fn.meta_value, ln.meta_value,u.user_email,mobile.meta_value as mobile from wp_bhaa_leaguesummary join wp_users u on u.id=leagueparticipant left JOIN wp_usermeta mobile ON (mobile.user_id=u.id AND mobile.meta_key='bhaa_runner_mobilephone') left JOIN wp_usermeta fn ON (fn.user_id=u.id AND fn.meta_key='first_name') left JOIN wp_usermeta ln ON (ln.user_id=u.id AND ln.meta_key='last_name') where league=4379 and leagueposition<=10 and leaguescorecount>=3 order by leaguedivision,leagueposition