Someone

select        CURRENT_DATE - i as day,        pa.num as signups_active,        pi.num as signups_inactive,        it.num as items,        a.num as articles,        r.numfrom        generate_series(0,45) as i                left join                        (                                select                                        DATE(created) as day,                                        count(*) as num                                from                                        profile                                where                                        status = 'A'                                group by                                        1                        ) as pa                on                        pa.day = CURRENT_DATE - i                left join                        (                                select                                        DATE(created) as day,                                        count(*) as num                                from                                        profile                                where                                        status = 'I'                                group by                                        1                        ) as pi                on                        pi.day = CURRENT_DATE - i                left join                        (                                select                                        DATE(created) as day,                                        count(*) as num                                from                                        item                                group by                                        1                        ) as it                on                        it.day = CURRENT_DATE - i                left join                        (                                select                                        DATE(created) as day,                                        count(*) as num                                from                                        article                                group by                                        1                        ) as a                on                        a.day = CURRENT_DATE - i                left join                        (                                select                                        DATE(created) as day,                                        count(*) as num                                from                                        rate                                group by                                        1                        ) as r                on                        r.day = CURRENT_DATE - iorder by        1 desc