MySQL Error

SCRIPT:
Number of MySQL function calls: 7
SQL statement:
SELECT *, cms_rd_name as description FROM referenzen r LEFT JOIN referenzen_desc d ON (r.cms_referenzen_id = d.cms_rd_referenzen_id AND d.cms_language = 'de_de') LEFT JOIN verlegebetriebe v ON (v.vb_id = r.cms_referenzen_verlegebetrieb) WHERE trash = 'N' AND r.cms_referenzen_id = '173'

MySQL error message: Column 'trash' in where clause is ambiguous

Kernel-Stack:

#FileLineCallArguments
1.   index.php4   include   /srv/shell/shellkernel/kernel.php
2.   kernel.php980   siteloader->execModules    
3.   siteloader.inc2625   js_contact->main    
4.   module.inc64   js_contact->getReferenceDetail   173
5.   module.inc103   MySQL->getRow   referenzen r LEFT JOIN referenzen_desc d ON (r.cms_referenzen_id = d.cms_rd_referenzen_id AND d.cms_language = 'de_de') LEFT JOIN verlegebetriebe v ON (v.vb_id = r.cms_referenzen_verlegebetrieb)
*, cms_rd_name as description
trash = 'N' AND r.cms_referenzen_id = '173'