Publications
- User warning: Got error 28 from storage engine
query: SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 876 ORDER BY v.weight, t.weight, t.name in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).
- User warning: Got error 28 from storage engine
query: SELECT DISTINCT(n.nid), bt.name as biblio_type_name, bt.name, b.biblio_year, b.biblio_date, 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 biblio_contributor as bc on b.vid = bc.vid JOIN biblio_contributor_data as bcd on bc.cid = bcd.cid INNER JOIN og_ancestry og_ancestry ON n.nid = og_ancestry.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 = 'og_public'))) AND ( ( UPPER(substring(bcd.lastname,1,1)) = 'H' ) AND (og_ancestry.group_nid = 865 ) AND (n.type='biblio' ) AND (n.status = 1 ) )ORDER BY bt.name asc, b.biblio_year DESC, b.biblio_date DESC, 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 0, 25 in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).
- User warning: Got error 28 from storage engine
query: SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 1933 ORDER BY v.weight, t.weight, t.name in _db_query() (line 169 of /var/www/html/iams/project/includes/database.mysqli.inc).
No items found
] 