Your Ad Here

advanced code snippet search

Posted By

serialk89 on 07/12/11


Tagged

mysql wordpress comentarios


Versions (?)

Seleccionar cantidad de comentarios por semanas, Wordpress

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  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  

You need to login to post a comment.