SELECT N.nid AS n_nid
FROM   workflow_node WN
       LEFT OUTER JOIN node N
                    ON WN.nid = N.tnid
WHERE  ( WN.sid IN (SELECT WT.sid
                    FROM   (SELECT sid,
                                   Concat(',', roles, ',') AS role_stamp
                            FROM   workflow_transitions) AS WT
                    WHERE  role_stamp LIKE '%5%')
         AND N.language = "en" )

$query->condition('WN.sid', $subquery, 'IN');