WITH job_nodes AS (
    SELECT 
        id as job_id,
        CAST(JSON_EXTRACT(properties, '$.node_id') AS UNSIGNED) as node_id,
        created_at as job_created_at
    FROM job_statuses 
    WHERE id IN (10435, 10436, 10437, 10438, 10439)
)
SELECT 
    p.id,
    p.asin,
    p.title,
    p.category as node_id,
    jn.job_id,
    p.created_at as product_created_at
FROM products p
JOIN job_nodes jn ON p.category = jn.node_id
WHERE p.created_at >= jn.job_created_at
ORDER BY p.id;