[Spce-user] sip:provider CE v3.0 released!

[Andrew Pogrebennyk]

On 22/08/2013 23:04, Theo wrote:
> ok thinking a little more - I ran your query and found the entries, but
> my database knowledge is REALLY limited. How would I delete those
> entries? I tried to be clever and simply replace SELECT with DELETE but
> that's clearly wrong....

I see, then you can delete them with something like:

delete from location where ruid in (select ruid from (select * from
location loc group by ruid having count(*) > 1) as ruid);

Andrew