{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Email': 'VARCHAR(255) NOT NULL', 'Status': 'VARCHAR(32)', 'SubStatus': 'VARCHAR(64)', 'DomainAgeDays': 'VARCHAR(16)', 'FreeEmail': 'VARCHAR(8)', 'MxFound': 'VARCHAR(8)', 'SmtpProvider': 'VARCHAR(128)', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'UpdateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'}
SELECT Email, Status, SubStatus,
DomainAgeDays, FreeEmail,
MxFound, SmtpProvider, UpdateTime
FROM data_zerobounce WHERE Email = '{email}'
AND Package = '{package}'
ORDER BY UpdateTime DESC LIMIT 1
INSERT INTO data_zerobounce
(Guid, Email, Status, SubStatus,
DomainAgeDays, FreeEmail, MxFound,
SmtpProvider, Package, Module)
VALUES
('{guid}', '{email}', '{status}',
'{sub_status}', '{domain_age_days}',
'{free_email}', '{mx_found}',
'{smtp_provider}',
'{package}', 'ObjServiceZeroBounce')
ON DUPLICATE KEY UPDATE
Status = VALUES(Status),
SubStatus = VALUES(SubStatus),
DomainAgeDays = VALUES(DomainAgeDays),
FreeEmail = VALUES(FreeEmail),
MxFound = VALUES(MxFound),
SmtpProvider = VALUES(SmtpProvider)
SELECT Email, Status, SubStatus, UpdateTime FROM data_zerobounce WHERE Package = '{package}' ORDER BY Email
SELECT
Status,
COUNT(*) AS Total
FROM data_zerobounce WHERE Package = '{package}' GROUP BY Status ORDER BY Total DESC