Select
				content_type_trip.nid,
				content_type_trip.field_price_value,
				content_type_trip.field_seats_available_value,
				content_type_trip.field_jod_price_value,
				content_field_deposit_amount_jod.field_deposit_amount_jod_value as depo_jod,
				content_field_deposit_amount_usd.field_deposit_amount_usd_value as depo_usd,
				content_field_deposit_deadline.field_deposit_deadline_value as depo_days,
				content_field_payment_deadline.field_payment_deadline_value as full_days,
				content_field_allow_deposit.field_allow_deposit_value as allow_deposit,
				field_service_activity_day_value as days,
				field_service_activity_location_nid as location,
				field_service_activity_nid as service_activity,
				field_guide_1_nid as guide1,
				field_guide_1_role_nid as guide1role,
				field_guide_2_nid as guide2,
				field_guide_2_role_nid as guide2role,
				field_guide_3_nid as guide3,
				field_guide_3_role_nid as guide3role,
				field_guide_4_nid as guide4,
				field_guide_4_role_nid as guide4role,
				field_notes_value as notes
			From content_type_trip
				LEFT Join content_field_deposit_amount_jod ON content_field_deposit_amount_jod.nid = content_type_trip.nid
				LEFT Join content_field_deposit_amount_usd ON content_field_deposit_amount_usd.nid = content_type_trip.nid
				LEFT Join content_field_deposit_deadline ON content_field_deposit_deadline.nid = content_type_trip.nid
				LEFT Join content_field_payment_deadline ON content_field_payment_deadline.nid = content_type_trip.nid
				LEFT Join content_field_allow_deposit ON content_field_allow_deposit.nid = content_type_trip.nid
				LEFT Join content_type_license_guide_underground ON content_type_license_guide_underground.nid = content_type_trip.nid