Public feed #887080

Someone

public text v1 · immutable
Raw Edit
·published 2008-02-01 03:00 UTC
rendered paste body
SELECT left_table. * , `RIGHT_TABLE_0`.`title` , `RIGHT_TABLE_0`.`type` , `RIGHT_TABLE_1`.`title` , `RIGHT_TABLE_1`.`type` 
FROM block left_table
INNER JOIN media_asset AS RIGHT_TABLE_0 ON left_table.name = RIGHT_TABLE_0.asset_id
LEFT JOIN media_asset AS RIGHT_TABLE_1 ON left_table.genre = RIGHT_TABLE_1.asset_id
WHERE 1 
LIMIT 0 , 30

generated from:

		$dao = DAOBroker::getDAO('Block');
				$block = new Block();
				$block->setName(ExpertValue::innerJoin('Gallery',array('title','type')));
				$block->setGenre(ExpertValue::leftJoin('Gallery',array('title','type')));
				$dao->search($block, true);