Skip to content

Instantly share code, notes, and snippets.

select distinct A.label as surname, A.wikidata as qs, B.label as forename, B.wikidata as qf, A.gender as gender
from forename as A, surname as B
WHERE (A.B = 0 and B.B = 0) AND
(A.D = 0 and B.D = 0) AND
(A.E = 0 and B.E = 0) AND
(A.F = 0 and B.F = 0) AND
(A.G = 0 and B.G = 0) AND
(A.I = 0 and B.I = 0) AND
(A.J = 0 and B.J = 0) AND
(A.K = 0 and B.K = 0) AND