Tag: heute minus 9 1/4 Jahre

Anzahl aller Adressen

SELECT * FROM `nladressen`

Anzahl aller NL-Adressen mit relevantem Geburtsdatum (im Berechnungsbereich)

SELECT * FROM `nladressen` WHERE `birthday` > "2015-04-18" ORDER BY `_created` DESC

Abonnenten kamen im letzten Jahr dazu

SELECT * FROM `nladressen` WHERE `createdate` > "2023-07-17" AND `active`= "1"

davon kamen über das Bestell-Formular dazu

SELECT * FROM `nladressen` WHERE `createdate` > "2023-07-17" AND `active`= "1" AND `status`= "110"

Abonnenten bekommen z.Zt. den Newsletter

SELECT * FROM `nladressen` WHERE `birthday` > "2015-04-18" AND `active`= "1" AND (`status` = "110" OR `status` = "100" OR `status` = "4")

davon sind angemeldet und aktiv über Anmeldeformular

SELECT * FROM `nladressen` WHERE `birthday` > "2015-04-18" AND `active`= "1" AND `status`= "110"

davon sind angemeldet und aktiv über manuelle Eingabe AKF

SELECT * FROM `nladressen` WHERE `birthday` > "2015-04-18" AND `active`= "1" AND `status`= "100"

davon sind neu angemeldet - bekommen den passenden Elternbrief mit "Willkommenstext"

SELECT * FROM `nladressen` WHERE `birthday` > "2015-04-18" AND `active`= "1" AND `status`= "4"

wurden im letzten Jahr mit NL-Abmeldung abgemeldet

SELECT * FROM `nladressen` WHERE `updatedate` > "2023-07-17" AND `newsletter`= "0" AND `status`= "5"

wurden im letzten Jahr nicht bestätigt

SELECT * FROM `nladressen` WHERE `createdate` > "2023-07-17" AND `active`= "1" AND `status`= "0"

Alter: 0.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2023-07-18" AND birthday <= "2024-01-16" AND active = "1" AND newsletter = "1"

Alter: 1 Jahre

SELECT * FROM nladressen WHERE birthday >= "2023-01-17" AND birthday <= "2023-07-18" AND active = "1" AND newsletter = "1"

Alter: 1.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2022-07-19" AND birthday <= "2023-01-17" AND active = "1" AND newsletter = "1"

Alter: 2 Jahre

SELECT * FROM nladressen WHERE birthday >= "2022-01-18" AND birthday <= "2022-07-19" AND active = "1" AND newsletter = "1"

Alter: 2.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2021-07-20" AND birthday <= "2022-01-18" AND active = "1" AND newsletter = "1"

Alter: 3 Jahre

SELECT * FROM nladressen WHERE birthday >= "2021-01-19" AND birthday <= "2021-07-20" AND active = "1" AND newsletter = "1"

Alter: 3.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2020-07-21" AND birthday <= "2021-01-19" AND active = "1" AND newsletter = "1"

Alter: 4 Jahre

SELECT * FROM nladressen WHERE birthday >= "2020-01-21" AND birthday <= "2020-07-21" AND active = "1" AND newsletter = "1"

Alter: 4.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2019-07-23" AND birthday <= "2020-01-21" AND active = "1" AND newsletter = "1"

Alter: 5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2019-01-22" AND birthday <= "2019-07-23" AND active = "1" AND newsletter = "1"

Alter: 5.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2018-07-24" AND birthday <= "2019-01-22" AND active = "1" AND newsletter = "1"

Alter: 6 Jahre

SELECT * FROM nladressen WHERE birthday >= "2018-01-23" AND birthday <= "2018-07-24" AND active = "1" AND newsletter = "1"

Alter: 6.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2017-07-25" AND birthday <= "2018-01-23" AND active = "1" AND newsletter = "1"

Alter: 7 Jahre

SELECT * FROM nladressen WHERE birthday >= "2017-01-24" AND birthday <= "2017-07-25" AND active = "1" AND newsletter = "1"

Alter: 7.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2016-07-26" AND birthday <= "2017-01-24" AND active = "1" AND newsletter = "1"

Alter: 8 Jahre

SELECT * FROM nladressen WHERE birthday >= "2016-01-26" AND birthday <= "2016-07-26" AND active = "1" AND newsletter = "1"

Alter: 8.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2015-07-28" AND birthday <= "2016-01-26" AND active = "1" AND newsletter = "1"

Alter: 9 Jahre

SELECT * FROM nladressen WHERE birthday >= "2015-01-27" AND birthday <= "2015-07-28" AND active = "1" AND newsletter = "1"