SELECT
*
FROM
`numbers` A
LEFT JOIN `numbers_type` B ON A.`number` = B.`number`
WHERE
B.`type` IN (1, 3, 5)SET @all_sum = 0;
SELECT `date`,`count`,`sum` FROM (
SELECT *, @all_sum:=@all_sum + `sum` AS mysum FROM `table` ORDER BY `date` DESC
) t
WHERE mysum < 5000;