$stmt = $pdo->prepare("SELECT m.*, u.username as sender_name FROM messages m 
                       JOIN users u ON m.sender_id = u.id 
                       WHERE m.receiver_id = ? ORDER BY m.created_at DESC LIMIT 5");
$stmt->execute([$user_id]);
$recent_messages = $stmt->fetchAll();
=======
// Get recent messages (simplified query without inquiries join)
$stmt = $pdo->prepare("SELECT m.*, u.username as sender_name FROM messages m
                       JOIN users u ON m.sender_id = u.id
                       WHERE m.receiver_id = ? ORDER BY m.created_at DESC LIMIT 5");
$stmt->execute([$user_id]);
$recent_messages = $stmt->fetchAll();

// Get user's favorite listings
$stmt = $pdo->prepare("SELECT l.*, m.name as mineral_name, u.username, u.company_name, u.country as seller_country,
                       u.verification_status as seller_verified, f.created_at as favorited_at
                       FROM favorites f
                       LEFT JOIN listings l ON f.listing_id = l.id
                       LEFT JOIN minerals m ON l.mineral_id = m.id
                       LEFT JOIN users u ON l.seller_id = u.id
                       WHERE f.user_id = ? AND l.listing_status = 'published'
                       ORDER BY f.created_at DESC LIMIT 5");
$stmt->execute([$user_id]);
$favorite_listings = $stmt->fetchAll();

// Get favorites count
$stmt = $pdo->prepare("SELECT COUNT(*) as count FROM favorites WHERE user_id = ?");
$stmt->execute([$user_id]);
$result = $stmt->fetch();
$favorites_count = $result['count'] ?? 0;