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 = 'seven-years-after-sieges-fallujah-struggles/1325615444'2