SELECT
    CAST(weather.date AS date) as date,
    weather.temp AS temp,
    weather.rain AS rain,
    products.name AS name
FROM
	weather
LEFT JOIN transactions ON CAST(transactions.date AS date) = CAST(weather.date AS date)
LEFT JOIN products ON transactions.id_product = products.id_product
ORDER BY
    weather.date DESC
LIMIT
    30;