API tools faq
paste
keeblebrox

Full Query

keeblebrox
May 4th, 2012
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.16 KB | None | 0 0
raw download clone embed print report
  1. SELECT
  2.     (0, EMAIL_FLAGS, BIRTH_YEAR, BIRTH_MONTH, BIRTH_DAY, GENDER_ID, SEGMENT_ID, LANGUAGE_ID, WHEN_ENTERED, WHEN_RENEW, WHEN_ADR3START, WHEN_ADR3END, PERSONSOURCE_ID, TIMEZONE_ID, USE_ADDRESS2, USE_ADDRESS3AGAIN, WHEN_UPDATED, NAME_LAST, NAME_FIRST, NAME_TITLE, NAME_SUFFIX, LETTER_SALUTATION, INFORMAL_LETTER_SALUTATION, NOTES, NOTESB, NOTE_ALERT, ADDRESS1_SALUTATION, ADDRESS1_STREETA, ADDRESS1_STREETB, ADDRESS1_CITY, ADDRESS1_STATE, ADDRESS1_COUNTRY, ADDRESS1_POSTALCODE, ADDRESS1_PHONE, ADDRESS1_APARTMENT, ADDRESS1_CELLPHONE, ADDRESS1_PHONEEXT, ADDRESS1_FAX, ADDRESS1_EMAIL, ADDRESS1_WEBSITE, ADDRESS2_SALUTATION, ADDRESS2_TITLE, ADDRESS2_DEPARTMENT, ADDRESS2_ORGANIZATION, ADDRESS2_STREETA, ADDRESS2_STREETB, ADDRESS2_CITY, ADDRESS2_STATE, ADDRESS2_COUNTRY, ADDRESS2_POSTALCODE, ADDRESS2_PHONE, ADDRESS2_PHONEEXT, ADDRESS2_APARTMENT, ADDRESS2_CELLPHONE, ADDRESS2_FAX, ADDRESS2_FAX2, ADDRESS2_EMAIL, ADDRESS2_WEBSITE, NAME_MID, USER_LOGIN_NAME, ANNUAL_RECEIPT, DECEASED, MOVED, SENSITIVE_CONTACT, INACTIVE_CONTACT, NOT_RECEIPTABLE, DEF_RECOGNITION, LANGUAGE2_ID, ADDRESS1_PHONE2, ADDRESS1_PHONE2EXT, ADDRESS1_EMAIL2, ADDRESS2_EMAIL2, ADDRESS2_PHONE2, ADDRESS2_PHONE2EXT, ASST_NAME, ASST_PHONE, ASST_FAX, ASST_EMAIL, ADDRESS3_APARTMENT, ADDRESS3_CELLPHONE, ADDRESS3_CITY, ADDRESS3_COUNTRY, ADDRESS3_EMAIL, ADDRESS3_FAX, ADDRESS3_PHONE, ADDRESS3_PHONEEXT, ADDRESS3_POSTALCODE, ADDRESS3_SALUTATION, ADDRESS3_STATE, ADDRESS3_STREETA, ADDRESS3_STREETB, FR_FUNDER_TYPE, FR_FY_START, FR_FY_END, FR_ASSETS, FR_NOTES, FR_BOARD, FR_ANNUAL_DISTN, MD_TITLE, MD_PHONE, MD_PHONEEXT, MD_EMAIL, MD_INCLUDE, PORTRAIT)
  3. FROM
  4.     cfr_person
  5. WHERE ID=1
  6. UNION ALL
  7. SELECT
  8.     (1, PERSONTYPE_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  9. FROM
  10.     cfr_person_persontype
  11. WHERE PERSON_ID=1
  12. UNION ALL
  13. SELECT
  14.     (2, VOLUNTEERTYPE_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  15. FROM
  16.     cfr_person_volunteertype
  17. WHERE PERSON_ID=1
  18. UNION ALL
  19. SELECT
  20.     (3, COMMTYPE_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  21. FROM
  22.     cfr_person_commtype
  23. WHERE PERSON_ID=1
  24. UNION ALL
  25. SELECT
  26.     (4, FACT_TYPE_ID, ID, PERSON_ID, NOTES_A, NOTES_B, NOTES_C, NOTES_D, WHEN_UPDATED, USER_LOGIN_NAME, CONTACT_A, CONTACT_B, STRING_A, STRING_B, CURRENCY_A, COUNT_A, COUNT_B, COUNT_C, DATE_A, DATE_B, TIME_A, TIME_B, DAY_OF_WEEK, LL_VALUE_A, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  27. FROM
  28.     cfr_fact
  29. WHERE PERSON_ID=1
  30. UNION ALL
  31. SELECT
  32.     (5, RELATIONTYPE_ID, PERSON_ID1, PERSON_ID2, NOTES, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  33. FROM
  34.     cfr_relation
  35. WHERE PERSON_ID1=1 OR PERSON_ID2=1
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!