user warning: Incorrect key file for table '/ramdisk/mysql/tmp/#sql_2987_1.MYI'; try to repair it query: SELECT DISTINCT(n.nid), bt.name as biblio_type_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 WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( (substring( 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 ,1 ,1)RLIKE LOWER('O')) AND (n.type='biblio' ) AND (n.status = 1 ) )ORDER BY 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 /home1/travismc/public_html/plateauculture.org/sites/all/modules/biblio/biblio.pages.inc on line 101.

Biblio

Export 1 results:
Sort by: Author [ Title  (Asc)] Type Year
Filters: First Letter Of Title is O  [Clear All Filters]
A B C D E F G H I J K L M N [O] P Q R S T U V W X Y Z   [Show ALL]

No items found

Modify or remove your filters and try again.