Our dedicated and professional members are located across the UK and abroad. NAVP ensures that all members have met strict joining and annual renewal criteria, so you can have peace of mind that your animal will be in safe, professional hands.
186string(809) "SELECT SQL_CALC_FOUND_ROWS u.ID, umf.meta_value as first_name, uml.meta_value as last_name FROM wp_users u LEFT JOIN wp_usermeta umh ON umh.meta_key = 'pmpromd_hide_directory' AND u.ID = umh.user_id LEFT JOIN wp_pmpro_memberships_users mu ON u.ID = mu.user_id LEFT JOIN wp_usermeta umf ON umf.meta_key = 'first_name' AND u.ID = umf.user_id LEFT JOIN wp_usermeta uml ON uml.meta_key = 'last_name' AND u.ID = uml.user_id LEFT JOIN wp_usermeta umm
ON umm.meta_key = CONCAT('pmpro_approval_', mu.membership_id)
AND umm.meta_key != 'pmpro_approval_log'
AND u.ID = umm.user_id WHERE mu.status = 'active' AND (umh.meta_value IS NULL OR umh.meta_value <> '1') AND mu.membership_id > 0 AND ( umm.meta_value LIKE '%approved%' OR umm.meta_value IS NULL ) GROUP BY u.ID ORDER BY u.display_name ASC LIMIT 345, 15"