SELECT caravans.*,phone,realname,email,users.ID userID FROM caravans JOIN uc_link on caravans.ID = caravanID JOIN users on users.ID = userID WHERE caravans.ID =