Unable to search for a Principal by email address.

select distinct p."DIRECTORYID" as DIRECTOR1_17_0_, p."NAME" as NAME2_17_0_, p."ACTIVE" as ACTIVE3_17_0_, p."CONCEPTION" as CONCEPTION4_17_0_, p."LASTMODIFIED" as LASTMODI5_17_0_ from "REMOTEPRINCIPAL" p ,"ATTRIBUTES" pa, "ATTRIBUTES" a, "ATTRIBUTEVALUES" av where p."DIRECTORYID" = ? and p.`DIRECTORYID` = pa.`REMOTEPRINCIPALDIRECTORYID`and p.`name` = pa.`REMOTEPRINCIPALNAME` and pa.`ID` = av.`ATTRIBUTEVALUEID` and pa.`ATTRIBUTE` = 'mail' and av.`VALUE` like ? order by p."NAME" asc, p."ACTIVE" asc