-- invite
SELECT count(u.user_), date(register)
FROM "44fe4dbf"."user" AS "u"
 LEFT JOIN "44fe4dbf"."custom_event_request_accepted" AS "rra" ON rra.user_ = u.user_
 LEFT JOIN "44fe4dbf"."request" AS "re" ON re.request_id::varchar = rra.additional::varchar
WHERE (re.request_type = 'invite')
GROUP BY date(register)
ORDER BY date(register) ASC

 -- promo
SELECT count(u.user_), date(register)
FROM "44fe4dbf"."user" AS "u"
 LEFT JOIN "44fe4dbf"."marketing_install" AS "rmi" ON rmi.user_id::varchar = u.user_
WHERE (rmi.referrer <> 'organic' AND rmi.referrer IS NOT NULL)
GROUP BY date(register)
ORDER BY date(register) ASC

 -- organic
SELECT count(u.user_), date(register)
FROM "44fe4dbf"."user" AS "u"
 LEFT JOIN "44fe4dbf"."marketing_install" AS "rmi" ON rmi.user_id::varchar = u.user_
 LEFT JOIN "44fe4dbf"."custom_event_request_accepted" AS "rra" ON rra.user_ = u.user_
 LEFT JOIN "44fe4dbf"."request" AS "re" ON re.request_id::varchar = rra.additional::varchar
WHERE (rmi.referrer = 'organic' OR rmi.referrer IS NULL) AND (re.request_type <> 'invite')
GROUP BY date(register)
ORDER BY date(register) ASC