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