View difference between Paste ID: MZ9CZyAU and 04dWK2VD

--- MySQL Query to select all reviews that are assigned to a product and with review content
+-- MySQL Query to export all Woocommerce reviews to a CSV file which can then be imported into Site Reviews
--- which can be used to export as a CSV and imported to the wp_comments table as WooCommerce reviews.
+
 -- 1. Install the [Database Browser](https://wordpress.org/plugins/database-browser/) plugin
--- 1. Install the [Adminer](https://wordpress.org/plugins/pexlechris-adminer/) plugin
+-- 2. Go to the "Tools > Database Browser" page
--- 2. Go to the "Tools > WP Adminer" page
+-- 3. Click the "Select table" button (it doesn’t matter which table is selected)
--- 3. Click the "SQL command" link)
+-- 4. Copy the table prefix of your tables (for example, if the table is `wp_posts`, the prefix is the first part with the underscore `wp_`).
--- 4. Paste the SQL query (replace every instance of `wp_` in the SQL query with your table prefix)
+-- 5. Click the "Edit query" button
--- 5. Click the "Execute" button
+-- 6. Paste the SQL query, replacing every instance of `wp_` in the SQL query with your table prefix.
--- 6. Click the "Export" link, change the first dropdown to "save", then click the "Export" button
+-- 7. Click the "Run query" button
--- 7. Go to the comments table and click "Select data"
+-- 8. Click the "CSV" button to download the results
--- 8. Scroll to the bottom of the table and click the "Import" link
+
--- 9. Select the CSV file you downloaded previously and click the "Import button
+SELECT
     c.comment_date as date,
-SELECT
+    c.comment_date_gmt as date_gmt,
-    ap.post_id as comment_post_ID,
+    cm.meta_value as rating,
-    r.name as comment_author,
+    c.comment_content as content,
-    r.email as comment_author_email,
+    c.comment_author as name,
-    r.ip_address as comment_author_IP,
+    c.comment_author_email as email,
-    p.post_date as comment_date,
+    c.comment_author_IP as ip_address,
-    p.post_date_gmt as comment_date_gmt,
+    c.comment_approved as is_approved,
-    p.post_content as comment_content,
+    c.comment_post_ID as assigned_posts,
-    r.is_approved as comment_approved,
+    c.user_id as user_id
-    'review' comment_type,
+FROM wp_comments AS c
-    p.post_author as user_id
+INNER JOIN wp_commentmeta AS cm ON c.comment_ID = cm.comment_id
-FROM wp_glsr_ratings AS r
+WHERE 1=1
-INNER JOIN wp_posts AS p ON r.review_id = p.ID
+AND c.comment_type = 'review'
-INNER JOIN wp_glsr_assigned_posts AS ap ON r.ID = ap.rating_id
+AND cm.meta_key = 'rating'
-INNER JOIN wp_posts AS p2 ON ap.post_id = p2.ID
+AND cm.meta_value IS NOT NULL