SELECT
    sad.stat_term,
    SUM(sad.stat_enters) as enters,
    SUM(sad.stat_hits) as hits,
    ROUND(SUM(`stat_enters`*`src_coef`)) as `clicks`,
    ROUND(SUM(`stat_teas`) / SUM(sad.stat_enters) * 100, 2) as percent_clicks,
    SUM(`stat_teas`) as `teaser_views`,
    SUM(`stat_teased`) as `teaser_clicks`,
    ROUND(SUM(`stat_teas`) / SUM(`stat_teased`), 2) as teaser_per,
    ROUND(SUM(sc.`src_per`* sad.`stat_enters`)) as costs,
    ROUND(SUM(`stat_enters`*`src_per`) / (SUM(`stat_orders_all`) - SUM(`stat_orders_trash`))) as cost_per_order,
    SUM(sad.stat_orders_profit) as profit
FROM `stat_A_days` as sad
LEFT JOIN stat_cost as sc ON sc.src_date = sad.stat_date AND sc.src_name = sad.stat_source
WHERE sad.`stat_date` >= '2017-12-01' AND sad.stat_source = 'marketgid'
GROUP BY sad.`stat_term`
HAVING
    (SUM(sad.stat_enters) >= 200 AND ROUND(SUM(`stat_teas`) / SUM(sad.stat_enters) * 100, 2) <= 10)
    OR
    (SUM(sad.stat_enters) >= 50 AND IFNULL(ROUND(SUM(`stat_teas`) / SUM(`stat_teased`), 2), 1.2) <= 1.2)
    OR
    (SUM(sad.stat_enters) > 3000 AND IFNULL(ROUND(SUM(`stat_enters`*`src_per`) / (SUM(`stat_orders_all`) - SUM(`stat_orders_trash`)), 2), 800) >= 800)