SELECT 
        `dvd_titles`.`title` AS `title`,
        `dvd_titles`.`release_date` AS `release_date`,
        `dvd_titles`.`award` AS `award`,
        `labels`.`label` AS `label`,
        `sounds`.`sound` AS `sound`,
        `genres`.`genre` AS `genre`,
        `ratings`.`rating` AS `rating`,
        `formats`.`format` AS `format`
    FROM
        (((((`dvd_titles`
        JOIN `formats`)
        JOIN `genres`)
        JOIN `labels`)
        JOIN `ratings`)
        JOIN `sounds`)
    WHERE
        ((`dvd_titles`.`label_id` = `labels`.`label_id`)
            AND (`dvd_titles`.`format_id` = `formats`.`format_id`)
            AND (`dvd_titles`.`genre_id` = `genres`.`genre_id`)
            AND (`ratings`.`rating_id` = `dvd_titles`.`rating_id`)
            AND (`sounds`.`sound_id` = `dvd_titles`.`sound_id`))