SELECT DISTINCT final_query.ID
FROM (
SELECT u.ID
FROM tcZVFXaoTc_users u
INNER JOIN tcZVFXaoTc_usermeta um ON um.user_id = u.ID AND um.meta_key = ‘member_exp’
WHERE CAST(um.meta_value AS DATE) >= CURRENT_DATE()
AND CONCAT(
(SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = u.ID AND meta_key = ‘first_name’ LIMIT 1), ‘ ‘,
(SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = u.ID AND meta_key = ‘last_name’ LIMIT 1)
) LIKE ‘{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}’
AND (SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = u.ID AND meta_key = ‘billing_company’ LIMIT 1) LIKE ‘{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}’
AND (SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = u.ID AND meta_key = ‘wp_capabilities’ LIMIT 1) LIKE ‘{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}member{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}’
UNION
SELECT DISTINCT postmeta.meta_value AS ID
FROM tcZVFXaoTc_postmeta AS postmeta
INNER JOIN tcZVFXaoTc_posts AS posts ON postmeta.post_id = posts.ID
WHERE posts.post_type LIKE ‘shop_subscription’
AND posts.post_status LIKE ‘wc-active’
AND postmeta.meta_key = ‘_customer_user’
AND CONCAT(
(SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = postmeta.meta_value AND meta_key = ‘first_name’ LIMIT 1), ‘ ‘,
(SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = postmeta.meta_value AND meta_key = ‘last_name’ LIMIT 1)
) LIKE ‘{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}’
AND (SELECT meta_value FROM tcZVFXaoTc_usermeta WHERE user_id = postmeta.meta_value AND meta_key = ‘billing_company’ LIMIT 1) LIKE ‘{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}{8ab2b2408421595f66ed2f8fa0132ebc1e7ad8a591337bb16cffa2f6f356c8b9}’
) AS final_query
JOIN tcZVFXaoTc_usermeta um_last
ON um_last.user_id = final_query.ID
AND um_last.meta_key = ‘last_name’
ORDER BY um_last.meta_value
