Announcement

Collapse
No announcement yet.

SQL query tables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    - node, contenttype, text
    - node, contenttype, channel. In order to get the heirarchy, you need to query the closure table.
    - user, usertextfield, userfield (the last is for custom profile fields)

    Leave a comment:


  • rnedelkow
    started a topic SQL query tables

    SQL query tables

    Hi,

    I'm looking for sql queries that can fetch info like :

    - user posts including content/body
    - nodes (channels) and sub-nodes(sub-channels)
    - user profile attributes

    Does anyone know the names of these tables?

    Thanks


widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X