SELECT old_keys.recno AS recno, 
        'http://example.org/' || old_keys.file, 
        old_metadata.value AS title 
    FROM old_keys 
    JOIN old_metadata 
    ON old_keys.recno = old_metadata.recno 
    WHERE term='dc.title' AND old_metadata.recno 
    IN (
        SELECT rowid AS recno 
        FROM old_fts5_metadata 
        WHERE old_fts5_metadata MATCH ?);