Has anyone had this long error before or know how it can be fixed"
Error:
user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.language AS node_language, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.type AS node_type, node.created AS node_created FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid LEFT JOIN term_node term_node3 ON node.vid = term_node3.vid LEFT JOIN term_node term_node4 ON node.vid = term_node4.vid LEFT JOIN term_node term_node5 ON node.vid = term_node5.vid LEFT JOIN term_node term_node6 ON node.vid = term_node6.vid LEFT JOIN term_node term_node7 ON node.vid = term_node7.vid LEFT JOIN term_node term_node8 ON node.vid = term_node8.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node.type in ('blog', 'article', 'audio', 'event', 'op_image', 'video')) AND (((term_node.tid = 17) OR (term_node2.tid = 444) OR (term_node3.tid = 17 AND term_node4.tid = 17 AND term_node5.tid = 17 AND term_node6.tid = 17) OR (term_node7.tid = 16) OR (term_node8.tid = 14))) GROUP BY nid ORDER BY node_created DESC ) count_alias in /home3/timinmul/public_html/openpublish/sites/all/modules/views/includes/view.inc on line 745.