Single Unit Front Load LG WashTower™ with Center Control™ 4.5 cu. ft. Washer and 7.4 cu. ft. Gas Dryer

LG ThinQ Care Warranty Promo

Purchase a qualifying LG product and register it through ThinQ app to receive a free 1 Year Extension on Manufacturer Warranty, valued up to $185

Valid from 07/11/2024 to 12/31/2024

SELECT LOWER(CONCAT(REPLACE(REPLACE(Brand_Data.CommonBrandName,' ','-'),'&','-'),'-',REPLACE(REPLACE(REPLACE(Rebates.PromotionName,'/','-'),' ','-'),'\'',''),'/',pbm.pkPromotion)) AS RebateLink, Brand_Data.CommonBrandName AS CommonBrandName from Rebates INNER JOIN PromotionsByModel AS pbm ON pbm.PromotionName = Rebates.PromotionName INNER JOIN Brand_Data on Brand_Data.CommonBrandName = Rebates.CommonBrandName INNER JOIN tbl_products AS pb ON pb.ProductKey = pbm.SKU WHERE pbm.EffectiveDate <= CURDATE() and pbm.ExpirationDate >= CURDATE() and Filename <> '' AND Rebates.pkID = ? GROUP BY Rebates.PromotionName, Rebates.PromotionDescription, Brand_Data.CommonBrandName UNION ALL (SELECT LOWER(CONCAT(REPLACE(REPLACE(pb.CommonBrandName,' ','-'),'&','-'),'-',REPLACE(REPLACE(REPLACE(Rebates.PromotionName,' ','-'),'\'',''),'&',''),'/',pkRebates)) AS RebateLink ,pb.CommonBrandName AS CommonBrandName from Rebates INNER JOIN rebatesbymodel AS pbm ON pbm.pkRebates = Rebates.pkID INNER JOIN tbl_products AS pb ON pb.pkID = pbm.pkProduct WHERE Rebates.EffectiveDate <= CURDATE() and Rebates.ExpirationDate >= CURDATE() and Filename <> '' AND pbm.pkRebates = ? GROUP BY Rebates.PromotionName, Rebates.PromotionDescription, pb.CommonBrandName) ORDER BY CommonBrandName

Query execution was interrupted

Commands out of sync; you can't run this command now