CREATE TABLE wp_reef_contacts (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
email VARCHAR(190) NOT NULL,
full_name VARCHAR(190) NOT NULL,
stage VARCHAR(32) NOT NULL DEFAULT 'lead',
source VARCHAR(64) NULL,
owner_id BIGINT UNSIGNED NULL,
created_at DATETIME NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY uq_email (email),
KEY idx_stage_created (stage, created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
SELECT id FROM wp_reef_contacts
WHERE stage = 'lead' AND created_at >= '2026-10-01';