query(" SELECT p.id, p.title, p.file_path, p.thumbnail_path, p.type, p.nsfw, p.camera_model, p.gps_lat, p.gps_lng, p.location_region, p.created_at, GROUP_CONCAT(t.name) AS tags, u.username, u.id AS user_id FROM posts p JOIN users u ON p.user_id = u.id LEFT JOIN post_tags pt ON p.id = pt.post_id LEFT JOIN tags t ON pt.tag_id = t.id GROUP BY p.id ORDER BY p.id DESC "); $posts = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> Admin Moderation

Admin Moderation Panel

Preview	Info	Metadata	Actions
	by	Camera: GPS: , View on Maps Region: Tags: #	Edit Post