#!/usr/bin/php -q
25-12-08 17:14:510SELECT 
SC.schedule_id,
SC.date_modified,
SB.schedule_block, 
SB.schedule_block_id,
SD.section_department_id,
SE.section_id,
CFV.value AS site_cf_value, 
CFV.field_id AS site_cf_id, 
JCFV.value AS job_cf_value, 
JCFV.field_id AS job_cf_id, 
Q.quote_id

FROM
schedule AS SC

JOIN schedule_block AS SB 
ON SC.schedule_id = SB.schedule_id 

JOIN section_departments AS SD 
ON SD.section_department_id = SC.id

JOIN quote_sections AS SE 
ON SE.section_id = SD.section_id

JOIN quotes AS Q 
ON Q.quote_id = SE.quote_id

JOIN project_job_custom_fields_values AS JCFV 
ON JCFV.job_id = Q.quote_id AND field_id = '3' 
                    
JOIN custom_fields_values AS CFV 
ON Q.location_id = CFV.associated_id AND CFV.field_id = '4' 

WHERE SC.date_modified BETWEEN NOW() - INTERVAL '48 hour' AND NOW()RESULTS POSTGRESS<pre>Array
(
    [0] => Array
        (
            [schedule_id] => 355459
            [date_modified] => 2025-12-08 10:50:26+00
            [schedule_block] => ["2025-12-09 08:00:00+00","2025-12-09 12:15:00+00")
            [schedule_block_id] => 1169397
            [section_department_id] => 203127
            [section_id] => 198114
            [site_cf_value] => 43173
            [site_cf_id] => 4
            [job_cf_value] => 2025-12-09
            [job_cf_id] => 3
            [quote_id] => 1002281
        )

    [1] => Array
        (
            [schedule_id] => 358055
            [date_modified] => 2025-12-08 11:08:38+00
            [schedule_block] => ["2026-01-02 12:00:00+00","2026-01-02 16:45:00+00")
            [schedule_block_id] => 1169482
            [section_department_id] => 152886
            [section_id] => 148573
            [site_cf_value] => 19286
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-02
            [job_cf_id] => 3
            [quote_id] => 953681
        )

    [2] => Array
        (
            [schedule_id] => 358116
            [date_modified] => 2025-12-08 12:08:39+00
            [schedule_block] => ["2025-12-22 08:00:00+00","2025-12-22 12:00:00+00")
            [schedule_block_id] => 1169736
            [section_department_id] => 161311
            [section_id] => 156881
            [site_cf_value] => 19640
            [site_cf_id] => 4
            [job_cf_value] => 2025-08-28
            [job_cf_id] => 3
            [quote_id] => 961900
        )

    [3] => Array
        (
            [schedule_id] => 357695
            [date_modified] => 2025-12-08 13:26:27+00
            [schedule_block] => ["2025-12-08 13:00:00+00","2025-12-08 13:15:00+00")
            [schedule_block_id] => 1170018
            [section_department_id] => 192081
            [section_id] => 187200
            [site_cf_value] => 20129
            [site_cf_id] => 4
            [job_cf_value] => 2025-12-08
            [job_cf_id] => 3
            [quote_id] => 991391
        )

)
</pre>