Как определить бюджет конкурента на контекстную рекламу: 3 нестандартных метода

WITH your as (SELECT * FROM `results` WHERE domain='alltime.ru' AND traff_cost>0),
     comp as (SELECT * FROM `results` WHERE domain='bestwatch.ru' AND traff_cost>0),
     cros as (SELECT your.traff_cost as your_traff_cost, 
                     comp.traff_cost as comp_traff_cost,
                     your.traff      as your_traff, 
                     comp.traff      as comp_traff,
                     your.position   as your_position, 
                     comp.position   as comp_position
              FROM your 
              INNER JOIN comp ON(your._se=comp._se AND your.keyword=comp.keyword)),
    sum_your as (SELECT sum(traff_cost) as your_traff_cost FROM your),
    sum_comp as (SELECT sum(traff_cost) as comp_traff_cost FROM comp),
    sum_cros as (SELECT sum(your_traff_cost) as cros_your_traff_cost, 
                        sum(comp_traff_cost) as cros_comp_traff_cost 
                 FROM cros)    
SELECT *,
       (your_traff_cost/comp_traff_cost) 
     * (cros_your_traff_cost/cros_comp_traff_cost)  as budgetRate, 
       (your_traff_cost/comp_traff_cost)            as reachRate,
       (cros_your_traff_cost/cros_comp_traff_cost)  as cpmRate
FROM(    
    SELECT * FROM sum_your 
        LEFT JOIN sum_comp ON(1=1)
        LEFT JOIN sum_cros ON(1=1)
)