Number of topics with media (url, video, image): 31,689[spoiler]select format(count(*), 0) from bungie.alltopics p where length(p.urlLinkOrImage) > 0;[/spoiler] Image formats used in OP's posts: [quote].jpg - 67,606 .png - 15,071 .gif - 7,735 .jpeg - 1,197 .bmp - 28[/quote][spoiler]create temporary table if not exists bungie.image_formats( imgFormat varchar(10) ); insert into image_formats values('.jpg'); insert into image_formats values('.png'); insert into image_formats values('.gif'); insert into image_formats values('.jpeg'); insert into image_formats values('.bmp'); select concat(img.imgFormat, ' - ', format(count(*), 0)) from bungie.alltopics p join image_formats img where p.urlLinkOrImage like concat('%', img.imgFormat, '%') group by img.imgFormat order by count(*) desc;[/spoiler] Top 20 people who post too many topics: [quote][url=http://www.bungie.net/en/View/Profile/index?mid=106460]Onion Beetle [/url] - 1,550 [url=http://www.bungie.net/en/View/Profile/index?mid=3367840]Big Boss[/url] - 1,417 [url=http://www.bungie.net/en/View/Profile/index?mid=23356]MyNameIsCharlie[/url] - 1,172 [url=http://www.bungie.net/en/View/Profile/index?mid=423038]TopWargamer[/url] - 1,089 [url=http://www.bungie.net/en/View/Profile/index?mid=324961]BADMAGIK[/url] - 855 [url=http://www.bungie.net/en/View/Profile/index?mid=744314]Gojira[/url] - 710 [url=http://www.bungie.net/en/View/Profile/index?mid=59027]WeededDragon[/url] - 703 [url=http://www.bungie.net/en/View/Profile/index?mid=2830422]TheChimichanga[/url] - 695 [url=http://www.bungie.net/en/View/Profile/index?mid=139127]The Defiant Few[/url] - 583 [url=http://www.bungie.net/en/View/Profile/index?mid=2637113]Player3Th0mas[/url] - 541 [url=http://www.bungie.net/en/View/Profile/index?mid=167320]lonepaul2441[/url] - 525 [url=http://www.bungie.net/en/View/Profile/index?mid=3813277]Black Heart[/url] - 508 [url=http://www.bungie.net/en/View/Profile/index?mid=3473480]Mister Sparkles [/url] - 495 [url=http://www.bungie.net/en/View/Profile/index?mid=3992460]The Onyx Taco[/url] - 494 [url=http://www.bungie.net/en/View/Profile/index?mid=2366481]Elegiac[/url] - 462 [url=http://www.bungie.net/en/View/Profile/index?mid=484031]AngryBrute[/url] - 425 [url=http://www.bungie.net/en/View/Profile/index?mid=3425829]Fat Man 3000[/url] - 419 [url=http://www.bungie.net/en/View/Profile/index?mid=3777375]jjj205[/url] - 409 [url=http://www.bungie.net/en/View/Profile/index?mid=423269]Spartan Ken 15[/url] - 406 [url=http://www.bungie.net/en/View/Profile/index?mid=3325860]o_____________o[/url] - 404 [/quote][spoiler]select concat( '[url=http://www.bungie.net/en/View/Profile/index?mid=', u.membershipId, ']', u.displayName, '[/url] - ', format(count(*), 0) ) from bungie.alltopics p join users u on u.membershipId = p.authorMembershipId group by p.authorMembershipId order by count(*) desc limit 0, 20;[/spoiler] Top 20 most edited topics:[quote][url=http://www.bungie.net/en/Forum/Post?id=61102938]CSS[/url] - 167 [url=http://www.bungie.net/en/Forum/Post?id=60296558]The 3DS Thread - News, Recommendations, and More![/url] - 160 [url=http://www.bungie.net/en/Forum/Post?id=62593404]Character Class/Race Poll; What will you choose?[/url] - 103 [url=http://www.bungie.net/en/Forum/Post?id=63010352]Santa's naughty list (over 100 names)[/url] - 100 [url=http://www.bungie.net/en/Forum/Post?id=47679257]Tags to find old threads + Top Topics archive [Part 1][/url] - 99 [url=http://www.bungie.net/en/Forum/Post?id=59798855]Official Destiny ARG (ARG: Complete!)[/url] - 99 [url=http://www.bungie.net/en/Forum/Post?id=60690785]Stills from Destiny Gameplay - New Confirmations[/url] - 97 [url=http://www.bungie.net/en/Forum/Post?id=60679220]Flood Census 2013[/url] - 86 [url=http://www.bungie.net/en/Forum/Post?id=62508136]Smi is streaming extremely lazily[/url] - 74 [url=http://www.bungie.net/en/Forum/Post?id=60351818]Alright, let's get some emotionally moving video game music here[/url] - 73 [url=http://www.bungie.net/en/Forum/Post?id=63173995]Realistic Usernames Thread! (75+ and counting asdf)[/url] - 73 [url=http://www.bungie.net/en/Forum/Post?id=60353469]CSS[/url] - 72 [url=http://www.bungie.net/en/Forum/Post?id=61023959]Crustiest of the crusty: Bnet'ers leave you're mark here![/url] - 67 [url=http://www.bungie.net/en/Forum/Post?id=49457946]Solution for redundant tags and sub forums[/url] - 66 [url=http://www.bungie.net/en/Forum/Post?id=59869003]PS4 out holidays 2013, check out the notes I made and discuss[/url] - 63 [url=http://www.bungie.net/en/Forum/Post?id=62298459]Pokemon Central------3DS codes[/url] - 63 [url=http://www.bungie.net/en/Forum/Post?id=60587930]CSS[/url] - 62 [url=http://www.bungie.net/en/Forum/Post?id=62756466]Join the legion of the Doge.[/url] - 60 [url=http://www.bungie.net/en/Forum/Post?id=61975329]Halo Wars Anyone?[/url] - 56 [url=http://www.bungie.net/en/Forum/Post?id=60721271]A factual comparison of the consoles[/url] - 54[/quote][spoiler]select concat( '[url=http://www.bungie.net/en/Forum/Post?id=', t.postId, ']', t.subject, '[/url] - ', t.editCount ) from bungie.alltopics t order by t.editCount desc limit 0, 20;[/spoiler] Number of topics edited not by the user who created it: 4,464[spoiler]select format(count(*), 0) from bungie.alltopics p where p.editorMembershipid != p.authorMembershipId;[/spoiler] Number of "shit" topics (topics with "shit" in the title, LOL): 587[spoiler]select format(count(*), 0) from bungie.alltopics p where lower(p.subject) like '%shit%';[/spoiler] Top 20 most active days for group creation: [quote]2013-08-31 - 18 2013-10-07 - 16 2013-02-18 - 16 2014-01-06 - 12 2013-07-10 - 12 2013-06-11 - 11 2013-10-21 - 11 2013-10-06 - 11 2013-07-08 - 11 2013-06-23 - 11 2013-11-02 - 11 2013-06-04 - 10 2013-06-22 - 10 2013-10-23 - 10 2013-10-03 - 10 2013-02-19 - 9 2013-10-04 - 9 2013-01-10 - 9 2013-09-03 - 9 2013-07-07 - 9[/quote][spoiler]select concat( date(g.creationDate), ' - ', format(count(*), 0) ) from bungie.groups g group by date(g.creationDate) order by count(*) desc limit 0, 20;[/spoiler] Number of groups that mention Destiny in their about section: 422[spoiler]select format(count(*), 0) from bungie.groups g where lower(g.about) like '%destiny%';[/spoiler] Number of groups that have Destiny as part of their group's name: 147[spoiler]select format(count(*), 0) from bungie.groups g where lower(g.name) like '%destiny%';[/spoiler] Number of groups that mention Destiny in either their name or about sections but are not tagged with #Destiny: 239[spoiler]select format(count(*), 0) from bungie.groups g where (lower(g.name) like '%destiny%' or lower(g.about) like '%destiny%') and not exists( select * from bungie.group_tags gt where gt.groupId = g.groupId and gt.tagId = (select tagId from bungie.tags where name = '#Destiny') ) [/spoiler] Top 20 most followed groups: [quote][url=http://www.bungie.net/en/Groups/Detail?groupId=3656]The Spartan I Project[/url] - 11,523 [url=http://www.bungie.net/en/Groups/Detail?groupId=8263]Coup D Bungie[/url] - 6,763 [url=http://www.bungie.net/en/Groups/Detail?groupId=2442]The Bungie Podcast[/url] - 4,736 [url=http://www.bungie.net/en/Groups/Detail?groupId=293]Mjolnir Battle Tactics[/url] - 3,674 [url=http://www.bungie.net/en/Groups/Detail?groupId=2302]Owners of the Katana[/url] - 3,407 [url=http://www.bungie.net/en/Groups/Detail?groupId=16555]Destiny[/url] - 3,344 [url=http://www.bungie.net/en/Groups/Detail?groupId=2812]Facility B5D[/url] - 1,721 [url=http://www.bungie.net/en/Groups/Detail?groupId=12337]Sapphire[/url] - 1,682 [url=http://www.bungie.net/en/Groups/Detail?groupId=39699]Bungie Mail Sack[/url] - 1,352 [url=http://www.bungie.net/en/Groups/Detail?groupId=13461]Minecrafters[/url] - 1,093 [url=http://www.bungie.net/en/Groups/Detail?groupId=602]KOTOR[/url] - 1,028 [url=http://www.bungie.net/en/Groups/Detail?groupId=3338]HLG[/url] - 950 [url=http://www.bungie.net/en/Groups/Detail?groupId=10888]Ask Your Ninja[/url] - 903 [url=http://www.bungie.net/en/Groups/Detail?groupId=19291]The Bird People[/url] - 782 [url=http://www.bungie.net/en/Groups/Detail?groupId=18533]TFS The Floods Sanctuary[/url] - 768 [url=http://www.bungie.net/en/Groups/Detail?groupId=3493]Mythic Members[/url] - 761 [url=http://www.bungie.net/en/Groups/Detail?groupId=19014]Halo Forum[/url] - 750 [url=http://www.bungie.net/en/Groups/Detail?groupId=16959]Secular Sevens[/url] - 729 [url=http://www.bungie.net/en/Groups/Detail?groupId=18909]Sociopaths United[/url] - 723 [url=http://www.bungie.net/en/Groups/Detail?groupId=39813]Art and Stuff[/url] - 692[/quote][spoiler]select concat( '[url=http://www.bungie.net/en/Groups/Detail?groupId=', g.groupId, ']', g.name, '[/url] - ', format(g.followerCount, 0) ) from bungie.groups g order by g.followerCount desc limit 0, 20;[/spoiler]