// 特定の内容のビューを何度も利用することになるので、
// ビュー自体に名前を付けておく
dbConnection.executeSimpleSQL(<![CDATA[
    CREATE VIEW IF NOT EXISTS historyvisits_and_places
        AS SELECT *
             FROM moz_historyvisits h
                  JOIN moz_places p ON p.id = h.place_id
  ]]>.toString());
var statement = dbConnection.createStatement(<![CDATA[
    SELECT DISTINCT from_info.title, from_info.url
      FROM historyvisits_and_places to_info
           JOIN historyvisits_and_places from_info
             ON from_info.id = to_info.from_visit
     WHERE to_info.url = ?1
           AND (to_info.visit_type = 1
                OR to_info.visit_type = 5
                OR to_info.visit_type = 6)
  ]]>.toString());
try {
  statement.bindStringParameter(0, 'http://www.mozilla.org/');
  while (statement.executeStep()) {
    var title = statement.getString(0);
    var url   = statement.getString(1);
    alert(title+'\n'+url);
  }
}
finally {
  statement.reset();
}
// 処理が完了したら、必要に応じてビューを削除する
// dbConnection.executeSimpleSQL(
// 'DROP VIEW historyvisits_and_places');