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

Tenderloin Art Gallery or Organization	Street Address	City	Zip Code	Telephone	No. art/cultural workers
Alonzo King LINES Ballet	25 Taylor Street	San Francisco	94103	415.863.3040	56
American Conservatory Theater	405 Geary Street	San Francisco	94102	415.749.2228	73
Bash Contemporary Art Gallery	210 Golden Gate Avenue	San Francisco	94102	415.926.8573	2
Book & Job Gallery	838 Geary Street	San Francisco	94109	415.857.4330	4
Center for New Music	55 Taylor Street	San Francisco	94102	415.275.2466	5
The Costume Shop	1117 Market Street	San Francisco	94102		6
CounterPulse	80 Turk Street	San Francisco	94102	415.626.2060	9
The Cutting Ball Theater	277 Taylor Street	San Francisco	94102	415.292.4700	43
Down Town Comedy Theater	287 Ellis Street	San Francisco	94102	415.378.4413	1


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

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

	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)

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