fixed listing active method sql syntax