All pastes #802366 Raw Edit

Someone

public text v1 · immutable
#802366 ·published 2007-11-30 02:46 UTC
rendered paste body
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 7 DAY <= calldate
	AND calldate < NOW() - INTERVAL 6 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 6 DAY <= calldate
	AND calldate < NOW() - INTERVAL 5 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 5 DAY <= calldate
	AND calldate < NOW() - INTERVAL 4 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 4 DAY <= calldate
	AND calldate < NOW() - INTERVAL 3 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 3 DAY <= calldate
	AND calldate < NOW() - INTERVAL 2 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 2 DAY <= calldate
	AND calldate < NOW() - INTERVAL 1 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 1 DAY <= calldate
	AND calldate < NOW()
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() <= calldate
	AND calldate < NOW() + INTERVAL 1 DAY;