WPSA
  • 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 node.nid, usernode_users.created AS usernode_users_created, users.uid AS users_uid, profile_firstname.value AS profile_firstname_value, profile_lastname.value AS profile_lastname_value, profile_brand.value AS profile_brand_value, profile_hometown.value AS profile_hometown_value FROM node node INNER JOIN usernode usernode ON node.nid = usernode.nid LEFT JOIN users usernode_users ON usernode.uid = usernode_users.uid INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_firstname ON users.uid = profile_firstname.uid AND profile_firstname.fid = '6' LEFT JOIN profile_values profile_lastname ON users.uid = profile_lastname.uid AND profile_lastname.fid = '5' LEFT JOIN profile_values profile_brand ON users.uid = profile_brand.uid AND profile_brand.fid = '3' LEFT JOIN profile_values profile_hometown ON users.uid = profile_hometown.uid AND profile_hometown.fid = '43' WHERE (node.type IN ('usernode')) AND (usernode_users.status = '1') ORDER BY usernode_users_created DESC LIMIT 0, 4 in /home/content/h/a/r/harlenfoley/html/includes/database.mysql.inc on line 172.
  • 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 node.nid, usernode_users.created AS usernode_users_created, users.uid AS users_uid, profile_firstname.value AS profile_firstname_value, profile_lastname.value AS profile_lastname_value, profile_brand.value AS profile_brand_value, profile_hometown.value AS profile_hometown_value FROM node node INNER JOIN usernode usernode ON node.nid = usernode.nid LEFT JOIN users usernode_users ON usernode.uid = usernode_users.uid INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_featured ON users.uid = profile_featured.uid AND profile_featured.fid = '275' LEFT JOIN profile_values profile_firstname ON users.uid = profile_firstname.uid AND profile_firstname.fid = '6' LEFT JOIN profile_values profile_lastname ON users.uid = profile_lastname.uid AND profile_lastname.fid = '5' LEFT JOIN profile_values profile_brand ON users.uid = profile_brand.uid AND profile_brand.fid = '3' LEFT JOIN profile_values profile_hometown ON users.uid = profile_hometown.uid AND profile_hometown.fid = '43' WHERE (node.type IN ('usernode')) AND (usernode_users.status = '1') AND (profile_featured.value = '1') ORDER BY usernode_users_created DESC LIMIT 0, 3 in /home/content/h/a/r/harlenfoley/html/includes/database.mysql.inc on line 172.

text text