SQL assistance

Working on a MySQL database for a newspaper so they can keep track of advertisers.

SELECT advertisers.name, advertisements.enddate, advertisements.startdate, advertisements.section, advertisements.description, advertisments.rate, advertisements.total, advertisements.archive, advertisements.comments, advertisements.size FROM advertisements, advertisers, addates, issues INNER JOIN addates ON issues.issue = addates.issue, INNER JOIN addates ON advertisements.archive = addates.archive, INNER JOIN advertisements ON advertisers.account = advertisements.account ORDER BY issues.date;

Returns not unique table/alias 'addates'. There are no fields in any table named 'addates'. Tried qualifying with dbname.table, and using `'s. Same error.

Try this:

SELECT
  advertisers.name,
  advertisements.enddate,
  advertisements.startdate,
  advertisements.section,
  advertisements.description,
  advertisments.rate,
  advertisements.total,
  advertisements.archive,
  advertisements.comments,
  advertisements.size
FROM advertisements
INNER JOIN addates
  ON addates.archive = advertisements.archive
INNER JOIN issues
  ON issues.issue = addates.issue
INNER JOIN advertisers
  ON advertisers.account = advertisements.account
ORDER BY issues.date