Home
February 12, 2008 - 12:31pm — Anonymous
  1. SELECT a.title, b.field_direccin_fsica_value
  2. FROM node a, content_type_instituciones b,
  3. term_node d,
  4. term_node e,
  5. term_node f,
  6. term_node g,
  7. term_node h,
  8. term_node i,
  9. term_node j,
  10. term_node k,
  11. term_node l
  12. WHERE a.nid = b.nid
  13. AND a.vid = b.vid
  14. AND d.tid =7
  15. AND d.nid = a.nid
  16. AND e.tid =69
  17. AND e.nid = a.nid
  18. AND f.tid =8
  19. AND f.nid = a.nid
  20. AND g.tid =9
  21. AND g.nid = a.nid
  22. AND h.tid =10
  23. AND h.nid = a.nid
  24. AND i.tid =11
  25. AND i.nid = a.nid
  26. AND j.tid =12
  27. AND j.nid = a.nid
  28. AND k.tid =13
  29. AND k.nid = a.nid
  30. AND l.tid = 265
  31. AND l.nid = a.nid