use inner instead of left join so tables with missing configs will not get used at all