%%[
VAR @category, @product
SET @category = LOOKUP("PurchaseHistory","LastCategory","SubscriberKey",_subscriberkey)
IF @category == "Electronics" THEN
  SET @product = "Premium Laptop Stand - 20% Off"
ELSEIF @category == "Clothing" THEN
  SET @product = "New Season Collection - Free Shipping"
ELSE
  SET @product = "Our Best Sellers This Week"
ENDIF
]%%
<h2>%%=v(@product)=%%</h2>

%%[
VAR @saleEnd, @hoursLeft
SET @saleEnd = "2026-05-20 23:59:59"
SET @hoursLeft = DateDiff(Now(), @saleEnd, "H")
]%%
<p>Hurry! Sale ends in %%=v(@hoursLeft)=%% hours!</p>

%%[
VAR @rows, @row, @i, @productName, @price
SET @rows = LOOKUPROWS("BrowseHistory","SubscriberKey",_subscriberkey)
FOR @i = 1 TO RowCount(@rows) DO
  SET @row = ROW(@rows, @i)
  SET @productName = FIELD(@row,"ProductName")
  SET @price = FIELD(@row,"Price")
]%%
  <tr><td>%%=v(@productName)=%%</td><td>$%%=v(@price)=%%</td></tr>
%%[ NEXT @i ]%%

SELECT 
  p.SubscriberKey,
  p.EmailAddress,
  COUNT(DISTINCT p.PurchaseID) AS PurchaseCount,
  COUNT(DISTINCT o.EventID) AS OpenCount
FROM Purchases p
INNER JOIN _Open o ON p.SubscriberKey = o.SubscriberKey
INNER JOIN _Subscribers s ON p.SubscriberKey = s.SubscriberKey
WHERE 
  p.PurchaseDate >= DATEADD(DAY,-90,GETDATE())
  AND o.EventDate >= DATEADD(DAY,-60,GETDATE())
  AND s.Status = 'Active'
GROUP BY p.SubscriberKey, p.EmailAddress
HAVING 
  COUNT(DISTINCT p.PurchaseID) >= 3
  AND COUNT(DISTINCT o.EventID) >= 5

SELECT s.SubscriberKey, s.EmailAddress
FROM MainSendDE s
WHERE NOT EXISTS (
  SELECT 1 FROM _Sent sent
  WHERE sent.SubscriberKey = s.SubscriberKey
  AND sent.EventDate >= DATEADD(DAY,-7,GETDATE())
)