Guest User

Untitled

a guest
Mar 20th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. $query = db_select('taxonomy_index', 't1');
  2. $query->distinct();
  3. $query->join('node', 't2', 't1.nid = t2.nid');
  4. $query->join('taxonomy_term_data', 't3', 't3.tid = t1.tid');
  5. $query->fields('t1', array('tid'));
  6. $query->fields('t3', array('name'));
  7. $query->fields('t1', array('nid'));
  8. $query->groupBy('t1.nid');
  9. $query->condition('t2.type', 'article', '=');
  10. $query->condition('t3.vid', '2', '=');
  11. $query->orderBy('t2.created', 'DESC');
  12. $query->range(0, 20);
  13. $result = $query->execute()->fetchAll();
  14. print_r($result);
  15.  
  16. tid name nid
  17. 1 apple 200
  18. 5 orange 165
  19. 9 grapes 130
  20. 5 orange 106
  21.  
  22. tid name nid
  23. 1 apple 200
  24. 5 orange 165
  25. 9 grapes 130
Add Comment
Please, Sign In to add comment