MODS::DBConnect=HASH(0x1acf728) DBI::db=HASH(0x1be4068) dashboard.cgi 299 SELECT nr.named_release_id AS id, nr.name, nr.version_label, nr.tier, nr.description, DATE_FORMAT(nr.released_at, '%b %d, %Y') AS released_h, UNIX_TIMESTAMP(nr.released_at) AS released_epoch, (SELECT COUNT(*) FROM NAMED_RELEASE_PINS p WHERE p.named_release_id = nr.named_release_id) AS pin_ct FROM NAMED_RELEASES nr WHERE nr.tier IN ('stable', 'working') ORDER BY (nr.tier = 'stable') DESC, nr.released_at DESC LIMIT 6