user warning: Table './utagents_drupal/profile_values' is marked as crashed and should be repaired
query: SELECT users.uid AS uid,
users.picture AS users_picture,
users.name AS users_name,
users.mail AS users_mail,
profile_values_profile_firstname.value AS profile_values_profile_firstname_value,
profile_values_profile_lastname.value AS profile_values_profile_lastname_value,
profile_values_profile_lastname.uid AS profile_values_profile_lastname_uid,
profile_values_profile_agency.value AS profile_values_profile_agency_value,
RAND() AS _random
FROM users users
INNER JOIN users_roles users_roles ON users.uid = users_roles.uid
LEFT JOIN profile_values profile_values_profile_firstname ON users.uid = profile_values_profile_firstname.uid AND profile_values_profile_firstname.fid = '7'
LEFT JOIN profile_values profile_values_profile_lastname ON users.uid = profile_values_profile_lastname.uid AND profile_values_profile_lastname.fid = '8'
LEFT JOIN profile_values profile_values_profile_agency ON users.uid = profile_values_profile_agency.uid AND profile_values_profile_agency.fid = '24'
WHERE (users_roles.rid = 3) AND ((profile_values_profile_firstname.value) != ('')) AND ((profile_values_profile_lastname.value) != (''))
ORDER BY _random ASC
LIMIT 0, 10 in /home/utagents/public_html/sites/all/modules/views/includes/view.inc on line 810.
