Warning: Undefined variable $count in /in/oZNDU on line 113
Warning: Undefined variable $full in /in/oZNDU on line 117
Warning: Undefined variable $full in /in/oZNDU on line 149
SELECT SQL_CALC_FOUND_ROWS
c.*,
con.*,
pur.*,
DATEDIFF(date_received,invoiceDate) as daysTaken,
p.promoName,
p.cnID,
p.ptID,
p.paymentPeriod,
c.cID AS cID,
(SELECT SUM(cashback) FROM claims_redemptions WHERE cID = c.cID AND `status` NOT IN ('invalid','incomplete')) AS `cashback_amount` FROM claims c
LEFT JOIN consumers con ON c.conID = con.conID
LEFT JOIN claims_purchases pur ON c.cID = pur.cID
LEFT JOIN promotions p ON c.pID = p.pID WHERE c.cID IS NOT NULL
AND p.status NOT IN ('hidden') ORDER BY c.cID ASC
Notice: Undefined variable: count in /in/oZNDU on line 113
Notice: Undefined variable: full in /in/oZNDU on line 117
Notice: Undefined variable: full in /in/oZNDU on line 149
SELECT SQL_CALC_FOUND_ROWS
c.*,
con.*,
pur.*,
DATEDIFF(date_received,invoiceDate) as daysTaken,
p.promoName,
p.cnID,
p.ptID,
p.paymentPeriod,
c.cID AS cID,
(SELECT SUM(cashback) FROM claims_redemptions WHERE cID = c.cID AND `status` NOT IN ('invalid','incomplete')) AS `cashback_amount` FROM claims c
LEFT JOIN consumers con ON c.conID = con.conID
LEFT JOIN claims_purchases pur ON c.cID = pur.cID
LEFT JOIN promotions p ON c.pID = p.pID WHERE c.cID IS NOT NULL
AND p.status NOT IN ('hidden') ORDER BY c.cID ASC
Output for 7.3.32 - 7.3.33
SELECT SQL_CALC_FOUND_ROWS
c.*,
con.*,
pur.*,
DATEDIFF(date_received,invoiceDate) as daysTaken,
p.promoName,
p.cnID,
p.ptID,
p.paymentPeriod,
c.cID AS cID,
(SELECT SUM(cashback) FROM claims_redemptions WHERE cID = c.cID AND `status` NOT IN ('invalid','incomplete')) AS `cashback_amount` FROM claims c
LEFT JOIN consumers con ON c.conID = con.conID
LEFT JOIN claims_purchases pur ON c.cID = pur.cID
LEFT JOIN promotions p ON c.pID = p.pID WHERE c.cID IS NOT NULL
AND p.status NOT IN ('hidden') ORDER BY c.cID ASC
Notice: Undefined variable: count in /in/oZNDU on line 114
Notice: Undefined variable: full in /in/oZNDU on line 117
Notice: Undefined variable: full in /in/oZNDU on line 150
SELECT SQL_CALC_FOUND_ROWS
c.*,
con.*,
pur.*,
DATEDIFF(date_received,invoiceDate) as daysTaken,
p.promoName,
p.cnID,
p.ptID,
p.paymentPeriod,
c.cID AS cID,
(SELECT SUM(cashback) FROM claims_redemptions WHERE cID = c.cID AND `status` NOT IN ('invalid','incomplete')) AS `cashback_amount` FROM claims c
LEFT JOIN consumers con ON c.conID = con.conID
LEFT JOIN claims_purchases pur ON c.cID = pur.cID
LEFT JOIN promotions p ON c.pID = p.pID WHERE c.cID IS NOT NULL
AND p.status NOT IN ('hidden') ORDER BY c.cID ASC