added associate query