[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:14:02] production.INFO: Query error in MYSHUTTERSANDBLINDS. Error is: SQLSTATE[HY000] [1049] Unknown database 'MYSHUTTERSANDBLINDS' (SQL: select * from `bm_users` where `bm_users`.`userid` = 14 limit 1)  
[2026-04-21 06:24:31] 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-21 06:42:48] production.INFO: Query error in LLOYDSBLINDS. 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-21 07:29:38] 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-21 07:30:00] 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-21 07:55:35] production.INFO: Query error in CHANNELBLINDS. 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-21 08:04:33] production.INFO: Query error in LLOYDSBLINDS. 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-21 08:10:58] production.INFO: Query error in LLOYDSBLINDS. 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-21 08:41:54] production.INFO: Query error in LLOYDSBLINDS. 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-21 08:58:53] 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-21 09:11:20] production.INFO: Query error in LLOYDSBLINDS. 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-21 09:20:57] production.INFO: Query error in CHANNELBLINDS. 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-21 09:40:01] production.INFO: Query error in LLOYDSBLINDS. 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-21 09:43:24] production.INFO: Query error in LLOYDSBLINDS. 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-21 10:08:15] 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-21 11:28:39] production.INFO: Query error in LLOYDSBLINDS. 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-21 11:44:59] production.INFO: Query error in MASTER. Error is: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Unit Type' in 'order clause' (SQL: select `fol_fieldOptionLinkId` as `id`, `op_customisedformdata`, `fi_fieldName` as `Field Name`, `fi_fieldCode` as `Field Code`, `fi_fieldId` as `fieldid`, `ft_availableforrecipe` as `availableforrecipe`, `fol_metatitle` as `metatitle`, `fol_metadescription` as `metadescription`, `fol_metakeywords` as `metakeyword`, `fol_canonicalurl` as `canonicalurl`, `fol_alttext` as `alttext`, `fol_headertagsection` as `headertagsection`, `op_optionType` as `pricingtype`, `op_optionId` as `optionid`, `op_hasprice` as `hasprice`, `op_availableForJob` as `jobitem`, `op_availableForEcommerce` as `ecommerce`, `op_availableForCustomerPortal` as `onlineportal`, `op_filterbycontacttype` as `filtertype`, `op_filterbypricegroup` as `filterpricegroup`, `op_filterbysupplier` as `filtersupplier`, `op_filterbyshuttertype` as `filtershutter`, `op_filterbyshuttersupplier` as `filtersupplier`, `op_filterbyminmax` as `minmax`, `op_customerType` as `customerType`, `fi_fieldType` as `fieldtype`, `fi_fieldId` as `fieldId`, `fi_fieldLevel` as `fieldlevel`, '1' as 'type', '0' as 'optionparentid', JSON_VALUE(IFNULL(pcomm.pcomm_data,'{}'), '$.463') AS `Max Drop`, JSON_VALUE(IFNULL(pcomm.pcomm_data,'{}'), '$.461') AS `Max Width`, JSON_VALUE(IFNULL(pcomm.pcomm_data,'{}'), '$.462') AS `Min Drop`, JSON_VALUE(IFNULL(pcomm.pcomm_data,'{}'), '$.460') AS `Min Width`, JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.96'))  AS `Option Code`, JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.94'))  AS `list_option_name`, JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.94'))  AS `Option Name`, (CASE WHEN JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.433'))='' THEN 1 ELSE
                        JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.433')) END)  AS   'Option Qty' , (select `pt_typename` from `bm_pricingtype` where `pt_status` = 0 and `pt_id` = JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.127'))) as `Pricing Type`, JSON_UNQUOTE(JSON_EXTRACT(REPLACE(REPLACE(REPLACE(op_customisedformdata, '\r\n', ''), '\n', ''), '\r', ''),'$.102'))  AS `Unit Cost`, CASE 
                            WHEN op_availableForJob = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Job Item`, CASE 
                            WHEN op_availableForCustomerPortal = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Online Portal`, CASE 
                            WHEN op_availableForEcommerce  = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Ecommercesite`, CASE 
                            WHEN op_filterbycontacttype  = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Account Type`, CASE 
                            WHEN op_filterbypricegroup  = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Price Group`, CASE 
                            WHEN op_filterbysupplier  = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Price Table Supplier`, CASE 
                            WHEN op_filterbyminmax  = 1 THEN 'Yes' 
                            ELSE 'No' 
                            END AS `Min,Max`, IF(JSON_UNQUOTE(JSON_EXTRACT(op_customerType, '$.1')) = 'true', 'Yes', 'No') AS `Domestic`, IF(JSON_UNQUOTE(JSON_EXTRACT(op_customerType, '$.2')) = 'true', 'Yes', 'No') AS `Contract`, IF(JSON_UNQUOTE(JSON_EXTRACT(op_customerType, '$.3')) = 'true', 'Yes', 'No') AS `Trade`, IF(JSON_UNQUOTE(JSON_EXTRACT(op_customerType, '$.4')) = 'true', 'Yes', 'No') AS `ECommerce` from `bm_fieldOptionLink` inner join `bm_option` on `op_optionId` = `fol_optionId` and `op_active` = 0 and `op_status` = 0 inner join `bm_fields` on `fol_fieldId` = `fi_fieldid` and `fi_fieldType` = 3 and `fi_active` = 0 inner join `bm_fieldtypes` on `ft_id` = `fi_fieldType` and `ft_status` = 0 left join `bm_product_wise_color_option_min_max` as `pcomm` on `pcomm`.`pcomm_option_id` = `op_optionId` and `pcomm`.`pcomm_product_id` = 142 and `pcomm`.`pcomm_status` = 0 where `fol_productId` = 142 and `fol_linkType` = 1 and `op_fieldTypeId` = 3 and `fi_status` = 0 and `fol_status` = 0 order by `Unit Type` asc)  
[2026-04-21 12:16:39] production.INFO: Query error in PERFECTBLINDSUK. 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-21 13:59:03] production.INFO: Query error in PERFECTBLINDSUK. 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-21 14:57:56] production.INFO: Query error in PERFECTBLINDSUK. 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-21 15:29:35] 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-21 15:42:03] 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)