categoryPrune.sql « maintenance « sql « service « gentoobrowse-api - GentooBrowse API - ICE API backing GentooBrowse.

summary refs log tree commit diff

path: root/gentoobrowse-api/service/sql/maintenance/categoryPrune.sql

blob: 3b75683a69ed885d4959b06c5fb37d8d6fe9e992 (plain)

DELETE FROM gentoobrowse.categories c
WHERE NOT EXISTS (
	SELECT FROM gentoobrowse.packages p
	WHERE p.categoryid = c.categoryid)