Changes between Initial Version and Version 1 of Ticket #2089, comment 17
- Timestamp:
- 09/26/2013 05:28:21 AM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #2089, comment 17
initial v1 2 2 3 3 {{{ 4 #!sql 4 5 SELECT `forum`.`ID`, `forummeta`.`meta_value`, `group`.`id` 5 6 6 FROM `wp_posts` AS `forum` 7 8 7 LEFT JOIN `wp_postmeta` AS `forummeta` 9 10 8 ON `forum`.`ID` = `forummeta`.`post_id` 11 12 9 AND `forummeta`.`meta_key` = '_bbp_old_forum_id' 13 14 10 LEFT JOIN `wp_bp_groups` AS `group` 15 16 11 ON `group`.`slug` = `forum`.`post_name` 17 18 12 WHERE `forum`.`post_type` = 'forum' AND `group`.`id` > 0 19 20 13 GROUP BY `forum`.`ID`; 21 14 }}}