SELECT * FROM
cdb_library a ,
(SELECT COUNT(1) AS SUM, CONCAT(title,publish) AS longStr FROM cdb_library GROUP BY title, publish) b
WHERE CONCAT(a.title,a.publish) = b.longStr AND b.sum>1 AND a.shenhe=1 ORDER BY title, publish
SELECT * FROM
cdb_library a ,
(SELECT COUNT(1) AS SUM, CONCAT(title,publish) AS longStr FROM cdb_library GROUP BY title, publish) b
WHERE CONCAT(a.title,a.publish) = b.longStr AND b.sum>1 AND a.shenhe=1 ORDER BY title, publish