SELECT GREATEST(@found := 1, id) AS id ,'uesrs' AS which_tb1
FROM users where id = 1
UNOIN ALL
SELECT id , 'users_archived' FROM users_archived WHERE id = 1 AND @found IS NULL
UNOIN ALL
SELECT 1, 'reselt' FROM DUAL WHERE ( @found := NULL ) IS NOT NULL;