I can't seem to wrap my head around it

SELECT `banned` , `password`
FROM `mrf_users`
INNER JOIN `mrf_uhash` AS `hash`
WHERE `user_idFK` =3 ON ( MD5( CONCAT( 'trick', `hash`.`hash` ) ) = `password` )


In this query I'm trying to retrieve the hash and then md5 the concated string and match it with the retrieved password, I'm aware it's syntactically so any pointers would be great.