SELECT SQL_CACHE SQL_CALC_FOUND_ROWS products.id, products.catid, products.title, products.ph1, products.lat, products.lng, products.address, products.phone, place.f3, products.stars_avg AS total_stars, IFNULL(reviews.id, 0) as revid, club.secure, club.filo, club.user, reviews.comments, reviews.date, products_stats.total_reviews FROM products INNER JOIN categories ON categories.catid = products.catid LEFT JOIN place ON products.place = place.f2 LEFT JOIN products_stats on products.id = products_stats.prodid LEFT JOIN reviews on reviews.id = products_stats.last_review_id LEFT JOIN club on club.id = reviews.userid WHERE products.country = 1 AND categories.top_cat LIKE '%<340>%' ORDER BY total_stars DESC LIMIT 0, 10