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 = 'reporters-first-novel-holds-mirror-culture-prone-ignoring-obvious/1309116906'2