You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: server/services/articles.js
+1-1Lines changed: 1 addition & 1 deletion
Original file line number
Diff line number
Diff line change
@@ -9,7 +9,7 @@ var Articles = {
9
9
10
10
// Returns Flow stories that haven't been moderated.
11
11
pending(cb){
12
-
db.query('SELECT * FROM articles where approved IS NULL ORDER BY created_at ASC',[],cb)
12
+
db.query('SELECT a.id, a,url, a.title, a.slug, a.body, u.name, u.avatar_url FROM articles as a JOIN users as u on a.user_id = u.id WHERE approved IS NULL ORDER BY a.created_at ASC',[],cb)
13
13
},
14
14
15
15
// Return 25 of the most recent Flow and News articles that are published
0 commit comments