db-schema/db_scripts/diff/15044.up

USE kamailio;

DELETE FROM peer_preferences WHERE uuid NOT IN (
  SELECT flags FROM lcr_gw
);