/* QED BITCH (of all time, add where clause timeSubmitted BETWEEN $startDate AND $endDate for fixed amounts) top 10 line most meters - SELECT mil,SUM(meters) FROM allproducts GROUP BY mil order by SUM(meters) DESC LIMIT 0,10 least meters - SELECT mil,SUM(meters) FROM allproducts GROUP BY mil order by SUM(meters) ASC LIMIT 0,10 most waste - SELECT mil,SUM(wasteProd) FROM allproducts GROUP BY mil order by SUM(wasteProd) DESC LIMIT 0,10 least waste - SELECT mil,SUM(wasteProd) FROM allproducts GROUP BY mil order by SUM(wasteProd) ASC LIMIT 0,10 most efficient - SELECT mil,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY mil order by eff DESC LIMIT 0,10 least efficient - SELECT mil,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY mil order by eff ASC LIMIT 0,10 top 10 product most meters - SELECT product,SUM(meters) FROM allproducts GROUP BY product order by SUM(meters) DESC LIMIT 0,10 least meters - SELECT product,SUM(meters) FROM allproducts GROUP BY product order by SUM(meters) ASC LIMIT 0,10 most waste - SELECT product,SUM(wasteProd) FROM allproducts GROUP BY product order by SUM(wasteProd) DESC LIMIT 0,10 least waste - SELECT product,SUM(wasteProd) FROM allproducts GROUP BY product order by SUM(wasteProd) ASC LIMIT 0,10 most efficient - SELECT product,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY product order by eff DESC LIMIT 0,10 least efficient - SELECT product,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY product order by eff ASC LIMIT 0,10 top 10 group most meters - SELECT productGroup,SUM(meters) FROM allproducts GROUP BY productGroup order by SUM(meters) DESC LIMIT 0,10 least meters - SELECT productGroup,SUM(meters) FROM allproducts GROUP BY productGroup order by SUM(meters) ASC LIMIT 0,10 most waste - SELECT productGroup,SUM(wasteProd) FROM allproducts GROUP BY productGroup order by SUM(wasteProd) DESC LIMIT 0,10 least waste - SELECT productGroup,SUM(wasteProd) FROM allproducts GROUP BY productGroup order by SUM(wasteProd) ASC LIMIT 0,10 most efficient - SELECT productGroup,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY productGroup order by eff DESC LIMIT 0,10 least efficient - SELECT productGroup,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY productGroup order by eff ASC LIMIT 0,10 top 10 shift most meters - SELECT shift,SUM(meters) FROM allproducts GROUP BY shift order by SUM(meters) DESC LIMIT 0,10 least meters - SELECT shift,SUM(meters) FROM allproducts GROUP BY shift order by SUM(meters) ASC LIMIT 0,10 most waste - SELECT shift,SUM(wasteProd) FROM allproducts GROUP BY shift order by SUM(wasteProd) DESC LIMIT 0,10 least waste - SELECT shift,SUM(wasteProd) FROM allproducts GROUP BY shift order by SUM(wasteProd) ASC LIMIT 0,10 most efficient - SELECT shift,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY shift order by eff DESC LIMIT 0,10 least efficient - SELECT shift,SUM(eff)/count(eff) as eff FROM allproducts where eff <> 0 GROUP BY shift order by eff ASC LIMIT 0,10 created alternate view 'allproducts' that is setup as: timeSubmitted mil shift product productGroup meters wasteProd eff */