Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. id | my_id | field_number | field_id | value
  2. ------------------------------------------------------------
  3. 1 | 101 | 78 | 88 | apple
  4. 2 | 287 | 76 | 55 | orange
  5. 3 | 893 | 45 | 33 | orange
  6. 4 | 922 | 23 | 33 | grape
  7. 5 | 198 | 09 | 88 | raisin
  8. 6 | 082 | 55 | 88 | apple
  9.  
  10. my_id | date_posted
  11. -----------------------
  12. 101 | 01-01-2014
  13. 287 | 17-01-2014
  14. 893 | 24-02-2014
  15. 922 | 18-03-2014
  16. 198 | 04-04-2014
  17. 082 | 16-04-2014
  18.  
  19. $count = $wpdb->get_results("SELECT COUNT(*) as count FROM wp_mymeta1 WHERE value='apple'" );
  20.  
  21. SELECT COUNT(*) AS count
  22. FROM wp_mymeta1 a
  23. JOIN wp_mymeta2 b ON b.my_id = a.my_id
  24. WHERE a.value = 'apple'
  25. AND b.date_posted = '01-01-2014'
  26.  
  27. SELECT wp_mymeta2.date_posted, COUNT(wp_mymeta1.my_id)
  28. FROM wp_mymeta1, wp_mymeta2
  29. WHERE value='apple' AND wp_mymeta2.my_id = wp_mymeta1.my_id
  30. GROUP BY wp_mymeta1.my_id, wp_mymeta2.date_posted;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement