James Turner (jturner@shield-legal.com)
2025-06-17 14:24:45

Running the code rn

James Turner (jturner@shield-legal.com)
2025-06-17 14:24:48

Let's see if this works..

James Turner (jturner@shield-legal.com)
2025-06-17 14:25:11

275k rows being generated

image.png
James Turner (jturner@shield-legal.com)
2025-06-17 14:25:31

WITH campaign_case_types AS ( SELECT id FROM postgres.public.case_type WHERE name IN ( 'Intake Case Type', 'CA Juv Hall Abuse - ACTS - DL Flatirons - Shield Legal', 'CA Juv Hall Abuse - ACTS - FYF - Shield Legal', 'CA Juv Hall Abuse - ACTS - LOSG (TC/D) - Shield Legal', 'CA Juv Hall Abuse - ACTS - SIL - ACTS', 'CA Juvenile Camps Abuse - ACTS Law - Shield Legal', 'CA Juvenile Camps Abuse - ACTS/Ghozland - Shield Legal', 'CA Juvenile Camps Abuse - ACTS/Loghmana - Shield Legal', 'CA Juvenile Camps Abuse - ACTS/VAN - Shield Legal', 'CA Juvenile Camps Abuse 2 - ACTS Law - Shield Legal', 'CA Juvenile Hall Abuse - ACTS - Banafshe Law Firm - Shield Legal', 'CA Juvenile Hall Abuse - ACTS - Laba Forman - Shield Legal', 'CA Juvenile Hall Abuse - ACTS - Levinson (MC) - Shield Legal', 'CA Juvenile Hall Abuse - ACTS - Levinson (SJ) - Shield Legal', 'CA Juvenile Hall Abuse - ACTS - Levinson (TC) - Shield Legal', 'CA Juvenile Hall Abuse - ACTS - VAM Law - Shield Legal', 'Ca Juvenile Hall Abuse - ACTS Law - Shield Legal', 'CA Juvenile Hall Abuse - ACTS/Ghozland - Shield Legal', 'Ca Juvenile Hall Abuse - ACTS/Loghmana - Shield Legal', 'CA Juvenile Hall Abuse - ACTS/VAN - Shield Legal', 'Ca Juvenile Hall Abuse 2 - ACTS Law - Shield Legal', 'Ca Juvenile Hall Abuse 3 - ACTS Law - Shield Legal', 'Ca Juvenile Hall Abuse 4 - ACTS Law - Shield Legal', 'Juv Hall Detention Abuse LA - ACTS - ASK LLP - Shield Legal', 'Juv Hall Detention Abuse LA - Kuzyk - ACTS - Shield Legal', 'Juvenile Hall Abuse - ACTS - Makarem - Shield Legal', 'Juvenile Hall Detention Abuse - ACTS - LOSG - TC - Shield Legal', 'LA County Foster Care Abuse - ACTS - DL/Flatirons - Shield Legal', 'LA County Foster Care Abuse - ACTS - Laba Forman - Shield Legal', 'LA County Foster Care Abuse - ACTS - Levinson (TC) - Shield Legal', 'LA Juvenile Hall Abuse TV - ACTS - DL/Flatirons - Shield Legal', 'Maclaren Hall - ACTS - LOSG(TC) - Shield Legal' ) ), leads_for_campaigns AS ( SELECT id AS leadid FROM postgres.public.lead WHERE casetypeid IN (SELECT id FROM campaign_case_types) ), latest_esign_status AS ( SELECT leadid, MAX(date) AS latest_esign FROM postgres.public.lead_history_status WHERE tostatus ILIKE '%Signed e-Sign%' GROUP BY leadid ) SELECT lh.**, les.latest_esign FROM postgres.public.lead_history lh JOIN leads_for_campaigns lfc ON lh.leadid = lfc.leadid JOIN latest_esign_status les ON lh.leadid = les.leadid;

deleted-U08FJ290LUX
2025-06-17 14:27:32

Thank you!!!!!!

James Turner (jturner@shield-legal.com)
2025-06-17 14:27:41

Ehh-- we will see if it works lol

James Turner (jturner@shield-legal.com)
2025-06-17 14:27:48

Loading now. It's a LOT of data

deleted-U08FJ290LUX
2025-06-17 14:30:49

Yeah there's so much that we don't even need which is super annoying

James Turner (jturner@shield-legal.com)
2025-06-24 11:39:26

Apple maps?

image.png
James Turner (jturner@shield-legal.com)
2025-06-24 11:39:28

(kidding)

deleted-U08FJ290LUX
2025-06-24 11:41:49

youre a samsung user?

James Turner (jturner@shield-legal.com)
2025-06-24 11:43:47
Screenshot_20250624-094258.png
James Turner (jturner@shield-legal.com)
2025-06-24 11:43:53

Google Pixel with a custom minimalist launcher

deleted-U08FJ290LUX
2025-06-24 11:44:08

:yuck:

🤣 James Turner
deleted-U08FJ290LUX
2025-06-24 11:44:39

ngl I like the Pixels though if the apple ecosystem weren't so convenient for me that's what I would get

James Turner (jturner@shield-legal.com)
2025-06-24 11:45:28

That's valid- I've never been an apple person but the apple lineup is actually starting to look compelling this year

deleted-U08FJ290LUX
2025-06-24 11:48:32

I think they're finally trying to compete with every now 😂

James Turner (jturner@shield-legal.com)
2025-06-24 12:06:04

I am also 100% for the Frutiger Aero revival

James Turner (jturner@shield-legal.com)
2025-06-24 12:06:10

we all need a little optimism rn

James Turner (jturner@shield-legal.com)
2025-06-24 12:06:26

I am also 100% for the Frutiger Aero revival

deleted-U08FJ290LUX
2025-06-24 12:10:43

Truly! Life was easier then and I hope we're inching back because I am over the lifeless beige

deleted-U08FJ290LUX
2025-08-28 13:06:53

Can you send me the PT's office please? I am going to see if they have some availability for when I get back

James Turner (jturner@shield-legal.com)
2025-08-28 13:07:46

Dr Pennington - https://g.co/kgs/Sae7Bqt

www.google.com
Orthopedics and Sports Medicine · Las Vegas, NV
3.5 ⭐ · Orthopedic clinic in Clark County, Nevada
Original URL: https://g.co/kgs/Sae7Bqt
deleted-U08FJ290LUX
2025-08-28 13:13:52

Thank you!!