WITH 
    JoinedData AS (
        SELECT 
            Orders.orderId, 
            Orders.productId, 
            Orders.orderTimestamp, 
            Products.productName, 
            Products.productTimestamp
        FROM 
            Orders
        LEFT JOIN 
            Products FOR SYSTEM_TIME AS OF Orders.orderTimestamp
        ON 
            Orders.productId = Products.id
    )
SELECT *
FROM JoinedData
WHERE ABS(TIMESTAMPDIFF(SECOND, orderTimestamp, productTimestamp)) <= 3600;