The effects of alcohol on
sustanon 250 leucine for β real weight loss & bodybuilding benefits?
Limited Support
Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.
We appreciate your patience and understanding while our team is away. Thank you for being part of the wpDiscuz community!
Merry Christmas and Happy Holidays! π
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: 8202
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.