Created
June 22, 2015 17:32
-
-
Save AndyA/41ac60126aa7f5d3019a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT r2.*, rm2.keep FROM (SELECT _parent, COUNT(keep) AS count FROM (SELECT r._parent, rm.keep FROM genome_related AS r, genome_related_meta AS rm WHERE rm._uuid=r._uuid GROUP BY r._parent, rm.keep) AS q GROUP BY _parent) AS q2, genome_related AS r2, genome_related_meta AS rm2 WHERE count>1 AND r2._parent=q2._parent AND r2._uuid=rm2._uuid |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment