WHERE ((DATE_FORMAT(ADDTIME(node_data_field_time.field_time_value, SEC_TO_TIME(28800)), '%Y-%m-%d') >= '2017-06-23') AND (node_data_field_genzong_time.field_genzong_time_value IS NULL))
AND ((node_data_field_chat_status.field_chat_status_value = 'complete') AND (node.type in ('kefuchat')) AND (node_data_field_suozaixiaoqu.field_suozaixiaoqu_value IS NULL))