****************** Raw Report File ****************** -- Chicken -- This lists all the products that cost -- more than a given price. USE nbc; SELECT ROUND(SUM(Ta),2) AS total_Ta, ROUND(SUM(Te),2) AS total_Te, ROUND(SUM(Ap),2) AS total_Ap, ROUND(SUM(Si),2) AS total_Si, ROUND(SUM(Cr),2) AS total_Cr, ROUND(SUM(total),2) AS weighed_grand_total, team from results INNER JOIN dishes_to_team on results.unique_dish_id = dishes_to_team.unique_dish_id WHERE category="Chicken" GROUP BY team ORDER BY weighed_grand_total DESC, total_Ta DESC, total_Te DESC, total_Ap DESC, total_Cr DESC ****************** Macros ****************** Array ( ) ****************** All Report Options ****************** Array ( [Filters] => Array ( ) [Variables] => Array ( ) [Includes] => Array ( ) [Name] => Chicken [Type] => Pdo [Database] => pdo [Environment] => main [Environments] => Array ( [0] => Array ( [name] => main [selected] => 1 ) ) [Query_Formatted] => 
USE nbc; 
SELECT 
  ROUND(
    SUM(Ta), 
    2
  ) AS total_Ta, 
  ROUND(
    SUM(Te), 
    2
  ) AS total_Te, 
  ROUND(
    SUM(Ap), 
    2
  ) AS total_Ap, 
  ROUND(
    SUM(Si), 
    2
  ) AS total_Si, 
  ROUND(
    SUM(Cr), 
    2
  ) AS total_Cr, 
  ROUND(
    SUM(total), 
    2
  ) AS weighed_grand_total, 
  team 
from 
  results 
  INNER JOIN dishes_to_team on results.unique_dish_id = dishes_to_team.unique_dish_id 
WHERE 
  category = "Chicken" 
GROUP BY 
  team 
ORDER BY 
  weighed_grand_total DESC, 
  total_Ta DESC, 
  total_Te DESC, 
  total_Ap DESC, 
  total_Cr DESC
[time_estimate] => Array ( [times] => Array ( [0] => 0.02432 [1] => 0.02474 [2] => 0.02557 [3] => 0.02649 [4] => 0.02669 [5] => 0.0267 [6] => 0.02708 [7] => 0.02874 [8] => 0.02903 [9] => 0.03056 [10] => 0.03694 ) [count] => 11 [min] => 0.02 [max] => 0.04 [median] => 0.03 [average] => 0.03 [q1] => 0.03 [q3] => 0.03 [iqr] => 0 [sum] => 0.31 [stdev] => 0 ) ) ****************** Generated Query ****************** USE nbc; SELECT ROUND(SUM(Ta),2) AS total_Ta, ROUND(SUM(Te),2) AS total_Te, ROUND(SUM(Ap),2) AS total_Ap, ROUND(SUM(Si),2) AS total_Si, ROUND(SUM(Cr),2) AS total_Cr, ROUND(SUM(total),2) AS weighed_grand_total, team from results INNER JOIN dishes_to_team on results.unique_dish_id = dishes_to_team.unique_dish_id WHERE category="Chicken" GROUP BY team ORDER BY weighed_grand_total DESC, total_Ta DESC, total_Te DESC, total_Ap DESC, total_Cr DESC ****************** Report Rows ****************** Array ( [0] => Array ( [rows] => Array ( [0] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 45.00 [filtered_value] => 45.00 [html_value] => 45.00 [chart_value] => 45.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 46.00 [filtered_value] => 46.00 [html_value] => 46.00 [chart_value] => 46.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 44.55 [filtered_value] => 44.55 [html_value] => 44.55 [chart_value] => 44.55 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => GRILLER UNCHAINED [filtered_value] => GRILLER UNCHAINED [html_value] => GRILLER UNCHAINED [chart_value] => GRILLER UNCHAINED [is_html] => [type] => [class] => ) ) [first] => 1 ) [1] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 45.00 [filtered_value] => 45.00 [html_value] => 45.00 [chart_value] => 45.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 49.00 [filtered_value] => 49.00 [html_value] => 49.00 [chart_value] => 49.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 38.00 [filtered_value] => 38.00 [html_value] => 38.00 [chart_value] => 38.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 44.25 [filtered_value] => 44.25 [html_value] => 44.25 [chart_value] => 44.25 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => BOARS [filtered_value] => BOARS [html_value] => BOARS [chart_value] => BOARS [is_html] => [type] => [class] => ) ) [first] => ) [2] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 45.00 [filtered_value] => 45.00 [html_value] => 45.00 [chart_value] => 45.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 42.30 [filtered_value] => 42.30 [html_value] => 42.30 [chart_value] => 42.30 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => BARBECUE MANTUA GANG [filtered_value] => BARBECUE MANTUA GANG [html_value] => BARBECUE MANTUA GANG [chart_value] => BARBECUE MANTUA GANG [is_html] => [type] => [class] => ) ) [first] => ) [3] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 45.00 [filtered_value] => 45.00 [html_value] => 45.00 [chart_value] => 45.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 41.95 [filtered_value] => 41.95 [html_value] => 41.95 [chart_value] => 41.95 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => SANTA MUERTE [filtered_value] => SANTA MUERTE [html_value] => SANTA MUERTE [chart_value] => SANTA MUERTE [is_html] => [type] => [class] => ) ) [first] => ) [4] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 41.00 [filtered_value] => 41.00 [html_value] => 41.00 [chart_value] => 41.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 39.00 [filtered_value] => 39.00 [html_value] => 39.00 [chart_value] => 39.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 40.40 [filtered_value] => 40.40 [html_value] => 40.40 [chart_value] => 40.40 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => ALL YOU CAN SMOKE [filtered_value] => ALL YOU CAN SMOKE [html_value] => ALL YOU CAN SMOKE [chart_value] => ALL YOU CAN SMOKE [is_html] => [type] => [class] => ) ) [first] => ) [5] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 40.10 [filtered_value] => 40.10 [html_value] => 40.10 [chart_value] => 40.10 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => DAGH DAL FOM [filtered_value] => DAGH DAL FOM [html_value] => DAGH DAL FOM [chart_value] => DAGH DAL FOM [is_html] => [type] => [class] => ) ) [first] => ) [6] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 37.00 [filtered_value] => 37.00 [html_value] => 37.00 [chart_value] => 37.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 38.00 [filtered_value] => 38.00 [html_value] => 38.00 [chart_value] => 38.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 39.00 [filtered_value] => 39.00 [html_value] => 39.00 [chart_value] => 39.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 39.45 [filtered_value] => 39.45 [html_value] => 39.45 [chart_value] => 39.45 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => JOINT VENTURE [filtered_value] => JOINT VENTURE [html_value] => JOINT VENTURE [chart_value] => JOINT VENTURE [is_html] => [type] => [class] => ) ) [first] => ) [7] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 37.00 [filtered_value] => 37.00 [html_value] => 37.00 [chart_value] => 37.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 24.00 [filtered_value] => 24.00 [html_value] => 24.00 [chart_value] => 24.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Si [i] => 4 [original_value] => 36.00 [filtered_value] => 36.00 [html_value] => 36.00 [chart_value] => 36.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => total_Cr [i] => 5 [original_value] => 37.00 [filtered_value] => 37.00 [html_value] => 37.00 [chart_value] => 37.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => weighed_grand_total [i] => 6 [original_value] => 33.50 [filtered_value] => 33.50 [html_value] => 33.50 [chart_value] => 33.50 [is_html] => [type] => [class] => ) [6] => ReportValue Object ( [key] => team [i] => 7 [original_value] => DEVILS [filtered_value] => DEVILS [html_value] => DEVILS [chart_value] => DEVILS [is_html] => [type] => [class] => ) ) [first] => ) ) [values] => Array ( [total_Ta] => Array ( [0] => 45.00 [1] => 45.00 [2] => 40.00 [3] => 43.00 [4] => 40.00 [5] => 40.00 [6] => 40.00 [7] => 37.00 ) [total_Te] => Array ( [0] => 44.00 [1] => 44.00 [2] => 44.00 [3] => 40.00 [4] => 41.00 [5] => 40.00 [6] => 40.00 [7] => 24.00 ) [total_Ap] => Array ( [0] => 46.00 [1] => 49.00 [2] => 44.00 [3] => 45.00 [4] => 42.00 [5] => 40.00 [6] => 37.00 [7] => 42.00 ) [total_Si] => Array ( [0] => 43.00 [1] => 38.00 [2] => 45.00 [3] => 40.00 [4] => 39.00 [5] => 40.00 [6] => 38.00 [7] => 36.00 ) [total_Cr] => Array ( [0] => 44.00 [1] => 42.00 [2] => 44.00 [3] => 42.00 [4] => 40.00 [5] => 42.00 [6] => 39.00 [7] => 37.00 ) [weighed_grand_total] => Array ( [0] => 44.55 [1] => 44.25 [2] => 42.30 [3] => 41.95 [4] => 40.40 [5] => 40.10 [6] => 39.45 [7] => 33.50 ) [team] => Array ( ) ) [count] => 8 ) )