**********************************
tested: drupal 6.14, views 2.8, acl 1.0

DISTINCT OFF IN VIEW
* Original query: SELECT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
* Modified query: SELECT DISTINCT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
* Original query: SELECT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
* Modified query: SELECT DISTINCT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)

Results WITHOUT PAGER

DISTINCT ON IN VIEW
* Original query: SELECT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d) GROUP BY nid
* Modified query: SELECT DISTINCT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d) GROUP BY nid
* Original query: SELECT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d) GROUP BY nid
* Modified query: SELECT DISTINCT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d) GROUP BY nid

Results! (only ONE RESULT, the first)


************************************
tested: drupal 6.14, views 2.6, acl 1.0

DISTINCT OFF IN VIEW
# Original query: SELECT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
# Modified query: SELECT DISTINCT node.nid AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
# Original query: SELECT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
# Modified query: SELECT DISTINCT node.nid AS nid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d) 

Results WITHOUT PAGER

DISTINCT ON IN VIEW
# Original query: SELECT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
# Modified query: SELECT DISTINCT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
# Original query: SELECT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d)
# Modified query: SELECT DISTINCT DISTINCT(node.nid) AS nid, node_data_field_photoperioxes.field_photoperioxes_fid AS node_data_field_photoperioxes_field_photoperioxes_fid, node_data_field_photoperioxes.field_photoperioxes_list AS node_data_field_photoperioxes_field_photoperioxes_list, node_data_field_photoperioxes.field_photoperioxes_data AS node_data_field_photoperioxes_field_photoperioxes_data, node_data_field_photoperioxes.delta AS node_data_field_photoperioxes_delta, node.type AS node_type, node.vid AS node_vid FROM {node} node LEFT JOIN {content_field_photoperioxes} node_data_field_photoperioxes ON node.vid = node_data_field_photoperioxes.vid WHERE (node.status <> 0) AND (node.type in ('%s')) AND (node.nid = %d) 

Results OK WITH PAGER