SELECT 
   eventAction, 
   adSystem, 
   COUNT (eventAction) as count,
   EXACT_COUNT_DISTINCT (extenalCID) as campaigns,
   EXACT_COUNT_DISTINCT (user_id) as users,
   IF (SUM(count_r) IS NULL, 0, SUM(count_r)) as count_r,
   IF (ROUND(AVG(count_r),1) IS NULL, 0, ROUND(AVG(count_r),1)) as count_r_avg,
   IF (NTH(51,QUANTILES(count_r,101)) IS NULL, 0, NTH(51,QUANTILES(count_r,101))) as count_r_median,
   SUM (r03) as r03, SUM (r04) as r04, SUM (r05) as r05, SUM (r06) as r06,
   SUM (r07) as r07, SUM (r08) as r08, SUM (r10) as r10, SUM (r11) as r11, SUM (r13) as r13,
   SUM (r14) as r14, SUM (r15) as r15, SUM (r16) as r16, SUM (r18) as r18, SUM (r19) as r19,
   SUM (r20) as r20, SUM (r22) as r22, SUM (r23) as r23, SUM (r24) as r24, SUM (r25) as r25,
   
FROM tools_web.recommender
WHERE ip NOT IN (SELECT ip FROM eLama.office_ip)
GROUP BY eventAction, adSystem, 
ORDER BY adSystem, count DESC