
--------------------------------------------------------------------------------
-- post metas
--------------------------------------------------------------------------------

SELECT m.`meta_key` , p.`post_title` ,  m.`meta_value`
FROM  `wp_posts` p,  `wp_postmeta` m
WHERE p.`ID` = m.`post_id`
AND ( p.`post_type` = 'page' OR p.`post_type` = 'portfolio' OR p.`post_type` = 'post' OR p.`post_type` = 'post' )
AND m.`meta_value` NOT LIKE '%!!!%'
AND m.`meta_key` != 'contact_form_name'
AND m.`meta_key` != 'map_hnear'
AND m.`meta_key` != 'map_ll'
AND m.`meta_key` NOT LIKE '_edit_%'
ORDER BY m.`meta_key`, p.`post_title`, p.`ID`


--------------------------------------------------------------------------------
-- post types
--------------------------------------------------------------------------------

SELECT `post_title`, `post_content`, `post_type`
FROM `wp_posts`
WHERE `post_type` = 'post'
AND `post_status` = 'publish'


SELECT `post_title`, `post_content`, `post_type`
FROM `wp_posts`
WHERE `post_type` = 'page'
AND `post_status` = 'publish'


SELECT `post_title`, `post_content`, `post_type`
FROM `wp_posts`
WHERE `post_type` = 'portfolio'
AND `post_status` = 'publish'


SELECT `post_title`, `post_content`, `post_type`
FROM `wp_posts`
WHERE `post_type` = 'wpcf7_contact_form'
AND `post_status` = 'publish'

--------------------------------------------------------------------------------
-- tax metas
--------------------------------------------------------------------------------

SELECT SUBSTR( o.`namespace`, 1, 11) AS ns_1, t.`name` AS ns_2, o.`name`, o.`value`
FROM `wp_gen_options` o, `wp_terms` t
WHERE o.`namespace` LIKE  'cm-%-opt-%'
AND o.`namespace` NOT LIKE  'cm-%-opt-archive'
AND o.`namespace` NOT LIKE  'cm-%-opt-index'
AND o.`namespace` NOT LIKE  'cm-%-opt-search'

AND t.`term_id` = SUBSTR( o.`namespace`, 12)

ORDER BY o.`namespace`, o.`name`




SELECT `namespace`, `name`, `value`
FROM  `wp_gen_options`
WHERE  `namespace` LIKE  'cm-%-opt-%'
AND ( 0
OR `namespace` LIKE  'cm-%-opt-archive'
OR `namespace` LIKE  'cm-%-opt-index'
OR `namespace` LIKE  'cm-%-opt-search'
)
ORDER BY `namespace`, `name`


--------------------------------------------------------------------------------
-- This is just for export of structure
--------------------------------------------------------------------------------

SELECT
`wp_posts`.`ID` AS `menu_item_ID`,
`wp_posts`.`post_title` AS `menu_item_title`,
`wp_posts`.`post_content` AS `menu_item_description`,
`wp_posts`.`menu_order` AS `order`,
`wp_postmeta`.`meta_value` AS `menu_item_parent`,
`wp_terms`.`name` AS `menu_name`

FROM `wp_terms`
, `wp_term_relationships`
, `wp_term_taxonomy`
, `wp_posts`
, `wp_postmeta`

WHERE 1
AND `wp_terms`.`term_id` = `wp_term_taxonomy`.`term_id`
AND `wp_term_relationships`.`term_taxonomy_id` = `wp_term_taxonomy`.`term_taxonomy_id`
AND `wp_term_relationships`.`object_id` = `wp_posts`.`id`
AND `wp_postmeta`.`post_id` = `wp_posts`.`id`

AND `wp_postmeta`.`meta_key` = '_menu_item_menu_item_parent'
AND `wp_term_taxonomy`.`taxonomy` = 'nav_menu'

ORDER BY `wp_terms`.`name`, `wp_postmeta`.`meta_value`, `wp_posts`.`menu_order`

--------------------------------------------------------------------------------
-- Export data - part #1
--------------------------------------------------------------------------------

SELECT
`wp_posts`.`ID` AS `menu_item_ID`,
`wp_postmeta`.`meta_key` AS `meta_key`,
`wp_postmeta`.`meta_value` AS `menu_value`

FROM `wp_terms`
, `wp_term_relationships`
, `wp_term_taxonomy`
, `wp_posts`
, `wp_postmeta`

WHERE 1
AND `wp_terms`.`term_id` = `wp_term_taxonomy`.`term_id`
AND `wp_term_relationships`.`term_taxonomy_id` = `wp_term_taxonomy`.`term_taxonomy_id`
AND `wp_term_relationships`.`object_id` = `wp_posts`.`id`
AND `wp_postmeta`.`post_id` = `wp_posts`.`id`

AND `wp_term_taxonomy`.`taxonomy` = 'nav_menu'

AND `wp_postmeta`.`meta_key` != '_menu_item_menu_item_parent'
AND `wp_postmeta`.`meta_key` != '_menu_item_classes'
AND `wp_postmeta`.`meta_key` != '_menu_item_xfn'
AND `wp_postmeta`.`meta_key` != '_menu_item_target'

--------------------------------------------------------------------------------
-- Export data - custom only
--------------------------------------------------------------------------------

SELECT
`wp_posts`.`ID` AS `menu_item_ID`,
`pm1`.`meta_key` AS `meta_key`,
`pm1`.`meta_value` AS `menu_value`

FROM `wp_terms`
, `wp_term_relationships`
, `wp_term_taxonomy`
, `wp_posts`
, `wp_postmeta` `pm1`
, `wp_postmeta` `pm2`

WHERE 1
AND `wp_terms`.`term_id` = `wp_term_taxonomy`.`term_id`
AND `wp_term_relationships`.`term_taxonomy_id` = `wp_term_taxonomy`.`term_taxonomy_id`
AND `wp_term_relationships`.`object_id` = `wp_posts`.`id`
AND `pm1`.`post_id` = `wp_posts`.`id`
AND `pm2`.`post_id` = `wp_posts`.`id`
AND `pm2`.`meta_key` = '_menu_item_type'
AND `pm2`.`meta_value` = 'custom'
AND `wp_term_taxonomy`.`taxonomy` = 'nav_menu'
AND `pm1`.`meta_key` = '_menu_item_url'


--------------------------------------------------------------------------------
-- Export data - taxonomies
--------------------------------------------------------------------------------

SELECT
`wp_posts`.`ID` AS `menu_item_ID`,
`pm1`.`meta_key` AS `meta_key`,
`t2`.`name` AS `menu_value`

FROM `wp_terms` `t1`
, `wp_terms` `t2`
, `wp_term_relationships`
, `wp_term_taxonomy`
, `wp_posts`
, `wp_postmeta` `pm1`
, `wp_postmeta` `pm2`

WHERE 1
AND `t1`.`term_id` = `wp_term_taxonomy`.`term_id`
AND `wp_term_relationships`.`term_taxonomy_id` = `wp_term_taxonomy`.`term_taxonomy_id`
AND `wp_term_relationships`.`object_id` = `wp_posts`.`id`
AND `pm1`.`post_id` = `wp_posts`.`id`
AND `pm2`.`post_id` = `wp_posts`.`id`
AND `pm2`.`meta_key` = '_menu_item_type'
AND `pm2`.`meta_value` = 'taxonomy'
AND `wp_term_taxonomy`.`taxonomy` = 'nav_menu'

AND `pm1`.`meta_key` = '_menu_item_object_id'

AND `t2`.`term_id` = `pm1`.`meta_value`

--------------------------------------------------------------------------------
-- Export data - posts
--------------------------------------------------------------------------------

SELECT
`p1`.`ID` AS `menu_item_ID`,
`p2`.`post_title` AS `menu_value`

FROM `wp_terms` `t1`
, `wp_term_relationships`
, `wp_term_taxonomy`
, `wp_posts` `p1`
, `wp_posts` `p2`
, `wp_postmeta` `pm1`
, `wp_postmeta` `pm2`

WHERE 1
AND `t1`.`term_id` = `wp_term_taxonomy`.`term_id`
AND `wp_term_relationships`.`term_taxonomy_id` = `wp_term_taxonomy`.`term_taxonomy_id`
AND `wp_term_relationships`.`object_id` = `p1`.`id`
AND `pm1`.`post_id` = `p1`.`id`
AND `pm2`.`post_id` = `p1`.`id`
AND `pm2`.`meta_key` = '_menu_item_type'
AND `pm2`.`meta_value` = 'post_type'
AND `wp_term_taxonomy`.`taxonomy` = 'nav_menu'

AND `pm1`.`meta_key` = '_menu_item_object_id'

AND `p2`.`ID` = `pm1`.`meta_value`
