Skip to content
This repository has been archived by the owner on Mar 15, 2020. It is now read-only.

Latest commit

 

History

History
14 lines (5 loc) · 350 Bytes

NOTES.md

File metadata and controls

14 lines (5 loc) · 350 Bytes

ALTER TABLE grano_entity DISABLE TRIGGER ALL;

DELETE FROM grano_entity e WHERE e.id NOT IN (SELECT DISTINCT p.entity_id FROM grano_property p WHERE p.entity_id IS NOT NULL);

ALTER TABLE grano_entity ENABLE TRIGGER ALL;

--

SELECT COUNT(e.id) FROM entity e WHERE e.id NOT IN (SELECT p.entity_id FROM property p WHERE p.entity_id IS NOT NULL);