daily pastebin goal
18%
SHARE
TWEET

Untitled

a guest Mar 20th, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ----------------------------------------------------------
  2. | provider id| 1-1-2019 | 1-1-2019 | 1-1-2019 | 1-1-2019 | -> dynamic
  3. ----------------------------------------------------------
  4. |    5       |     5    |    3     |    9     |    8     |
  5. ----------------------------------------------------------
  6. |    18      |     11   |    56    |    79    |    34    |
  7. ----------------------------------------------------------
  8.      
  9. select `providers`.`id`,(select `orders`.c
  10. from `orders`,`providers`
  11. where
  12. `orders`.`providerId` = `providers`.`id`
  13. and
  14. `orders`.`createdAt` >= "2019-01-01 00:00:00"
  15. GROUP BY `providers`.`id`;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top