Advertisement
vuylov

Untitled

Mar 12th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.37 KB | None | 0 0
  1. SELECT stat_date as day, stat_content as teaser_id, SUM(stat_orders_profit) as profit
  2. FROM stat_A_days
  3. WHERE
  4.     stat_content IN (1509640, 1512713, 1523276, 1523275)
  5.     AND stat_date >= (
  6.         SELECT MIN(DATE(created_at))
  7.         FROM source_external_teaser as et
  8.         WHERE et.ext_id IN (1509640, 1512713, 1523276, 1523275)
  9.     )
  10. GROUP BY stat_content, stat_date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement