$latestconfession = $DB_site->query_first (" SELECT COUNT(*) AS votes, confessions.confessionid, confessions.visible, confessions.text, confession_rate.rate, user.username FROM confessions LEFT JOIN confession_rate ON (confessions.confessionid = confession_rate.confessionid) LEFT JOIN user ON (user.userid = confessions.userid) WHERE confessions.visible = 1 GROUP BY confessions.confessionid ORDER BY confessions.confessionid DESC LIMIT 1 ");