Profile Punks!

Now that we are all sharing our Hive punks, I thought it would be interesting/fun to see what are those punks that have made it to profile pictures! So far there are only 71 in the list - looking forward to see it growing.

account name	punk image	punk number
@stayoutoftherz		1936
@goranb		3292
@lloyddavis		2656
@aicoding		4468
@erikah		7189
@allcapsonezero		702
@marcurio		5972
@shitsignals		2373
@martibis		2334
@fredfettmeister		1521
@maxxstorm		7186
@freedomprepper		4619
@solymi		2596
@spinvest		9623
@h3nny		3328
@swelker101		5427
@muenchen		4890
@muratkbesiroglu		3969
@black-jack-21		5043
@hetty-rowan		3242
@brettpullen		6371
@thethoughtpolice		6811
@icom7		3114
@olegn		4728
@onebakeryprod		7858
@jasonrussell		532
@papowich		5855
@jk6276		8315
@jonamccallum		5267
@wizardx		6065
@queengaga		7910
@kentzz001		3216
@distorsionz		8478
@reseller		4157
@dragosroua		3004
@robmojo		4667
@laritheghost		3755
@cooperclub		2213
@blainjones		517
@thisismylife		2458
@buff-news		4466
@sharkthelion		3111
@cancermancer		990
@splinternews		3071
@blackzoda		6222
@dinopack		4006
@frewdist		4644
@crossflow		990
@howweroll		4524
@clayboyn		3082
@splashocean		4796
@wehmoen		428
@gungunkrishu		3807
@ctrpch		8675
@shawnsporter		3351
@vlemon		2484
@steify		5020
@cloutinho69		3221
@cryptothesis		5506
@ericwilson		4589
@emrebeyler		8171
@akmenos		8269
@khan.dayyanz		4811
@skylinebuds		1776
@gertph		6284
@shandalar		7729
@weitoostrong		3341
@atnazo		8391
@rival		4683
@brianhuang		8306
@kwskicky		8481

How to?

As always, sharing is caring. If you are into exploring @hivesql data, here is a query that will allow you to easily retrieve this table:

SELECT *, 
CASE WHEN LEN(punksTable.[Punk image]) > 51 THEN SUBSTRING(punksTable.[Punk image], 45, 4) 
            ELSE SUBSTRING(punksTable.[Punk image], 45, 3) END as 'Punk number' 
FROM( SELECT 
      '@' + [name] AS 'Account'
      ,JSON_VALUE(JSON_QUERY([posting_json_metadata], '$.profile'), '$.profile_image') AS 'Punk image'
  FROM [DBHive].[dbo].[Accounts]
  where posting_json_metadata like '%hivepunks%') punksTable