delete from weblogger_ping_urls
where package_id = :package_id
and ping_url = :ping_url
insert into weblogger_ping_urls (
package_id,
ping_url
) values (
:package_id,
:ping_url
)
select ping_url
from weblogger_ping_urls
where package_id = :package_id
order by ping_url asc