user warning: Not unique table/alias: 'na'
query: SELECT DISTINCT(n.nid), bt.name as biblio_type_name, bt.name, CASE
WHEN SUBSTR(n.title,1,1)='"' THEN LOWER(SUBSTR(n.title,2))
WHEN SUBSTR(n.title,1,1)='\'' THEN LOWER(SUBSTR(n.title,2))
WHEN SUBSTR(n.title,1,2)='A ' THEN LOWER(SUBSTR(n.title,3))
WHEN SUBSTR(n.title,1,3)='An ' THEN LOWER(SUBSTR(n.title,4))
WHEN SUBSTR(n.title,1,4)='The ' THEN LOWER(SUBSTR(n.title,5))
ELSE LOWER(n.title)
END FROM node n left join biblio b on n.vid=b.vid inner join biblio_types bt on b.biblio_type=bt.tid INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'private_author') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'private_author') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (n.type='biblio' ) AND (n.status = 1 ) ))ORDER BY bt.name , CASE
WHEN SUBSTR(n.title,1,1)='"' THEN LOWER(SUBSTR(n.title,2))
WHEN SUBSTR(n.title,1,1)='\'' THEN LOWER(SUBSTR(n.title,2))
WHEN SUBSTR(n.title,1,2)='A ' THEN LOWER(SUBSTR(n.title,3))
WHEN SUBSTR(n.title,1,3)='An ' THEN LOWER(SUBSTR(n.title,4))
WHEN SUBSTR(n.title,1,4)='The ' THEN LOWER(SUBSTR(n.title,5))
ELSE LOWER(n.title)
END LIMIT 10 in /home/creeheal/public_html/sites/all/modules/biblio/biblio.module on line 1813.
] 