SELECT DISTINCT lodges.LodgeID , Lodge , profile_photo_one , Activity , GSG_Listing , GSG_URL , GSG_Submit , GSG_Publish , Product_Type , profile_intro , Visible FROM lodges INNER JOIN lodge_activities_it ON lodges.LodgeID = lodge_activities_it.LodgeID INNER JOIN lodge_activities ON lodge_activities.ActivityID = lodge_activities_it.ActivityID INNER JOIN product_profiles ON lodges.LodgeID = product_profiles.LodgeID INNER JOIN product_other_images ON lodges.LodgeID = product_other_images.LodgeID INNER JOIN product_users ON lodges.LodgeID = product_users.LodgeIDIT WHERE Activity = 'Zimbabwe' AND profile_intro > '' AND profile_photo_one > '' AND Visible = 'Yes' AND (Product_Type = 'Property' OR Product_Type = 'Mobile Safari') ORDER BY Lodge