Get max url from PostgreSQL statement
Guess I have figured it out.

By first selecting the first url:

select min("cdata".url) as url


And then order the query by date:

order by date asc


It does return the right url and it combines the rest of the columns.

EDIT:
Above answer did not work as expected. This didn't either: https://wiki.postgresql.org/wiki/First/last_(aggregate)

EDIT 2:
Alright, I ran several tests and this seems to go well:

last("cdata".url) AS url


in combination with the max(date). So if someone has a better solution, please let me know :)

EDIT 3:
Alright, I think I just fixed it. I just select the url by executing a subquery and select the right row by comparing all "group by" fields, guess this is the best solution to my problem:

(SELECT url from sqpr as cd where"cd".kword = "cdata".kword and cd.kid="cdata".kid and cd.accid="cdata".accid and cd. adgstatus ="cdata". adgstatus and cd. adgcid ="cdata". adgcid and cd. adgname ="cdata". adgname and cd. adgid ="cdata". adgid and cd. sterm ="cdata". sterm and cd. mtype ="cdata". mtype ORDER BY date DESC LIMIT 1) AS url