[2026-04-11 07:30:22] production.INFO: Query error in WESTCOUNTRY. Error is: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'undefined' in 'on clause' (SQL: select JSON_MERGE(jd_jobcustomoizedkeyvalue,jd_deletedcustokeyvalue) AS customoizedarray, `jd_customerid` as `customerid`, `jd_contactid` as `contactid`, `jd_id` as `id`, `jd_jobref` as `orderid`, `jd_createddate` as `createddate`, `jd_orderdate` as `orderdate`, `jd_invoicedate` as `invoicedate`, `jd_completeddate` as `completeddate`, `jd_seq` as `seq`, `jd_status` as `status`, `jd_contactaddid` as `contactaddressid`, `jd_templateid` as `templateid`, `jd_createdby` as `createdby`, `jd_accref` as `accref`, IF(jd_invoiceno=0,"",jd_invoiceno) AS invoiceno, `jd_accref` as `accref`, `jd_orderstatus` as `orderstatus`, `jd_jobstatus` as `jobstatus`, `defaultsalestaxlabel`, `organization_id` as `organizationid`, `jmq_id` as `pivotId`, `jmq_duedate` as `duedate`, `jmq_sceduleddate` as `sceduleddate`, `jmq_listprice` as `listprice`, `jmq_netprice` as `netprice`, `jmq_vat` as `vat`, `jmq_isvaton` as `isvaton`, `jmq_deliverycost` as `deliverycost`, `jmq_deliverycosttypeid` as `deliverycosttypeid`, `jmq_deliverycostid` as `deliverycostid`, `jmq_overridetypeid` as `orderformtypeid`, `jmq_orderformprice` as `orderformprice`, `jmq_editpricebyid` as `editpricebyid`, `jmq_isroundon` as `isroundon`, `jmq_grossprice` as `grossprice`, `jmq_grossprofit` as `grossprofit`, `jmq_costprice` as `totcostprice`, `jmq_amountoutstanding` as `amountoutstanding`, `jmq_totpaid` as `totpaid`, `jmq_creditlimit` as `creditlimit`, `jmq_creditbalance` as `creditbalance`, `jmq_overdue` as `overdue`, `jmq_userdefinedarray` as `userdefinedarray`, `jmq_overrideprice` as `overrideprice`, `jmq_overridenetprice` as `overridenetprice`, `jmq_overridevatprice` as `overridevatprice`, `jmq_overridegrossprice` as `overridegrossprice`, `jmq_iscostpriceon` as `iscostpriceon`, `jmq_isonlineorder` as `isonlineorder`, `jmq_isonlineordersubmitted` as `submittedjob`, `jmq_endcustomervatprice` as `endcustomervatprice`, `jmq_endcustomeroverridetype` as `endcustomeroverridetype`, `jmq_endcustomeroverridevalue` as `endcustomeroverridevalue`, `jmq_endcustomeroverridenetprice` as `endcustomeroverridenetprice`, `jmq_endcustomeroverridevatprice` as `endcustomeroverridevatprice`, `jmq_endcustomeroverridegrossprice` as `endcustomeroverridegrossprice`, `jmq_endcustomerdeliverycost` as `endcustomerdeliverycost`, `jmq_endcustomerdeliverycostinclvat` as `endcustomerdeliverycostinclvat`, `jmq_endcustomerfittingcost` as `endcustomerfittingcost`, `jmq_endcustomerfittingcostinclvat` as `endcustomerfittingcostinclvat`, `jmq_commissionaddedvalue` as `commissionaddedvalue `, `jmq_onlinedeliveryaddreddtype` as `onlinedeliveryaddreddtype`, IF(jmq_overridetypeid=5,jmq_overrideprice,IF(jmq_overridetypeid=4,(jmq_listprice * jmq_overrideprice)/100,0)) AS discamt, `jmq_grossprofit_percentage` as `grossprofitpercentage` from `bm_jobdetails` inner join `bm_jobmultiquote` on `jmq_jobid` = undefined left join `bm_organizationdetails` on `organization_id` = JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.33')) where `jd_id` = undefined and `jd_status` = 0 and `jmq_id` = undefined)  
[2026-04-11 08:46:01] production.INFO: Query error in WESTCOUNTRY. Error is: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'undefined' in 'on clause' (SQL: select JSON_MERGE(jd_jobcustomoizedkeyvalue,jd_deletedcustokeyvalue) AS customoizedarray, `jd_customerid` as `customerid`, `jd_contactid` as `contactid`, `jd_id` as `id`, `jd_jobref` as `orderid`, `jd_createddate` as `createddate`, `jd_orderdate` as `orderdate`, `jd_invoicedate` as `invoicedate`, `jd_completeddate` as `completeddate`, `jd_seq` as `seq`, `jd_status` as `status`, `jd_contactaddid` as `contactaddressid`, `jd_templateid` as `templateid`, `jd_createdby` as `createdby`, `jd_accref` as `accref`, IF(jd_invoiceno=0,"",jd_invoiceno) AS invoiceno, `jd_accref` as `accref`, `jd_orderstatus` as `orderstatus`, `jd_jobstatus` as `jobstatus`, `defaultsalestaxlabel`, `organization_id` as `organizationid`, `jmq_id` as `pivotId`, `jmq_duedate` as `duedate`, `jmq_sceduleddate` as `sceduleddate`, `jmq_listprice` as `listprice`, `jmq_netprice` as `netprice`, `jmq_vat` as `vat`, `jmq_isvaton` as `isvaton`, `jmq_deliverycost` as `deliverycost`, `jmq_deliverycosttypeid` as `deliverycosttypeid`, `jmq_deliverycostid` as `deliverycostid`, `jmq_overridetypeid` as `orderformtypeid`, `jmq_orderformprice` as `orderformprice`, `jmq_editpricebyid` as `editpricebyid`, `jmq_isroundon` as `isroundon`, `jmq_grossprice` as `grossprice`, `jmq_grossprofit` as `grossprofit`, `jmq_costprice` as `totcostprice`, `jmq_amountoutstanding` as `amountoutstanding`, `jmq_totpaid` as `totpaid`, `jmq_creditlimit` as `creditlimit`, `jmq_creditbalance` as `creditbalance`, `jmq_overdue` as `overdue`, `jmq_userdefinedarray` as `userdefinedarray`, `jmq_overrideprice` as `overrideprice`, `jmq_overridenetprice` as `overridenetprice`, `jmq_overridevatprice` as `overridevatprice`, `jmq_overridegrossprice` as `overridegrossprice`, `jmq_iscostpriceon` as `iscostpriceon`, `jmq_isonlineorder` as `isonlineorder`, `jmq_isonlineordersubmitted` as `submittedjob`, `jmq_endcustomervatprice` as `endcustomervatprice`, `jmq_endcustomeroverridetype` as `endcustomeroverridetype`, `jmq_endcustomeroverridevalue` as `endcustomeroverridevalue`, `jmq_endcustomeroverridenetprice` as `endcustomeroverridenetprice`, `jmq_endcustomeroverridevatprice` as `endcustomeroverridevatprice`, `jmq_endcustomeroverridegrossprice` as `endcustomeroverridegrossprice`, `jmq_endcustomerdeliverycost` as `endcustomerdeliverycost`, `jmq_endcustomerdeliverycostinclvat` as `endcustomerdeliverycostinclvat`, `jmq_endcustomerfittingcost` as `endcustomerfittingcost`, `jmq_endcustomerfittingcostinclvat` as `endcustomerfittingcostinclvat`, `jmq_commissionaddedvalue` as `commissionaddedvalue `, `jmq_onlinedeliveryaddreddtype` as `onlinedeliveryaddreddtype`, IF(jmq_overridetypeid=5,jmq_overrideprice,IF(jmq_overridetypeid=4,(jmq_listprice * jmq_overrideprice)/100,0)) AS discamt, `jmq_grossprofit_percentage` as `grossprofitpercentage` from `bm_jobdetails` inner join `bm_jobmultiquote` on `jmq_jobid` = undefined left join `bm_organizationdetails` on `organization_id` = JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.33')) where `jd_id` = undefined and `jd_status` = 0 and `jmq_id` = undefined)  
[2026-04-11 12:01:19] production.INFO: Query error in SOLIHULL. Error is: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%joeo'connor%' o...' at line 1 (SQL: select `bm_appointment`.*, concat(app_recurrencerule, COALESCE(concat("EXDATE=",app_recurrenceexception),"")) as app_recurrencerule, `app_sdatetime`, `app_sdate`, `app_stime`, `app_eventid`, `app_timezone`, `bm_appointmenttype`.`apptypename`, `jd_jobref`, `username`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))) AS `name`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.51')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.52')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.53')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.54')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.47')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.286'))) AS `address`, `jd_jobmultiquoteid` as `pivotId` from `bm_appointment` left join `bm_jobdetails` on `app_orderId` = `jd_id` and `jd_status` = 0 inner join `bm_appointmenttype` on `apptypeid` = `app_appointmentType` and `app_status` = 0 inner join `bm_users` on `userid` = `app_userId` and `bm_users`.`status` = 0 left join `bm_common_dropdown_list` on `dropdown_id` = `app_cal_status` and `dropdown_status` = 0 left join `bm_salessource` on JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.39')) = `ss_id` and `ss_status` = 0 where `bm_appointmenttype`.`status` = 0 and (replace(apptypename,' ', '') LIKE '%joeo'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%joeo'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))),' ', '') LIKE '%joeo'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50'))),' ', '') LIKE '%joeo'connor%' or replace(jd_jobref,' ', '') LIKE '%joeo'connor%' or replace(app_products,' ', '') LIKE '%joeo'connor%' or replace(username,' ', '') LIKE '%joeo'connor%' or replace(dropdown_displayname,' ', '') LIKE '%joeo'connor%' or replace(ss_sourcename,' ', '') LIKE '%joeo'connor%' or replace(app_sdate,' ', '') LIKE '%joeo'connor%' or replace(app_edate,' ', '') LIKE '%joeo'connor%' or replace(app_description,' ', '') LIKE '%joeo'connor%') group by `app_eventid` order by `app_sdate` desc, `app_stime` desc)  
[2026-04-11 12:01:22] production.INFO: Query error in SOLIHULL. Error is: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%o'connor%' or r...' at line 1 (SQL: select `bm_appointment`.*, concat(app_recurrencerule, COALESCE(concat("EXDATE=",app_recurrenceexception),"")) as app_recurrencerule, `app_sdatetime`, `app_sdate`, `app_stime`, `app_eventid`, `app_timezone`, `bm_appointmenttype`.`apptypename`, `jd_jobref`, `username`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))) AS `name`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.51')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.52')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.53')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.54')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.47')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.286'))) AS `address`, `jd_jobmultiquoteid` as `pivotId` from `bm_appointment` left join `bm_jobdetails` on `app_orderId` = `jd_id` and `jd_status` = 0 inner join `bm_appointmenttype` on `apptypeid` = `app_appointmentType` and `app_status` = 0 inner join `bm_users` on `userid` = `app_userId` and `bm_users`.`status` = 0 left join `bm_common_dropdown_list` on `dropdown_id` = `app_cal_status` and `dropdown_status` = 0 left join `bm_salessource` on JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.39')) = `ss_id` and `ss_status` = 0 where `bm_appointmenttype`.`status` = 0 and (replace(apptypename,' ', '') LIKE '%o'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%o'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))),' ', '') LIKE '%o'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50'))),' ', '') LIKE '%o'connor%' or replace(jd_jobref,' ', '') LIKE '%o'connor%' or replace(app_products,' ', '') LIKE '%o'connor%' or replace(username,' ', '') LIKE '%o'connor%' or replace(dropdown_displayname,' ', '') LIKE '%o'connor%' or replace(ss_sourcename,' ', '') LIKE '%o'connor%' or replace(app_sdate,' ', '') LIKE '%o'connor%' or replace(app_edate,' ', '') LIKE '%o'connor%' or replace(app_description,' ', '') LIKE '%o'connor%') group by `app_eventid` order by `app_sdate` desc, `app_stime` desc)  
[2026-04-11 12:01:33] production.INFO: Query error in SOLIHULL. Error is: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%joeo'connor%' o...' at line 1 (SQL: select `bm_appointment`.*, concat(app_recurrencerule, COALESCE(concat("EXDATE=",app_recurrenceexception),"")) as app_recurrencerule, `app_sdatetime`, `app_sdate`, `app_stime`, `app_eventid`, `app_timezone`, `bm_appointmenttype`.`apptypename`, `jd_jobref`, `username`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))) AS `name`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.51')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.52')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.53')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.54')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.47')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.286'))) AS `address`, `jd_jobmultiquoteid` as `pivotId` from `bm_appointment` left join `bm_jobdetails` on `app_orderId` = `jd_id` and `jd_status` = 0 inner join `bm_appointmenttype` on `apptypeid` = `app_appointmentType` and `app_status` = 0 inner join `bm_users` on `userid` = `app_userId` and `bm_users`.`status` = 0 left join `bm_common_dropdown_list` on `dropdown_id` = `app_cal_status` and `dropdown_status` = 0 left join `bm_salessource` on JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.39')) = `ss_id` and `ss_status` = 0 where `bm_appointmenttype`.`status` = 0 and (replace(apptypename,' ', '') LIKE '%joeo'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%joeo'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))),' ', '') LIKE '%joeo'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50'))),' ', '') LIKE '%joeo'connor%' or replace(jd_jobref,' ', '') LIKE '%joeo'connor%' or replace(app_products,' ', '') LIKE '%joeo'connor%' or replace(username,' ', '') LIKE '%joeo'connor%' or replace(dropdown_displayname,' ', '') LIKE '%joeo'connor%' or replace(ss_sourcename,' ', '') LIKE '%joeo'connor%' or replace(app_sdate,' ', '') LIKE '%joeo'connor%' or replace(app_edate,' ', '') LIKE '%joeo'connor%' or replace(app_description,' ', '') LIKE '%joeo'connor%') group by `app_eventid` order by `app_sdate` desc, `app_stime` desc)  
[2026-04-11 12:01:36] production.INFO: Query error in SOLIHULL. Error is: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%o'connor%' or r...' at line 1 (SQL: select `bm_appointment`.*, concat(app_recurrencerule, COALESCE(concat("EXDATE=",app_recurrenceexception),"")) as app_recurrencerule, `app_sdatetime`, `app_sdate`, `app_stime`, `app_eventid`, `app_timezone`, `bm_appointmenttype`.`apptypename`, `jd_jobref`, `username`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))) AS `name`, concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.44')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.51')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.52')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.53')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.54')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.47')), ' ', JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.286'))) AS `address`, `jd_jobmultiquoteid` as `pivotId` from `bm_appointment` left join `bm_jobdetails` on `app_orderId` = `jd_id` and `jd_status` = 0 inner join `bm_appointmenttype` on `apptypeid` = `app_appointmentType` and `app_status` = 0 inner join `bm_users` on `userid` = `app_userId` and `bm_users`.`status` = 0 left join `bm_common_dropdown_list` on `dropdown_id` = `app_cal_status` and `dropdown_status` = 0 left join `bm_salessource` on JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.39')) = `ss_id` and `ss_status` = 0 where `bm_appointmenttype`.`status` = 0 and (replace(apptypename,' ', '') LIKE '%o'connor%' or replace(jd_jobcustomoizedkeyvalue,' ', '') LIKE '%o'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.45')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.46'))),' ', '') LIKE '%o'connor%' or replace(concat(JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.49')), JSON_UNQUOTE(JSON_EXTRACT(jd_jobcustomoizedkeyvalue,'$.50'))),' ', '') LIKE '%o'connor%' or replace(jd_jobref,' ', '') LIKE '%o'connor%' or replace(app_products,' ', '') LIKE '%o'connor%' or replace(username,' ', '') LIKE '%o'connor%' or replace(dropdown_displayname,' ', '') LIKE '%o'connor%' or replace(ss_sourcename,' ', '') LIKE '%o'connor%' or replace(app_sdate,' ', '') LIKE '%o'connor%' or replace(app_edate,' ', '') LIKE '%o'connor%' or replace(app_description,' ', '') LIKE '%o'connor%') group by `app_eventid` order by `app_sdate` desc, `app_stime` desc)