Sheridan

;; Copyright (C) 2014 Emanuele Tomasi <targzeta@gmail.com>

;; This program is free software: you can redistribute it and/or modify
;; it under the terms of the GNU General Public License as published by
;; the Free Software Foundation, either version 3 of the License, or
;; (at your option) any later version.
;;
;; This program is distributed in the hope that it will be useful,
;; but WITHOUT ANY WARRANTY; without even the implied warranty of
;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

Sheridan

Verifying that +sheridan is my openname (Bitcoin username). https://onename.io/sheridan

Sheridan

select i from 
                (
                    select t1.parentid as i from rsdn_messages t1
                    where not exists (select t2.id from rsdn_messages t2 where t2.id=t1.parentid) and t1.parentid != 0 and t1.forumid in (0,1,2,3,33,32)
                union
                    select t3.topicid as i from rsdn_messages t3
                    where not exists(select t4.id from rsdn_messages t4 where t4.id=t3.topicid) and t3.topicid != 0 and t3.forumid in (0,1,2,3,33,32)
                ) t