$cols .= ", ($subsql AND message ~ '<img') AS imagecount";
$sql = "SELECT $cols FROM issues i WHERE page = ?";
if (isset($_GET['open'])) {
$sql .= ' AND closed IS NULL';
}
$sql .= ' ORDER BY closed IS NOT NULL, updated DESC';
$cols .= ", ($subsql AND message ~ '<img') AS imagecount";
$sql = "SELECT $cols FROM issues i WHERE page = ?";
if (isset($_GET['open'])) {
$sql .= ' AND closed IS NULL';
}
$sql .= ' ORDER BY closed IS NOT NULL, updated DESC';