Time : 11:05:22
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT h.*,
                           (111.111 * DEGREES(
                               ACOS(
                                   COS(RADIANS(31.1075588)) * COS(RADIANS(h.latitude)) *
                                   COS(RADIANS(h.longitude) - RADIANS(77.1959622)) +
                                   SIN(RADIANS(31.1075588)) * SIN(RADIANS(h.latitude))
                               )
                           )) AS distance
                    FROM rt_service_providers h
                    WHERE h.status = 1
                      AND h.amount > 0

                      -- Exclude helpers with overlapping bookings
                      AND h.id NOT IN (
                          SELECT provider_id
                          FROM rt_booking_on_the_go
                          WHERE booking_status IN ('Accepted','Started')
                            AND (
                                (type='normal' 
                                    AND date_time IS NOT NULL
                                    AND date_time != ''
                                    AND date_time != '0000-00-00 00:00:00'
                                    AND date_time < '2025-12-12 10:26:12'
                                    AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > '2025-12-12 10:26:12'
                                )
                                OR
                                (type='schedule' 
                                    AND schedule_date IS NOT NULL AND schedule_date != ''
                                    AND schedule_time IS NOT NULL AND schedule_time != ''
                                    AND CONCAT(schedule_date, ' ', schedule_time) < '2025-12-12 10:26:12'
                                    AND DATE_ADD(CONCAT(schedule_date, ' ', schedule_time), INTERVAL hours_per_day*60 MINUTE) > '2025-12-12 10:26:12'
                                )
                            )
                      )

                      -- Exclude helpers already pre-assigned
                      AND h.id NOT IN (
                          SELECT pah.provider_id
                          FROM pre_assigned_helper pah
                          JOIN rt_booking_on_the_go b 
                            ON b.booking_app_id = pah.booking_app_id
                          WHERE b.booking_status IN ('Requested','Schedule')
                      )

                      -- Availability filters
                      AND h.deactivate_account = 0
                      AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                      AND h.latitude IS NOT NULL
                      AND h.longitude IS NOT NULL
                      AND h.category_id <> ''
                      AND h.last_seen IS NOT NULL

                    ORDER BY distance ASC, h.last_seen DESC
                    LIMIT 1

Time : 11:02:23
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT h.*,
       (111.111 * DEGREES(
           ACOS(
               COS(RADIANS(31.1075588)) * COS(RADIANS(h.latitude)) *
               COS(RADIANS(h.longitude) - RADIANS(77.1959622)) +
               SIN(RADIANS(31.1075588)) * SIN(RADIANS(h.latitude))
           )
       )) AS distance
FROM rt_service_providers h
WHERE h.status = 1
  AND h.amount > 0

  -- Exclude helpers with overlapping normal bookings
  AND h.id NOT IN (
      SELECT provider_id FROM (
          SELECT provider_id,
                 STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s') AS normal_dt,
                 hours_per_day
          FROM rt_booking_on_the_go
          WHERE booking_status IN ('Accepted','Started','Requested','Schedule')
            AND type='normal'
      ) AS safe_bookings
      WHERE normal_dt IS NOT NULL
        AND normal_dt < ''
        AND DATE_ADD(normal_dt, INTERVAL hours_per_day MINUTE) > ''
  )

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1;

Time : 11:01:19
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT h.*,
       (111.111 * DEGREES(
           ACOS(
               COS(RADIANS(31.1075588)) * COS(RADIANS(h.latitude)) *
               COS(RADIANS(h.longitude) - RADIANS(77.1959622)) +
               SIN(RADIANS(31.1075588)) * SIN(RADIANS(h.latitude))
           )
       )) AS distance
FROM rt_service_providers h
WHERE h.status = 1
  AND h.amount > 0

  -- Exclude helpers with overlapping normal bookings
  AND h.id NOT IN (
      SELECT provider_id FROM (
          SELECT provider_id,
                 STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s') AS normal_dt,
                 hours_per_day
          FROM rt_booking_on_the_go
          WHERE booking_status IN ('Accepted','Started','Requested','Schedule')
            AND type='normal'
      ) AS safe_bookings
      WHERE normal_dt IS NOT NULL
        AND normal_dt < ''
        AND DATE_ADD(normal_dt, INTERVAL hours_per_day MINUTE) > ''
  )

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1;

Time : 11:00:21
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT h.*,
       (111.111 * DEGREES(
           ACOS(
               COS(RADIANS(31.1075588)) * COS(RADIANS(h.latitude)) *
               COS(RADIANS(h.longitude) - RADIANS(77.1959622)) +
               SIN(RADIANS(31.1075588)) * SIN(RADIANS(h.latitude))
           )
       )) AS distance
FROM rt_service_providers h
WHERE h.status = 1
  AND h.amount > 0

  -- Exclude helpers with overlapping normal bookings
  AND h.id NOT IN (
      SELECT provider_id FROM (
          SELECT provider_id,
                 STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s') AS normal_dt,
                 hours_per_day
          FROM rt_booking_on_the_go
          WHERE booking_status IN ('Accepted','Started','Requested','Schedule')
            AND type='normal'
      ) AS safe_bookings
      WHERE normal_dt IS NOT NULL
        AND normal_dt < ''
        AND DATE_ADD(normal_dt, INTERVAL hours_per_day MINUTE) > ''
  )

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1;

Time : 10:51:20
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
    h.*,
    (
        111.111 * DEGREES(
            acos(
                cos(radians(31.1075588)) 
                * cos(radians(h.latitude))
                * cos(radians(h.longitude) - radians(77.1959622))
                + sin(radians(31.1075588))
                * sin(radians(h.latitude))
            )
        )
    ) AS distance  
FROM rt_service_providers h
WHERE 
    h.status = 1
    AND h.amount > 0

    -- Allowed categories
    AND (
        FIND_IN_SET(1, h.category_id)
        OR FIND_IN_SET(20, h.category_id)
        OR FIND_IN_SET(8, h.category_id)
        OR FIND_IN_SET(17, h.category_id)
        OR FIND_IN_SET(2, h.category_id)
    )

    -- DO NOT PICK HELPERS WHO ARE BUSY IN OVERLAPPING BOOKINGS
    AND h.id NOT IN (
    SELECT provider_id 
    FROM rt_booking_on_the_go
    WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')
    
    AND (

        /* NORMAL BOOKING */
        (
            type = 'normal'
            
            AND STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s') IS NOT NULL

            AND STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s') < ''
            AND DATE_ADD(
                    STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s'),
                    INTERVAL hours_per_day MINUTE
                ) > ''
        )

        OR

        /*  SCHEDULE BOOKING */
        (
            type = 'schedule'

            AND STR_TO_DATE(NULLIF(CONCAT(schedule_date,' ',schedule_time),''), '%Y-%m-%d %H:%i:%s') IS NOT NULL
            
            AND STR_TO_DATE(CONCAT(schedule_date,' ',schedule_time), '%Y-%m-%d %H:%i:%s') < ''
            AND DATE_ADD(
                STR_TO_DATE(CONCAT(schedule_date,' ',schedule_time), '%Y-%m-%d %H:%i:%s'),
                INTERVAL hours_per_day * 60 MINUTE
            ) > ''
        )
    )
)


    -- Block helpers already pre-assigned somewhere else
    AND h.id NOT IN (
        SELECT pah.provider_id
        FROM pre_assigned_helper pah
        JOIN rt_booking_on_the_go b 
            ON b.booking_app_id = pah.booking_app_id
        WHERE b.booking_status IN ('Requested', 'Schedule')
    )

    -- Availability filters
    AND h.deactivate_account = 0
    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
    AND h.latitude IS NOT NULL
    AND h.longitude IS NOT NULL
    AND h.category_id <> ''
    AND h.last_seen IS NOT NULL

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1

Time : 10:50:20
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
    h.*,
    (
        111.111 * DEGREES(
            acos(
                cos(radians(31.1075588)) 
                * cos(radians(h.latitude))
                * cos(radians(h.longitude) - radians(77.1959622))
                + sin(radians(31.1075588))
                * sin(radians(h.latitude))
            )
        )
    ) AS distance  
FROM rt_service_providers h
WHERE 
    h.status = 1
    AND h.amount > 0

    -- Allowed categories
    AND (
        FIND_IN_SET(1, h.category_id)
        OR FIND_IN_SET(20, h.category_id)
        OR FIND_IN_SET(8, h.category_id)
        OR FIND_IN_SET(17, h.category_id)
        OR FIND_IN_SET(2, h.category_id)
    )

    -- DO NOT PICK HELPERS WHO ARE BUSY IN OVERLAPPING BOOKINGS
    AND h.id NOT IN (
    SELECT provider_id 
    FROM rt_booking_on_the_go
    WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')
    
    AND (

        /* NORMAL BOOKING */
        (
            type = 'normal'
            
            AND STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s') IS NOT NULL

            AND STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s') < ''
            AND DATE_ADD(
                    STR_TO_DATE(date_time, '%Y-%m-%d %H:%i:%s'),
                    INTERVAL hours_per_day MINUTE
                ) > ''
        )

        OR

        /*  SCHEDULE BOOKING */
        (
            type = 'schedule'

            AND STR_TO_DATE(NULLIF(CONCAT(schedule_date,' ',schedule_time),''), '%Y-%m-%d %H:%i:%s') IS NOT NULL
            
            AND STR_TO_DATE(CONCAT(schedule_date,' ',schedule_time), '%Y-%m-%d %H:%i:%s') < ''
            AND DATE_ADD(
                STR_TO_DATE(CONCAT(schedule_date,' ',schedule_time), '%Y-%m-%d %H:%i:%s'),
                INTERVAL hours_per_day * 60 MINUTE
            ) > ''
        )
    )
)


    -- Block helpers already pre-assigned somewhere else
    AND h.id NOT IN (
        SELECT pah.provider_id
        FROM pre_assigned_helper pah
        JOIN rt_booking_on_the_go b 
            ON b.booking_app_id = pah.booking_app_id
        WHERE b.booking_status IN ('Requested', 'Schedule')
    )

    -- Availability filters
    AND h.deactivate_account = 0
    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
    AND h.latitude IS NOT NULL
    AND h.longitude IS NOT NULL
    AND h.category_id <> ''
    AND h.last_seen IS NOT NULL

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1

Time : 10:49:19
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
    h.*,
    (
        111.111 * DEGREES(
            acos(
                cos(radians(31.1075588)) 
                * cos(radians(h.latitude))
                * cos(radians(h.longitude) - radians(77.1959622))
                + sin(radians(31.1075588))
                * sin(radians(h.latitude))
            )
        )
    ) AS distance  
FROM rt_service_providers h
WHERE 
    h.status = 1
    AND h.amount > 0

    -- Allowed categories
    AND (
        FIND_IN_SET(1, h.category_id)
        OR FIND_IN_SET(20, h.category_id)
        OR FIND_IN_SET(8, h.category_id)
        OR FIND_IN_SET(17, h.category_id)
        OR FIND_IN_SET(2, h.category_id)
    )

    -- DO NOT PICK HELPERS WHO ARE BUSY IN OVERLAPPING BOOKINGS
    AND h.id NOT IN (
    SELECT provider_id 
    FROM rt_booking_on_the_go
    WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')
    
    AND (

        /* NORMAL BOOKINGS (SAFE) */
        (
            type = 'normal'
            AND date_time IS NOT NULL 
            AND date_time != ''
            AND CASE 
                    WHEN date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    THEN (
                        date_time < ''
                        AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                    )
                    ELSE 0
                END
        )

        OR

        /* SCHEDULE BOOKINGS (SAFE) */
        (
            type = 'schedule'
            AND schedule_date IS NOT NULL AND schedule_date != ''
            AND schedule_time IS NOT NULL AND schedule_time != ''
            AND CASE 
                    WHEN schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
                     AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    THEN (
                        CONCAT(schedule_date, ' ', schedule_time) < ''
                        AND DATE_ADD(
                            CONCAT(schedule_date, ' ', schedule_time),
                            INTERVAL hours_per_day * 60 MINUTE
                        ) > ''
                    )
                    ELSE 0
                END
        )
    )
)


    -- Block helpers already pre-assigned somewhere else
    AND h.id NOT IN (
        SELECT pah.provider_id
        FROM pre_assigned_helper pah
        JOIN rt_booking_on_the_go b 
            ON b.booking_app_id = pah.booking_app_id
        WHERE b.booking_status IN ('Requested', 'Schedule')
    )

    -- Availability filters
    AND h.deactivate_account = 0
    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
    AND h.latitude IS NOT NULL
    AND h.longitude IS NOT NULL
    AND h.category_id <> ''
    AND h.last_seen IS NOT NULL

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1

Time : 10:48:14
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
    h.*,
    (
        111.111 * DEGREES(
            acos(
                cos(radians(31.1075588)) 
                * cos(radians(h.latitude))
                * cos(radians(h.longitude) - radians(77.1959622))
                + sin(radians(31.1075588))
                * sin(radians(h.latitude))
            )
        )
    ) AS distance  
FROM rt_service_providers h
WHERE 
    h.status = 1
    AND h.amount > 0

    -- Allowed categories
    AND (
        FIND_IN_SET(1, h.category_id)
        OR FIND_IN_SET(20, h.category_id)
        OR FIND_IN_SET(8, h.category_id)
        OR FIND_IN_SET(17, h.category_id)
        OR FIND_IN_SET(2, h.category_id)
    )

    -- DO NOT PICK HELPERS WHO ARE BUSY IN OVERLAPPING BOOKINGS
    AND h.id NOT IN (
        SELECT provider_id 
        FROM rt_booking_on_the_go
        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')
        AND (

            /* ───────────── NORMAL BOOKINGS (safe) ───────────── */
            (
                type = 'normal'
                AND date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
                AND date_time < ''
                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
            )

            OR

            /* ───────────── SCHEDULE BOOKINGS (safe) ───────────── */
            (
                type = 'schedule'
                AND schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
                AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                AND DATE_ADD(
                    CONCAT(schedule_date, ' ', schedule_time),
                    INTERVAL hours_per_day * 60 MINUTE
                ) > ''
            )
        )
    )

    -- Block helpers already pre-assigned somewhere else
    AND h.id NOT IN (
        SELECT pah.provider_id
        FROM pre_assigned_helper pah
        JOIN rt_booking_on_the_go b 
            ON b.booking_app_id = pah.booking_app_id
        WHERE b.booking_status IN ('Requested', 'Schedule')
    )

    -- Availability filters
    AND h.deactivate_account = 0
    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
    AND h.latitude IS NOT NULL
    AND h.longitude IS NOT NULL
    AND h.category_id <> ''
    AND h.last_seen IS NOT NULL

ORDER BY distance ASC, h.last_seen DESC
LIMIT 1

Time : 10:47:18
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 71
Raw SQL : SELECT 
        h.*,
        (
            111.111 * DEGREES(
                acos(
                    cos(radians(31.1075588)) 
                    * cos(radians(h.latitude))
                    * cos(radians(h.longitude) - radians(77.1959622))
                    + sin(radians(31.1075588))
                    * sin(radians(h.latitude))
                )
            )
        ) AS distance  
    FROM rt_service_providers h
    WHERE 
        h.status = 1
        AND h.amount > 0

        AND (
            FIND_IN_SET(1, h.category_id)
            OR FIND_IN_SET(20, h.category_id)
            OR FIND_IN_SET(8, h.category_id)
            OR FIND_IN_SET(17, h.category_id)
            OR FIND_IN_SET(2, h.category_id)
        )

        AND h.id NOT IN (
            SELECT provider_id
            FROM rt_booking_on_the_go
            WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

            AND (
    -- NORMAL BOOKINGS FIRST
    (
        type = 'normal'
        AND date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
        AND date_time < ''
        AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
    )

    OR

    -- SCHEDULE BOOKINGS (only if both schedule_date & time valid)
    (
        type = 'schedule'
        AND schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
        AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
        AND CONCAT(schedule_date,' ',schedule_time) < ''
        AND DATE_ADD(
            CONCAT(schedule_date,' ',schedule_time),
            INTERVAL hours_per_day * 60 MINUTE
        ) > ''
    )
)


        AND h.id NOT IN (
            SELECT pah.provider_id
            FROM pre_assigned_helper pah
            JOIN rt_booking_on_the_go b 
                ON b.booking_app_id = pah.booking_app_id
            WHERE b.booking_status IN ('Requested', 'Schedule')
        )

        AND h.deactivate_account = 0
        AND h.last_seen >= NOW() - INTERVAL 96 HOUR
        AND h.latitude IS NOT NULL
        AND h.longitude IS NOT NULL

    ORDER BY distance ASC, h.last_seen DESC
    LIMIT 1

Time : 10:46:23
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 71
Raw SQL : SELECT 
        h.*,
        (
            111.111 * DEGREES(
                acos(
                    cos(radians(31.1075588)) 
                    * cos(radians(h.latitude))
                    * cos(radians(h.longitude) - radians(77.1959622))
                    + sin(radians(31.1075588))
                    * sin(radians(h.latitude))
                )
            )
        ) AS distance  
    FROM rt_service_providers h
    WHERE 
        h.status = 1
        AND h.amount > 0

        AND (
            FIND_IN_SET(1, h.category_id)
            OR FIND_IN_SET(20, h.category_id)
            OR FIND_IN_SET(8, h.category_id)
            OR FIND_IN_SET(17, h.category_id)
            OR FIND_IN_SET(2, h.category_id)
        )

        AND h.id NOT IN (
            SELECT provider_id
            FROM rt_booking_on_the_go
            WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

            AND (
    -- NORMAL BOOKINGS FIRST
    (
        type = 'normal'
        AND date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
        AND date_time < ''
        AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
    )

    OR

    -- SCHEDULE BOOKINGS (only if both schedule_date & time valid)
    (
        type = 'schedule'
        AND schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
        AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
        AND CONCAT(schedule_date,' ',schedule_time) < ''
        AND DATE_ADD(
            CONCAT(schedule_date,' ',schedule_time),
            INTERVAL hours_per_day * 60 MINUTE
        ) > ''
    )
)


        AND h.id NOT IN (
            SELECT pah.provider_id
            FROM pre_assigned_helper pah
            JOIN rt_booking_on_the_go b 
                ON b.booking_app_id = pah.booking_app_id
            WHERE b.booking_status IN ('Requested', 'Schedule')
        )

        AND h.deactivate_account = 0
        AND h.last_seen >= NOW() - INTERVAL 96 HOUR
        AND h.latitude IS NOT NULL
        AND h.longitude IS NOT NULL

    ORDER BY distance ASC, h.last_seen DESC
    LIMIT 1

Time : 10:44:16
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
        h.*,
        (
            111.111 * DEGREES(
                acos(
                    cos(radians(31.1075588)) 
                    * cos(radians(h.latitude))
                    * cos(radians(h.longitude) - radians(77.1959622))
                    + sin(radians(31.1075588))
                    * sin(radians(h.latitude))
                )
            )
        ) AS distance  
    FROM rt_service_providers h
    WHERE 
        h.status = 1
        AND h.amount > 0

        AND (
            FIND_IN_SET(1, h.category_id)
            OR FIND_IN_SET(20, h.category_id)
            OR FIND_IN_SET(8, h.category_id)
            OR FIND_IN_SET(17, h.category_id)
            OR FIND_IN_SET(2, h.category_id)
        )

        AND h.id NOT IN (
            SELECT provider_id
            FROM rt_booking_on_the_go
            WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

            AND (
                (
                    type = 'normal'
                    AND date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    AND date_time < ''
                    AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                )
                OR
                (
                    type = 'schedule'
                    AND schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
                    AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    AND CONCAT(schedule_date,' ',schedule_time) < ''
                    AND DATE_ADD(
                        CONCAT(schedule_date,' ',schedule_time), 
                        INTERVAL hours_per_day * 60 MINUTE
                    ) > ''
                )
            )
        )

        AND h.id NOT IN (
            SELECT pah.provider_id
            FROM pre_assigned_helper pah
            JOIN rt_booking_on_the_go b 
                ON b.booking_app_id = pah.booking_app_id
            WHERE b.booking_status IN ('Requested', 'Schedule')
        )

        AND h.deactivate_account = 0
        AND h.last_seen >= NOW() - INTERVAL 96 HOUR
        AND h.latitude IS NOT NULL
        AND h.longitude IS NOT NULL

    ORDER BY distance ASC, h.last_seen DESC
    LIMIT 1

Time : 10:43:17
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
        h.*,
        (
            111.111 * DEGREES(
                acos(
                    cos(radians(31.1075588)) 
                    * cos(radians(h.latitude))
                    * cos(radians(h.longitude) - radians(77.1959622))
                    + sin(radians(31.1075588))
                    * sin(radians(h.latitude))
                )
            )
        ) AS distance  
    FROM rt_service_providers h
    WHERE 
        h.status = 1
        AND h.amount > 0

        AND (
            FIND_IN_SET(1, h.category_id)
            OR FIND_IN_SET(20, h.category_id)
            OR FIND_IN_SET(8, h.category_id)
            OR FIND_IN_SET(17, h.category_id)
            OR FIND_IN_SET(2, h.category_id)
        )

        AND h.id NOT IN (
            SELECT provider_id
            FROM rt_booking_on_the_go
            WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

            AND (
                (
                    type = 'normal'
                    AND date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    AND date_time < ''
                    AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                )
                OR
                (
                    type = 'schedule'
                    AND schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
                    AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    AND CONCAT(schedule_date,' ',schedule_time) < ''
                    AND DATE_ADD(
                        CONCAT(schedule_date,' ',schedule_time), 
                        INTERVAL hours_per_day * 60 MINUTE
                    ) > ''
                )
            )
        )

        AND h.id NOT IN (
            SELECT pah.provider_id
            FROM pre_assigned_helper pah
            JOIN rt_booking_on_the_go b 
                ON b.booking_app_id = pah.booking_app_id
            WHERE b.booking_status IN ('Requested', 'Schedule')
        )

        AND h.deactivate_account = 0
        AND h.last_seen >= NOW() - INTERVAL 96 HOUR
        AND h.latitude IS NOT NULL
        AND h.longitude IS NOT NULL

    ORDER BY distance ASC, h.last_seen DESC
    LIMIT 1

Time : 10:42:17
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
        h.*,
        (
            111.111 * DEGREES(
                acos(
                    cos(radians(31.1075588)) 
                    * cos(radians(h.latitude))
                    * cos(radians(h.longitude) - radians(77.1959622))
                    + sin(radians(31.1075588))
                    * sin(radians(h.latitude))
                )
            )
        ) AS distance  
    FROM rt_service_providers h
    WHERE 
        h.status = 1
        AND h.amount > 0

        AND (
            FIND_IN_SET(1, h.category_id)
            OR FIND_IN_SET(20, h.category_id)
            OR FIND_IN_SET(8, h.category_id)
            OR FIND_IN_SET(17, h.category_id)
            OR FIND_IN_SET(2, h.category_id)
        )

        AND h.id NOT IN (
            SELECT provider_id
            FROM rt_booking_on_the_go
            WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

            AND (
                (
                    type = 'normal'
                    AND date_time REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    AND date_time < ''
                    AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                )
                OR
                (
                    type = 'schedule'
                    AND schedule_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'
                    AND schedule_time REGEXP '^[0-9]{2}:[0-9]{2}:[0-9]{2}$'
                    AND CONCAT(schedule_date,' ',schedule_time) < ''
                    AND DATE_ADD(
                        CONCAT(schedule_date,' ',schedule_time), 
                        INTERVAL hours_per_day * 60 MINUTE
                    ) > ''
                )
            )
        )

        AND h.id NOT IN (
            SELECT pah.provider_id
            FROM pre_assigned_helper pah
            JOIN rt_booking_on_the_go b 
                ON b.booking_app_id = pah.booking_app_id
            WHERE b.booking_status IN ('Requested', 'Schedule')
        )

        AND h.deactivate_account = 0
        AND h.last_seen >= NOW() - INTERVAL 96 HOUR
        AND h.latitude IS NOT NULL
        AND h.longitude IS NOT NULL

    ORDER BY distance ASC, h.last_seen DESC
    LIMIT 1

Time : 10:41:14
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    AND h.amount > 0

                                    -- Allowed categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    -- 1️⃣ Helper must NOT be in any conflicting booking
                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL booking (safe datetime)
                                            (
                                                type = 'normal'
                                                AND STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s') IS NOT NULL
                                                AND STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s') < ''
                                                AND DATE_ADD(
                                                    STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s'),
                                                    INTERVAL hours_per_day MINUTE
                                                ) > ''
                                            )

                                            OR

                                            -- SCHEDULE booking (safe datetime)
                                            (
                                                type = 'schedule'
                                                AND STR_TO_DATE(
                                                    CONCAT(NULLIF(schedule_date,''),' ',NULLIF(schedule_time,'')),
                                                    '%Y-%m-%d %H:%i:%s'
                                                ) IS NOT NULL
                                                AND STR_TO_DATE(
                                                    CONCAT(NULLIF(schedule_date,''),' ',NULLIF(schedule_time,'')),
                                                    '%Y-%m-%d %H:%i:%s'
                                                ) < ''
                                                AND DATE_ADD(
                                                    STR_TO_DATE(
                                                        CONCAT(NULLIF(schedule_date,''),' ',NULLIF(schedule_time,'')),
                                                        '%Y-%m-%d %H:%i:%s'
                                                    ),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )
                                        )
                                    )

                                    -- 2️⃣ Not pre-assigned
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- 3️⃣ Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:40:18
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    AND h.amount > 0

                                    -- Allowed categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    -- 1️⃣ Helper must NOT be in any conflicting booking
                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL booking (safe datetime)
                                            (
                                                type = 'normal'
                                                AND STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s') IS NOT NULL
                                                AND STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s') < ''
                                                AND DATE_ADD(
                                                    STR_TO_DATE(NULLIF(date_time,''), '%Y-%m-%d %H:%i:%s'),
                                                    INTERVAL hours_per_day MINUTE
                                                ) > ''
                                            )

                                            OR

                                            -- SCHEDULE booking (safe datetime)
                                            (
                                                type = 'schedule'
                                                AND STR_TO_DATE(
                                                    CONCAT(NULLIF(schedule_date,''),' ',NULLIF(schedule_time,'')),
                                                    '%Y-%m-%d %H:%i:%s'
                                                ) IS NOT NULL
                                                AND STR_TO_DATE(
                                                    CONCAT(NULLIF(schedule_date,''),' ',NULLIF(schedule_time,'')),
                                                    '%Y-%m-%d %H:%i:%s'
                                                ) < ''
                                                AND DATE_ADD(
                                                    STR_TO_DATE(
                                                        CONCAT(NULLIF(schedule_date,''),' ',NULLIF(schedule_time,'')),
                                                        '%Y-%m-%d %H:%i:%s'
                                                    ),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )
                                        )
                                    )

                                    -- 2️⃣ Not pre-assigned
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- 3️⃣ Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:39:15
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:38:16
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:37:16
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKINGS (check only when both schedule date/time exist)
                                            (
                                                type = 'schedule'
                                                AND schedule_date IS NOT NULL AND schedule_date != ''
                                                AND schedule_time IS NOT NULL AND schedule_time != ''
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                    CONCAT(schedule_date, ' ', schedule_time),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:36:17
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKINGS (check only when both schedule date/time exist)
                                            (
                                                type = 'schedule'
                                                AND schedule_date IS NOT NULL AND schedule_date != ''
                                                AND schedule_time IS NOT NULL AND schedule_time != ''
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                    CONCAT(schedule_date, ' ', schedule_time),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:35:15
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKINGS (check only when both schedule date/time exist)
                                            (
                                                type = 'schedule'
                                                AND schedule_date IS NOT NULL AND schedule_date != ''
                                                AND schedule_time IS NOT NULL AND schedule_time != ''
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                    CONCAT(schedule_date, ' ', schedule_time),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:34:16
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKINGS (check only when both schedule date/time exist)
                                            (
                                                type = 'schedule'
                                                AND schedule_date IS NOT NULL AND schedule_date != ''
                                                AND schedule_time IS NOT NULL AND schedule_time != ''
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                    CONCAT(schedule_date, ' ', schedule_time),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:33:13
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started', 'Requested', 'Schedule')

                                        AND (

                                            -- NORMAL BOOKINGS (only check if date_time is valid)
                                            (
                                                type = 'normal'
                                                AND date_time IS NOT NULL
                                                AND date_time != ''
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKINGS (check only when both schedule date/time exist)
                                            (
                                                type = 'schedule'
                                                AND schedule_date IS NOT NULL AND schedule_date != ''
                                                AND schedule_time IS NOT NULL AND schedule_time != ''
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                    CONCAT(schedule_date, ' ', schedule_time),
                                                    INTERVAL hours_per_day * 60 MINUTE
                                                ) > ''
                                            )

                                        )
                                    )



                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:32:13
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started')

                                        AND (

                                            -- NORMAL BOOKING OVERLAP
                                            (
                                                type = 'normal'
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKING OVERLAP
                                            (
                                                type = 'schedule'
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                        CONCAT(schedule_date, ' ', schedule_time),
                                                        INTERVAL hours_per_day * 60 MINUTE
                                                    ) > ''
                                            )

                                        )
                                    )


                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:29:11
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started')

                                        AND (

                                            -- NORMAL BOOKING OVERLAP
                                            (
                                                type = 'normal'
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKING OVERLAP
                                            (
                                                type = 'schedule'
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                        CONCAT(schedule_date, ' ', schedule_time),
                                                        INTERVAL hours_per_day * 60 MINUTE
                                                    ) > ''
                                            )

                                        )
                                    )


                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1

Time : 10:28:10
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
Raw SQL : SELECT 
                                    h.*,
                                    (
                                        111.111 * DEGREES(
                                            acos(
                                                cos(radians(31.1075588)) 
                                                * cos(radians(h.latitude))
                                                * cos(radians(h.longitude) - radians(77.1959622))
                                                + sin(radians(31.1075588))
                                                * sin(radians(h.latitude))
                                            )
                                        )
                                    ) AS distance  
                                FROM rt_service_providers h
                                WHERE 
                                    h.status = 1
                                    -- AND (FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6' OR FIND_IN_SET(6, sub_category_id) OR sub_category_id = '6')
                                    AND h.amount > 0
                                    
                                    -- Allowed booking categories
                                    AND (
                                        FIND_IN_SET(1, h.category_id)
                                        OR FIND_IN_SET(20, h.category_id)
                                        OR FIND_IN_SET(8, h.category_id)
                                        OR FIND_IN_SET(17, h.category_id)
                                        OR FIND_IN_SET(2, h.category_id)
                                    )

                                    AND h.id NOT IN (
                                        SELECT provider_id 
                                        FROM rt_booking_on_the_go
                                        WHERE booking_status IN ('Accepted', 'Started')

                                        AND (

                                            -- NORMAL BOOKING OVERLAP
                                            (
                                                type = 'normal'
                                                AND date_time < ''
                                                AND DATE_ADD(date_time, INTERVAL hours_per_day MINUTE) > ''
                                            )

                                            OR

                                            -- SCHEDULE BOOKING OVERLAP
                                            (
                                                type = 'schedule'
                                                AND CONCAT(schedule_date, ' ', schedule_time) < ''
                                                AND DATE_ADD(
                                                        CONCAT(schedule_date, ' ', schedule_time),
                                                        INTERVAL hours_per_day * 60 MINUTE
                                                    ) > ''
                                            )

                                        )
                                    )


                                    -- 2️⃣ Helper is NOT already pre-assigned to any active booking
                                    AND h.id NOT IN (
                                        SELECT pah.provider_id
                                        FROM pre_assigned_helper pah
                                        JOIN rt_booking_on_the_go b 
                                            ON b.booking_app_id = pah.booking_app_id
                                        WHERE b.booking_status IN ('Requested', 'Schedule')
                                    )

                                    -- Availability filters
                                    AND h.deactivate_account = 0
                                    AND h.last_seen >= NOW() - INTERVAL 96 HOUR
                                    AND h.latitude IS NOT NULL
                                    AND h.longitude IS NOT NULL
                                    AND h.category_id <> ''
                                    AND h.last_seen IS NOT NULL

                                ORDER BY distance ASC, h.last_seen DESC
                                LIMIT 1