Home

sql to confirm contributers to drupal6

February 11, 2008 - 8:43pm — Anonymous
  1. CREATE TEMPORARY TABLE contributors
  2. SELECT n.uid
  3. FROM project_issues i INNER JOIN node n ON i.nid = n.nid
  4. INNER JOIN files f ON i.nid = f.nid
  5. WHERE i.pid = 9609
  6. AND n.created < UNIX_TIMESTAMP('2007-01-15 03:00:00')
  7. AND n.created > UNIX_TIMESTAMP('2006-05-01 04:00:00');
  8.  
  9. INSERT INTO contributors
  10. SELECT c.uid
  11. FROM project_issue_comments pic INNER JOIN comment_upload_files cuf ON pic.cid = cuf.cid
  12. INNER JOIN comments c ON pic.cid = c.cid
  13. WHERE pic.pid = 9609
  14. AND c.timestamp < UNIX_TIMESTAMP('2007-01-15 03:00:00')
  15. AND c.timestamp > UNIX_TIMESTAMP('2006-05-01 04:00:00');
  16.  
  17. SELECT COUNT(DISTINCT(uid)) FROM contributors;
  18.  
  19. SELECT COUNT(1) FROM contributors;