- user warning: Unknown column 'node_data_field_edmember_firstname.field_edmember_firstname_valu' in 'field list'
query: SELECT COUNT(*) FROM (SELECT DISTINCT(users.uid) AS uid_1,
node_users_node_data_field_edmember_photo.field_edmember_photo_fid AS node_users_node_data_field_edmember_photo_field_edmember_pho,
node_users_node_data_field_edmember_photo.field_edmember_photo_list AS node_users_node_data_field_edmember_photo_field_edmember_pho_1,
node_users_node_data_field_edmember_photo.field_edmember_photo_data AS node_users_node_data_field_edmember_photo_field_edmember_pho_2,
node_users.type AS node_users_type,
node_users.nid AS node_users_nid,
node_users.vid AS node_users_vid,
node_users_node_data_field_salutation.field_salutation_value AS node_users_node_data_field_salutation_field_salutation_value,
node_users_node_data_field_edmember_photo.field_edmember_name_value AS node_users_node_data_field_edmember_photo_field_edmember_nam,
node_users_node_data_field_edmember_photo.field_edmember_firstname_value AS node_users_node_data_field_edmember_photo_field_edmember_fir,
node_users__location.city AS node_users__location_city,
node_users__location.province AS node_users__location_province,
node_users__location.country AS node_users__location_country,
node_users__location.lid AS node_users__location_lid,
users.uid AS uid,
node_data_field_edmember_firstname.field_edmember_firstname_value AS node_users_node_data_field_edmember_photo_field_edmember_fir_1
FROM users users
INNER JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile'
INNER JOIN users_roles users_roles ON users.uid = users_roles.uid
LEFT JOIN content_type_profile node_users_node_data_field_edmember_photo ON node_users.vid = node_users_node_data_field_edmember_photo.vid
LEFT JOIN content_type_user_contact node_users_node_data_field_salutation ON node_users.vid = node_users_node_data_field_salutation.vid
LEFT JOIN location_instance node_users__location_instance ON node_users.vid = node_users__location_instance.vid
LEFT JOIN location_instance node_users_node_users__location_instance ON node_users.vid = node_users_node_users__location_instance.vid
LEFT JOIN location node_users__location ON node_users__location_instance.lid = node_users__location.lid
WHERE (users.status <> 0) AND (users_roles.rid = 4)
GROUP BY uid_1
ORDER BY node_users_node_data_field_edmember_photo_field_edmember_fir_1 ASC
) count_alias in /home/hublib/public_html/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
- user warning: Unknown column 'node_data_field_edmember_firstname.field_edmember_firstname_valu' in 'field list'
query: SELECT DISTINCT(users.uid) AS uid_1,
node_users_node_data_field_edmember_photo.field_edmember_photo_fid AS node_users_node_data_field_edmember_photo_field_edmember_pho,
node_users_node_data_field_edmember_photo.field_edmember_photo_list AS node_users_node_data_field_edmember_photo_field_edmember_pho_1,
node_users_node_data_field_edmember_photo.field_edmember_photo_data AS node_users_node_data_field_edmember_photo_field_edmember_pho_2,
node_users.type AS node_users_type,
node_users.nid AS node_users_nid,
node_users.vid AS node_users_vid,
node_users_node_data_field_salutation.field_salutation_value AS node_users_node_data_field_salutation_field_salutation_value,
node_users_node_data_field_edmember_photo.field_edmember_name_value AS node_users_node_data_field_edmember_photo_field_edmember_nam,
node_users_node_data_field_edmember_photo.field_edmember_firstname_value AS node_users_node_data_field_edmember_photo_field_edmember_fir,
node_users__location.city AS node_users__location_city,
node_users__location.province AS node_users__location_province,
node_users__location.country AS node_users__location_country,
node_users__location.lid AS node_users__location_lid,
users.uid AS uid,
node_data_field_edmember_firstname.field_edmember_firstname_value AS node_users_node_data_field_edmember_photo_field_edmember_fir_1
FROM users users
INNER JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile'
INNER JOIN users_roles users_roles ON users.uid = users_roles.uid
LEFT JOIN content_type_profile node_users_node_data_field_edmember_photo ON node_users.vid = node_users_node_data_field_edmember_photo.vid
LEFT JOIN content_type_user_contact node_users_node_data_field_salutation ON node_users.vid = node_users_node_data_field_salutation.vid
LEFT JOIN location_instance node_users__location_instance ON node_users.vid = node_users__location_instance.vid
LEFT JOIN location_instance node_users_node_users__location_instance ON node_users.vid = node_users_node_users__location_instance.vid
LEFT JOIN location node_users__location ON node_users__location_instance.lid = node_users__location.lid
WHERE (users.status <> 0) AND (users_roles.rid = 4)
GROUP BY uid_1
ORDER BY node_users_node_data_field_edmember_photo_field_edmember_fir_1 ASC
LIMIT 0, 15 in /home/hublib/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.
