Aláíróink száma MailPoet2-ben: [abase table=”wp_wysija_user” sql=”SELECT COUNT(*) FROM wp_wysija_user WHERE status=’1′ OR status=’-1′”]
Aláíróink száma MailPoet3-ban: [abase table=”wp_mailpoet_subscribers” sql=”SELECT COUNT(*) FROM wp_mailpoet_subscribers WHERE status != ‘unconfirmed'”]
[abase table=”wp_mailpoet_subscribers” sql=”SELECT s.first_name, (SELECT scf.value from wp_mailpoet_subscriber_custom_field scf WHERE scf.custom_field_id=7 and s.id=scf.subscriber_id) val_7, (SELECT scf.value from wp_mailpoet_subscriber_custom_field scf WHERE scf.custom_field_id=4 and s.id=scf.subscriber_id) val_4, (SELECT scf.value from wp_mailpoet_subscriber_custom_field scf WHERE scf.custom_field_id=5 and s.id=scf.subscriber_id) val_5, (SELECT scf.value from wp_mailpoet_subscriber_custom_field scf WHERE scf.custom_field_id=3 and s.id=scf.subscriber_id) val_3 FROM wp_mailpoet_subscribers s GROUP BY s.id, s.first_name ORDER BY s.id DESC;”]
Ez wpdatatable