I have view with three arguments. One of them is tid. This works but when nodes have multiple terms, they are double in the SQL agregation. If I activate the reduce duplicates function, I get

user warning: Unknown column 'preview' in 'on clause' query: SELECT COUNT(*) FROM (SELECT COUNT(node.nid) AS nid, users_node_data_field_assign.uid AS users_node_data_field_assign_uid, users_node_data_field_assign.name AS users_node_data_field_assign_name, node_users_node_data_field_assign.title AS node_users_node_data_field_assign_title, node_users_node_data_field_assign.nid AS node_users_node_data_field_assign_nid, GREATEST(node.changed, node_comment_statistics.last_comment_timestamp) AS node_comment_statistics_last_updated FROM node node LEFT JOIN content_field_assign node_data_field_assign ON node.vid = node_data_field_assign.vid INNER JOIN users users_node_data_field_assign ON node_data_field_assign.field_assign_uid = users_node_data_field_assign.uid INNER JOIN node node_users_node_data_field_assign ON users_node_data_field_assign.uid = node_users_node_data_field_assign.uid AND node_users_node_data_field_assign.type = 'profile' LEFT JOIN content_field_status node_data_field_status ON node.vid = node_data_field_status.vid LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = preview INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status <> 0) AND (node_data_field_status.field_status_value IS NOT NULL) AND (node_data_field_assign.field_assign_uid IS NOT NULL) AND (node_data_field_status.field_status_value = 'views') AND (term_node_value_0.tid = 0) GROUP BY users_node_data_field_assign_uid ORDER BY nid DESC, node_comment_statistics_last_updated DESC ) count_alias in C:\xampp\htdocs\atriumteam\profiles\openatrium\modules\contrib\views\includes\view.inc on line 745