Publications

user warning: Can't create/write to file '/tmp/#sql_4d68_0.MYI' (Errcode: 30) query: SELECT *, CASE LOWER(SUBSTR(b.biblio_month,1,3)) WHEN 'jan' THEN 1 WHEN 'feb' THEN 2 WHEN 'mar' THEN 3 WHEN 'apr' THEN 4 WHEN 'may' THEN 5 WHEN 'jun' THEN 6 WHEN 'jul' THEN 7 WHEN 'aug' THEN 8 WHEN 'sep' THEN 9 WHEN 'oct' THEN 10 WHEN 'nov' THEN 11 WHEN 'dec' THEN 12 ELSE MONTH( FROM_UNIXTIME( n.created ) ) END AS month FROM inl_node n left join inl_biblio b on n.nid=b.nid INNER JOIN inl_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 = 'tac_lite') OR (na.gid = 1 AND na.realm = 'tac_lite'))) AND ( n.type='biblio' and outgroup=0 AND n.status=1 ) ORDER BY b.biblio_year DESC, month DESC, n.created , SUBSTRING(n.title,1,1) ASC, b.biblio_bibtype ASC LIMIT 120, 30 in /var/www/obonet/includes/database.mysql.inc on line 174.
Sort by:[Year][Title][Type]

No items found

Syndicate content