SELECT * FROM `dle_post` WHERE CONCAT('|', `xfields`, '|') LIKE '%|key|123|%'
SELECT count(*) from `runs` where `date` >= unix_timestamp(curdate());
SELECT count(distinct client) from `runs` where `date` >= unix_timestamp(curdate());
SELECT COUNT(*) FROM (
SELECT
`client`, MIN(`date`) `first_run`
FROM `runs`
GROUP BY `client`
HAVING `first_run` >= unix_timestamp(curdate())
) `todays_first_runs`;
мне вылезает ошибка #1064