SQL запрос получения списка товаров с адресами и рейтингом

SELECT CONCAT(‘https://site.name/product/’,pm1.post_name) as PRODUCT_URL,pm1.ID as PRODUCT_ID,AVG(pm.meta_value) as AVERAGE_RATING, pm1.comment_count as COMMENT_COUNT FROM in_comments as p
INNER JOIN in_commentmeta as pm ON p.comment_ID = pm.comment_id
INNER JOIN in_posts as pm1 ON p.comment_post_ID = pm1.ID
INNER JOIN in_postmeta as pm2 ON p.comment_post_ID = pm2.post_id
WHERE p.comment_approved = 1
AND pm.meta_key = ‘rating’
AND pm1.post_type LIKE ‘product’
AND pm1.post_status LIKE ‘publish’
AND pm1.post_parent = ‘0’
AND pm2.meta_key LIKE ‘_stock_status’
group by pm1.ID desc
ORDER BY AVERAGE_RATING DESC