SELECT
    p_name,
    c_name,
    item
FROM (
    SELECT
        p_name,
        c_name,
        item,
        column_value AS city
    FROM
        (
            SELECT
                p_name,
                c_name,
                item,
                cities
            FROM (
                SELECT
                    p_name,
                    item,
                    CAST(COLLECT(city) AS CITIES_ARRAY) AS cities
                FROM (
                    SELECT
                    p_name,
                    item,
                    column_value AS city
                    FROM
                    producers p,
                    TABLE(p.cities) ct
                )
                WHERE
                    city < 500
                GROUP BY p_name, item
            )
            NATURAL JOIN customers c
        ) p,
        TABLE(p.cities)
)
NATURAL JOIN cities ct
WHERE ct.country = 'Russia'