#!/usr/bin/php -q
26-07-21 18:52:440SELECT 
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] => 450900
            [date_modified] => 2026-07-20 10:00:48+01
            [schedule_block] => ["2026-07-16 11:00:00+01","2026-07-16 11:30:00+01")
            [schedule_block_id] => 1696089
            [section_department_id] => 230292
            [section_id] => 224787
            [site_cf_value] => 1849
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-11
            [job_cf_id] => 3
            [quote_id] => 1028815
        )

    [1] => Array
        (
            [schedule_id] => 450900
            [date_modified] => 2026-07-20 10:00:48+01
            [schedule_block] => ["2026-07-16 11:30:00+01","2026-07-16 11:45:00+01")
            [schedule_block_id] => 1696090
            [section_department_id] => 230292
            [section_id] => 224787
            [site_cf_value] => 1849
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-11
            [job_cf_id] => 3
            [quote_id] => 1028815
        )

    [2] => Array
        (
            [schedule_id] => 468993
            [date_modified] => 2026-07-20 14:10:17+01
            [schedule_block] => ["2026-07-30 11:30:00+01","2026-07-30 11:45:00+01")
            [schedule_block_id] => 1697529
            [section_department_id] => 230288
            [section_id] => 224783
            [site_cf_value] => 41279
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-15
            [job_cf_id] => 3
            [quote_id] => 1028811
        )

    [3] => Array
        (
            [schedule_id] => 466415
            [date_modified] => 2026-07-20 14:44:29+01
            [schedule_block] => ["2026-07-20 10:15:00+01","2026-07-20 10:45:00+01")
            [schedule_block_id] => 1697748
            [section_department_id] => 244424
            [section_id] => 238604
            [site_cf_value] => 7855
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-20
            [job_cf_id] => 3
            [quote_id] => 1042540
        )

    [4] => Array
        (
            [schedule_id] => 466415
            [date_modified] => 2026-07-20 14:44:29+01
            [schedule_block] => ["2026-07-20 10:45:00+01","2026-07-20 12:30:00+01")
            [schedule_block_id] => 1697749
            [section_department_id] => 244424
            [section_id] => 238604
            [site_cf_value] => 7855
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-20
            [job_cf_id] => 3
            [quote_id] => 1042540
        )

    [5] => Array
        (
            [schedule_id] => 466415
            [date_modified] => 2026-07-20 14:44:29+01
            [schedule_block] => ["2026-07-20 13:00:00+01","2026-07-20 14:45:00+01")
            [schedule_block_id] => 1697750
            [section_department_id] => 244424
            [section_id] => 238604
            [site_cf_value] => 7855
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-20
            [job_cf_id] => 3
            [quote_id] => 1042540
        )

    [6] => Array
        (
            [schedule_id] => 458974
            [date_modified] => 2026-07-20 14:58:27+01
            [schedule_block] => ["2026-07-21 10:45:00+01","2026-07-21 13:45:00+01")
            [schedule_block_id] => 1697856
            [section_department_id] => 244465
            [section_id] => 238645
            [site_cf_value] => 10095
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-21
            [job_cf_id] => 3
            [quote_id] => 1042581
        )

    [7] => Array
        (
            [schedule_id] => 467013
            [date_modified] => 2026-07-20 15:28:44+01
            [schedule_block] => ["2026-07-20 13:30:00+01","2026-07-20 15:30:00+01")
            [schedule_block_id] => 1698047
            [section_department_id] => 208078
            [section_id] => 202899
            [site_cf_value] => 7014
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-07
            [job_cf_id] => 3
            [quote_id] => 1007034
        )

    [8] => Array
        (
            [schedule_id] => 467882
            [date_modified] => 2026-07-20 16:47:42+01
            [schedule_block] => ["2026-07-23 08:30:00+01","2026-07-23 09:00:00+01")
            [schedule_block_id] => 1698541
            [section_department_id] => 230292
            [section_id] => 224787
            [site_cf_value] => 1849
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-11
            [job_cf_id] => 3
            [quote_id] => 1028815
        )

    [9] => Array
        (
            [schedule_id] => 453867
            [date_modified] => 2026-07-21 08:48:53+01
            [schedule_block] => ["2026-07-21 08:00:00+01","2026-07-21 08:30:00+01")
            [schedule_block_id] => 1699184
            [section_department_id] => 238682
            [section_id] => 233003
            [site_cf_value] => 2648
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-17
            [job_cf_id] => 3
            [quote_id] => 1036993
        )

    [10] => Array
        (
            [schedule_id] => 459217
            [date_modified] => 2026-07-21 11:45:57+01
            [schedule_block] => ["2026-07-21 08:45:00+01","2026-07-21 11:45:00+01")
            [schedule_block_id] => 1700159
            [section_department_id] => 238616
            [section_id] => 232937
            [site_cf_value] => 8235
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-21
            [job_cf_id] => 3
            [quote_id] => 1036927
        )

    [11] => Array
        (
            [schedule_id] => 469703
            [date_modified] => 2026-07-21 12:55:59+01
            [schedule_block] => ["2026-07-22 10:15:00+01","2026-07-22 10:45:00+01")
            [schedule_block_id] => 1700471
            [section_department_id] => 34214
            [section_id] => 32280
            [site_cf_value] => T403833
            [site_cf_id] => 4
            [job_cf_value] => 2024-01-29
            [job_cf_id] => 3
            [quote_id] => 842267
        )

    [12] => Array
        (
            [schedule_id] => 468183
            [date_modified] => 2026-07-21 14:05:20+01
            [schedule_block] => ["2026-08-11 12:00:00+01","2026-08-11 14:15:00+01")
            [schedule_block_id] => 1700720
            [section_department_id] => 244403
            [section_id] => 238583
            [site_cf_value] => 18229
            [site_cf_id] => 4
            [job_cf_value] => 2026-08-11
            [job_cf_id] => 3
            [quote_id] => 1042519
        )

    [13] => Array
        (
            [schedule_id] => 469691
            [date_modified] => 2026-07-21 15:18:37+01
            [schedule_block] => ["2026-07-21 13:00:00+01","2026-07-21 13:15:00+01")
            [schedule_block_id] => 1701112
            [section_department_id] => 220684
            [section_id] => 215332
            [site_cf_value] => 1837
            [site_cf_id] => 4
            [job_cf_value] => 2026-02-23
            [job_cf_id] => 3
            [quote_id] => 1019417
        )

    [14] => Array
        (
            [schedule_id] => 469902
            [date_modified] => 2026-07-21 15:58:05+01
            [schedule_block] => ["2026-07-22 12:15:00+01","2026-07-22 15:15:00+01")
            [schedule_block_id] => 1701272
            [section_department_id] => 238721
            [section_id] => 233042
            [site_cf_value] => M719
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-08
            [job_cf_id] => 3
            [quote_id] => 1037032
        )

    [15] => Array
        (
            [schedule_id] => 461435
            [date_modified] => 2026-07-21 15:59:47+01
            [schedule_block] => ["2026-07-22 08:15:00+01","2026-07-22 10:15:00+01")
            [schedule_block_id] => 1701281
            [section_department_id] => 244400
            [section_id] => 238580
            [site_cf_value] => 7648
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-22
            [job_cf_id] => 3
            [quote_id] => 1042516
        )

    [16] => Array
        (
            [schedule_id] => 460875
            [date_modified] => 2026-07-21 16:00:01+01
            [schedule_block] => ["2026-07-22 10:15:00+01","2026-07-22 12:00:00+01")
            [schedule_block_id] => 1701284
            [section_department_id] => 244462
            [section_id] => 238642
            [site_cf_value] => 4216
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-22
            [job_cf_id] => 3
            [quote_id] => 1042578
        )

    [17] => Array
        (
            [schedule_id] => 469907
            [date_modified] => 2026-07-21 16:04:51+01
            [schedule_block] => ["2026-07-29 12:15:00+01","2026-07-29 12:30:00+01")
            [schedule_block_id] => 1701304
            [section_department_id] => 238675
            [section_id] => 232996
            [site_cf_value] => 8619
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-29
            [job_cf_id] => 3
            [quote_id] => 1036986
        )

    [18] => Array
        (
            [schedule_id] => 456583
            [date_modified] => 2026-07-21 17:44:47+01
            [schedule_block] => ["2026-07-21 08:30:00+01","2026-07-21 10:45:00+01")
            [schedule_block_id] => 1701809
            [section_department_id] => 238735
            [section_id] => 233056
            [site_cf_value] => 43450
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-21
            [job_cf_id] => 3
            [quote_id] => 1037046
        )

)
</pre>