{pboot:sort scode=1}[sort:rows]{/pboot:sort}首页用。用这个需要指定栏目scode的id,适合统计一个总栏目下面多少条内容{pboot:sql sql="SELECT count(*) AS c FROM ay_content"}[sql:c]{/pboot:sql}首页用。SQL语句,统计全站数据{pboot:sql sql="select count(id) as tota
CREATE TABLE my_tmp AS SELECT MIN(ID) AS col1 FROM wp_posts GROUP BY post_title;DELETE FROM wp_posts WHERE ID NOT IN (SELECT col1 FROM my_tmp);DROP TABLE my_tmp;wordpress删除重复文章,直接在phpmyadmin里运行语句即可。特别提示,运行前先备份一下,以防万一。