I think you’d simply add the following:
AND EXISTS (
SELECT 1 FROM user_badges ib
WHERE cf.user_id = ib.user_id
AND ib.badge_id = 888
)
Where 888 is the badge ID number of the other prerequisite badge. See the following for details:
I think you’d simply add the following:
AND EXISTS (
SELECT 1 FROM user_badges ib
WHERE cf.user_id = ib.user_id
AND ib.badge_id = 888
)
Where 888 is the badge ID number of the other prerequisite badge. See the following for details: