Advertisement
TDCustmerSupportJP

Untitled

Jul 7th, 2017
2,206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.15 KB | None | 0 0
  1. SELECT td_title, COUNT(1) AS page_cnt
  2. FROM access_log
  3. WHERE TD_TIME_RANGE(time,'2017-01-01','2017-02-01','JST')
  4. GROUP BY td_title
  5. ORDER BY page_cnt DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement