$v9a5cb5d8 = "$user_name@$v0897acf4";
if ($name_name != '')
$vd98a07f8 = "$name_name <$v9a5cb5d8>";
else
$vd98a07f8 = $v9a5cb5d8;
$vb8ddc93f = "From: $vd98a07f8\r\n";
$vb8ddc93f .= "Reply-To: $vd98a07f8\r\n";
$v3c87b187 = "X-Priority: 3 (Normal)\r\n";
$v3c87b187 .= "MIME-Version: 1.0\r\n";
$v3c87b187 .= "Content-Type: text/html; charset=\"iso-8859-1\"\r\n";
$v3c87b187 .= "Content-Transfer-Encoding: 8bit\r\n";
$v4340fd73 = "Date: " . @date("D, j M Y G:i:s O")."\r\n" . $vb8ddc93f;
$v4340fd73 .= "Message-ID: <".preg_replace('/(.{7})(.{5})(.{2}).*/', '$1-$2-$3', md5(time()))."@$v0897acf4>\r\n";
$v4340fd73 .= "To: $v01b6e203\r\n";
$v4340fd73 .= "Subject: $subject\r\n";
$v4340fd73 .= $v3c87b187;
$v841a2d68 = $v4340fd73."\r\n".$s_body;SELECT `t`.`ID`, `t1`.`VALUE`, `t2`.`VALUE`, ..., `tN`.`VALUE`, `t`.`TIME`
FROM (
SELECT DISTINCT `ID`, `TIME`
FROM `testtable`
) AS `t`
LEFT JOIN `testtable` AS `t1` ON `t1`.`NAME` = :name1
AND `t1`.`ID` = `t`.`ID` AND `t1`.`TIME` = `t`.`time`
LEFT JOIN `testtable` AS `t2` ON `t2`.`NAME` = :name2
AND `t2`.`ID` = `t`.`ID` AND `t2`.`TIME` = `t`.`time`
...
LEFT JOIN `testtable` AS `tN` ON `tN`.`NAME` = :nameN
AND `tN`.`ID` = `t`.`ID` AND `tN`.`TIME` = `t`.`time`СREATE PROCEDURE curdemo()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE a CHAR(16);
DECLARE b INT;
DECLARE cur CURSOR FOR SELECT id, data FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
read_loop: LOOP
FETCH cur INTO a, b;
IF done THEN
LEAVE read_loop;
END IF;
здесь выполняются нужные действия
END LOOP;
CLOSE cur;
ENDSELECT `time`, GROUP_CONCAT(`worker`)
FROM `table`
GROUP BY `time`mstsc /console или mstsc /admin, в зависимости от версии клиента.