JOIN and PART functionality added for archive view