An example query to export GD Ratings & Reviews via database.
Estimated reading time: 1 minute
This example assumes a working knowledge of phpMyAdmin, MySQL databases and SQL queries, use at your own risk.
SELECT s01_GD_Ratings_Product_Reviews.title AS TITLE, s01_GD_Ratings_Product_Reviews.overall AS RATING, s01_GD_Ratings_Product_Reviews.summary AS SUMMARY, s01_GD_Ratings_Product_Reviews.recommended AS RECOMMENDED, s01_Products.code AS PRODUCT_CODE, s01_GD_Ratings_Product_Reviews.approved AS APPROVED, s01_GD_Ratings_Product_Reviews.created_at AS CREATED_AT, s01_GD_Ratings_Users.nickname AS USER_NICKNAME, s01_GD_Ratings_Users.email AS USER_EMAIL, s01_GD_Ratings_Users.location AS USER_LOCATION FROM s01_GD_Ratings_Product_Reviews LEFT JOIN s01_Products ON s01_GD_Ratings_Product_Reviews.product_id = s01_Products.id LEFT JOIN s01_GD_Ratings_Users ON s01_GD_Ratings_Product_Reviews.id = s01_GD_Ratings_Users.id WHERE s01_Products.id IS NOT NULL
** Have questions or need assistance with your Miva store? Contact us today!