#1066 - Not unique table/alias
Den fejl får jeg når jeg vil eksekvereSELECT
`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