SELECT
ad.affiliate_username,
ad.affiliate_id,
ad.geo,
ad.manager_name,
ad.traffic_type,
ad.sum_unique_click_count,
ad.sum_reg_count_total,
ad.sum_ftd_count,
ad.avg_reg_to_ftd,
ad.sum_deposits,
ad.sum_ggr,
ad.sum_ngr,
ad.sum_net_cash,
ad.sum_cpa,
ad.sum_revenue_share,
ad.sum_total_reward,
ad.sum_e_cpa,
ad.sum_fixed_fee,
ad.expected_deposit_total,
ad.expected_avg_deposit_per_player,
ad.expected_ggr_total,
ad.expected_ngr_total,
ad.multi_reg_players,
ad.multi_reg_percent,
ad.multi_ftd_players,
ad.roi,
ad.net_profit,
ad.multi_ftd_percent,
(SELECT COUNT(*)
FROM (
SELECT
referon_general.affiliate_id,
referon_general.geo,
referon_general.manager_name,
referon_general.traffic_type,
referon_general.rewarding_plan
FROM referon_general
WHERE referon_general.date BETWEEN ? AND ?
AND referon_general.geo = ad.geo
AND referon_general.affiliate_id = ad.affiliate_id
GROUP BY referon_general.affiliate_id, referon_general.geo, referon_general.manager_name, referon_general.traffic_type, referon_general.rewarding_plan
) AS subquery
) AS detailed_row_count