szbl · December 12, 2015 01:21
diff --git a/tca.sql b/tca.sql
 INSERT INTO 
 	wp_usermeta ( user_id, meta_key, meta_value )
 SELECT	
 	u.ID as user_id, 'szbl_favorites' as meta_key, pm.post_id as meta_value
 FROM	wp_users u, wp_postmeta pm
 WHERE	CONCAT( '_stcr@_', u.user_email ) = pm.meta_key
 ORDER BY user_email
	INSERT INTO
	wp_usermeta ( user_id, meta_key, meta_value )
	SELECT
	u.ID as user_id, 'szbl_favorites' as meta_key, pm.post_id as meta_value
	FROM wp_users u, wp_postmeta pm
	WHERE CONCAT( '_stcr@_', u.user_email ) = pm.meta_key
	ORDER BY user_email