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 DISTINCT(node.nid) AS nid, node_data_field_image_image.field_image_image_fid AS node_data_field_image_image_field_image_image_fid, node_data_field_image_image.field_image_image_list AS node_data_field_image_image_field_image_image_list, node_data_field_image_image.field_image_image_data AS node_data_field_image_image_field_image_image_data, node.language AS node_language, node_data_field_image_image.delta AS node_data_field_image_image_delta, node.type AS node_type, node.vid AS node_vid, node_users_1.title AS node_users_1_title, node_users_1.nid AS node_users_1_nid, node_users_1.language AS node_users_1_language, node_users_node_data_field_date_birthday.field_date_birthday_value AS node_users_node_data_field_date_birthday_field_date_birthday_value, node_users.nid AS node_users_nid, node_users.language AS node_users_language, node_users.type AS node_users_type, node_users.vid AS node_users_vid, 'Amateur Escortservice' AS customfield_markup_4, node_users_node_data_field_date_birthday.field_ort_value AS node_users_node_data_field_date_birthday_field_ort_value, users.uid AS users_uid, RAND() AS _random, node.created AS node_created FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'personal_data' LEFT JOIN node node_users_1 ON users.uid = node_users_1.uid AND node_users_1.type = 'escort_data' LEFT JOIN content_field_image_image node_data_field_image_image ON node.vid = node_data_field_image_image.vid LEFT JOIN content_field_escort_category node_data_field_escort_category_value_0 ON node_users_1.vid = node_data_field_escort_category_value_0.vid AND node_data_field_escort_category_value_0.field_escort_category_value = 1 LEFT JOIN content_field_escort_category node_data_field_escort_category_value_1 ON node_users_1.vid = node_data_field_escort_category_value_1.vid AND node_data_field_escort_category_value_1.field_escort_category_value = 3 LEFT JOIN content_field_escort_category node_data_field_escort_category_value_2 ON node_users_1.vid = node_data_field_escort_category_value_2.vid AND node_data_field_escort_category_value_2.field_escort_category_value = 7 LEFT JOIN content_field_escort_category node_data_field_escort_category_value_3 ON node_users_1.vid = node_data_field_escort_category_value_3.vid AND node_data_field_escort_category_value_3.field_escort_category_value = 8 LEFT JOIN content_type_personal_data node_users_node_data_field_date_birthday ON node_users.vid = node_users_node_data_field_date_birthday.vid WHERE (node.promote <> 0) AND (node.status = 1) AND (node.sticky <> 0) AND (node_data_field_image_image.delta = 0) AND (node.type in ('personal_gallery')) AND (users.status <> 0) AND (node_data_field_escort_category_value_0.field_escort_category_value = 1 OR node_data_field_escort_category_value_1.field_escort_category_value = 3 OR node_data_field_escort_category_value_2.field_escort_category_value = 7 OR node_data_field_escort_category_value_3.field_escort_category_value = 8) AND (node_data_field_image_image.field_image_image_list <> 0) GROUP BY nid ORDER BY _random ASC, node_created DESC LIMIT 0, 4 in /mnt/web012/c2/99/52521299/htdocs/escort/sites/all/modules/views/includes/view.inc on line 810.