megajoining selects for configuration properties