Sam Matthews mapsam

ProgrammingError: (ProgrammingError) missing FROM-clause entry for table "patient_referral" LINE 6: ..._referral.status = 'COMPLETED') ORDER BY coalesce(patient_re... ^ 'SELECT count(*) AS count_1 \nFROM (SELECT patient.created AS patient_created, patient.last_modified AS patient_last_modified, patient.id AS patient_id, patient.full_name AS patient_full_name, patient.first_name AS patient_first_name, patient.middle_name AS patient_middle_name, patient.last_name AS patient_last_name, patient.dob AS patient_dob, patient.ssn AS patient_ssn, patient.email AS patient_email, patient.gender AS patient_gender, patient.transgender AS patient_transgender, patient.race AS patient_race, patient.race_other AS patient_race_other, patient.ethnicity AS patient_ethnicity, patient.languages AS patient_languages, patient.languages_other AS patient_languages_other, patient.has_interpreter_yn AS patient_has_interpreter_yn, patient.education_level AS patient_education_level, patient.marital_status AS patient_marital_status, patien

	def days_from_today(field):
	'''Takes a python date object and returns days from today
	'''
	if isinstance(field, datetime.date):
	return (
	datetime.date(field.year, field.month, field.day) -
	datetime.date.today()
	).days
	elif isinstance(field, datetime.datetime):
	field = field.replace(tzinfo=pytz.utc)

	<style>
	.cf:before,
	.cf:after {
	content:" ";
	display:table;
	}
	.cf:after {
	clear:both;
	}
	.cf {


	{
	"elem": "wizard",
	"nodes": [
	{
	"id": 0,
	"title": "Are you having a seriously good time?",
	"content": "",
	"type": "pickOne",
	"triggers": [

	// block sections, to be used within .containers
	// all exist on a 12 unit grid and are relative in
	// size to the container element
	$break: 50em;

	@mixin width($num) {
	width: 100% * ($num / 12)
	}

	.block_1,

	<html lang="en">
	<head>
	<title>hello world</title>
	<script src="http://code.jquery.com/jquery-1.11.0.min.js"></script>
	<script src="http://code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
	<style>
	body {
	padding:0;
	margin:0;
	}

	<div class="video">
	<iframe src="https://player.vimeo.com/video/135995751" class="video-iframe" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
	</div>