Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT retreats.retreat_id,
- AVG(review_total_rating) AS retreat_total_rating,
- AVG(review_cost) AS total_review_cost,
- retreat_logo,
- retreat_name,
- retreat_website,
- retreat_facebook,
- retreat_instagram,
- retreat_verified,
- retreat_location,
- retreat_founded_in,
- retreat_approved,
- count(reviews.retreat_id) as retreat_number_of_reviews
- FROM retreats
- LEFT JOIN reviews
- ON retreats.retreat_id = reviews.retreat_id
- WHERE retreat_approved = 1
- GROUP BY retreats.retreat_id
- ORDER BY 'total_review_cost' DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement