1
        CREATE PROCEDURE update_logo_id_in_feeds(feed_id INT)
          BEGIN
            UPDATE feeds SET logo_id =
            (
              SELECT image_id
              FROM posts
              WHERE id =
              (
                 SELECT post_id 
                 FROM feed_posts 
                 WHERE priority=
                    (
                       SELECT MAX(feed_posts.priority)
                       FROM feed_posts
                       WHERE feed_posts.feed_id = feed_id
                    )
                 AND feed_posts.feed_id = feed_id
              )
            )
            WHERE feeds.id = feed_id;
          END 

I have such procedure. It call when new post add to feed (write in pivot table feed_posts) and set logo_id. I have 100 feeds and when I add one post to 100 feeds - all 100 feeds have same logo_id. How check when UPDATE if other feeds with such logo_id exists and don't update?

loruka
  • 11
  • 2

0 Answers0