(EMAIL) PromoNinja ping - to be sent 12.02

ecommerceberlin / exhibitors

account-nextgen.vercel.app

MIT License

0 stars 1 forks source link

(EMAIL) PromoNinja ping - to be sent 12.02 #193

Closed KarolinaTEH closed 9 months ago

KarolinaTEH commented 9 months ago

information from the ranking (leaders) is going to be included in the content, so I'll update this comment and create PR on 12/02 Subject: EN: Urgent: Final days to use VIP tickets and schedule your meetings! DE: Dringend: Noch ein paar Tage, um VIP-Tickets zu nutzen und Termine zu vereinbaren!

File: to be updated (content for review is available here: https://docs.google.com/document/d/1tmcLf74Elxys1mHxcWcZtCD4fq0ijEo0dklPIzipTeQ/edit)

KarolinaTEH commented 9 months ago

@az can you please let me know which companies are the top 3 distributors of VIP invitations?

az commented 9 months ago

@KarolinaTEH

eventjuicer_company_vipcodes | phpMyAdmin 4 8 3 2024-02-12 10-17-00

az commented 9 months ago

SELECTcompany_id, COUNT(*) AS count FROMeventjuicer_company_vipcodesWHEREevent_id= 100 ANDparticipant_id> 0 GROUP BYcompany_idORDER BYcountDESC

KarolinaTEH commented 9 months ago

File: ebe8-promoninja-warning-en.blade.php ebe8-promoninja-warning-de.blade.php