#!/usr/bin/php -q
26-01-31 10:43:560SELECT 
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] => 384100
            [date_modified] => 2026-01-29 15:44:34+00
            [schedule_block] => ["2026-02-20 08:00:00+00","2026-02-20 12:00:00+00")
            [schedule_block_id] => 1270077
            [section_department_id] => 220685
            [section_id] => 215333
            [site_cf_value] => 11614
            [site_cf_id] => 4
            [job_cf_value] => 2026-02-20
            [job_cf_id] => 3
            [quote_id] => 1019418
        )

    [1] => Array
        (
            [schedule_id] => 382569
            [date_modified] => 2026-01-29 15:46:21+00
            [schedule_block] => ["2026-01-29 11:15:00+00","2026-01-29 11:45:00+00")
            [schedule_block_id] => 1270084
            [section_department_id] => 143473
            [section_id] => 139219
            [site_cf_value] => 44523
            [site_cf_id] => 4
            [job_cf_value] => 2025-07-11
            [job_cf_id] => 3
            [quote_id] => 945970
        )

    [2] => Array
        (
            [schedule_id] => 382569
            [date_modified] => 2026-01-29 15:46:21+00
            [schedule_block] => ["2026-01-29 12:00:00+00","2026-01-29 15:45:00+00")
            [schedule_block_id] => 1270085
            [section_department_id] => 143473
            [section_id] => 139219
            [site_cf_value] => 44523
            [site_cf_id] => 4
            [job_cf_value] => 2025-07-11
            [job_cf_id] => 3
            [quote_id] => 945970
        )

    [3] => Array
        (
            [schedule_id] => 384126
            [date_modified] => 2026-01-29 16:00:59+00
            [schedule_block] => ["2026-02-17 08:00:00+00","2026-02-17 11:45:00+00")
            [schedule_block_id] => 1270181
            [section_department_id] => 220719
            [section_id] => 215367
            [site_cf_value] => 2260
            [site_cf_id] => 4
            [job_cf_value] => 2026-02-17
            [job_cf_id] => 3
            [quote_id] => 1019452
        )

    [4] => Array
        (
            [schedule_id] => 381654
            [date_modified] => 2026-01-29 16:20:49+00
            [schedule_block] => ["2026-01-29 11:15:00+00","2026-01-29 12:00:00+00")
            [schedule_block_id] => 1270289
            [section_department_id] => 143473
            [section_id] => 139219
            [site_cf_value] => 44523
            [site_cf_id] => 4
            [job_cf_value] => 2025-07-11
            [job_cf_id] => 3
            [quote_id] => 945970
        )

    [5] => Array
        (
            [schedule_id] => 381654
            [date_modified] => 2026-01-29 16:20:49+00
            [schedule_block] => ["2026-01-29 12:00:00+00","2026-01-29 14:45:00+00")
            [schedule_block_id] => 1270290
            [section_department_id] => 143473
            [section_id] => 139219
            [site_cf_value] => 44523
            [site_cf_id] => 4
            [job_cf_value] => 2025-07-11
            [job_cf_id] => 3
            [quote_id] => 945970
        )

    [6] => Array
        (
            [schedule_id] => 384161
            [date_modified] => 2026-01-29 16:39:27+00
            [schedule_block] => ["2026-02-11 12:00:00+00","2026-02-11 12:15:00+00")
            [schedule_block_id] => 1270345
            [section_department_id] => 143473
            [section_id] => 139219
            [site_cf_value] => 44523
            [site_cf_id] => 4
            [job_cf_value] => 2025-07-11
            [job_cf_id] => 3
            [quote_id] => 945970
        )

    [7] => Array
        (
            [schedule_id] => 378316
            [date_modified] => 2026-01-30 12:46:39+00
            [schedule_block] => ["2026-01-30 08:15:00+00","2026-01-30 08:45:00+00")
            [schedule_block_id] => 1272060
            [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
        )

    [8] => Array
        (
            [schedule_id] => 378316
            [date_modified] => 2026-01-30 12:46:39+00
            [schedule_block] => ["2026-01-30 08:45:00+00","2026-01-30 12:30:00+00")
            [schedule_block_id] => 1272061
            [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
        )

    [9] => Array
        (
            [schedule_id] => 383686
            [date_modified] => 2026-01-30 14:27:56+00
            [schedule_block] => ["2026-01-30 12:45:00+00","2026-01-30 13:00:00+00")
            [schedule_block_id] => 1272503
            [section_department_id] => 143495
            [section_id] => 139241
            [site_cf_value] => M2122
            [site_cf_id] => 4
            [job_cf_value] => 2025-06-30
            [job_cf_id] => 3
            [quote_id] => 945992
        )

    [10] => Array
        (
            [schedule_id] => 384686
            [date_modified] => 2026-01-30 14:47:49+00
            [schedule_block] => ["2026-02-02 12:00:00+00","2026-02-02 16:15:00+00")
            [schedule_block_id] => 1272581
            [section_department_id] => 152947
            [section_id] => 148634
            [site_cf_value] => 43999
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-29
            [job_cf_id] => 3
            [quote_id] => 953742
        )

    [11] => Array
        (
            [schedule_id] => 384713
            [date_modified] => 2026-01-30 15:44:45+00
            [schedule_block] => ["2026-01-30 15:30:00+00","2026-01-30 15:45:00+00")
            [schedule_block_id] => 1272790
            [section_department_id] => 208066
            [section_id] => 202887
            [site_cf_value] => 7818
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-30
            [job_cf_id] => 3
            [quote_id] => 1007022
        )

    [12] => Array
        (
            [schedule_id] => 382466
            [date_modified] => 2026-01-30 17:21:07+00
            [schedule_block] => ["2026-01-30 14:15:00+00","2026-01-30 14:30:00+00")
            [schedule_block_id] => 1273224
            [section_department_id] => 208066
            [section_id] => 202887
            [site_cf_value] => 7818
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-30
            [job_cf_id] => 3
            [quote_id] => 1007022
        )

    [13] => Array
        (
            [schedule_id] => 382466
            [date_modified] => 2026-01-30 17:21:07+00
            [schedule_block] => ["2026-01-30 14:30:00+00","2026-01-30 17:15:00+00")
            [schedule_block_id] => 1273225
            [section_department_id] => 208066
            [section_id] => 202887
            [site_cf_value] => 7818
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-30
            [job_cf_id] => 3
            [quote_id] => 1007022
        )

    [14] => Array
        (
            [schedule_id] => 380138
            [date_modified] => 2026-01-30 20:33:38+00
            [schedule_block] => ["2026-01-30 13:00:00+00","2026-01-30 16:00:00+00")
            [schedule_block_id] => 1273352
            [section_department_id] => 143495
            [section_id] => 139241
            [site_cf_value] => M2122
            [site_cf_id] => 4
            [job_cf_value] => 2025-06-30
            [job_cf_id] => 3
            [quote_id] => 945992
        )

)
</pre>