Skip to:
Content

bbPress.org

Changes between Initial Version and Version 1 of Ticket #2089, comment 17


Ignore:
Timestamp:
09/26/2013 05:28:21 AM (8 years ago)
Author:
netweb
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #2089, comment 17

    initial v1  
    22
    33{{{
     4#!sql
    45SELECT `forum`.`ID`, `forummeta`.`meta_value`, `group`.`id`
    5 
    66FROM `wp_posts` AS `forum`
    7 
    87LEFT JOIN `wp_postmeta` AS `forummeta`
    9 
    108ON `forum`.`ID` = `forummeta`.`post_id`
    11 
    129AND `forummeta`.`meta_key` = '_bbp_old_forum_id'
    13 
    1410LEFT JOIN `wp_bp_groups` AS `group`
    15 
    1611ON `group`.`slug` = `forum`.`post_name`
    17 
    1812WHERE `forum`.`post_type` = 'forum' AND `group`.`id` > 0
    19 
    2013GROUP BY `forum`.`ID`;
    2114}}}