Posted By

serialk89 on 07/12/11


Tagged

mysql wordpress comentarios


Versions (?)

Seleccionar cantidad de comentarios por semanas, Wordpress


 / Published in: MySQL
 

  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.