Listing.ChromeExtension.sql

-- get the 10 most recent sold listings for the specific agency
SELECT id, status, sold_price, sold_date 
FROM listings_listing 
WHERE agency_id = '3ab9adc2-7fd2-4b24-8cd0-d0cc69270fbf' AND status = 'S' 
ORDER BY sold_date DESC LIMIT 10;

-- modify the query set to a new date somewhere between now and four weeks ago
UPDATE listings_listing
SET sold_date = now(),
	source_type = 'M'
FROM ( SELECT id, status, sold_price, sold_date 
FROM listings_listing 
WHERE agency_id = '3ab9adc2-7fd2-4b24-8cd0-d0cc69270fbf' AND status = 'S' 
ORDER BY sold_date DESC LIMIT 10) as subquery
WHERE listings_listing.id = subquery.id;