SQL

Appache Authors Awk Bash CLI CSS Deployment Design Process Fonts FTP Git Hooks HTML Interface Linux Loop Minimalism MonsterThemes MySQL Object Office Open Source Opinion Outsourcing PHP Post Slug Principles Productivity Python Refactoring SFTP Snippet SQL SSH Subversion SVN Terminal Themes Tutorial Ubuntu Updates Version Control Without a Plugin WordPress XAMPP

  • Find Posts with the Most Number of Revisions

    I was working on a content-heavy website that have a very big wp_posts table. This obviously caused by a revisions. To confirm this I needed to find out which where the posts with the most number of revisions. As I had guessed, I found out revisions where killing the wp_posts table. Quite a few posts…