SQL util para barriosenaccion

utils_barriosenaccion.sql

COPY(select DISTINCT ON (problem.id) problem.id, body.name, problem.name, users.email, problem.title, problem.state, problem.category, problem.detail, problem.latitude, problem.longitude from problem, users, body where problem.user_id=users.id AND problem.state in ('confirmed', 'investigating', 'in progress', 'planned', 'action scheduled', 'fixed', 'fixed - council', 'fixed - user', 'unable to fix', 'not responsible', 'duplicate', 'closed', 'internal referral') AND problem.whensent > NOW() - INTERVAL '5 weeks' and body.id IN (1, 2, 5)) to stdout
COPY(select users.id, users.name, users.email, from_body from users, body )  to STDOUT;