我正在尝试获取提交总数，我想要2个结果，1个具有特定状态的提交和1个具有所有状态:SELECTsubmissions.campid,COUNT(submissions.id)ASsubsCountTotal,(SELECTCOUNT(submissions.id)FROMsubmissions,campaingsWHEREsubmissions.campid=campaings.idANDcampaings.status=1andsubmissions.time>=campaings.startdateandsubmissions.status=10GROUPBYsubmissions