steffen-wirth
1/9/2020 - 1:26 PM
add_all_user_to_newsletter shopware 5
INSERT INTO s_campaigns_mailaddresses(customer, groupID, email, lastmailing, lastread, added, double_optin_confirmed)
SELECT 1,0,email,0,0,CURRENT_TIMESTAMP(),NULL FROM s_userINSERT INTO s_campaigns_mailaddresses(customer, groupID, email, lastmailing, lastread, added, double_optin_confirmed)
SELECT 1,0,email,0,0,CURRENT_TIMESTAMP(),NULL FROM s_user