#!/usr/bin/php -q
25-04-22 16:58:570SELECT 
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] => 234339
            [date_modified] => 2025-04-22 15:06:05+01
            [schedule_block] => ["2025-04-22 12:15:00+01","2025-04-22 13:15:00+01")
            [schedule_block_id] => 736674
            [section_department_id] => 98794
            [section_id] => 95181
            [site_cf_value] => 44786
            [site_cf_id] => 4
            [job_cf_value] => 2025-04-07
            [job_cf_id] => 3
            [quote_id] => 905178
        )

    [1] => Array
        (
            [schedule_id] => 234339
            [date_modified] => 2025-04-22 15:06:05+01
            [schedule_block] => ["2025-04-22 13:15:00+01","2025-04-22 15:15:00+01")
            [schedule_block_id] => 736675
            [section_department_id] => 98794
            [section_id] => 95181
            [site_cf_value] => 44786
            [site_cf_id] => 4
            [job_cf_value] => 2025-04-07
            [job_cf_id] => 3
            [quote_id] => 905178
        )

    [2] => Array
        (
            [schedule_id] => 237194
            [date_modified] => 2025-04-22 10:43:28+01
            [schedule_block] => ["2025-05-08 13:00:00+01","2025-05-08 16:45:00+01")
            [schedule_block_id] => 736045
            [section_department_id] => 115222
            [section_id] => 111402
            [site_cf_value] => 43996
            [site_cf_id] => 4
            [job_cf_value] => 2025-03-27
            [job_cf_id] => 3
            [quote_id] => 921403
        )

    [3] => Array
        (
            [schedule_id] => 232733
            [date_modified] => 2025-04-22 12:16:45+01
            [schedule_block] => ["2025-04-22 12:00:00+01","2025-04-22 12:15:00+01")
            [schedule_block_id] => 736238
            [section_department_id] => 134898
            [section_id] => 130812
            [site_cf_value] => M2570
            [site_cf_id] => 4
            [job_cf_value] => 2025-04-22
            [job_cf_id] => 3
            [quote_id] => 937579
        )

    [4] => Array
        (
            [schedule_id] => 222444
            [date_modified] => 2025-04-22 08:57:05+01
            [schedule_block] => ["2025-04-22 08:00:00+01","2025-04-22 08:15:00+01")
            [schedule_block_id] => 735806
            [section_department_id] => 109917
            [section_id] => 106162
            [site_cf_value] => 7336
            [site_cf_id] => 4
            [job_cf_value] => 2025-05-06
            [job_cf_id] => 3
            [quote_id] => 916159
        )

    [5] => Array
        (
            [schedule_id] => 222444
            [date_modified] => 2025-04-22 08:57:05+01
            [schedule_block] => ["2025-04-22 08:15:00+01","2025-04-22 08:45:00+01")
            [schedule_block_id] => 735807
            [section_department_id] => 109917
            [section_id] => 106162
            [site_cf_value] => 7336
            [site_cf_id] => 4
            [job_cf_value] => 2025-05-06
            [job_cf_id] => 3
            [quote_id] => 916159
        )

    [6] => Array
        (
            [schedule_id] => 237170
            [date_modified] => 2025-04-22 10:04:17+01
            [schedule_block] => ["2025-05-06 08:30:00+01","2025-05-06 10:30:00+01")
            [schedule_block_id] => 735948
            [section_department_id] => 109917
            [section_id] => 106162
            [site_cf_value] => 7336
            [site_cf_id] => 4
            [job_cf_value] => 2025-05-06
            [job_cf_id] => 3
            [quote_id] => 916159
        )

    [7] => Array
        (
            [schedule_id] => 227092
            [date_modified] => 2025-04-22 15:48:40+01
            [schedule_block] => ["2025-04-22 15:15:00+01","2025-04-22 15:45:00+01")
            [schedule_block_id] => 736851
            [section_department_id] => 134928
            [section_id] => 130842
            [site_cf_value] => 16986
            [site_cf_id] => 4
            [job_cf_value] => 2025-05-07
            [job_cf_id] => 3
            [quote_id] => 937609
        )

    [8] => Array
        (
            [schedule_id] => 237499
            [date_modified] => 2025-04-22 16:26:27+01
            [schedule_block] => ["2025-05-07 08:30:00+01","2025-05-07 10:00:00+01")
            [schedule_block_id] => 736921
            [section_department_id] => 134928
            [section_id] => 130842
            [site_cf_value] => 16986
            [site_cf_id] => 4
            [job_cf_value] => 2025-05-07
            [job_cf_id] => 3
            [quote_id] => 937609
        )

)
</pre>