// Total Pieces
$stats_totalpieces = @$DB_site->query_first("
SELECT COUNT(*) AS count
FROM prs_pieces
");
// Total Reviews
$stats_totalreviews = @$DB_site->query_first("
SELECT COUNT(*) AS count
FROM prs_reviews
");
// Average Rating
$stats_avgrate = @$DB_site->query_first("
SELECT AVG(rating) AS avg
FROM prs_rating
");
// Top Rated Piece
$stats_toprated = @$DB_site->query_first("
SELECT COUNT(prs_ratings.rating) AS count, *
FROM prs_ratings
LEFT JOIN prs_pieces ON (prs_pieces.pieceid = prs_rating.pieceid)
ORDER BY count
DESC LIMIT 1
");
// might need to change this into a quick query of select from piece 'review_count' order by review count
// Top Reviewed
$stats_topreviewed = @$DB_site->query_first("
SELECT COUNT(prs_reviews.pagetext) AS count, *
FROM prs_reviews
LEFT JOIN prs_pieces ON (prs_pieces.pieceid = prs_reviews.pieceid)
ORDER BY count
DESC LIMIT 1
");
// Top Viewed
$stats_topviewed = @$DB_site->query_first("
SELECT *
FROM prs_views
ORDER BY views
DESC LIMIT 1
");
// Top Poster
$stats_topposter = @$DB_site->query_first("
SELECT *
FROM prs_user
ORDER BY pieces DESC
LIMIT 1
");
// Top Reviewer
$stats_topreviewer = @$DB_site->query_first("
SELECT *
FROM prs_user
ORDER BY reviews DESC
LIMIT 1
");