Rsa97

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`

UPDATE `table` 
  SET `position` = FIND_IN_SET(`image_id`, :image_ids_list)
  WHERE `news_id` = :news_id
    AND FIND_IN_SET(`image_id`, :image_ids_list) != 0