Rsa97

$curdate = '';
while (($row = $result_set -> fetch_assoc()) != false) {
  $date = sdate("M Y", 0, $row["date"]);
  if ($curdate != $date) {
    echo "<h2>Отчетность за ".sdate("M Y", 0, $row["date"])."</h2>";
    $curdate = $date;
  }
  echo "<a href=\"".$row["link"]."\">".$row["name"]."</a>";
  echo "<span>(".fdate("d M Y h:i", 0, $row["date"]).")</span><hr>";
}

$params["image_url"] = (isset($array['image_url']) ? $array['image_url'] : NULL);

UPDATE ... `image_url` = IFNULL(:image_url, `image_url`) ...

SELECT `s`.`user`, `u`.`name`, `s`.`OCI`, `s`.`OCO`, `s`.`CCP`, `s`.`PV`, `us`.`total_games`, 
       `s2`.`total_games` AS `today_games`, `s3`.`total_games` AS `yesterday_games`, 
       `s4`.`date` AS `high_OCI_date`
  FROM `qz_user_stat_date` AS `s` 
  JOIN `qz_users` AS `u` ON `u`.`id` = `s`.`user`
  JOIN `qz_user_stat` AS `us` ON `us`.`user` = `s`.`user`
  LEFT JOIN `qz_user_stat_date` AS `s2` ON `s2`.`user` = `s`.`user` AND `s2`.`date` = :today
  LEFT JOIN `qz_user_stat_date` AS `s3` ON `s3`.`user` = `s`.`user` AND `s3`.`date` = :yesterday
  LEFT JOIN (
    SELECT `t`.`user` AS `usr`, min(`t`.`date`) AS `date`
      FROM `qz_user_stat_date` AS `t`
      JOIN (
        SELECT `user`, max(`OCI`)  AS `oci`
          FROM `qz_user_stat_date` 
          GROUP BY `user`
      ) AS `o` ON `o`.`user` = `t`.`user` AND `o`.`oci` = `t`.`OCI`
      GROUP BY `t`.`user`
    ) AS `s4` ON `s4`.`usr` = `s`.`user`

SELECT `post_id` FROM `posts` WHERE `author_id` IN (:id1, :id2, :id3)

SELECT `p1`.`post_id`
  FROM `posts` AS `p1` 
  JOIN `posts` AS `p2` 
    ON `p2`.`post_id` = `p1`.`post_id` AND `p2`.`author_id` = :id2
  JOIN `posts` AS `p3` 
    ON `p3`.`post_id` = `p1`.`post_id` AND `p3`.`author_id` = :id3
  WHERE `p1`.`author_id` = :id1

http-URI    = "http:" "//" authority path-abempty [ "?" query ] 
              [ "#" fragment ]
query       = *( pchar / "/" / "?" )
pchar       = unreserved / pct-encoded / sub-delims / ":" / "@"
unreserved  = ALPHA / DIGIT / "-" / "." / "_" / "~"
pct-encoded = "%" HEXDIG HEXDIG
sub-delims  = "!" / "$" / "&" / "'" / "(" / ")" 
              / "*" / "+" / "," / ";" / "="
ALPHA      := [A-Za-z]
DIGIT      := [0-9]
HEXDIG     := [0-9A-F]

UPDATE `users` 
  LEFT JOIN (
    SELECT `user_id_from`, COUNT(*) AS `count` FROM `messages` GROUP BY `user_id_from`
  ) AS `from` ON `from`.`user_id_from` = `users`.`user_id`
  LEFT JOIN (
    SELECT `user_id_to`, COUNT(*) AS `count` FROM `messages` GROUP BY `user_id_to`
  ) AS `to` ON `to`.`user_id_to` = `users`.`user_id`
  SET `users`.`sended` = IFNULL(`from`.`count`, 0), 
      `users`.`received` = IFNULL(`to`.`count`, 0)