SELECT DAY,
       value
FROM (
        (SELECT count(*) AS value,
                now() AS DAY
         FROM offer
         WHERE generated_at > concat(date(now()) , ' 00:00:00')
           AND generated_at < now())
      UNION
        (SELECT count(*) AS value,
                now() - interval 1 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 1 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 1 DAY)
      UNION
        (SELECT count(*) AS value,
                now()- interval 2 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 2 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 2 DAY)
      UNION
        (SELECT count(*) AS value,
                now()- interval 3 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 3 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 3 DAY)
      UNION
        (SELECT count(*) AS value,
                now()- interval 4 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 4 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 4 DAY)
      UNION
        (SELECT count(*) AS value,
                now() - interval 5 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 5 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 5 DAY)
      UNION
        (SELECT count(*) AS value,
                now() - interval 6 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 6 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 6 DAY)
      UNION
        (SELECT count(*) AS value,
                now() - interval 7 DAY AS DAY
         FROM offer
         WHERE generated_at > concat(date(now() - interval 7 DAY) , ' 00:00:00')
           AND generated_at < now() - interval 7 DAY))AS teste