From here is it possible to see the full and detailed actions of timeline. Example: number upvotes, question or answer link/id time received etc?
How is it possible to receive it from SEDE?
@Martin perfect; thank you! I'm not a DBA, so I'm really hacking at the SQL. Also found data.stackexchange.com/unix/query/82456/sql-server-row-number, but I think my actual problem was that I didn't name my tables, so I kept "running out of resources"
hrmph. I don't know enough SQL :(
If I wanted to select users that do not have the Informed badge, what's the right incantation? I tried SELECT ... from Users LEFT OUTER JOIN badges on b.userid = u.id and b.name = 'Informed' ... but I'm getting users in the results that do have the Informed badge
Using this query,
I would like to add a new column with user id
I try this
;with postvotes as
(
select v.creationdate,
, p.id postid
, case v.votetypeid
when 1 then 'accepts'
when 2 then 'up-votes'
when 3 then 'down-votes'
...