#!/usr/bin/php -q
26-04-15 05:27:410SELECT 
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] => 418816
            [date_modified] => 2026-04-13 11:31:41+01
            [schedule_block] => ["2026-04-13 08:00:00+01","2026-04-13 08:15:00+01")
            [schedule_block_id] => 1429007
            [section_department_id] => 227575
            [section_id] => 222123
            [site_cf_value] => 2520
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-13
            [job_cf_id] => 3
            [quote_id] => 1026163
        )

    [1] => Array
        (
            [schedule_id] => 418816
            [date_modified] => 2026-04-13 11:31:41+01
            [schedule_block] => ["2026-04-13 08:15:00+01","2026-04-13 11:30:00+01")
            [schedule_block_id] => 1429008
            [section_department_id] => 227575
            [section_id] => 222123
            [site_cf_value] => 2520
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-13
            [job_cf_id] => 3
            [quote_id] => 1026163
        )

    [2] => Array
        (
            [schedule_id] => 417197
            [date_modified] => 2026-04-13 11:34:51+01
            [schedule_block] => ["2026-04-13 08:30:00+01","2026-04-13 11:45:00+01")
            [schedule_block_id] => 1429024
            [section_department_id] => 227635
            [section_id] => 222183
            [site_cf_value] => M2701
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-13
            [job_cf_id] => 3
            [quote_id] => 1026223
        )

    [3] => Array
        (
            [schedule_id] => 414567
            [date_modified] => 2026-04-13 14:28:22+01
            [schedule_block] => ["2026-04-13 13:45:00+01","2026-04-13 14:00:00+01")
            [schedule_block_id] => 1430159
            [section_department_id] => 227620
            [section_id] => 222168
            [site_cf_value] => M2175
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-28
            [job_cf_id] => 3
            [quote_id] => 1026208
        )

    [4] => Array
        (
            [schedule_id] => 414567
            [date_modified] => 2026-04-13 14:28:22+01
            [schedule_block] => ["2026-04-13 14:00:00+01","2026-04-13 14:15:00+01")
            [schedule_block_id] => 1430160
            [section_department_id] => 227620
            [section_id] => 222168
            [site_cf_value] => M2175
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-28
            [job_cf_id] => 3
            [quote_id] => 1026208
        )

    [5] => Array
        (
            [schedule_id] => 401932
            [date_modified] => 2026-04-13 14:44:40+01
            [schedule_block] => ["2026-04-13 14:15:00+01","2026-04-13 14:45:00+01")
            [schedule_block_id] => 1430222
            [section_department_id] => 230259
            [section_id] => 224754
            [site_cf_value] => M3039
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-30
            [job_cf_id] => 3
            [quote_id] => 1028782
        )

    [6] => Array
        (
            [schedule_id] => 401927
            [date_modified] => 2026-04-13 15:18:22+01
            [schedule_block] => ["2026-04-13 14:45:00+01","2026-04-13 15:00:00+01")
            [schedule_block_id] => 1430365
            [section_department_id] => 230222
            [section_id] => 224717
            [site_cf_value] => M3199
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-29
            [job_cf_id] => 3
            [quote_id] => 1028745
        )

    [7] => Array
        (
            [schedule_id] => 401927
            [date_modified] => 2026-04-13 15:18:22+01
            [schedule_block] => ["2026-04-13 15:00:00+01","2026-04-13 15:15:00+01")
            [schedule_block_id] => 1430366
            [section_department_id] => 230222
            [section_id] => 224717
            [site_cf_value] => M3199
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-29
            [job_cf_id] => 3
            [quote_id] => 1028745
        )

    [8] => Array
        (
            [schedule_id] => 419791
            [date_modified] => 2026-04-13 16:45:21+01
            [schedule_block] => ["2026-04-22 12:00:00+01","2026-04-22 16:30:00+01")
            [schedule_block_id] => 1431010
            [section_department_id] => 227667
            [section_id] => 222215
            [site_cf_value] => T403249
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-22
            [job_cf_id] => 3
            [quote_id] => 1026255
        )

    [9] => Array
        (
            [schedule_id] => 415181
            [date_modified] => 2026-04-13 21:03:51+01
            [schedule_block] => ["2026-04-13 12:30:00+01","2026-04-13 15:00:00+01")
            [schedule_block_id] => 1432290
            [section_department_id] => 182184
            [section_id] => 177468
            [site_cf_value] => 2304
            [site_cf_id] => 4
            [job_cf_value] => 2025-10-30
            [job_cf_id] => 3
            [quote_id] => 981677
        )

    [10] => Array
        (
            [schedule_id] => 419910
            [date_modified] => 2026-04-14 08:16:14+01
            [schedule_block] => ["2026-04-29 12:15:00+01","2026-04-29 17:00:00+01")
            [schedule_block_id] => 1432814
            [section_department_id] => 230222
            [section_id] => 224717
            [site_cf_value] => M3199
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-29
            [job_cf_id] => 3
            [quote_id] => 1028745
        )

    [11] => Array
        (
            [schedule_id] => 419918
            [date_modified] => 2026-04-14 08:19:46+01
            [schedule_block] => ["2026-04-28 12:00:00+01","2026-04-28 16:15:00+01")
            [schedule_block_id] => 1432828
            [section_department_id] => 227620
            [section_id] => 222168
            [site_cf_value] => M2175
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-28
            [job_cf_id] => 3
            [quote_id] => 1026208
        )

    [12] => Array
        (
            [schedule_id] => 419926
            [date_modified] => 2026-04-14 08:25:55+01
            [schedule_block] => ["2026-04-30 08:00:00+01","2026-04-30 11:30:00+01")
            [schedule_block_id] => 1432854
            [section_department_id] => 230259
            [section_id] => 224754
            [site_cf_value] => M3039
            [site_cf_id] => 4
            [job_cf_value] => 2026-04-30
            [job_cf_id] => 3
            [quote_id] => 1028782
        )

    [13] => Array
        (
            [schedule_id] => 402198
            [date_modified] => 2026-04-14 09:02:04+01
            [schedule_block] => ["2026-04-14 08:00:00+01","2026-04-14 08:45:00+01")
            [schedule_block_id] => 1432985
            [section_department_id] => 230271
            [section_id] => 224766
            [site_cf_value] => 42156
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-01
            [job_cf_id] => 3
            [quote_id] => 1028794
        )

    [14] => Array
        (
            [schedule_id] => 402198
            [date_modified] => 2026-04-14 09:02:04+01
            [schedule_block] => ["2026-04-14 08:45:00+01","2026-04-14 09:00:00+01")
            [schedule_block_id] => 1432986
            [section_department_id] => 230271
            [section_id] => 224766
            [site_cf_value] => 42156
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-01
            [job_cf_id] => 3
            [quote_id] => 1028794
        )

    [15] => Array
        (
            [schedule_id] => 419961
            [date_modified] => 2026-04-14 09:02:07+01
            [schedule_block] => ["2026-05-01 11:45:00+01","2026-05-01 16:00:00+01")
            [schedule_block_id] => 1432988
            [section_department_id] => 230271
            [section_id] => 224766
            [site_cf_value] => 42156
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-01
            [job_cf_id] => 3
            [quote_id] => 1028794
        )

    [16] => Array
        (
            [schedule_id] => 401983
            [date_modified] => 2026-04-14 09:28:08+01
            [schedule_block] => ["2026-04-14 08:45:00+01","2026-04-14 09:15:00+01")
            [schedule_block_id] => 1433170
            [section_department_id] => 230283
            [section_id] => 224778
            [site_cf_value] => 42216
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-06
            [job_cf_id] => 3
            [quote_id] => 1028806
        )

    [17] => Array
        (
            [schedule_id] => 402232
            [date_modified] => 2026-04-14 09:51:05+01
            [schedule_block] => ["2026-04-14 09:00:00+01","2026-04-14 09:15:00+01")
            [schedule_block_id] => 1433318
            [section_department_id] => 230240
            [section_id] => 224735
            [site_cf_value] => 8012
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-06
            [job_cf_id] => 3
            [quote_id] => 1028763
        )

    [18] => Array
        (
            [schedule_id] => 402232
            [date_modified] => 2026-04-14 09:51:05+01
            [schedule_block] => ["2026-04-14 09:15:00+01","2026-04-14 09:45:00+01")
            [schedule_block_id] => 1433319
            [section_department_id] => 230240
            [section_id] => 224735
            [site_cf_value] => 8012
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-06
            [job_cf_id] => 3
            [quote_id] => 1028763
        )

    [19] => Array
        (
            [schedule_id] => 420304
            [date_modified] => 2026-04-14 12:28:01+01
            [schedule_block] => ["2026-05-06 12:00:00+01","2026-05-06 15:45:00+01")
            [schedule_block_id] => 1435078
            [section_department_id] => 230240
            [section_id] => 224735
            [site_cf_value] => 8012
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-06
            [job_cf_id] => 3
            [quote_id] => 1028763
        )

    [20] => Array
        (
            [schedule_id] => 420308
            [date_modified] => 2026-04-14 12:30:36+01
            [schedule_block] => ["2026-05-06 08:00:00+01","2026-05-06 11:30:00+01")
            [schedule_block_id] => 1435102
            [section_department_id] => 230283
            [section_id] => 224778
            [site_cf_value] => 42216
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-06
            [job_cf_id] => 3
            [quote_id] => 1028806
        )

    [21] => Array
        (
            [schedule_id] => 420009
            [date_modified] => 2026-04-14 17:20:16+01
            [schedule_block] => ["2026-04-14 15:15:00+01","2026-04-14 17:30:00+01")
            [schedule_block_id] => 1437709
            [section_department_id] => 231158
            [section_id] => 148588
            [site_cf_value] => 18774
            [site_cf_id] => 4
            [job_cf_value] => 2026-02-06
            [job_cf_id] => 3
            [quote_id] => 953696
        )

    [22] => Array
        (
            [schedule_id] => 411672
            [date_modified] => 2026-04-14 20:07:14+01
            [schedule_block] => ["2026-04-14 15:15:00+01","2026-04-14 17:15:00+01")
            [schedule_block_id] => 1438193
            [section_department_id] => 231158
            [section_id] => 148588
            [site_cf_value] => 18774
            [site_cf_id] => 4
            [job_cf_value] => 2026-02-06
            [job_cf_id] => 3
            [quote_id] => 953696
        )

)
</pre>