/* 1820 */ select activeaccount.id as activeuserid, posts.*, accounts.username as accountsusername, accounts.fullname as accountsfullname, (select count(members.trusted) from members left join membertree on members.postid = membertree.parentid where (members.postid = posts.id or membertree.postid = posts.id) and members.accountid = activeuserid and members.trusted != 1) as activeuserispendingmember, ((select count(*) from members left join membertree on members.postid = membertree.parentid where members.accountid = activeuserid and membertree.postid = posts.id and members.trusted = 1 and members.accountid != posts.accountid) + (select count(*) from members where members.accountid = activeuserid and members.postid = posts.id and members.trusted = 1 and members.accountid != posts.accountid)) as activeuseristrustedmember, (select count(recipientaccountid) from recipients where recipients.tablename = "posts" and recipients.tableid = posts.id and recipients.recipientaccountid = activeuserid) as activeuserisrecipient, (select count(trusted) from contacts where contacts.accountid = posts.accountid and contacts.contactid = activeuserid and contacts.trusted = 1) as activeuseristrustedcontact, concat(posts.viewpermissions, posts.editpermissions, posts.replypermissions, posts.approvepermissions, posts.moderatepermissions, posts.tagpermissions) as permissions from accounts as activeaccount, posts left join accounts on posts.accountid = accounts.id where activeaccount.id = 0 and posts.id = 2090 limit 1;
Viking ship discovered under lost Norwegian burial mound
https://www.abc.net.au/news/2019-11-27/viking-burial-ship-found-norway-about-1000-years-old/11743586
Archaeologists say their data reveals the outline of a vessel that was probably used in a Viking funeral more than 1,000 years ago, buried under a mound worn down by ploughing.
Cancel esc
Cancel esc