The example is based on the use of segments created earlier. You can also create the same segment by directly querying the dedicated optin table.
Here the contact must be in "Activated & promo mails" AND in "Newsletter optin". Putting the segments in the same filter would have resulted in an OR, see example above.
