Hi all!
I want to put this three queries in only one... Take a look that the
only thing that changes is the message_type_id. Any suggestions??
SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,
sum(total_num_messages)
FROM statistics_daily
WHERE message_type_id IN (4,5)
AND statistics_date = CURRENT_DATE
AND telecom_operator_id <> 0
AND telephone_number IN ( $numbers )
GROUP BY date_in
SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,
sum(total_num_messages)
FROM statistics_daily
WHERE message_type_id IN (6)
AND statistics_date = CURRENT_DATE
AND telecom_operator_id <> 0
AND telephone_number IN ( $numbers )
GROUP BY date_in
SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,
sum(total_num_messages)
FROM statistics_daily
WHERE message_type_id IN (21)
AND statistics_date = CURRENT_DATE
AND telecom_operator_id <> 0
AND telephone_number IN ( $numbers )
GROUP BY date_in
Thank you in advance!
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
