select count(n.nid) as count from node n inner join content_type_kefuchat kefuchat on n.nid=kefuchat.nid inner join content_field_genzong_time genzong_time on n.nid=genzong_time.nid inner join content_field_time field_time on n.nid=field_time.nid inner join content_field_is_baoming is_baoming on n.nid=is_baoming.nid inner join content_field_is_dingjing is_dingjing on n.nid=is_dingjing.nid where n.type='kefuchat' and field_time.field_time_value >='2017-02-28 16:00:00' and kefuchat.field_suozaixiaoqu_value in ('wz','xq','hd') and genzong_time.field_genzong_time_value is null and kefuchat.f
