SELECT id, created_at, updated_at, details, formatted_address, place_id, ptype FROM (
            SELECT :projection,
            CASE WHEN EXISTS(
                SELECT task.id
                FROM task
                LEFT JOIN property_task ON property_task.task_id = task.id
                LEFT JOIN property ON property.id = property_task.property_id
                LEFT JOIN contact_task ON contact_task.task_id = task.id
                LEFT JOIN contact ON contact.id = contact_task.contact_id
                LEFT JOIN "user" ON "user".id = task.owner_id
                LEFT JOIN user_group ON user_group.user_id = "user".id
                WHERE task.owner_id = {$userId}
                AND "user".id = user_group.user_id
                AND user_group.group_id = {$groupId}
                AND (contact.address_id = address.id OR property.address_id = address.id)
                AND task_type_id IN (4, 5, 6, 7)
                AND task.status = 'remind'
                AND date_trunc('day', task.tasked_at) <= date_trunc('day', NOW())
            ) THEN 'remind' ELSE 'null' END AS ptype,
            (details::json#>>'{location,latitude}') AS latitude,
            (details::json#>>'{location,longitude}') AS longitude
            FROM address
            WHERE point( (details::json#>>'{location,longitude}')::DOUBLE PRECISION , (details::json#>>'{location,latitude}')::DOUBLE PRECISION)<@polygon('({$string})')
            ) AS addresses
        WHERE addresses.ptype != 'null'

        SELECT :projection,
        (details::json#>>'{location,latitude}') AS latitude,
        (details::json#>>'{location,longitude}') AS longitude
        FROM address
        LEFT JOIN "user" ON address.user_id = "user".id
        LEFT JOIN user_group ON user_group.user_id = "user".id
        LEFT JOIN task ON "user"."id" = "task"."owner_id"
        LEFT JOIN property_task ON property_task.task_id = task.id
        LEFT JOIN property ON property.id = property_task.property_id
        LEFT JOIN contact_task ON contact_task.task_id = task.id
        LEFT JOIN contact ON contact.id = contact_task.contact_id
        WHERE point( (details::json#>>'{location,longitude}')::DOUBLE PRECISION , (details::json#>>'{location,latitude}')::DOUBLE PRECISION)<@polygon('({$string})')
        AND task.owner_id = {$userId}
        AND "user".id = user_group.user_id
        AND user_group.group_id = {$groupId}
        AND (contact.address_id = address.id OR property.address_id = address.id)
        AND task_type_id IN (4, 5, 6, 7)
        AND task.status = 'remind'
        AND date_trunc('day', task.tasked_at) <= date_trunc('day', NOW())

            SELECT :projection,
            CASE WHEN EXISTS(
                SELECT task.id
                FROM task
                LEFT JOIN property_task ON property_task.task_id = task.id
                LEFT JOIN property ON property.id = property_task.property_id
                LEFT JOIN contact_task ON contact_task.task_id = task.id
                LEFT JOIN contact ON contact.id = contact_task.contact_id
                LEFT JOIN "user" ON "user".id = task.owner_id
                LEFT JOIN user_group ON user_group.user_id = "user".id
                WHERE task.owner_id = {$userId}
                AND "user".id = user_group.user_id
                AND user_group.group_id = {$groupId}
                AND (contact.address_id = address.id OR property.address_id = address.id)
                AND task_type_id IN (4, 5, 6, 7)
                AND task.status = 'remind'
                AND date_trunc('day', task.tasked_at) <= date_trunc('day', NOW())
            ) THEN 'remind' ELSE 'null' END AS ptype,
            (details::json#>>'{location,latitude}') AS latitude,
            (details::json#>>'{location,longitude}') AS longitude
            FROM address
            WHERE point( (details::json#>>'{location,longitude}')::DOUBLE PRECISION , (details::json#>>'{location,latitude}')::DOUBLE PRECISION)<@polygon('({$string})')
            HAVING address.ptype != 'null'