_db_rewrite_sql does not check for duplicate JOIN statements => Not unique table/alias: 'n' on front view

I suspect only very few users have run into this obscure error.. it caused my frontpage view being empty for anonymous users (DOH!!! GAU!).. Both modr8_db_rewrite_sql and webform_report_db_rewrite_sql add the same join statement:

          $return['join'] = "LEFT JOIN {node} n ON $primary_table.nid = n.nid";

which causing the query to fail with this error:

Message
Not unique table/alias: 'n'
query: SELECT node.nid AS nid,
   node.sticky AS node_sticky,
   node.created AS node_created
 FROM node node 
  LEFT JOIN node n ON node.nid = n.nid LEFT JOIN node n ON node.nid = n.nid WHERE ((n.moderate != 1)) AND
  (n.type <> 'webform_report') AND (  (node.promote <> 0) AND (node.status <> 0) AND
  (node.language in ('en', 'en'))
   )ORDER BY node_sticky DESC, node_created DESC
 LIMIT 0, 6 in /var/www/drupal-hfopi/sites/all/modules/views/includes/view.inc on line 723.

The solution is to invoke a array_unique on the join array. Don't think this is needed for the WHERE statements too.. patches attached, applies to D6 and HEAD.