MySQL加速左外连接/检查空查询

The object of my query is to get all rows from table a where gender = f and username does not exist in table b where campid = xxxx. Here is the query I am using with success:The object of my query is to get all rows from