[2026-04-18 07:41:33] production.INFO: Query error in BLINDSSHUTTER. 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)