wri/gfw

Make sure stories in homepage (and others) present the latest first

d4weed opened this issue · 2 comments

d4weed commented

Also make sure it doesn't break where there's no preview_url (we should have a default)

the query should be:

https://wri-01.cartodb.com/api/v2/sql?q=SELECT cartodb_id,title,media,ST_AsGeoJSON(the_geom) AS the_geom FROM community_stories WHERE visible=true order by created_at desc LIMIT 3

apercas commented

Fixed!

6af1bd8