Rsa97

SELECT *
  FROM (
    SELECT MIN(`id`) AS `id`
      FROM `table`
      GROUP BY `sm_name`
  ) AS `u`
  JOIN `table` USING(`id`)

SELECT `recipe_id`, COUNT(*) AS `count`
  FROM `recipe_product`
  WHERE (`product_id` = 1 AND `product_weight` > 100)
    OR (`product_id` = 2 AND `product_weight` BETWEEN 200 AND 400)
    OR (`product_id` = 3 AND `product_weight` < 10)
  GROUP BY `recipe_id`
  HAVING `count` = 3

SELECT `recipe_id`, COUNT(*) AS `count`
  FROM `recipe_product`
  WHERE `recipe_id` NOT IN (SELECT `recipe_id` FROM `recipe_product` WHERE `product_id` NOT IN (1, 2, 3))
    AND ((`product_id` = 1 AND `product_weight` > 100)
      OR (`product_id` = 2 AND `product_weight` BETWEEN 200 AND 400)
      OR (`product_id` = 3 AND `product_weight` < 10))
  GROUP BY `recipe_id`
  HAVING `count` = 3

INSERT
  INTO `main` (`email1`, `email2`, `flag`) 
  SELECT `email`, `email`, 1
    FROM `test`
  ON DUPLICATE KEY UPDATE `flag` = 1

BEGIN TRANSACTION;
UPDATE `sh_prod_im` SET `updated` = 0;

INSERT 
  INTO `sh_prod_im` (`article`, ..., `updated`) 
  VALUES (:article, ..., 1) 
  ON DUPLICATE KEY UPDATE ..., `updated` = 1;

DELETE FROM `sh_prod_im` WHERE `updated` = 0;
COMMIT;