Rsa97

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

SELECT `u`.`id`, `u`.`name`
  FROM `article_subject` AS `as`
  JOIN `user_subject` AS `us` 
    ON `as`.`article_id` = :article_id AND `us`.`subject_id` = `as`.`subject_id`
  JOIN `users` AS `u` 
    ON `u`.`id` = `us`.`user_id`

SELECT `p`.*
  FROM `product` AS `p`
  JOIN `attributes` AS `a1` ON `a1`.`object_id` = `p`.`id`
    AND `a1`.`field_id` = :field1 AND `a1`.`value` = :value1
  JOIN `attributes` AS `a2` ON `a2`.`object_id` = `p`.`id`
    AND `a2`.`field_id` = :field2 AND `a2`.`value` = :value2

... ON DUPLICATE KEY UPDATE `dat`= VALUES(`dat`), `status` = VALUES(`status`)

INSERT INTO `table1` (`field1`, `field2`, ...) SELECT `field1`, `field2`, ... FROM `table2` WHERE ...;
DELETE FROM `table2` WHERE ...;

SELECT `p1`.`maker`
  FROM `product` AS `p1`
  LEFT `product` AS `p2` ON `p2`.`maker` = `p1`.`maker`
    AND `p1`.`type` LIKE 'PC%' AND `p2`.`type` LIKE 'Laptop%'
  WHERE `p2`.`maker` IS NULL

SELECT `p`.`id`, `p`.`userId`, IFNULL(`c`.`count`, 0)
  FROM `posts` AS `p`
  LEFT JOIN (
    SELECT `postId`, COUNT(*) AS `count`
      FROM `post_likes`
      GROUP BY `postId`
  ) AS `c` ON `c`.`postId` = `p`.`id`