SELECT tx_dam.uid AS damid, tx_dam.file_path, tx_dam.file_name, tx_dam_mm_ref.ident, tt_news.uid AS newsid, tt_news.title
FROM tx_dam
LEFT JOIN tx_dam_mm_ref ON (tx_dam_mm_ref.uid_local = tx_dam.uid)
JOIN tt_news ON (tt_news.uid = tx_dam_mm_ref.uid_foreign)
WHERE tx_dam_mm_ref.tablenames='tt_news'
AND tt_news.hidden=0 AND tt_news.deleted=0
ORDER BY tt_news.uid