user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
query: SELECT COUNT(*) FROM (SELECT node.nid AS nid
FROM node node
WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
LEFT JOIN term_hierarchy th3 ON th2.parent = th3.tid
WHERE tn.tid = 717
OR th1.tid = 717
OR th2.tid = 717
OR th3.tid = 717
))
) count_alias in /home/infomir_account/myinfomir.com/modules/views/includes/view.inc on line 805.
user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
query: SELECT node.nid AS nid,
node.sticky AS node_sticky,
node.created AS node_created
FROM node node
WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
LEFT JOIN term_hierarchy th3 ON th2.parent = th3.tid
WHERE tn.tid = 717
OR th1.tid = 717
OR th2.tid = 717
OR th3.tid = 717
))
ORDER BY node_sticky DESC, node_created DESC
LIMIT 0, 10 in /home/infomir_account/myinfomir.com/modules/views/includes/view.inc on line 810.