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
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 node node_users_2 ON users.uid = node_users_2.uid AND node_users_2.type = 'profile1'
LEFT JOIN content_field_image_image node_data_field_image_image ON node.vid = node_data_field_image_image.vid
INNER JOIN users_roles users_roles ON node.uid = users_roles.uid
INNER JOIN content_type_escort_data node_users_1_node_data_field_whatdoyouintend ON node_users_1.vid = node_users_1_node_data_field_whatdoyouintend.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_field_land2 node_data_field_land2_value_0 ON node_users.vid = node_data_field_land2_value_0.vid AND node_data_field_land2_value_0.field_land2_value = '25'
LEFT JOIN content_type_personal_data node_users_node_data_field_ort ON node_users.vid = node_users_node_data_field_ort.vid
LEFT JOIN content_type_profile1 node_users_2_node_data_field_nationality ON node_users_2.vid = node_users_2_node_data_field_nationality.vid
LEFT JOIN content_type_escort_data node_users_1_node_data_field_buchbar ON node_users_1.vid = node_users_1_node_data_field_buchbar.vid
WHERE (node.status = 1) AND (node_data_field_image_image.delta = 0) AND (node.type in ('personal_gallery')) AND (users.status <> 0) AND (users_roles.rid = 4) AND (node_users_1_node_data_field_whatdoyouintend.field_whatdoyouintend_value = 2) 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_land2_value_0.field_land2_value = '25')
) count_alias in /mnt/web012/c2/99/52521299/htdocs/escort/sites/all/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_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_node_data_field_ort.field_ort_value AS node_users_node_data_field_ort_field_ort_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,
node_users_node_data_field_ort.field_postleitzahl_value AS node_users_node_data_field_ort_field_postleitzahl_value,
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_2_node_data_field_nationality.field_nationality_value AS node_users_2_node_data_field_nationality_field_nationality_value,
node_users_2.nid AS node_users_2_nid,
node_users_2.language AS node_users_2_language,
node_users_2.type AS node_users_2_type,
node_users_2.vid AS node_users_2_vid,
node_users_node_data_field_ort.field_date_birthday_value AS node_users_node_data_field_ort_field_date_birthday_value,
node_users_2_node_data_field_nationality.field_grebe_value AS node_users_2_node_data_field_nationality_field_grebe_value,
node_users_2_node_data_field_nationality.field_weight_value AS node_users_2_node_data_field_nationality_field_weight_value,
node_users_1_node_data_field_buchbar.field_buchbar_value AS node_users_1_node_data_field_buchbar_field_buchbar_value,
node_users_1.type AS node_users_1_type,
node_users_1.vid AS node_users_1_vid,
users.uid AS users_uid,
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 node node_users_2 ON users.uid = node_users_2.uid AND node_users_2.type = 'profile1'
LEFT JOIN content_field_image_image node_data_field_image_image ON node.vid = node_data_field_image_image.vid
INNER JOIN users_roles users_roles ON node.uid = users_roles.uid
INNER JOIN content_type_escort_data node_users_1_node_data_field_whatdoyouintend ON node_users_1.vid = node_users_1_node_data_field_whatdoyouintend.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_field_land2 node_data_field_land2_value_0 ON node_users.vid = node_data_field_land2_value_0.vid AND node_data_field_land2_value_0.field_land2_value = '25'
LEFT JOIN content_type_personal_data node_users_node_data_field_ort ON node_users.vid = node_users_node_data_field_ort.vid
LEFT JOIN content_type_profile1 node_users_2_node_data_field_nationality ON node_users_2.vid = node_users_2_node_data_field_nationality.vid
LEFT JOIN content_type_escort_data node_users_1_node_data_field_buchbar ON node_users_1.vid = node_users_1_node_data_field_buchbar.vid
WHERE (node.status = 1) AND (node_data_field_image_image.delta = 0) AND (node.type in ('personal_gallery')) AND (users.status <> 0) AND (users_roles.rid = 4) AND (node_users_1_node_data_field_whatdoyouintend.field_whatdoyouintend_value = 2) 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_land2_value_0.field_land2_value = '25')
ORDER BY node_created DESC
LIMIT 0, 8 in /mnt/web012/c2/99/52521299/htdocs/escort/sites/all/modules/views/includes/view.inc on line 810.
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.