prospector sql

fixed.sql

UPDATE "subscriber_source" ss 
SET    subscriber_source_approved = 't' 
WHERE  subscriber_source_approved = 'f' 
       AND subscriber_id in ('SOME IDS...')
       AND source_id = '20150707140016042989000000' 
       AND 0 < (SELECT Count(*) 
                FROM   newsfeed, newsfeed_item
                WHERE  newsfeed.newsfeed_id = newsfeed_item.newsfeed_id 
                       AND ss.subscriber_id = newsfeed.subscriber_id 
                       AND newsfeed_item.source_id = 
                           '20150707140016042989000000' 
                       AND newsfeed_active = 't' 
                       AND newsfeed_curated = 'f') 

timeout.sql

UPDATE "subscriber_source" ss 
SET    subscriber_source_approved = 't' 
WHERE  subscriber_source_approved = 'f' 
       AND 0 < (SELECT Count(*) 
                FROM   newsfeed, 
                       newsfeed_item 
                WHERE  newsfeed.newsfeed_id = newsfeed_item.newsfeed_id 
                       AND ss.subscriber_id = newsfeed.subscriber_id 
                       AND newsfeed_item.source_id = 
                           '20150707140016042989000000' 
                       AND newsfeed_active = 't' 
                       AND newsfeed_curated = 'f')