SELECT BlogName || '.tumblr.com/post/' || postID, datetime(NotesGatheredDateTime, 'unixepoch'), * FROM Posts WHERE NotesGatheredDateTime <> 0 ORDER BY postdate descSELECT datetime(TimeStamp, 'unixepoch'), rbn.BlogName || '.tumblr.com/post/' || N.postid, *, nbn.BlogName || '.tumblr.com' FROM Notes N inner JOIN BlogNames rbn on rbn.BlogId = N.RootBlogId inner JOIN BlogNames nbn on nbn.BlogId = N.NoteBlogId inner JOIN NoteTypes t on t.TypeId = N.TypeId inner JOIN Posts P on P.PostID = N.PostID and P.BlogName = rbn.BlogName WHERE rbn.BlogName NOT IN ('xlittle-ghost', 'glimmerin-darlin', 'vvenus-child') and t.Type like 'r%' and rbn.BlogName = 'zomb-eh' and P.HasImage = 1 ORDER BY TimeStamp desc