Site counts in map vs tabular results

[johanvonboer]

A result load with no filters in the general domain results in 3462 sites in the map view, but 2554 sites in the tabular view.

Tabular SQL

SELECT alias_1, ARRAY_TO_STRING(ARRAY_AGG(DISTINCT alias_2),',') AS text_agg_of_alias_2, COUNT(alias_3) AS count_of_alias_3, alias_4, alias_5
FROM (
SELECT tbl_sites.site_name AS alias_1, tbl_record_types.record_type_name AS alias_2, tbl_analysis_entities.analysis_entity_id AS alias_3, tbl_sites.site_id AS alias_4, tbl_sites.site_id AS alias_5, tbl_sites.site_name AS alias_6
FROM tbl_analysis_entities
INNER JOIN tbl_datasets ON tbl_datasets."dataset_id" = tbl_analysis_entities."dataset_id" INNER JOIN tbl_physical_samples ON tbl_physical_samples."physical_sample_id" = tbl_analysis_entities."physical_sample_id" INNER JOIN tbl_sample_groups ON tbl_sample_groups."sample_group_id" = tbl_physical_samples."sample_group_id" INNER JOIN tbl_sites ON tbl_sites."site_id" = tbl_sample_groups."site_id" INNER JOIN tbl_methods ON tbl_methods."method_id" = tbl_datasets."method_id" INNER JOIN tbl_record_types ON tbl_record_types."record_type_id" = tbl_methods."record_type_id"
WHERE 1 = 1

GROUP BY alias_1, alias_2, alias_3, alias_4, alias_5, alias_6
) AS X
GROUP BY alias_1, alias_4, alias_5, alias_6
ORDER BY alias_6

Map SQL

SELECT DISTINCT tbl_sites.site_id AS id_column, tbl_sites.site_name AS name, coalesce(latitude_dd, 0.0) AS latitude_dd, coalesce(longitude_dd, 0) AS longitude_dd
FROM tbl_sites

WHERE 1 = 1