- warning: pg_query(): Query failed: ERROR: syntax error at or near "A"
LINE 4: WHEN SUBSTR(n.title,1,2)='A ' THEN LOW...
^ in /projects/nld/group/includes/database.pgsql.inc on line 138.
- user warning:
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 WHERE (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 25 OFFSET 0 in /projects/nld/group/sites/all/modules/biblio/biblio.pages.inc on line 100.