SELECT "CONTACT"."ORGANISATION_REF", "MEMBER"."MEMBERSHIP_NO", "MEMBER"."JOIN_DATE", "lu_mem_class"."LOOKUP_FULL_DESC", "MEMBERSHIP_GRADE"."DESCRIPTION", "INDIVIDUAL_LOC"."MAIN_LOCATION", "LOCATION"."ADDRESS1", "LOCATION"."ADDRESS2", "LOCATION"."ADDRESS3", "LOCATION"."TOWN", "LOCATION"."COUNTY", "LOCATION"."POSTCODE", "LOCATION"."COUNTRY", "INDIVIDUAL"."TITLE", "INDIVIDUAL"."SURNAME", "TELEPHONE"."STD_CODE", "TELEPHONE"."NUMBER", "EMAIL"."EMAIL_ADDRESS", "TELEPHONE"."MAIN_NUMBER", "EMAIL"."MAIN_EMAIL", "CONTACT"."VALID_FROM", "CONTACT"."CONTACT_STATUS", "CONTACT"."TYPE", "MEMBER"."MEMBER_STATUS", "INDIVIDUAL"."INDIVIDUAL_STATUS", "INDIVIDUAL"."INDIVIDUAL_REF", "INDIVIDUAL"."FAMILY_REF", "MEMBER"."MEMBER_REF", "Contact_old"."VALID_TO", "Org_Old"."COMPANY_NAME", "Org_Old"."TYPE", "Contact_old"."ORGANISATION_REF", "Org_Old"."ORGANISATION_REF", "LOCATION"."COUNTRY_CODE", "INDIVIDUAL"."LABEL_NAME", "ATTRIBUTE"."ATTR_CODE_REF" FROM (((((((((("INTEGRA_Live"."dbo"."CONTACT" "CONTACT" INNER JOIN "INTEGRA_Live"."dbo"."INDIVIDUAL" "INDIVIDUAL" ON "CONTACT"."INDIVIDUAL_REF"="INDIVIDUAL"."INDIVIDUAL_REF") INNER JOIN "INTEGRA_Live"."dbo"."MEMBER" "MEMBER" ON "INDIVIDUAL"."INDIVIDUAL_REF"="MEMBER"."INDIVIDUAL_REF") LEFT OUTER JOIN "INTEGRA_Live"."dbo"."TELEPHONE" "TELEPHONE" ON "INDIVIDUAL"."INDIVIDUAL_REF"="TELEPHONE"."INDIVIDUAL_REF") LEFT OUTER JOIN "INTEGRA_Live"."dbo"."EMAIL" "EMAIL" ON "INDIVIDUAL"."INDIVIDUAL_REF"="EMAIL"."INDIVIDUAL_REF") INNER JOIN "INTEGRA_Live"."dbo"."INDIVIDUAL_LOC" "INDIVIDUAL_LOC" ON "INDIVIDUAL"."INDIVIDUAL_REF"="INDIVIDUAL_LOC"."INDIVIDUAL_REF") INNER JOIN "INTEGRA_Live"."dbo"."CONTACT" "Contact_old" ON "INDIVIDUAL"."INDIVIDUAL_REF"="Contact_old"."INDIVIDUAL_REF") LEFT OUTER JOIN "INTEGRA_Live"."dbo"."ATTRIBUTE" "ATTRIBUTE" ON "INDIVIDUAL"."INDIVIDUAL_REF"="ATTRIBUTE"."INDIVIDUAL_REF") INNER JOIN "INTEGRA_Live"."dbo"."MEMBERSHIP_GRADE" "MEMBERSHIP_GRADE" ON "MEMBER"."MEMBER_GRADE"="MEMBERSHIP_GRADE"."MEMBER_GRADE_REF") INNER JOIN "INTEGRA_Live"."dbo"."LOOKUP" "lu_mem_class" ON ("MEMBER"."MEMBER_CLASS"="lu_mem_class"."LOOKUP_REF") AND ("MEMBERSHIP_GRADE"."CLASS_LOOKUP_REF"="lu_mem_class"."LOOKUP_REF")) INNER JOIN "INTEGRA_Live"."dbo"."LOCATION" "LOCATION" ON "INDIVIDUAL_LOC"."LOCATION_REF"="LOCATION"."LOCATION_REF") INNER JOIN "INTEGRA_Live"."dbo"."ORGANISATION" "Org_Old" ON "Contact_old"."ORGANISATION_REF"="Org_Old"."ORGANISATION_REF" WHERE "INDIVIDUAL_LOC"."MAIN_LOCATION"='Y' AND ("TELEPHONE"."MAIN_NUMBER" IS NULL OR "TELEPHONE"."MAIN_NUMBER"='y') AND "CONTACT"."ORGANISATION_REF"=1 AND ("EMAIL"."MAIN_EMAIL" IS NULL OR "EMAIL"."MAIN_EMAIL"='Y') AND "CONTACT"."CONTACT_STATUS"=1123 AND "CONTACT"."TYPE"=8199 AND "MEMBER"."MEMBER_STATUS"=33 AND ("CONTACT"."VALID_FROM">={ts '2011-06-01 00:00:00'} AND "CONTACT"."VALID_FROM"<{ts '2011-07-21 00:00:00'}) AND "INDIVIDUAL"."INDIVIDUAL_STATUS"=87 AND "Org_Old"."TYPE"=8198 AND ("Contact_old"."VALID_TO" IS NULL AND "Contact_old"."ORGANISATION_REF"=1 OR ("Contact_old"."VALID_TO">={ts '2011-06-01 00:00:00'} AND "Contact_old"."VALID_TO"<{ts '2011-07-21 00:00:00'}) AND "Contact_old"."ORGANISATION_REF"<>1) AND ("ATTRIBUTE"."ATTR_CODE_REF"<>9289 OR "ATTRIBUTE"."ATTR_CODE_REF" IS NULL ) ORDER BY "MEMBER"."JOIN_DATE", "MEMBER"."MEMBER_REF", "INDIVIDUAL"."TITLE", "INDIVIDUAL"."SURNAME", "Contact_old"."VALID_TO" DESC