|
user warning: Not unique table/alias: 'na'
query: SELECT DISTINCT n.*, b.* FROM node n left join biblio b on n.vid=b.vid 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 = 1 AND na.realm = 'content_access_rid'))) AND ( (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (b.biblio_authors RLIKE 'Parkin' ) AND (n.type='biblio' ) AND (n.status = 1 ) ) ) ORDER BY b.biblio_year DESC, b.biblio_date DESC, SUBSTRING(n.title,1,1) ASC, b.biblio_type ASC in /home/content/j/b/4/jb442/html/includes/database.mysql.inc on line 172.
|