Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
History is littered with hundreds of conflicts over the future of a community, group, location or business that were "resolved" when one of the parties stepped ahead and destroyed what was there. With the original point of contention destroyed, the debates would fall to the wayside. Archive Team believes that by duplicated condemned data, the conversation and debate can continue, as well as the richness and insight gained by keeping the materials. Our projects have ranged in size from a single volunteer downloading the data to a small-but-critical site, to over 100 volunteers stepping forward to acquire terabytes of user-created data to save for future generations.
The main site for Archive Team is at archiveteam.org and contains up to the date information on various projects, manifestos, plans and walkthroughs.
This collection contains the output of many Archive Team projects, both ongoing and completed. Thanks to the generous providing of disk space by the Internet Archive, multi-terabyte datasets can be made available, as well as in use by the Wayback Machine, providing a path back to lost websites and work.
Our collection has grown to the point of having sub-collections for the type of data we acquire. If you are seeking to browse the contents of these collections, the Wayback Machine is the best first stop. Otherwise, you are free to dig into the stacks to see what you may find.
The Archive Team Panic Downloads are full pulldowns of currently extant websites, meant to serve as emergency backups for needed sites that are in danger of closing, or which will be missed dearly if suddenly lost due to hard drive crashes or server failures.
环境信息
问题描述
1.有一张表如下：
CREATE TABLEidentity_certificate(idbigint(20) unsigned NOT NULL AUTO_INCREMENT,mobilevarchar(32) NOT NULL DEFAULT '' COMMENT '手机号',namevarchar(32) NOT NULL DEFAULT '' COMMENT '姓名',idcardvarchar(32) NOT NULL DEFAULT '' COMMENT '身份证号',idcard_positive_urlvarchar(500) NOT NULL DEFAULT '' COMMENT '身份证正面图片',idcard_negative_urlvarchar(500) NOT NULL DEFAULT '' COMMENT '身份证反面图片',statusint(4) NOT NULL DEFAULT '0' COMMENT '认证状态(0-待审核;1-审核通过;2-已拒绝;3-二级审核中;)', PRIMARY KEY (id) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='实名认证表';2.现在需要查询表中的最大值，sql形式如下：
select r1.* from identity_certificate r1,(select max(id) as id from identity_certificate
group by idcard) r2 where r1.id=r2.id
3.使用apijson请求
{ "[]": { 'query': 2, "page": 0, "count": 0, "identity_certificate": { "@schema": "auth", "@column": "max(id):abcid", "@group": 'idcard', }, "identity_certificate": { "@schema": "auth", "id@": "/identity_certificate/abcid", }, }, "total@": "/[]/total" }错误信息
请求变成了，第一个属性被覆盖，导致请求变成了无结果的请求。
{"[]":{"query":2,"page":0,"count":0,"identity_certificate":{"@schema":"auth","id@":"/identity_certificate/abcid"}},"total@":"/[]/total"}结果：
{code: 200, msg: "success"}有类似于sql改名机制解决这个问题么？如何解决？