Wordpress sql: link wp comments table to new table following these rules

Hi, I'm using wordpress with Wpgeodirectory plugin installed. Through this plugin I have: listings (custom post types) and users add reviews (GD Reviews) to these listings (GD Listings). These reviews are wordpress comments (with star ratings). See following instructions by developer and the attached to easily understand how it works. The issue: some of these reviews are simply comments, need to link properly by creating entries. See specific details by developer: GD reviews are stored in DB table “wp_geodir_post_review” & it is linked to table “wp_comments”. See attachments that explains how review is linked between “wp_geodir_post_review” & “wp_comments”. – To make comments as a reviews you have to create entries for those comments into “wp_geodir_post_review” table. They are linked to each other via comment_id column. – wp_comments > comment_parent = 0 are only allowed as a review – Save NULL value for post_city, post_region, post_country, post_latitude. post_longitude in “wp_geodir_post_review” table. They are auto merged after running GT tool. – After all entries created in “wp_geodir_post_review” table run tool from GeoDirectory > GD Tools > Ratings check The goal: 1) plan a script or sql queries accordlying to specified rules above (and an additional check to avoid duplicates) 2) run the sql queries accordling to the specified rules above, and then run the tools (already made by plugin developer). 3) [optional] add random ratings (integer value, from 2 to 4 ) into column "overall_rating" only for these "imported" reviews Feel free to ask further details, thanks