[drupal-support] latest posts with username/pic

[Jad Madi]

$result = db_query("SELECT n.uid, n.created, n.title, n.nid, n.changed
FROM site_node n
WHERE n.type = 'blog'
ORDER BY n.changed
DESC LIMIT 50");



any idea how to add one more query to get username/picture behind the post?