SET @users_id = 33258;
SET @custom_name = 'Old'; 
SET @custom_value = 'Yes'; 


INSERT IGNORE INTO `customs` (`users_id`, `name`, `what`, `type`, `is_defined`, `is_required`, `is_hidden`) VALUES (@users_id, @custom_name, 'string', 'text', 'no', 'no', 'no'); 
SELECT `id` INTO @customs_id FROM `customs` WHERE `name` = @custom_name AND `users_id` = @users_id; 

INSERT IGNORE INTO `custom_values` (`customs_id`, `value`) VALUES (@customs_id, @custom_value); 

SELECT `id` INTO @value_id FROM `custom_values` WHERE `customs_id` = @customs_id AND `value` = @custom_value; 
INSERT INTO `custom_values_subscribers` (`custom_values_id`, `subscribers_id`) SELECT @value_id,s.`id` FROM `subscribers` s join campaigns c on s.`campaigns_id` = c.id

LEFT JOIN `subscriber_activity_opens` sao ON s.`id` = sao.`subscribers_id`
LEFT JOIN subscriber_activity_clicks sac on s.id = sac.subscribers_id

WHERE  c.users_id = @users_id and s.id <= '170969649'  
group by 2 having (max(sao.created_on) <= '2012-01-01' or max(sao.created_on) is Null) and (max(sac.created_on) <= '2012-01-01' or max(sac.created_on) is Null)