gistfile1

mysql> SELECT
    ->   n.nid, n.created, issuedata.timestamp as first_review
    -> FROM
    ->   (SELECT
    ->     pic.nid,
    ->     (
    ->       SELECT
    ->         pic2.sid
    ->       FROM
    ->         project_issue_comments pic2
    ->       WHERE
    ->         pic2.nid = 1341924 AND
    ->         pic2.comment_number = pic.comment_number - 1
    ->     ) as "original_state",
    ->     (
    ->       SELECT
    ->         pis2.name
    ->       FROM
    ->         project_issue_state pis2
    ->       WHERE
    ->         pis2.sid = original_state
    ->     ) as "original_state_name",
    ->     pic.sid as "new_state",
    ->     pis.name as "new_state_name",
    ->     pic.comment_number,
    ->     pic.timestamp
    ->   FROM
    ->     project_issue_comments pic
    ->   JOIN
    ->     project_issue_state pis ON pic.sid = pis.sid
    ->   WHERE
    ->     pic.nid = 1341924) as issuedata
    -> LEFT JOIN
    ->   node n on n.nid = issuedata.nid
    -> WHERE
    ->   issuedata.original_state = 8 AND
    ->   issuedata.new_state = 13
    -> ORDER BY
    ->   issuedata.timestamp
    -> LIMIT
    ->   1;
+---------+------------+--------------+
| nid     | created    | first_review |
+---------+------------+--------------+
| 1341924 | 1321338297 |   1321752039 | 
+---------+------------+--------------+
1 row in set (0.05 sec)