use joins for select
alpha app management