SHARE
TWEET

Untitled

a guest Dec 3rd, 2019 82 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     CAST(weather.date AS date) as date,
  3.     weather.temp AS temp,
  4.     weather.rain AS rain,
  5.     products.name AS name
  6. FROM
  7.     weather
  8. LEFT JOIN transactions ON CAST(transactions.date AS date) = CAST(weather.date AS date)
  9. LEFT JOIN products ON transactions.id_product = products.id_product
  10. ORDER BY
  11.     weather.date DESC
  12. LIMIT
  13.     30;
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