Advanced Search

Seleccionar cantidad de comentarios por semanas, Wordpress

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT * , COUNT( * ) AS num
  2. FROM wp_o0qb3z_comments
  3. WHERE  `comment_date` 
  4. BETWEEN  '2011-07-04'
  5. AND  '2011-07-10'
  6. GROUP BY  `comment_author_email` 
  7. ORDER BY num DESC 
  8. LIMIT 0 , 30

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.