I have a query that works when I have a field view_type = sale but when the view_type = lead it doesn't return any records even when I know there is one. Here is the query...
SELECT a.id, a.user_email, a.user_registered, a.user_login, b1.meta_value AS first_name, b2.meta_value as last_name, b3.meta_value as qualified,
b4.meta_value as referrer,
b5.meta_value as view_type,
b6.meta_value as ref_by,
b7.meta_value as wp_optimizemember_custom_fields
FROM wp_users a
INNER JOIN wp_usermeta b1 ON b1.user_id = a.ID AND b1.meta_key = 'first_name'
INNER JOIN wp_usermeta b2 ON b2.user_id = a.ID AND b2.meta_key = 'last_name'
INNER JOIN wp_usermeta b3 ON b3.user_id = a.ID AND b3.meta_key = 'qualified'
INNER JOIN wp_usermeta b4 ON b4.user_id = a.ID AND b4.meta_key = 'referrer'
INNER JOIN wp_usermeta b5 ON b5.user_id = a.ID AND b5.meta_key = 'view_type'
INNER JOIN wp_usermeta b6 ON b6.user_id = a.ID AND b6.meta_key = 'ref_by'
INNER JOIN wp_usermeta b7 ON b7.user_id = a.ID AND b7.meta_key = 'wp_optimizemember_custom_fields'
WHERE (b4.meta_value LIKE '$user_ID' AND b5.meta_value LIKE 'lead') or
(b6.meta_value LIKE '$user_ID' AND b5.meta_value LIKE 'lead')
What wrong with this query?