****************** Raw Report File ****************** -- Mystery Box -- 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(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="Mystery Box" 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] => Mystery Box [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(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 = "Mystery Box" 
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.02488 [1] => 0.02861 [2] => 0.02891 [3] => 0.0292 [4] => 0.02997 [5] => 0.03095 [6] => 0.03194 [7] => 0.03197 [8] => 0.03219 [9] => 0.03576 [10] => 0.03597 ) [count] => 11 [min] => 0.02 [max] => 0.04 [median] => 0.03 [average] => 0.03 [q1] => 0.03 [q3] => 0.03 [iqr] => 0 [sum] => 0.34 [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(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="Mystery Box" 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] => 49.00 [filtered_value] => 49.00 [html_value] => 49.00 [chart_value] => 49.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 51.00 [filtered_value] => 51.00 [html_value] => 51.00 [chart_value] => 51.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 50.00 [filtered_value] => 50.00 [html_value] => 50.00 [chart_value] => 50.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Cr [i] => 4 [original_value] => 52.00 [filtered_value] => 52.00 [html_value] => 52.00 [chart_value] => 52.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 50.00 [filtered_value] => 50.00 [html_value] => 50.00 [chart_value] => 50.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [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] => 1 ) [1] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 47.00 [filtered_value] => 47.00 [html_value] => 47.00 [chart_value] => 47.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 47.00 [filtered_value] => 47.00 [html_value] => 47.00 [chart_value] => 47.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Cr [i] => 4 [original_value] => 48.00 [filtered_value] => 48.00 [html_value] => 48.00 [chart_value] => 48.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 46.45 [filtered_value] => 46.45 [html_value] => 46.45 [chart_value] => 46.45 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [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] => 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] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.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_Cr [i] => 4 [original_value] => 44.00 [filtered_value] => 44.00 [html_value] => 44.00 [chart_value] => 44.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 44.40 [filtered_value] => 44.40 [html_value] => 44.40 [chart_value] => 44.40 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => GRILLER UNCHAINED [filtered_value] => GRILLER UNCHAINED [html_value] => GRILLER UNCHAINED [chart_value] => GRILLER UNCHAINED [is_html] => [type] => [class] => ) ) [first] => ) [3] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 47.00 [filtered_value] => 47.00 [html_value] => 47.00 [chart_value] => 47.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Cr [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] => weighed_grand_total [i] => 5 [original_value] => 43.15 [filtered_value] => 43.15 [html_value] => 43.15 [chart_value] => 43.15 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [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] => ) [4] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 46.00 [filtered_value] => 46.00 [html_value] => 46.00 [chart_value] => 46.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_Ap [i] => 3 [original_value] => 39.00 [filtered_value] => 39.00 [html_value] => 39.00 [chart_value] => 39.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Cr [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] => weighed_grand_total [i] => 5 [original_value] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.00 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [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] => ) [5] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.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] => 43.00 [filtered_value] => 43.00 [html_value] => 43.00 [chart_value] => 43.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Cr [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] => weighed_grand_total [i] => 5 [original_value] => 41.70 [filtered_value] => 41.70 [html_value] => 41.70 [chart_value] => 41.70 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => DEVILS [filtered_value] => DEVILS [html_value] => DEVILS [chart_value] => DEVILS [is_html] => [type] => [class] => ) ) [first] => ) [6] => 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] => 40.00 [filtered_value] => 40.00 [html_value] => 40.00 [chart_value] => 40.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_Cr [i] => 4 [original_value] => 41.00 [filtered_value] => 41.00 [html_value] => 41.00 [chart_value] => 41.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 41.40 [filtered_value] => 41.40 [html_value] => 41.40 [chart_value] => 41.40 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => SANTA MUERTE [filtered_value] => SANTA MUERTE [html_value] => SANTA MUERTE [chart_value] => SANTA MUERTE [is_html] => [type] => [class] => ) ) [first] => ) [7] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_Ta [i] => 1 [original_value] => 35.00 [filtered_value] => 35.00 [html_value] => 35.00 [chart_value] => 35.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_Te [i] => 2 [original_value] => 36.00 [filtered_value] => 36.00 [html_value] => 36.00 [chart_value] => 36.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_Cr [i] => 4 [original_value] => 37.00 [filtered_value] => 37.00 [html_value] => 37.00 [chart_value] => 37.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 36.50 [filtered_value] => 36.50 [html_value] => 36.50 [chart_value] => 36.50 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => JOINT VENTURE [filtered_value] => JOINT VENTURE [html_value] => JOINT VENTURE [chart_value] => JOINT VENTURE [is_html] => [type] => [class] => ) ) [first] => ) ) [values] => Array ( [total_Ta] => Array ( [0] => 49.00 [1] => 47.00 [2] => 45.00 [3] => 42.00 [4] => 42.00 [5] => 42.00 [6] => 43.00 [7] => 35.00 ) [total_Te] => Array ( [0] => 51.00 [1] => 47.00 [2] => 43.00 [3] => 43.00 [4] => 46.00 [5] => 41.00 [6] => 40.00 [7] => 36.00 ) [total_Ap] => Array ( [0] => 50.00 [1] => 43.00 [2] => 46.00 [3] => 47.00 [4] => 39.00 [5] => 43.00 [6] => 40.00 [7] => 42.00 ) [total_Cr] => Array ( [0] => 52.00 [1] => 48.00 [2] => 44.00 [3] => 43.00 [4] => 43.00 [5] => 40.00 [6] => 41.00 [7] => 37.00 ) [weighed_grand_total] => Array ( [0] => 50.00 [1] => 46.45 [2] => 44.40 [3] => 43.15 [4] => 43.00 [5] => 41.70 [6] => 41.40 [7] => 36.50 ) [team] => Array ( ) ) [count] => 8 ) )