Domain Views 6.x-2.9 Bug

This bug is for 6.x-2.9 but unable to choose that selection for version above.

We have a CCK-created "News Item" content type with instances published to three different domains.

The view (both preview and on the 3 websites) is only returning 4 rows. There are 7 rows published on all three domains. I copied and ran the SQL query generated in the preview in myphpadmin and its returns all 7 rows for all three domains. Here is the SQL from the preview where "***CURRENT_DOMAIN***" was replaced with each domain's domain_id:

SELECT node.nid AS nid,
node_data_field_news_thumbnail.field_news_thumbnail_fid AS
node_data_field_news_thumbnail_field_news_thumbnail_fid,
node_data_field_news_thumbnail.field_news_thumbnail_list AS
node_data_field_news_thumbnail_field_news_thumbnail_list,
node_data_field_news_thumbnail.field_news_thumbnail_data AS
node_data_field_news_thumbnail_field_news_thumbnail_data,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_news_thumbnail.field_news_title_value AS
node_data_field_news_thumbnail_field_news_title_value,
node_data_field_news_thumbnail.field_news_date_value AS
node_data_field_news_thumbnail_field_news_date_value,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node_data_field_news_thumbnail.field_news_photo_fid AS
node_data_field_news_thumbnail_field_news_photo_fid,
node_data_field_news_thumbnail.field_news_photo_list AS
node_data_field_news_thumbnail_field_news_photo_list,
node_data_field_news_thumbnail.field_news_photo_data AS
node_data_field_news_thumbnail_field_news_photo_data,
node_revisions.body AS node_revisions_body,
node_data_field_news_date.field_news_date_value AS
node_data_field_news_date_field_news_date_value
FROM node node
LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid
LEFT JOIN content_type_dealership_news_item node_data_field_news_thumbnail ON node.vid = node_data_field_news_thumbnail.vid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN content_type_dealership_news_item node_data_field_news_date ON node.vid = node_data_field_news_date.vid
WHERE (node.type in ('dealership_news_item'))
AND (((domain_access.realm = 'domain_id'
AND domain_access.gid = ***CURRENT_DOMAIN***)
OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0)))
AND (node.status <> 0)
ORDER BY node_data_field_news_date_field_news_date_value DESC

Question is: why am I getting different incomplete results through the preview interface and on the websites?