****************** Raw Report File ****************** -- Home Dish -- This lists all the products that cost -- more than a given price. USE sanmarino; SELECT ROUND(SUM(taste),2) AS total_taste, ROUND(SUM(texture),2) AS total_texture, ROUND(SUM(appearance),2) AS total_appearance, ROUND(SUM(creativity),2) AS total_creativity, 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="HomeDish" GROUP BY team ORDER BY weighed_grand_total DESC, total_taste DESC, total_texture DESC, total_appearance DESC, total_creativity DESC ****************** Macros ****************** Array ( ) ****************** All Report Options ****************** Array ( [Filters] => Array ( ) [Variables] => Array ( ) [Includes] => Array ( ) [Name] => Home Dish [Type] => Pdo [Database] => pdo [Environment] => main [Environments] => Array ( [0] => Array ( [name] => main [selected] => 1 ) ) [Query_Formatted] => 
USE sanmarino; 
SELECT 
  ROUND(
    SUM(taste), 
    2
  ) AS total_taste, 
  ROUND(
    SUM(texture), 
    2
  ) AS total_texture, 
  ROUND(
    SUM(appearance), 
    2
  ) AS total_appearance, 
  ROUND(
    SUM(creativity), 
    2
  ) AS total_creativity, 
  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 = "HomeDish" 
GROUP BY 
  team 
ORDER BY 
  weighed_grand_total DESC, 
  total_taste DESC, 
  total_texture DESC, 
  total_appearance DESC, 
  total_creativity DESC
[time_estimate] => Array ( [times] => Array ( [0] => 0.02514 [1] => 0.02655 [2] => 0.02663 [3] => 0.02702 [4] => 0.02783 [5] => 0.02829 [6] => 0.03016 [7] => 0.03123 [8] => 0.03256 [9] => 0.0378 [10] => 0.04039 ) [count] => 11 [min] => 0.03 [max] => 0.04 [median] => 0.03 [average] => 0.03 [q1] => 0.03 [q3] => 0.03 [iqr] => 0.01 [sum] => 0.33 [stdev] => 0 ) ) ****************** Generated Query ****************** USE sanmarino; SELECT ROUND(SUM(taste),2) AS total_taste, ROUND(SUM(texture),2) AS total_texture, ROUND(SUM(appearance),2) AS total_appearance, ROUND(SUM(creativity),2) AS total_creativity, 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="HomeDish" GROUP BY team ORDER BY weighed_grand_total DESC, total_taste DESC, total_texture DESC, total_appearance DESC, total_creativity DESC ****************** Report Rows ****************** Array ( [0] => Array ( [rows] => Array ( [0] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [i] => 1 [original_value] => 51.00 [filtered_value] => 51.00 [html_value] => 51.00 [chart_value] => 51.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_texture [i] => 2 [original_value] => 52.00 [filtered_value] => 52.00 [html_value] => 52.00 [chart_value] => 52.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [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_creativity [i] => 4 [original_value] => 47.00 [filtered_value] => 47.00 [html_value] => 47.00 [chart_value] => 47.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 50.40 [filtered_value] => 50.40 [html_value] => 50.40 [chart_value] => 50.40 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Leon [filtered_value] => Leon [html_value] => Leon [chart_value] => Leon [is_html] => [type] => [class] => ) ) [first] => 1 ) [1] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [i] => 1 [original_value] => 50.00 [filtered_value] => 50.00 [html_value] => 50.00 [chart_value] => 50.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_texture [i] => 2 [original_value] => 50.00 [filtered_value] => 50.00 [html_value] => 50.00 [chart_value] => 50.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [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_creativity [i] => 4 [original_value] => 50.00 [filtered_value] => 50.00 [html_value] => 50.00 [chart_value] => 50.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] => Griller_Unchained [filtered_value] => Griller_Unchained [html_value] => Griller_Unchained [chart_value] => Griller_Unchained [is_html] => [type] => [class] => ) ) [first] => ) [2] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [i] => 2 [original_value] => 49.00 [filtered_value] => 49.00 [html_value] => 49.00 [chart_value] => 49.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [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_creativity [i] => 4 [original_value] => 49.00 [filtered_value] => 49.00 [html_value] => 49.00 [chart_value] => 49.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 49.15 [filtered_value] => 49.15 [html_value] => 49.15 [chart_value] => 49.15 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Emilian_Piggers [filtered_value] => Emilian_Piggers [html_value] => Emilian_Piggers [chart_value] => Emilian_Piggers [is_html] => [type] => [class] => ) ) [first] => ) [3] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [i] => 2 [original_value] => 49.00 [filtered_value] => 49.00 [html_value] => 49.00 [chart_value] => 49.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [i] => 3 [original_value] => 52.00 [filtered_value] => 52.00 [html_value] => 52.00 [chart_value] => 52.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_creativity [i] => 4 [original_value] => 49.00 [filtered_value] => 49.00 [html_value] => 49.00 [chart_value] => 49.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 48.55 [filtered_value] => 48.55 [html_value] => 48.55 [chart_value] => 48.55 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Smoky_Porkys [filtered_value] => Smoky_Porkys [html_value] => Smoky_Porkys [chart_value] => Smoky_Porkys [is_html] => [type] => [class] => ) ) [first] => ) [4] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [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_appearance [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_creativity [i] => 4 [original_value] => 50.00 [filtered_value] => 50.00 [html_value] => 50.00 [chart_value] => 50.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 48.15 [filtered_value] => 48.15 [html_value] => 48.15 [chart_value] => 48.15 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Lord_of_the_grill [filtered_value] => Lord_of_the_grill [html_value] => Lord_of_the_grill [chart_value] => Lord_of_the_grill [is_html] => [type] => [class] => ) ) [first] => ) [5] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [i] => 1 [original_value] => 46.00 [filtered_value] => 46.00 [html_value] => 46.00 [chart_value] => 46.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_texture [i] => 2 [original_value] => 45.00 [filtered_value] => 45.00 [html_value] => 45.00 [chart_value] => 45.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [i] => 3 [original_value] => 52.00 [filtered_value] => 52.00 [html_value] => 52.00 [chart_value] => 52.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_creativity [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.65 [filtered_value] => 46.65 [html_value] => 46.65 [chart_value] => 46.65 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Smoketrotter [filtered_value] => Smoketrotter [html_value] => Smoketrotter [chart_value] => Smoketrotter [is_html] => [type] => [class] => ) ) [first] => ) [6] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [i] => 2 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [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_creativity [i] => 4 [original_value] => 46.00 [filtered_value] => 46.00 [html_value] => 46.00 [chart_value] => 46.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 43.40 [filtered_value] => 43.40 [html_value] => 43.40 [chart_value] => 43.40 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Oversmoke [filtered_value] => Oversmoke [html_value] => Oversmoke [chart_value] => Oversmoke [is_html] => [type] => [class] => ) ) [first] => ) [7] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [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_appearance [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_creativity [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] => 42.90 [filtered_value] => 42.90 [html_value] => 42.90 [chart_value] => 42.90 [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] => ) [8] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [i] => 1 [original_value] => 41.00 [filtered_value] => 41.00 [html_value] => 41.00 [chart_value] => 41.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_texture [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_appearance [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_creativity [i] => 4 [original_value] => 42.00 [filtered_value] => 42.00 [html_value] => 42.00 [chart_value] => 42.00 [is_html] => [type] => [class] => ) [4] => ReportValue Object ( [key] => weighed_grand_total [i] => 5 [original_value] => 41.20 [filtered_value] => 41.20 [html_value] => 41.20 [chart_value] => 41.20 [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] => ) [9] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [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_appearance [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_creativity [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] => 40.45 [filtered_value] => 40.45 [html_value] => 40.45 [chart_value] => 40.45 [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] => ) [10] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [i] => 2 [original_value] => 35.00 [filtered_value] => 35.00 [html_value] => 35.00 [chart_value] => 35.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [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_creativity [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] => 39.60 [filtered_value] => 39.60 [html_value] => 39.60 [chart_value] => 39.60 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => A-team [filtered_value] => A-team [html_value] => A-team [chart_value] => A-team [is_html] => [type] => [class] => ) ) [first] => ) [11] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [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_texture [i] => 2 [original_value] => 39.00 [filtered_value] => 39.00 [html_value] => 39.00 [chart_value] => 39.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [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_creativity [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] => 38.75 [filtered_value] => 38.75 [html_value] => 38.75 [chart_value] => 38.75 [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] => ) [12] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [i] => 1 [original_value] => 36.00 [filtered_value] => 36.00 [html_value] => 36.00 [chart_value] => 36.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_texture [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_appearance [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_creativity [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] => 38.50 [filtered_value] => 38.50 [html_value] => 38.50 [chart_value] => 38.50 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Latino_Heat [filtered_value] => Latino_Heat [html_value] => Latino_Heat [chart_value] => Latino_Heat [is_html] => [type] => [class] => ) ) [first] => ) [13] => Array ( [values] => Array ( [0] => ReportValue Object ( [key] => total_taste [i] => 1 [original_value] => 38.00 [filtered_value] => 38.00 [html_value] => 38.00 [chart_value] => 38.00 [is_html] => [type] => [class] => ) [1] => ReportValue Object ( [key] => total_texture [i] => 2 [original_value] => 38.00 [filtered_value] => 38.00 [html_value] => 38.00 [chart_value] => 38.00 [is_html] => [type] => [class] => ) [2] => ReportValue Object ( [key] => total_appearance [i] => 3 [original_value] => 36.00 [filtered_value] => 36.00 [html_value] => 36.00 [chart_value] => 36.00 [is_html] => [type] => [class] => ) [3] => ReportValue Object ( [key] => total_creativity [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] => weighed_grand_total [i] => 5 [original_value] => 37.60 [filtered_value] => 37.60 [html_value] => 37.60 [chart_value] => 37.60 [is_html] => [type] => [class] => ) [5] => ReportValue Object ( [key] => team [i] => 6 [original_value] => Ghost_griller [filtered_value] => Ghost_griller [html_value] => Ghost_griller [chart_value] => Ghost_griller [is_html] => [type] => [class] => ) ) [first] => ) ) [values] => Array ( [total_taste] => Array ( [0] => 51.00 [1] => 50.00 [2] => 49.00 [3] => 47.00 [4] => 49.00 [5] => 46.00 [6] => 42.00 [7] => 42.00 [8] => 41.00 [9] => 37.00 [10] => 42.00 [11] => 37.00 [12] => 36.00 [13] => 38.00 ) [total_texture] => Array ( [0] => 52.00 [1] => 50.00 [2] => 49.00 [3] => 49.00 [4] => 46.00 [5] => 45.00 [6] => 42.00 [7] => 43.00 [8] => 41.00 [9] => 43.00 [10] => 35.00 [11] => 39.00 [12] => 40.00 [13] => 38.00 ) [total_appearance] => Array ( [0] => 46.00 [1] => 50.00 [2] => 50.00 [3] => 52.00 [4] => 50.00 [5] => 52.00 [6] => 50.00 [7] => 45.00 [8] => 42.00 [9] => 45.00 [10] => 43.00 [11] => 43.00 [12] => 42.00 [13] => 36.00 ) [total_creativity] => Array ( [0] => 47.00 [1] => 50.00 [2] => 49.00 [3] => 49.00 [4] => 50.00 [5] => 48.00 [6] => 46.00 [7] => 44.00 [8] => 42.00 [9] => 40.00 [10] => 40.00 [11] => 40.00 [12] => 40.00 [13] => 36.00 ) [weighed_grand_total] => Array ( [0] => 50.40 [1] => 50.00 [2] => 49.15 [3] => 48.55 [4] => 48.15 [5] => 46.65 [6] => 43.40 [7] => 42.90 [8] => 41.20 [9] => 40.45 [10] => 39.60 [11] => 38.75 [12] => 38.50 [13] => 37.60 ) [team] => Array ( ) ) [count] => 14 ) )