func GroupByTemplateWithGroupSub() () {

    dateStart := time.Now().Unix()
    dateStop := time.Now().Unix()

    dates := squirrel.And{
        squirrel.Expr("event_date <= toDateTime(?)", dateStart),
        squirrel.Expr("event_date >= toDateTime(?)", dateStop),
    }

    nestedOrderPrelandingSelect := squirrel.
        Select(
            "visit_template_id as prelanding_id",
            "count(*)          as count_order_prelanding",
            "",
        ).
        From("orders_local").
        Where(dates).
        GroupBy("visit_template_id")

    nestedVisitPrelandingSelect := squirrel.
        Select("template_id as prelanding_id",
            "count(*)    as count_visit_prelanding").
        From("visits_local").
        Where(              dates,      ).
        GroupBy("template_id")

    nestedPrelandingSelect := squirrel.
        Select("*").
        FromSelect(
            nestedVisitPrelandingSelect,
            "visit_template",
        ).
        JoinClause(
            nestedOrderPrelandingSelect.
                Prefix("any left join (").
                Suffix(") as template using prelanding_id"),
        )

    resultSelect := squirrel.
        Select(
            "prelanding_id",
            "count_visit_prelanding",
            "count_visit_landing",
            "count_order_prelanding",
            "count_order_landing",
        ).
        FromSelect(
            nestedPrelandingSelect,
            "a",
        )

    log.Println(resultSelect.ToSql())

}