
func (r *GroupRepository) StatsGroup(ctx context.Context, gid uuid.UUID) (GroupStatistics, error) {
	q := `
		SELECT
            (SELECT COUNT(*) FROM user_groups WHERE group_id = $2) AS total_users,
            (SELECT COUNT(*) FROM entities e JOIN entity_types et ON et.id = e.entity_type_entities WHERE e.group_entities = $2 AND e.archived = false AND et.is_location = false) AS total_items,
            (SELECT COUNT(*) FROM entities e JOIN entity_types et ON et.id = e.entity_type_entities WHERE e.group_entities = $2 AND et.is_location = true) AS total_locations,
            (SELECT COUNT(*) FROM tags WHERE group_tags = $2) AS total_tags,
            (SELECT SUM(e.purchase_price*e.quantity) FROM entities e JOIN entity_types et ON et.id = e.entity_type_entities WHERE e.group_entities = $2 AND e.archived = false AND et.is_location = false) AS total_item_price,
            (SELECT COUNT(*)
                FROM entities e
                JOIN entity_types et ON et.id = e.entity_type_entities
                    WHERE e.group_entities = $2
                    AND e.archived = false
                    AND et.is_location = false
                    AND (e.lifetime_warranty = true OR e.warranty_expires > $1)
                ) AS total_with_warranty;
`
	var stats GroupStatistics
