[TYPO3-dev] Language overlay on query

[Pierre Rouwens]

Hi there,

I have this kinf of query :
$select = 'tx_bulletinsirre_bulletin.code as code, 
tx_bulletinsirre_bulletin.starttime as date,tx_bulletinsirre_article.uid as 
uid,tx_bulletinsirre_article.titre as titre';
$from = 'tx_bulletinsirre_article,tx_bulletinsirre_bulletin';
$where = 'tx_bulletinsirre_article.sys_language_uid in (0,-1)'.
	' and 
year(from_unixtime(tx_bulletinsirre_bulletin.starttime))='.intval($year).
	' and tx_bulletinsirre_article.parentid=tx_bulletinsirre_bulletin.uid'.
	$this->cObj->enableFields('tx_bulletinsirre_bulletin').
	$this->cObj->enableFields('tx_bulletinsirre_article');
$order = 'tx_bulletinsirre_bulletin.starttime desc';
$res = 
$GLOBALS['TYPO3_DB']->exec_SELECTquery($select,$from,$where,$order,'');

And I need to have an overlay on the field "titre", of course a simple
$row = 
$GLOBALS['TSFE']->sys_page->getRecordOverlay('tx_bulletinsirre_article', 
$row, $GLOBALS['TSFE']->sys_language_content,'');
doesn't work because the row is not from only one table.
What is the best way to achieve this ? i've searched withtout any chance.

thanks in advance for any hint.

Pierre