title: How would I make this query run faster?
body: <p>How would I make this query run faster...?</p>
  
  <pre>
  SELECT    account_id, 
            account_name, 
            account_update, 
            account_sold, 
            account_mds, 
            ftp_url,         
            ftp_livestatus, 
            number_digits, 
            number_cw,
            client_name, 
            ppc_status, 
            user_name 
  FROM     
           Accounts, 
           FTPDetails, 
           SiteNumbers, 
           Clients, 
           PPC, 
           Users 
  
  WHERE    Accounts.account_id = FTPDetails.ftp_accountid 
  AND      Accounts.account_id = SiteNumbers.number_accountid 
  AND      Accounts.account_client = Clients.client_id     
  AND      Accounts.account_id = PPC.ppc_accountid 
  AND      Accounts.account_designer = Users.user_id   
  AND      Accounts.account_active = 'active' 
  AND      FTPDetails.ftp_active = 'active' 
  AND      SiteNumbers.number_active = 'active' 
  AND      Clients.client_active = 'active'    
  AND      PPC.ppc_active = 'active'   
  AND      Users.user_active = 'active' 
  ORDER BY 
           Accounts.account_update DESC
  </pre>
  
  <p>Thanks in advance :)</p>
  
  <p><strong>EXPLAIN query results:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/ocU62.jpg" alt="first part of table"></p>
  
  <p><img src="https://i.stack.imgur.com/agtzB.jpg" alt="second part of table"></p>
  
  <p>I don't really have any foreign keys set up...I was trying to avoid making alterations to the database as will have to do a complete overhaul soon.</p>
  
  <p>only primary keys are the id of each table e.g. account_id, ftp_id, ppc_id ...</p>