SELECT CONCAT('sms_', IF(is_auto = 0, 'user' , 'auto')) AS subtype, SUM(messages_count * (customers_count + recipients_count)) AS COUNT FROM outgoing_message AS m INNER JOIN small_text_message AS s ON m.id = s.id WHERE STATUS <> 'pending' AND user_id = :user_id AND sent_at >= :START GROUP BY TYPE, is_auto UNION ALL SELECT CONCAT('newsletter_', IF(is_auto = 0, 'user' , 'auto')) AS subtype, SUM(customers_count + recipients_count) AS COUNT FROM outgoing_message AS m JOIN newsletter AS n ON m.id = n.id WHERE STATUS <> 'pending' AND user_id = :user_id AND sent_at >= :START GROUP BY TYPE, is_auto