The effects of alcohol on
sustanon 250 leucine for – real weight loss & bodybuilding benefits?
Question (SQL) Relating wp_wc_feedback_forms items to wp_comments
(@rocky)
New Member
Joined: 1 year ago
Hi - first off, fantastic product - thank you so much for this!
I'm trying to programmatically pull comments out of the WordPress SQL database.
This works well when I relate wp_posts table and wp_comments tables.
However, I'm struggling to link inline comments to content within the wp_comments table.
There doesn't seem to be a way to identify which comments relate to which inline unique_id within the wp_wc_feedback_forms table.
I assume I should be looking somewhere else? Any help would be appreciated!
Many thanks,
R
(@asti)
Illustrious Member
Joined: 8 years ago
Hi,
I'll ask the developers and get back to you soon.
(@asti)
Joined: 8 years ago
Illustrious Member
Posts: 8187
Nov 25, 2024 9:24 am
Hi,
The wpdiscuz_feedback_form_id meta key in the wp_commentmeta table can be used to retrieve the IDs of the inline comment feedback forms.
SELECT *
FROM `wp_comments` c
JOIN `wp_commentmeta` m ON c.`comment_ID` = m.`comment_id` AND m.`meta_key` = 'wpdiscuz_feedback_form_id'
JOIN `wp_wc_feedback_forms` ff ON ff.`id` = m.`meta_value`
WHERE c.`comment_post_ID` = 1
AND ff.`unique_id` = '0sdbxr5cfy'
The SQL above gets the inline comments with unique_id = 0sdbxr5cfy for the post ID = 1.
The wp_ is just a prefix, in your case, it may differ.
