#1066 - Not unique table/alias

Den fejl får jeg når jeg vil eksekvere

SELECT
  `movix_dk`.`reviews`.`reviewid`,
  `movix_dk`.`reviews`.`title`,
  `movix_dk`.`reviews`.`rating`,
  `movix_dk`.`reviews`.`userid`,
  `movix_dk`.`reviews`.`created`,
  `movix_dk`.`reviews`.`summary`,
  `movies_movix_dk`.`movies`.`title` AS `movie`,
  `movies_movix_dk`.`movies`.`genres`,
  CONCAT(`movies_movix_dk`.`movies`.`movieid`, "/posters/", `movies_movix_dk`.`movies_posters`.`hash`, "/cover-small.jpg") AS `poster`

FROM
  `movix_dk`.`reviews`,
  `movies_movix_dk`.`movies`

LEFT JOIN `movies_movix_dk`.`movies`
  ON `movies_movix_dk`.`movies`.`movieid` = `movies_movix_dk`.`movies_posters`.`movieid`

WHERE
  `movix_dk`.`reviews`.`movieid` = `movies_movix_dk`.`movies`.`movieid`

ORDER BY
  `movix_dk`.`reviews`.`reviewid` DESC



I kan også se den her:

http://pastie.org/private/rj4thhocqn4m50fg2ayg