222
|
0 |
0 |
$self->dbh->selectrow_hashref(qq[\n SELECT id, name, project, note, "timestamp", planner_name, planner_email,\n tags, script_hash\n FROM (\n SELECT c.change_id AS id, c.change AS name, c.project, c.note,\n $tscol AS "timestamp", c.planner_name, c.planner_email,\n $tagcol AS tags, c.committed_at, c.script_hash\n FROM changes c\n LEFT JOIN tags t ON c.change_id = t.change_id\n WHERE c.project = ?\n AND c.committed_at $op (\n SELECT committed_at FROM changes WHERE change_id = ?\n )\n GROUP BY c.change_id, c.change, c.project, c.note, c.planned_at,\n c.planner_name, c.planner_email, c.committed_at, c.script_hash\n ) changes\n ORDER BY changes.committed_at $dir\n LIMIT 1 $offset_expr\n ], undef, $self->plan->project, $change_id) || (return undef)
|