Hola y bienvenido @rapphann ![]()
Me temo que yo tampoco soy un maestro de SQL
Pero creo que sería algo así:
SELECT us.user_id, current_timestamp AS granted_at
FROM user_stats AS us
WHERE us.likes_received >= 100
AND us.likes_given >= 100
AND (:backfill OR us.user_id IN (:user_ids))