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-29" ORDER BY `_created` DESC

Abonnenten kamen im letzten Jahr dazu

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

davon kamen über das Bestell-Formular dazu

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

Abonnenten bekommen z.Zt. den Newsletter

SELECT * FROM `nladressen` WHERE `birthday` > "2015-04-29" 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-29" AND `active`= "1" AND `status`= "110"

davon sind angemeldet und aktiv über manuelle Eingabe AKF

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

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

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

wurden im letzten Jahr mit NL-Abmeldung abgemeldet

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

wurden im letzten Jahr nicht bestätigt

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

Alter: 0.5 Jahre

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

Alter: 1 Jahre

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

Alter: 1.5 Jahre

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

Alter: 2 Jahre

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

Alter: 2.5 Jahre

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

Alter: 3 Jahre

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

Alter: 3.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2020-08-01" AND birthday <= "2021-01-30" AND active = "1" AND newsletter = "1"

Alter: 4 Jahre

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

Alter: 4.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2019-08-03" AND birthday <= "2020-02-01" AND active = "1" AND newsletter = "1"

Alter: 5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2019-02-02" AND birthday <= "2019-08-03" AND active = "1" AND newsletter = "1"

Alter: 5.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2018-08-04" AND birthday <= "2019-02-02" AND active = "1" AND newsletter = "1"

Alter: 6 Jahre

SELECT * FROM nladressen WHERE birthday >= "2018-02-03" AND birthday <= "2018-08-04" AND active = "1" AND newsletter = "1"

Alter: 6.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2017-08-05" AND birthday <= "2018-02-03" AND active = "1" AND newsletter = "1"

Alter: 7 Jahre

SELECT * FROM nladressen WHERE birthday >= "2017-02-04" AND birthday <= "2017-08-05" AND active = "1" AND newsletter = "1"

Alter: 7.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2016-08-06" AND birthday <= "2017-02-04" AND active = "1" AND newsletter = "1"

Alter: 8 Jahre

SELECT * FROM nladressen WHERE birthday >= "2016-02-06" AND birthday <= "2016-08-06" AND active = "1" AND newsletter = "1"

Alter: 8.5 Jahre

SELECT * FROM nladressen WHERE birthday >= "2015-08-08" AND birthday <= "2016-02-06" AND active = "1" AND newsletter = "1"

Alter: 9 Jahre

SELECT * FROM nladressen WHERE birthday >= "2015-02-07" AND birthday <= "2015-08-08" AND active = "1" AND newsletter = "1"