SELECT k2.id, k2.alias FROM #__di_alias a left join #__di_contents c on ( CONCAT('node/',c.did) = a.src ) left join #__k2_items k2 on (k2.id = c.k2id) WHERE a.dst = 'unequal-responsibility-crime/1315328149'2