Authors
user warning: Unknown column 'bd.drupal_uid' in 'SELECT'
query: SELECT bd.cid, bd.drupal_uid, bd.name, bd.lastname,
bd.firstname, bd.prefix, bd.suffix, bd.initials,
bd.affiliation, bd.md5, COUNT(*) AS cnt
FROM biblio_contributor b
LEFT JOIN biblio_contributor_data bd ON b.cid = bd.cid
INNER JOIN node n on n.vid = b.vid
WHERE (UPPER(SUBSTRING(lastname,1,1)) = 'M' ) AND (n.status = 1 )
GROUP BY bd.cid, bd.drupal_uid, bd.name, bd.lastname,
bd.firstname, bd.prefix, bd.suffix,
bd.initials, bd.affiliation, bd.md5
HAVING COUNT(*) > 0
ORDER BY lastname ASC, SUBSTRING(firstname,1,1) ASC,
initials ASC in /home/tris/public_html/modules/contrib/biblio/biblio.pages.inc on line 1167.
