USE provisioning;

DELETE FROM xmlhostgroups
  WHERE group_id = (SELECT id FROM xmlgroups WHERE name = 'xmpp')
  AND host_id = (SELECT id FROM xmlhosts WHERE description = 'Prosody');

DELETE FROM xmlhosts WHERE description = 'Prosody';
DELETE FROM xmlgroups WHERE name = 'xmpp';