SELECT A.*,B.*
FROM
JAVA_LANG_OBJECT AS A ,
ORG_CONSERVE_OBJECTS_BOOK AS B ,
JAVA_LANG_OBJECT AS C ,
JAVA_UTIL_ABSTRACTCOLLECTION AS D ,
JAVA_UTIL_ABSTRACTLIST AS E ,
JAVA_UTIL_ARRAYLIST AS F ,
C__ARRAY AS H ,
C__ARRAY_MEMBER_JAVA_LANG_OBJECT AS I ,
JAVA_LANG_OBJECT AS J ,
ORG_CONSERVE_OBJECTS_AUTHOR AS K ,
JAVA_UTIL_ABSTRACTCOLLECTION AS M ,
JAVA_UTIL_ABSTRACTSET AS N ,
JAVA_UTIL_HASHSET AS O ,
C__ARRAY AS Q ,
JAVA_UTIL_ABSTRACTCOLLECTION AS S ,
JAVA_UTIL_ABSTRACTSET AS T ,
JAVA_UTIL_HASHSET AS U ,
C__ARRAY AS W
WHERE A.C__REALID = B.C__ID AND A.C__REALCLASS = 'org.conserve.objects.Book'
AND F.C__ID = E.C__REALID AND E.C__REALCLASS = 'java.util.ArrayList'
AND E.C__ID = D.C__REALID AND D.C__REALCLASS = 'java.util.AbstractList'
AND D.C__ID = C.C__REALID AND C.C__REALCLASS = 'java.util.AbstractCollection'
AND K.C__ID = J.C__REALID AND J.C__REALCLASS = 'org.conserve.objects.Author'
AND N.C__ID = M.C__REALID AND M.C__REALCLASS = 'java.util.AbstractSet'
AND O.C__ID = N.C__REALID AND N.C__REALCLASS = 'java.util.HashSet'
AND T.C__ID = S.C__REALID AND S.C__REALCLASS = 'java.util.AbstractSet'
AND U.C__ID = T.C__REALID AND T.C__REALCLASS = 'java.util.HashSet'
AND B.AUTHORS = C.C__ID
AND D.C__COLLECTION_CONTENTS = H.C__ID
AND H.C__ID = I.C__ARRAY_MEMBER_ID
AND I.C__POSITION = 0
AND I.C__VALUE = J.C__ID
AND K.FIRSTNAME = 'Isaac'
AND K.BOOKS = O.C__ID
AND M.C__COLLECTION_CONTENTS = Q.C__ID
AND B.KEYWORDS = U.C__ID
AND S.C__COLLECTION_CONTENTS = W.C__ID