0

Please login or register to vote for this query.

(click on this box to dismiss)

Zero and non-zero accepted count. Self-accepted answers do not count.

Q&A about the site for Joomla! administrators, users, developers and designers

-- How Unsung am I?
-- Zero and non-zero accepted count. Self-accepted answers do not count.
select * from votetypes;
--select top 100 * from votes;
with A as (select p.id as [Post Link], v.creationdate, v.votetypeid,
case when votetypeid = 1 then 15 else case when votetypeid = 2 then 10 else -2 end end as drep
from votes v inner join posts p on v.postid = p.id
where v.votetypeid<4 and
p.owneruserid = 2093077)
select creationdate, sum(drep) from A
group by creationdate
order by creationdate desc

fork query

edited nov 29 20 anonymous

created jul 17 10 Eric