connected <br> sfa_source_connDB Connected<br/>---- t2 Droped 2025-12-06 10:34:46drop table if exists t2<br/>---- End Time ---2025-12-06 10:34:47<br>--affected rows--0<br/>---- t2 Created 2025-12-06 10:34:47create table t2
select products.division, products.productcode, products.productcode as sa_prod_code, products.productname,productbrandtype.productbrandtype as  brand_name, '' as range_name, products.productbrandtype as productbrandid, 
0000000000 as productsubbrandid, 0 as flag, products.productid as productid
from products
INNER JOIN productbrandtype on productbrandtype.productbrandtypeid = products.productbrandtype
where productcategory='R'
group by products.division, products.productcode<br/>---- End Time ---2025-12-06 10:34:49<br>--affected rows--826<br/>---- productbrand Insert 2025-12-06 10:34:49insert into productbrand
select productbrandid, division as divisionid, brand_name as productbrand, '' as brandtype, 0 as deleted, '0000-00-00' as deleted_date, now() as created_date
from t2
where t2.productbrandid not in (select productbrand.productbrandid from productbrand where deleted=0)
GROUP BY t2.productbrandid<br/>---- End Time ---2025-12-06 10:34:49<br>--affected rows--0<br/>---- End Time ---2025-12-06 10:34:49<br>--affected rows--0<br/>---- product_master update 2025-12-06 10:34:49insert into products_master
(productid,productsubbrandid,divisionid,productcode,productname,productcategory,deleted,deleted_date,created_date,productbrandid,sa_prod_code)
select productid, productsubbrandid, division as divisionid,productcode,productname,'R' as productcategory,
0 as deleted, '0000-00-00' as deleted_date, '0000-00-00' as created_date, productbrandid,sa_prod_code
from t2
where flag = 0 and t2.productid not in (select products_master.productid from products_master where deleted=0)<br/>---- End Time ---2025-12-06 10:34:49<br>--affected rows--0<br/>---- brandname update 2025-12-06 10:34:49update productbrand,productbrandtype
set productbrand.productbrand = productbrandtype.productbrandtype
where productbrand.productbrandid = productbrandtype.productbrandtypeid<br/>---- End Time ---2025-12-06 10:34:49<br>--affected rows--0<br/>---- productname update 2025-12-06 10:34:49update t2,products_master
set products_master.productname = t2.productname
where t2.productid = products_master.productid and flag=0 and products_master.deleted=0<br/>---- End Time ---2025-12-06 10:34:49<br>--affected rows--0-----------------------------------------------------------------INSERT INTO Cron_Records (Cron_name, Start_time, End_time, Execution_time, Date) VALUES ('products_upload','10:34:46','10:34:49','00:00:03','2025-12-06');<br>--affected rows--1<br> <b> CRON EXECUTED SUCCESSFULLY </b><br/>---- End Time ---2025-12-06 10:34:50<br>--affected rows--1