SELECT
	a.id,
	a.name,
	a.filename,
	a.project_id,
	( p.name ) AS project_name
FROM
	asset a
INNER JOIN
	project p
ON
	(
			a.id = #asset_id#
		AND
			p.id = #project_id#
		AND
			a.project_id = p.id
	)