Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT td_title, COUNT(1) AS page_cnt
- FROM access_log
- WHERE TD_TIME_RANGE(time,'2017-01-01','2017-02-01','JST')
- GROUP BY td_title
- ORDER BY page_cnt DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement