Skip to content

Instantly share code, notes, and snippets.

@ApoGouv

ApoGouv/select-posts-and-K2-old-ID.sql

Created March 27, 2018 06:30
Show Gist options
  • Save ApoGouv/eab2c24fe46c3abd888652f42ee1ea79 to your computer and use it in GitHub Desktop.
Save ApoGouv/eab2c24fe46c3abd888652f42ee1ea79 to your computer and use it in GitHub Desktop.
Download ZIP
WP - FG Joomla to Wordpress
Raw
select-posts-and-K2-old-ID.sql
SELECT `p`.`ID`, `p`.`post_title`, `p`.`post_name`, `pm`.`meta_value`
FROM `wp_posts` AS `p`
LEFT JOIN `wp_postmeta` AS `pm` ON `p`.`ID` = `pm`.`post_id`
WHERE `post_type` = 'post'
AND `pm`.`meta_key` = '_fgj2wp_old_k2_id'
LIMIT 0, 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment