# Connection: develop # Host: localhost # Saved: 2004-03-04 20:56:44 # USE TBDEVELOP SELECT DISTINCT ID FROM LINK, ( SELECT ID FROM TBOBJECT, ( SELECT OBJID FROM (SELECT OBJID, COUNT(*) AS CNT FROM FINDPARAM WHERE (STRING='armatrading' AND NAME='ID') OR (STRING='joan armatrading' AND NAME='TITLE') GROUP BY OBJID) AS A WHERE CNT >=2) AS B WHERE CLASS='Skrowten.TB.Database.Production' AND ID=OBJID) AS C WHERE ID=CHILDID AND PARENTID=11;