changed site api to get associate data from its own columsn instead of from a separated table