var statement = dbConnection.createStatement(<![CDATA[
    SELECT b.id, b.title, p.url
      FROM moz_bookmarks b
           JOIN moz_places p ON p.id = b.fk
           JOIN moz_bookmarks parent ON parent.id = b.parent
     WHERE parent.id = ?1 AND b.type =1
     ORDER BY b.position ASC
  ]]>.toString());
try {
  statement.bindDoubleParameter(0, 1);
  while (statement.executeStep()) {
    var id    = statement.getDouble(0);
    var title = statement.getString(1);
    var url   = statement.getString(2);
    alert(id+'\n'+title+'\n'+url);
  }
}
finally {
  statement.reset();
}