Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. function dokan_get_sellers_by_term_id( $term_id = 0 )
  3. {
  4. global $wpdb;
  5. if( !$term_id ) {
  6. $term_id = get_queried_object()->term_id;
  7. }
  8. else {
  9. $term_id = intval( $term_id );
  10. }
  11. if( !$term_id )
  12. return;
  13. /**
  14. * Query
  15. */
  16. $query = "SELECT user.* FROM `wp_users` user
  17. LEFT JOIN `wp_posts` post ON user.ID = post.post_author AND post.post_type = 'product'
  18. LEFT JOIN `wp_term_relationships` taxr ON taxr.object_id = post.ID
  19. LEFT JOIN `wp_term_taxonomy` tax ON taxr.term_taxonomy_id = tax.term_taxonomy_id
  20. WHERE post.post_status = 'publish' AND tax.taxonomy = 'product_cat' AND tax.term_id = %d
  21. GROUP BY user.user_login";
  22. // prepare
  23. $query = $wpdb->prepare( $query, $term_id );
  24. // get
  25. if( $result = $wpdb->get_results( $query ) ) {
  26. return $result;
  27. }
  28. return;
  29. }
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement