added forced joins & record counting