select
COUNT(*)
from intention
where is_active=1
and status=3
and (TIMESTAMPDIFF(SECOND, updated_time,( CURRENT_DATE ) )>=1296000)
order by updated_time desc
select
COUNT(*)
from intention
where is_active=1
and status=3
and (TIMESTAMPDIFF(SECOND, updated_time,(SELECT NOW() AS System) )>=1296000)
order by updated_time desc
COUNT(*)
from intention
where is_active=1
and status=3
and (TIMESTAMPDIFF(SECOND, updated_time,( CURRENT_DATE ) )>=1296000)
order by updated_time desc
select
COUNT(*)
from intention
where is_active=1
and status=3
and (TIMESTAMPDIFF(SECOND, updated_time,(SELECT NOW() AS System) )>=1296000)
order by updated_time desc