select
    "gwcsu"."id",
    "gwcsu"."imei",
    "gwcsu"."description",
    "gwcsu"."lastContainerName",
    (
        select "history"."imeiId", "history"."latitude" from "history"
        where
            (
                "history"."imeiId" = "gwcsu"."id"
                and not("history"."latitude" is null)
                and not("history"."longitude" is null)
                and not("history"."dateTime" is null)
            )
        order by
            "history"."dateTime" desc limit 1
    )
from
    "gwcsu" inner join "cmd_site_userprofile_imeiid" on
    (
        "gwcsu"."id" = "cmd_site_userprofile_imeiid"."gwcsu_id"
    )
where
    "cmd_site_userprofile_imeiid"."userprofile_id" = 19