Listing 1615

(SELECT *, SUM(punts_kick_total) as punts_kick_totalsum, SUM(punts_kick_yards) as punts_kick_yardssum, 
SUM(punts_kick_inside) as punts_kick_insidesum, SUM(kick_extra_made) as kick_extra_madesum, 
SUM(kick_fg_made) as kick_fg_madesum, SUM(rec_total) as rec_totalsum, SUM(rec_tds) as rec_tdssum, 
SUM(rec_yards) as rec_yardssum, SUM(def_defensed) as def_defensedsum, SUM(def_tacklessolo) as def_tacklessolosum, 
SUM(def_ints) as def_intssum, SUM(def_inttd) as def_inttdsum, SUM(def_sacks) as def_sackssum, SUM(pass_yards) as pass_yardssum, 
SUM(pass_ints) as pass_intssum, SUM(rush_yards) as rush_yardssum, SUM(pass_tds) as pass_tdssum, SUM(rush_tds) as rush_tdssum, 
SUM(fumbles_committed) as fumbles_committedsum, SUM(fumbles_td) as fumbles_tdsum, ROUND(AVG(score), 2) as avgpoints, 
SUM(score) as scoresum, COUNT(*) as totalgames
FROM boxscore_players_nfl p, players_top_nfl t
WHERE p.first = t.first AND p.last = t.last AND t.rank >= '20' AND p.pos NOT LIKE '%running-back%' AND  p.pos NOT LIKE '%wide-receiver%' AND score > '10' AND
DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= p.date
GROUP BY p.first, p.last
ORDER BY score DESC
LIMIT 3)
 
UNION 
(SELECT *, SUM(punts_kick_total) as punts_kick_totalsum, SUM(punts_kick_yards) as punts_kick_yardssum, 
SUM(punts_kick_inside) as punts_kick_insidesum, SUM(kick_extra_made) as kick_extra_madesum, 
SUM(kick_fg_made) as kick_fg_madesum, SUM(rec_total) as rec_totalsum, SUM(rec_tds) as rec_tdssum, 
SUM(rec_yards) as rec_yardssum, SUM(def_defensed) as def_defensedsum, SUM(def_tacklessolo) as def_tacklessolosum, 
SUM(def_ints) as def_intssum, SUM(def_inttd) as def_inttdsum, SUM(def_sacks) as def_sackssum, SUM(pass_yards) as pass_yardssum, 
SUM(pass_ints) as pass_intssum, SUM(rush_yards) as rush_yardssum, SUM(pass_tds) as pass_tdssum, SUM(rush_tds) as rush_tdssum, 
SUM(fumbles_committed) as fumbles_committedsum, SUM(fumbles_td) as fumbles_tdsum, ROUND(AVG(score), 2) as avgpoints, 
SUM(score) as scoresum, COUNT(*) as totalgames
FROM boxscore_players_nfl p, players_top_nfl t
WHERE p.first = t.first AND p.last = t.last AND t.rank >= '25' AND p.pos = 'running-back' AND score > '10' AND
DATE_SUB(CURDATE(),INTERVAL 6 DAY) <= p.date
GROUP BY p.first, p.last
ORDER BY score DESC
LIMIT 4)
 
UNION
(SELECT *, SUM(punts_kick_total) as punts_kick_totalsum, SUM(punts_kick_yards) as punts_kick_yardssum, 
SUM(punts_kick_inside) as punts_kick_insidesum, SUM(kick_extra_made) as kick_extra_madesum, 
SUM(kick_fg_made) as kick_fg_madesum, SUM(rec_total) as rec_totalsum, SUM(rec_tds) as rec_tdssum, 
SUM(rec_yards) as rec_yardssum, SUM(def_defensed) as def_defensedsum, SUM(def_tacklessolo) as def_tacklessolosum, 
SUM(def_ints) as def_intssum, SUM(def_inttd) as def_inttdsum, SUM(def_sacks) as def_sackssum, SUM(pass_yards) as pass_yardssum, 
SUM(pass_ints) as pass_intssum, SUM(rush_yards) as rush_yardssum, SUM(pass_tds) as pass_tdssum, SUM(rush_tds) as rush_tdssum, 
SUM(fumbles_committed) as fumbles_committedsum, SUM(fumbles_td) as fumbles_tdsum, ROUND(AVG(score), 2) as avgpoints, 
SUM(score) as scoresum, COUNT(*) as totalgames
FROM boxscore_players_nfl p, players_top_nfl t
WHERE p.first = t.first AND p.last = t.last AND t.rank >= 35 AND p.pos = 'wide-receiver' AND score > '10' AND
DATE_SUB(CURDATE(),INTERVAL 6 DAY) <= p.date
GROUP BY p.first, p.last
ORDER BY score DESC
LIMIT 3)
 
ORDER BY score DESC