问如果post是由同一用户创建的，则排除计数中的用户。

EN

CREATE TABLE `member` (
  `memberid` int(11) NOT NULL,
  `email` text
);

CREATE TABLE `protocol` (
  `protocolid` int(11) NOT NULL,
  `createdby` int(11) NOT NULL,
  `status` varchar(256) DEFAULT NULL
) ;

CREATE TABLE `protocolpost` (
  `protocolid` int(11) NOT NULL,
  `protocolpostid` int(11) NOT NULL,
  `createdby` text
  ) ;

CREATE TABLE `protocolpostcomment` (
  `protocolpostcommentid` int(11) NOT NULL,
  `protocolpostid` int(11) NOT NULL,
  `commentedby` varchar(256) DEFAULT NULL,
  `hasfeedbackreplyviewed` tinyint(1) DEFAULT NULL
) ;

SELECT 
       protocols.*,
       protocolFeedbackReply.*,
       protocolfeedback.*
FROM   protocolpost AS protocolfeedback
       JOIN protocol AS protocols
         ON protocols.protocolid = protocolfeedback.protocolid
       JOIN protocolpostcomment AS protocolFeedbackReply
         ON protocolfeedback.protocolpostid =
            protocolFeedbackReply.protocolpostid
WHERE  protocols.createdby = 1038
       AND protocols.status = "published"
       AND protocolFeedbackReply.hasfeedbackreplyviewed = 0
       AND protocolfeedback.createdby NOT LIKE Concat('%', (SELECT email
                                                            FROM   member
                                                            WHERE
                                               memberid = 1038),
                                               '%');