Company Scoreboard

Error loading companies data: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bs_sub.benchmark_numerical_score' in 'HAVING': SELECT "nfd"."nid" AS "nid", "nfd"."title" AS "title", "fcid"."field_company_id_value" AS "field_company_id_value" FROM "node_field_data" "nfd" INNER JOIN "node__field_company_id" "fcid" ON fcid.entity_id = nfd.nid INNER JOIN "node__field_disclosure_language" "fdl" ON fdl.entity_id = nfd.nid INNER JOIN "node__field_region" "fr" ON fr.entity_id = nfd.nid WHERE ("fdl"."field_disclosure_language_value" = :db_condition_placeholder_0) AND ("nfd"."type" = :db_condition_placeholder_1) AND ("nfd"."status" = :db_condition_placeholder_2) AND ("nfd"."title" LIKE :db_condition_placeholder_3 ESCAPE '\\') AND ("fr"."field_region_target_id" = :db_condition_placeholder_4) AND ("fcid"."field_company_id_value" IN (SELECT "mas_sub"."company_id" AS "company_id" FROM "measurement_area_score" "mas_sub" INNER JOIN "benchmark_score" "bs_sub" ON bs_sub.company_id = mas_sub.company_id AND bs_sub.benchmark_id = mas_sub.benchmark_id GROUP BY "mas_sub"."company_id" HAVING (bs_sub.benchmark_numerical_score BETWEEN :min_score AND :max_score))) ORDER BY "nfd"."title" ASC LIMIT 10 OFFSET 0; Array ( [:db_condition_placeholder_0] => English [:db_condition_placeholder_1] => company [:db_condition_placeholder_2] => 1 [:db_condition_placeholder_3] => %hKicQCoE% [:db_condition_placeholder_4] => 65 [:min_score] => 0 [:max_score] => 1 )