fixed join issue on multiple tables. removed almost all hardcoded urls