Friends, I am going crazy as a condition that I do not want is happening despite my wishes.

[DoyaCat]

Friends, I have a news notification event similar to Facebook. I show the events that develop in the titles opened by individuals on Facebook and in the notification panel on this site. My issue is to have the notification show when the title belongs to me or when the activities of users I follow occur in titles I have opened. Key Values to be Explained: OwnerID indicates who the news belongs to in the news table. Type indicates what type of news it is. For example, think of Example 1 as opening a title, adding 2 comments, liking 3 comments. user_follow.UserID indicates the user being followed in my user follow table. Goal: Notify me if the titles I have added are approved or if the users I follow have interacted with the titles I have opened. Conditions: (OwnerID = ME and Type = Title Opened) means a title has been opened, or (OwnerID = ME and user_follow.UserID = ME and news.UserID != ME and Type != Title Opened) means the users I follow will interact with the titles I have opened. The problem here is that only the users I follow as specified are not working; it also includes users I do not follow. SELECT news.UserID, news.OwnerID, titles.TitleName, titles.SEO, options.OptionName, news.Type, news.OwnerSaw, news.AddedDate NewsDate, users.Name, users.LastName, users.ProfilePicture FROM news LEFT JOIN titles ON news.BestofID = titles.BestofID LEFT JOIN options ON news.OptionID = options.OptionID LEFT JOIN users ON news.UserID = users.UserID LEFT JOIN user_follow ON news.OwnerID = user_follow.UserID WHERE (OwnerID = 1 AND Type = 1 AND news.UserID = 1) OR (OwnerID = 1 AND user_follow.UserID = 1 AND news.UserID != 1 AND Type != 1) GROUP BY news.NewsID ORDER BY news.AddedDate DESC LIMIT 10 Normally, logically, if anyone interacts with any news in my titles, notify me, and this works flawlessly. However, when it comes to being notified only when users I follow interact with my titles, issues arise.