```sql SELECT DISTINCT ?d_canton_id ?d_total ?d_category_name ?d_municipality_id ?d_municipality_name ?d_operator_name WHERE { ?observationSet0 . ?observationSet0 ?source0 . ?source0 ?d_category . ?source0 ?d_municipality . ?source0 ?d_operator . ?source0 ?d_period . ?source0 ?d_total . ?source0 ?d_product . FILTER ( (?d_category = ) ) FILTER ( (?d_product = ) ) FILTER ( (?d_period = "2009"^^) ) OPTIONAL { ?d_category ?d_category_en . FILTER ( LANGMATCHES(LANG(?d_category_en), "en") ) } OPTIONAL { ?d_category ?d_category_x . FILTER ( (LANG(?d_category_x) = "") ) } BIND(COALESCE(?d_category_en, ?d_category_x) AS ?d_category_name) OPTIONAL { ?d_municipality ?d_canton . ?d_canton ?d_canton_id . FILTER ( (?d_canton_id != "CHE") ) } OPTIONAL { ?d_municipality ?d_municipality_id . } OPTIONAL { ?d_municipality ?d_municipality_en . FILTER ( LANGMATCHES(LANG(?d_municipality_en), "en") ) } OPTIONAL { ?d_municipality ?d_municipality_x . FILTER ( (LANG(?d_municipality_x) = "") ) } BIND(COALESCE(?d_municipality_en, ?d_municipality_x) AS ?d_municipality_name) OPTIONAL { ?d_operator ?d_operator_en . FILTER ( LANGMATCHES(LANG(?d_operator_en), "en") ) } OPTIONAL { ?d_operator ?d_operator_x . FILTER ( (LANG(?d_operator_x) = "") ) } BIND(COALESCE(?d_operator_en, ?d_operator_x) AS ?d_operator_name) } GROUP BY ?d_canton_id ?d_category ?d_total ?d_category_name ?d_municipality_id ?d_municipality_name ?d_operator_name ```