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 u. * , u.access AS lastlogin, name_first.value AS name_first, name_last.value AS name_last, vistaleader.value AS vistaleader, enddate.value AS enddate, blog.lastblog AS lastblog, blog.blognid as blognid
FROM users u
INNER JOIN profile_values name_first ON u.uid = name_first.uid
AND name_first.fid =26
INNER JOIN profile_values name_last ON u.uid = name_last.uid
AND name_last.fid =27
INNER JOIN profile_values vista_role ON u.uid = vista_role.uid
AND vista_role.fid =13
LEFT JOIN profile_values vistaleader ON u.uid = vistaleader.uid
AND vistaleader.fid =41
LEFT JOIN profile_values enddate ON u.uid = enddate.uid
AND enddate.fid =17
LEFT JOIN (
SELECT max( blog.created ) AS lastblog, blog.uid, max(blog.nid) as blognid
FROM node blog
WHERE TYPE = 'field_report'
GROUP BY blog.uid
ORDER BY blog.created DESC
)blog ON u.uid = blog.uid
WHERE vista_role.value = 'current'
ORDER BY name_first ASC in /home/communo3/public_html/ctcvista.org/includes/database.mysql.inc on line 172.
