title: Get the top ten equipment from suffixed tables
body: <p>I've been developing an application that show what are the top equipment that has problems in the system. For that I´ve create a tables like:</p>
  
  <pre><code>---------------------      ---------------------
  - equipments_201404 -      - equipments_201405 -
  ---------------------      ---------------------
  - id                -      - id                -
  - equipName         -      - equipName         -
  - dateTime          -      - dateTime          -
  - ...               -      - ...               -
  ---------------------      ---------------------
  </code></pre>
  
  <p>This kind of separation has to be with the amount of data that has to be storage. Because that, I wondering if there is a way to obtain the top ten equipment in a query or through PHP.</p>