|
830
|
0 |
0 |
$self->dbh->selectrow_hashref(qq[\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.script_hash\n FROM changes c\n LEFT JOIN tags t ON c.change_id = t.change_id\n WHERE c.change_id = ?\n GROUP BY c.change_id, c.change, c.project, c.note, c.planned_at,\n c.planner_name, c.planner_email, c.script_hash\n ], undef, $change_id) || (return undef)
|
|
883
|
0 |
0 |
$self->dbh->selectrow_hashref(qq[\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.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 ORDER BY c.committed_at $dir\n LIMIT 1 $offset_expr\n ], undef, $self->plan->project, $change_id) || (return undef)
|