Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. SELECT retreats.retreat_id,
  2. AVG(review_total_rating) AS retreat_total_rating,
  3. AVG(review_cost) AS total_review_cost,
  4. retreat_logo,
  5. retreat_name,
  6. retreat_website,
  7. retreat_facebook,
  8. retreat_instagram,
  9. retreat_verified,
  10. retreat_location,
  11. retreat_founded_in,
  12. retreat_approved,
  13. count(reviews.retreat_id) as retreat_number_of_reviews
  14. FROM retreats
  15. LEFT JOIN reviews
  16. ON retreats.retreat_id = reviews.retreat_id
  17. WHERE retreat_approved = 1
  18. GROUP BY retreats.retreat_id
  19. ORDER BY 'total_review_cost' DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement