Как за 10 минут собрать семантическое ядро и еще 5 крутых SEO-кейсов

SELECT `url`,
sum(`raw_traff`)           AS `raw_traff`,
sum(`filtered_traff`)      AS `filtered_traff`,
sum(`raw_traff_cost`)      AS `raw_traff_cost`,
sum(`filtered_traff_cost`) AS `filtered_traff_cost`,
100*sum(`filtered_traff`)/sum(`raw_traff`) AS `filtered_traff_procent`

FROM (SELECT 
  `raw_results`.`url`      AS `url`,
  `raw_results`.`_se`      AS `_se`,
  `raw_results`.`cost`     AS `cost`,
  `raw_results`.`position` AS `position`,
  `raw_results`.`traff`    AS `raw_traff`,
  `results`.`traff`        AS `filtered_traff`,
  (`raw_results`.`traff` * `raw_results`.`cost`) AS `raw_traff_cost`,
  (`results`.`traff` * `results`.`cost`)         AS `filtered_traff_cost`
  FROM raw_results() as `raw_results`
  LEFT JOIN `results`
  USING `keyword`,`_se`,`position`
) 
GROUP BY `url`

SELECT `url`, 
    sum(`traff`) AS `traff`,
    sum(`traff_cost`) AS `traff_cost`,
    sum(`brand_traff`) AS `brand_traff`,
    sum(`brand_traff_cost`) AS `brand_traff_cost`,
    (100*sum(`brand_traff`)/sum(`traff`)) AS `brand_traff_prc`,
    (100*sum(`brand_traff_cost`)/sum(`traff_cost`)) AS `brand_traff_cost_prc` 
FROM(SELECT *,        
        (`is_brand` * `traff`)      AS `brand_traff`,
        (`is_brand` * `traff_cost`) AS `brand_traff_cost`
    FROM (SELECT *,
        (`traff` * `cost`) AS `traff_cost`,
        1 * (
            `keyword` like '%серпстат%'    OR 
            `keyword` like '%serpstat%'    OR
            `keyword` like '%серп стат%'    OR 
            `keyword` like '%serp stat%'    OR
            `keyword` like '%продвигатор%' OR
            `keyword` like '%prodvigator%' 
        )  as `is_brand`
       FROM `results`
    )
)  
GROUP BY `url`
ORDER BY `brand_traff_prc` DESC

SELECT ('<a href=”'+url+'”>'+FIRST(keyword)+'</a>') as link_code
FROM (SELECT * FROM results ORDER BY traff DESC)
GROUP BY url ORDER BY sum_traff DESC