#!/usr/bin/php -q
26-06-05 23:16:270SELECT 
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] => 446641
            [date_modified] => 2026-06-04 08:17:58+01
            [schedule_block] => ["2026-07-03 08:15:00+01","2026-07-03 12:15:00+01")
            [schedule_block_id] => 1603183
            [section_department_id] => 244416
            [section_id] => 238596
            [site_cf_value] => 9158
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-03
            [job_cf_id] => 3
            [quote_id] => 1042532
        )

    [1] => Array
        (
            [schedule_id] => 446652
            [date_modified] => 2026-06-04 08:25:54+01
            [schedule_block] => ["2026-07-07 12:15:00+01","2026-07-07 16:45:00+01")
            [schedule_block_id] => 1603208
            [section_department_id] => 230218
            [section_id] => 224713
            [site_cf_value] => 3824
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-07
            [job_cf_id] => 3
            [quote_id] => 1028741
        )

    [2] => Array
        (
            [schedule_id] => 435705
            [date_modified] => 2026-06-04 09:04:54+01
            [schedule_block] => ["2026-06-10 15:45:00+01","2026-06-10 16:15:00+01")
            [schedule_block_id] => 1603365
            [section_department_id] => 230239
            [section_id] => 224734
            [site_cf_value] => 20279
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-10
            [job_cf_id] => 3
            [quote_id] => 1028762
        )

    [3] => Array
        (
            [schedule_id] => 446215
            [date_modified] => 2026-06-04 09:05:54+01
            [schedule_block] => ["2026-06-04 08:30:00+01","2026-06-04 09:00:00+01")
            [schedule_block_id] => 1603385
            [section_department_id] => 230300
            [section_id] => 224795
            [site_cf_value] => 11581
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-06
            [job_cf_id] => 3
            [quote_id] => 1028823
        )

    [4] => Array
        (
            [schedule_id] => 446686
            [date_modified] => 2026-06-04 09:27:03+01
            [schedule_block] => ["2026-06-04 09:15:00+01","2026-06-04 09:30:00+01")
            [schedule_block_id] => 1603517
            [section_department_id] => 238623
            [section_id] => 232944
            [site_cf_value] => 8027
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-04
            [job_cf_id] => 3
            [quote_id] => 1036934
        )

    [5] => Array
        (
            [schedule_id] => 446742
            [date_modified] => 2026-06-04 09:41:14+01
            [schedule_block] => ["2026-06-15 12:00:00+01","2026-06-15 12:15:00+01")
            [schedule_block_id] => 1603606
            [section_department_id] => 252531
            [section_id] => 215367
            [site_cf_value] => 2260
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-15
            [job_cf_id] => 3
            [quote_id] => 1019452
        )

    [6] => Array
        (
            [schedule_id] => 446743
            [date_modified] => 2026-06-04 09:41:19+01
            [schedule_block] => ["2026-06-15 12:00:00+01","2026-06-15 16:00:00+01")
            [schedule_block_id] => 1603608
            [section_department_id] => 252531
            [section_id] => 215367
            [site_cf_value] => 2260
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-15
            [job_cf_id] => 3
            [quote_id] => 1019452
        )

    [7] => Array
        (
            [schedule_id] => 446810
            [date_modified] => 2026-06-04 10:32:03+01
            [schedule_block] => ["2026-06-10 08:30:00+01","2026-06-10 10:00:00+01")
            [schedule_block_id] => 1603800
            [section_department_id] => 203156
            [section_id] => 198143
            [site_cf_value] => TTRC004
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-10
            [job_cf_id] => 3
            [quote_id] => 1002310
        )

    [8] => Array
        (
            [schedule_id] => 432130
            [date_modified] => 2026-06-04 13:24:19+01
            [schedule_block] => ["2026-06-04 13:15:00+01","2026-06-04 13:30:00+01")
            [schedule_block_id] => 1604697
            [section_department_id] => 244407
            [section_id] => 238587
            [site_cf_value] => 19120
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-06
            [job_cf_id] => 3
            [quote_id] => 1042523
        )

    [9] => Array
        (
            [schedule_id] => 446689
            [date_modified] => 2026-06-04 14:05:32+01
            [schedule_block] => ["2026-06-04 09:00:00+01","2026-06-04 09:30:00+01")
            [schedule_block_id] => 1604872
            [section_department_id] => 238636
            [section_id] => 232957
            [site_cf_value] => 9735
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-04
            [job_cf_id] => 3
            [quote_id] => 1036947
        )

    [10] => Array
        (
            [schedule_id] => 446689
            [date_modified] => 2026-06-04 14:05:32+01
            [schedule_block] => ["2026-06-04 09:30:00+01","2026-06-04 14:00:00+01")
            [schedule_block_id] => 1604873
            [section_department_id] => 238636
            [section_id] => 232957
            [site_cf_value] => 9735
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-04
            [job_cf_id] => 3
            [quote_id] => 1036947
        )

    [11] => Array
        (
            [schedule_id] => 435047
            [date_modified] => 2026-06-04 14:19:53+01
            [schedule_block] => ["2026-06-04 12:45:00+01","2026-06-04 15:00:00+01")
            [schedule_block_id] => 1604915
            [section_department_id] => 238741
            [section_id] => 233062
            [site_cf_value] => M1445
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-04
            [job_cf_id] => 3
            [quote_id] => 1037052
        )

    [12] => Array
        (
            [schedule_id] => 446971
            [date_modified] => 2026-06-04 16:27:17+01
            [schedule_block] => ["2026-06-04 12:15:00+01","2026-06-04 12:45:00+01")
            [schedule_block_id] => 1605587
            [section_department_id] => 238636
            [section_id] => 232957
            [site_cf_value] => 9735
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-04
            [job_cf_id] => 3
            [quote_id] => 1036947
        )

    [13] => Array
        (
            [schedule_id] => 437409
            [date_modified] => 2026-06-04 16:27:33+01
            [schedule_block] => ["2026-06-04 18:00:00+01","2026-06-04 18:15:00+01")
            [schedule_block_id] => 1605588
            [section_department_id] => 230240
            [section_id] => 224735
            [site_cf_value] => 8012
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-04
            [job_cf_id] => 3
            [quote_id] => 1028763
        )

    [14] => Array
        (
            [schedule_id] => 447333
            [date_modified] => 2026-06-04 16:30:35+01
            [schedule_block] => ["2026-06-19 12:15:00+01","2026-06-19 15:30:00+01")
            [schedule_block_id] => 1605595
            [section_department_id] => 208118
            [section_id] => 202939
            [site_cf_value] => M4647
            [site_cf_id] => 4
            [job_cf_value] => 2026-01-19
            [job_cf_id] => 3
            [quote_id] => 1007074
        )

    [15] => Array
        (
            [schedule_id] => 447450
            [date_modified] => 2026-06-05 07:49:33+01
            [schedule_block] => ["2026-07-06 08:15:00+01","2026-07-06 11:30:00+01")
            [schedule_block_id] => 1606292
            [section_department_id] => 244407
            [section_id] => 238587
            [site_cf_value] => 19120
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-06
            [job_cf_id] => 3
            [quote_id] => 1042523
        )

    [16] => Array
        (
            [schedule_id] => 447453
            [date_modified] => 2026-06-05 07:57:24+01
            [schedule_block] => ["2026-07-06 11:45:00+01","2026-07-06 15:45:00+01")
            [schedule_block_id] => 1606296
            [section_department_id] => 230300
            [section_id] => 224795
            [site_cf_value] => 11581
            [site_cf_id] => 4
            [job_cf_value] => 2026-07-06
            [job_cf_id] => 3
            [quote_id] => 1028823
        )

    [17] => Array
        (
            [schedule_id] => 447545
            [date_modified] => 2026-06-05 09:06:53+01
            [schedule_block] => ["2026-06-18 08:15:00+01","2026-06-18 11:45:00+01")
            [schedule_block_id] => 1606503
            [section_department_id] => 227624
            [section_id] => 222172
            [site_cf_value] => 4395
            [site_cf_id] => 4
            [job_cf_value] => 2026-03-26
            [job_cf_id] => 3
            [quote_id] => 1026212
        )

    [18] => Array
        (
            [schedule_id] => 444092
            [date_modified] => 2026-06-05 13:05:53+01
            [schedule_block] => ["2026-06-08 09:00:00+01","2026-06-08 11:45:00+01")
            [schedule_block_id] => 1607494
            [section_department_id] => 230273
            [section_id] => 224768
            [site_cf_value] => 9845
            [site_cf_id] => 4
            [job_cf_value] => 2026-05-29
            [job_cf_id] => 3
            [quote_id] => 1028796
        )

    [19] => Array
        (
            [schedule_id] => 447900
            [date_modified] => 2026-06-05 13:26:35+01
            [schedule_block] => ["2026-07-07 08:00:00+01","2026-07-07 11:30:00+01")
            [schedule_block_id] => 1607553
            [section_department_id] => 238651
            [section_id] => 232972
            [site_cf_value] => 10052
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-05
            [job_cf_id] => 3
            [quote_id] => 1036962
        )

    [20] => Array
        (
            [schedule_id] => 444189
            [date_modified] => 2026-06-05 14:30:25+01
            [schedule_block] => ["2026-06-18 14:15:00+01","2026-06-18 15:15:00+01")
            [schedule_block_id] => 1607764
            [section_department_id] => 227625
            [section_id] => 222173
            [site_cf_value] => M1695
            [site_cf_id] => 4
            [job_cf_value] => 2026-03-30
            [job_cf_id] => 3
            [quote_id] => 1026213
        )

    [21] => Array
        (
            [schedule_id] => 436480
            [date_modified] => 2026-06-05 16:54:59+01
            [schedule_block] => ["2026-06-05 08:00:00+01","2026-06-05 08:15:00+01")
            [schedule_block_id] => 1608206
            [section_department_id] => 238651
            [section_id] => 232972
            [site_cf_value] => 10052
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-05
            [job_cf_id] => 3
            [quote_id] => 1036962
        )

    [22] => Array
        (
            [schedule_id] => 436480
            [date_modified] => 2026-06-05 16:54:59+01
            [schedule_block] => ["2026-06-05 08:15:00+01","2026-06-05 09:15:00+01")
            [schedule_block_id] => 1608207
            [section_department_id] => 238651
            [section_id] => 232972
            [site_cf_value] => 10052
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-05
            [job_cf_id] => 3
            [quote_id] => 1036962
        )

    [23] => Array
        (
            [schedule_id] => 444079
            [date_modified] => 2026-06-05 16:55:29+01
            [schedule_block] => ["2026-06-05 12:30:00+01","2026-06-05 13:00:00+01")
            [schedule_block_id] => 1608218
            [section_department_id] => 238671
            [section_id] => 232992
            [site_cf_value] => 5242
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-05
            [job_cf_id] => 3
            [quote_id] => 1036982
        )

    [24] => Array
        (
            [schedule_id] => 444079
            [date_modified] => 2026-06-05 16:55:29+01
            [schedule_block] => ["2026-06-05 13:30:00+01","2026-06-05 17:00:00+01")
            [schedule_block_id] => 1608219
            [section_department_id] => 238671
            [section_id] => 232992
            [site_cf_value] => 5242
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-05
            [job_cf_id] => 3
            [quote_id] => 1036982
        )

    [25] => Array
        (
            [schedule_id] => 438375
            [date_modified] => 2026-06-05 21:43:24+01
            [schedule_block] => ["2026-06-05 08:45:00+01","2026-06-05 12:15:00+01")
            [schedule_block_id] => 1608673
            [section_department_id] => 230307
            [section_id] => 224802
            [site_cf_value] => M591
            [site_cf_id] => 4
            [job_cf_value] => 2026-06-05
            [job_cf_id] => 3
            [quote_id] => 1028830
        )

)
</pre>