id--------name-----date----status
1---------Ivan-----25.01-----1
3---------Artem-----25.03-----1
4---------Sasha-----25.04-----1
6---------Gena-----25.06-----1
2---------Sergei-----25.02-----2
5---------Aleksei-----25.05-----2
create view cur_time as select now();
MyISAM
баланс на моем сайте
select u.id, u.login
coalesce(income.sum, 0) - coalesce(payment.sum, 0) as balance
from users u
left join (
select user_id, sum(money) as sum from moneyuser group by user_id
) income ON u.id = income.user_id
left join (
select user_id, sum(money) as sum from payments group by user_id
) payment ON u.id = payment.user_idwhere payment.user_id is null and income.user_id is null(
select ...
)
union all
(
select ...
)
limit 1FROM statya s
WHERE s.del = 0
AND s.raz_id = 1
AND s.langid = 1
s.st_date IS NOT NULL and s.st_date < 1234567890
order by if (s.st_date > 1234567890, s.st_date, 0), s.st_date DESC
limit 1если я хочу гарантированные true транзакции то мне надо ставить только 1?
select id, count(0) as match_count from tablename
where keyword in (...)
group by id
order by match_count descselect curr.user_id, (curr.exp - coalesce(lastr.exp, 0)) as diff
from user_exp curr
left join user_exp lastr ON curr.user_id = lastr.user_id and lastr.date = CURRENT_DATE - interval '1week'
where curr.date = CURRENT_DATE
order by diff descoperand comparison_operator SOME (subquery)