#!/bin/bash
echo "== vultr emails (subject/from/date/to) =="
mysql -N -e "SELECT id, LEFT(\`from\`,60), LEFT(\`to\`,60), subject, created_at FROM radius.email_conversations WHERE \`from\` LIKE '%vultr%' OR subject LIKE '%Vultr%' OR body LIKE '%vultr%' ORDER BY id;" 
echo
echo "== full body of a couple =="
mysql -N -e "SELECT id, subject, LEFT(body,1500) FROM radius.email_conversations WHERE subject LIKE '%Vultr%' OR subject LIKE '%vultr%' ORDER BY id LIMIT 8;" 
echo "== any account/billing/2fa/password in vultr bodies =="
mysql -N -e "SELECT id, subject, LEFT(body,800) FROM radius.email_conversations WHERE body LIKE '%vultr%' AND (body LIKE '%API%' OR body LIKE '%password%' OR body LIKE '%billing%' OR body LIKE '%login%' OR body LIKE '%2FA%' OR body LIKE '%verify%');"
