How to make an email campaign using wordpress?

Question

Email

Can you please tell me which plugin can be used to make an e-mail newsletter based on a ready-made database?
Paid or free plugin, it doesn't matter.
Thanks in advance!

Answer 1

Everything for you: https://ru.wordpress.org/plugins/search/email/
Choose any one you like and use it to your health.

Answer 2

You'd better connect an external smtp service to send emails, because Usually mass sending of mailings on the hosting is blocked.
Proceed as follows:
1) Register in the service https://www.mailgun.com/
2) Set up the domain in the service from which you will send letters.
3) Install the mailgun plugin for wp from the plugin directory https://ru.wordpress.org/plugins/mailgun/ or from the github https://github.com/mailgun/wordpress-plugin .
The plugin allows you to work with mailgun via http api. You can put any other plugin that will work with mailgun via smtp.
4) Do mailings ...
5) PROFIT!!!
ps Any other external smtp or service can be used instead of mailgun.
If you are too lazy to do all of the above, you can write to me in the telegram https://teleg.cc/shifaley , I will help for a small fee.

Answer 3

Make an EXPLAIN request and then see what's wrong.
And at first glance, DISTINCT is superfluous, because ID must be unique (if not, then get the quantity by the primary key).
---
This JOIN is superfluous:
LEFT JOIN `city` `city` ON city.id=product.city_id

Answer 4

LEFT JOINs are not needed - their data is not used anywhere. You can try to move conditions from WHERE to ON.

SELECT COUNT(DISTINCT `p`.`id`)
  FROM `product` AS `p`
  JOIN `product_to_category` AS `p2c` ON `p`.`id` = `p2c`.`product_id`
    AND `p`.`publish` = 1
    AND `p2c`.`category_id` IN (917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950)
  JOIN `city` AS `c` ON `c`.`id` = `p`.`city_id`
    AND (`c`.`id` = 108 OR `c`.`parent_id` = 108)

Well, the correct indexes, here already see EXPLAIN /