and orgType = #{orgType} and registerTime = ]]> #{startDate} and registerTime #{endDate} select * from base_serviceorg limit #{iDisplayStart},#{iDisplayLength} select * from base_serviceorg where oid = #{oid} or saasComId = #{saasComId} limit 1 select count(1) from base_serviceorg SELECT IF(a.orgType = '5','安保公司','') AS orgType ,a.orgName ,a.orgIntroduce ,a.orgExperience ,a.orgExperts ,a.orgContactName ,a.orgContactPhone ,a.orgContactAddress ,a.orgScale ,a.legalName ,a.legalIdCardNo ,DATE_FORMAT(a.foundDate,'%Y-%m-%d %H:%i:%s') AS 'foundDate' ,DATE_FORMAT(a.registerTime,'%Y-%m-%d %H:%i:%s') AS 'registerTime' FROM base_serviceorg a LEFT JOIN sp_activity_serviceorg b ON a.id = b.serviceOrgId WHERE b.activityId = #{activityId} AND a.orgType = '5' SELECT CONCAT(a.id,'') AS serialNumber ,'GS0013287238YS231' AS comCerNo ,a.orgName ,DATE_FORMAT(a.foundDate,'%Y-%m-%d %H:%i:%s') AS 'foundDate' ,a.orgScale ,a.legalName ,a.legalIdCardNo FROM base_serviceorg a LEFT JOIN sp_activity_serviceorg b ON a.id = b.serviceOrgId WHERE b.activityId = #{activityId} AND a.orgType = '5' limit 1