query.sql

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 
(A.L = 0 and B.L = 0) AND 
(A.M = 0 and B.M = 0) AND 
(A.P = 0 and B.P = 0) AND 
(A.Q = 0 and B.Q = 0) AND 
(A.U = 0 and B.U = 0) AND 
(A.V = 0 and B.V = 0) AND 
(A.X = 0 and B.X = 0) AND 
(A.Y = 0 and B.Y = 0) AND 
(A.A >= 1 or B.A >= 1) AND 
(A.C = 1 xor B.C = 1) AND 
(A.H = 1 xor B.H = 1) AND 
(A.N = 1 xor B.N = 1) AND 
(A.O = 1 xor B.O = 1) AND 
(A.R >= 1 or B.R >= 1) AND 
(A.S = 1 xor B.S = 1) AND 
(A.T = 1 xor B.T = 1) AND 
(A.W = 1 xor B.W = 1) AND 
(A.Z = 1 xor B.Z = 1) AND 
(A.labels_length = 4) AND (B.labels_length = 9)