the problem is the way you are creating the database, it is not going to do what you want this way.
you should have a users table
users:
userID - Primary Key
userName
etc...
an Articles table
articles:
articleID - Primary Key
articleUserID - Foreign key relation to the users.UserID- this is the ID of the author
articleUpdateDate
etc...
and a subscriptions table:
subscriptions:
subscriptionID - Primary Key
subscriptionArticleID - Foreign key to articles.articleID
subscriptionUserID - Foreign key to users.userID - Id of the subscribers
you can then create a recordset like
SELECT users.*, articles.*, subscriptions.*
FROM users
INNER JOIN articles (INNER JOIN subscriptions ON articles.articleID = subscriptions.subscriptionArticleID )
ON users.UserID = articles.articleUserID
WHERE subscriptions.subscriptionUserID = <User1 ID>
ORDER BY articles.articleUpdateDate ASC