현행 → 신규 이관 검증

SELECT meta_value
FROM wp_postmeta
WHERE post_id = 6288
  AND meta_key = '_kte_attributes';
-- → a:12:{s:4:"Date";a:...}  (역직렬화 필요)

SELECT id, name, role, input_type
FROM option_groups WHERE product_id = $1;

SELECT id, name FROM option_items
WHERE option_group_id = $1;

SELECT ID FROM wp_posts
WHERE post_parent = 6288 AND post_type = 'kte_variation';

SELECT meta_key, meta_value FROM wp_postmeta
WHERE post_id = <변형ID>;  -- attribute_*, _price

SELECT selector, sell_price, currency, priority
FROM price_rules WHERE product_id = $1;

SELECT meta_value FROM wp_postmeta
WHERE post_id = 6288 AND meta_key = '_kte_validations';

SELECT kind, selector FROM option_validations
WHERE product_id = $1;

SELECT id, total_amount, status FROM wp_wc_orders WHERE id = ?;
SELECT * FROM wp_woocommerce_order_items
WHERE order_id = ? AND order_item_type IN ('line_item','fee');

SELECT option_path, sell_price_snapshot, travel_date
FROM order_items WHERE order_id = $1;
-- option_path: {"Car Type":"Limo Van","Date":"2019-09-27",...}

SELECT c.comment_content, cm.meta_value AS rating
FROM wp_comments c
LEFT JOIN wp_commentmeta cm ON cm.comment_id = c.comment_ID AND cm.meta_key = 'rating'
WHERE c.comment_post_ID = 6288
  AND c.comment_type IN ('review','comment')
  AND c.comment_approved = 1 AND c.comment_parent = 0;

SELECT rating, body, verified, created_at
FROM reviews WHERE product_id = $1 AND status = 'approved';

SELECT u.ID, u.user_email FROM wp_users u;
SELECT meta_value FROM wp_usermeta
WHERE user_id = ? AND meta_key LIKE '%points%';

SELECT balance FROM point_balances WHERE user_id = $1;
SELECT delta, reason_code, occurred_at
FROM point_transactions WHERE user_id = $1;

SELECT title, description, og_title
FROM wp_aioseo_posts WHERE post_id = 6288;

SELECT title, description, og_title, og_description
FROM seo_meta WHERE entity_type = 'product' AND entity_id = $1;

SELECT meta_value FROM wp_postmeta
WHERE post_id = 6288 AND meta_key = '_thumbnail_id';
SELECT guid FROM wp_posts WHERE ID = <attId>;

SELECT cdn_url, role, sort FROM product_media
WHERE product_id = $1 ORDER BY sort;

SELECT meta_key, meta_value FROM wp_postmeta
WHERE post_id = 6288 AND meta_key LIKE '_kte_extra_content_%';

SELECT key, label, body, visibility, sort
FROM product_sections WHERE product_id = $1 ORDER BY sort;