Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql-temptable-43f4-a7057-3a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /home/joshyouth84/public_html/wp-includes/class-wpdb.php on line 2187
WordPress database error: [Disk full (/tmp/#sql-temptable-43f4-a7057-3a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT
COUNT(*) AS aggregate_count, AVG(tmp2.rating) AS aggregate_rating
FROM (
SELECT pm4.meta_value AS rating
FROM (
SELECT DISTINCT pm2.post_id
FROM wp_posts p1
INNER JOIN wp_postmeta pm2 ON pm2.meta_key = 'wpcr3_review_post' AND pm2.meta_value = p1.id
WHERE p1.id = 3576
) tmp1
INNER JOIN wp_posts p2 ON p2.id = tmp1.post_id AND p2.post_status = 'publish' AND p2.post_type = 'wpcr3_review'
INNER JOIN wp_postmeta pm4 ON pm4.post_id = p2.id AND pm4.meta_key = 'wpcr3_review_rating' AND pm4.meta_value IS NOT NULL AND pm4.meta_value != '0'
GROUP BY p2.id
) tmp2
