mixed sub- query with joins

SELECT 

    sakila_customer_0.customer_id AS sakila_customer_0_customer_id,

    sakila_customer_0.first_name AS sakila_customer_0_first_name,

    sakila_customer_0.last_name AS sakila_customer_0_last_name,

    sakila_rental_0.rental_date AS sakila_rental_0_rental_date,

    sakila_film_0.title AS sakila_film_0_title,

    sakila_film_0.rating AS sakila_film_0_rating,

    sakila_payment_0.amount AS sakila_payment_0_amount

FROM

    sakila.payment sakila_payment_0

        JOIN

    sakila.customer sakila_customer_0 ON (sakila_customer_0.customer_id = sakila_payment_0.customer_id

        AND sakila_customer_0.address_id IN (SELECT 

            sakila_address_0.address_id

        FROM

            sakila.address sakila_address_0

        WHERE

            sakila_address_0.city_id IN (SELECT 

                    sakila_city_0.city_id

                FROM

                    sakila.city sakila_city_0

                WHERE

                    sakila_city_0.country_id IN (SELECT 

                            sakila_country_0.country_id

                        FROM

                            sakila.country sakila_country_0

                        WHERE

                            sakila_country_0.country = 'Canada'))))

        JOIN

    sakila.rental sakila_rental_0 ON sakila_rental_0.rental_id = sakila_payment_0.rental_id

        JOIN

    sakila.inventory sakila_inventory_0 ON sakila_inventory_0.inventory_id = sakila_rental_0.inventory_id

        JOIN

    sakila.film sakila_film_0 ON (sakila_film_0.film_id = sakila_inventory_0.film_id

        AND sakila_film_0.film_id IN (SELECT 

            sakila_film_category_0.film_id

        FROM

            sakila.film_category sakila_film_category_0

        WHERE

            sakila_film_category_0.category_id IN (SELECT 

                    sakila_category_0.category_id

                FROM

                    sakila.category sakila_category_0

                WHERE

                    sakila_category_0.name = 'Action')));