user warning: Can't create/write to file '/tmp/#sql_9a4_0.MYI' (Errcode: 30) query: SELECT DISTINCT(n.nid), bt.name as biblio_type_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 bc1 on n.vid = bc1.vid 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 = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( (bc1.cid = 5285 ) AND (n.type='biblio' ) AND (n.status = 1 ) )ORDER BY 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 asc LIMIT 0, 25 in /var/www/iarc/sites/all/modules/biblio/biblio.pages.inc on line 101.

Publications

Found 1 results

Sort by: Author Title [ Year  (Desc)]
Filters: Author is K. Otsuki  [Clear All Filters]

No items found

Modify or remove your filters and try again.