What is your Super Power?

[ohiosmith]

I can flip an over-medium egg without breaking the yolk.

[mikeytherat]

1. I can crack eggs 4 at a time (2 in each hand)

I knew that McDonald's training would pay off one day!

mikey_the_rat

[ohiosmith]

4. Super-Super Power.

[u4ic]

2. I have the evil eye

[ohiosmith]

5. and.....

[EFerrari]

3. Animals spill their secrets to me. Some plants, too.

lol

[ohiosmith]

15. Beware of chrysanthemums and gerbils. Both are notorious liars.

[taterguy]

6. I can make seconds feel like hours

[Throd]

7. I can lose my car keys in 10 seconds

Anywhere, anytime.

[johnnie]

8. I can irritate someone in seconds

It's a gift really :)

[Dora]

9. I can make a lattice-top pie without anxiety.

Look out. I'm dangerous.

[ThomCat]

10. I can dance on crutches.

:)

[LSK]

11. I can solve almost any IT problem at my job

Except routers. Never got into that.

[ChickMagic]

12. I have a titanium exoskeleton

with plasma rifles mounted on the shoulders. Bring it on Freeptards!

[MAGICBULLET]

13. I'm a barber

I cut hair with my feet. I can teleport too.

[mainegreen]

14. I can look at this without going blind

SELECT SOURCE.INT_LINE_ITEM_ID, SOURCE.SOURCE_PK, E_VD.INT_VENDOR_ID, SOURCE.INT_MEMBER_ID, SOURCE.INT_PERSON_ID, SOURCE.FLT_MAXIMUM_ALLOWED, E_VD.TXT_VENDOR_NAME AS TXT_REMIT_NAME, E_VDL.TXT_ADDR1 AS TXT_REMIT_ADDR1, E_VDL.TXT_ADDR2 AS TXT_REMIT_ADDR2, E_VDL.TXT_ADDR3 AS TXT_REMIT_ADDR3, E_VDL.TXT_CITY AS TXT_REMIT_CITY, E_VDL.INT_STATE_ID AS INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, E_VDL.TXT_ZIP_5 AS TXT_REMIT_ZIP_5, E_VDL.TXT_ZIP_4 AS TXT_REMIT_ZIP_4, E_VDL.TXT_ZIP_INTL AS TXT_REMIT_ZIP_INTL, E_VDL.TXT_COUNTRY AS TXT_REMIT_COUNTRY, SOURCE.INT_VENDOR_ID AS INT_LIEN_ORIG_VENDOR_ID FROM (SELECT * FROM (( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, F_PAYMENTS.INT_VENDOR_ID, F_PAYMENTS.INT_MEMBER_ID, F_PAYMENTS.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_PAYMENTS INNER JOIN F_LINE_ITEM ON F_PAYMENTS.INT_PAYMENT_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_PAYMENTS.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_PAYMENTS.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_PAYMENTS.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_PAYMENTS.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_PAYMENTS.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE (F_PAYMENTS.INT_VENDOR_ID IS NOT NULL OR F_PAYMENTS.INT_MEMBER_ID IS NOT NULL OR F_PAYMENTS.INT_PERSON_ID IS NOT NULL) AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, F_RECOVERY.INT_VENDOR_ID, F_RECOVERY.INT_MEMBER_ID, F_RECOVERY.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_RECOVERY INNER JOIN F_LINE_ITEM ON F_RECOVERY.INT_RECOVERY_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_RECOVERY.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_RECOVERY.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_RECOVERY.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_RECOVERY.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_RECOVERY.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE (F_RECOVERY.INT_VENDOR_ID IS NOT NULL OR F_RECOVERY.INT_MEMBER_ID IS NOT NULL OR F_RECOVERY.INT_PERSON_ID IS NOT NULL) AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, F_INVOICE.INT_VENDOR_ID, NULL AS INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_INVOICE INNER JOIN F_LINE_ITEM ON F_INVOICE.INT_INVOICE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_INVOICE.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_INVOICE.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_INVOICE.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN L_STATES ON F_INVOICE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_INVOICE.INT_VENDOR_ID IS NOT NULL AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(E_VENDOR.TXT_VENDOR_NAME,'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(E_VENDOR_LOCATION.TXT_CITY,'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, NULL AS INT_VENDOR_ID, F_DEDUCTIBLE.INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_DEDUCTIBLE INNER JOIN F_LINE_ITEM ON F_DEDUCTIBLE.INT_DEDUCTIBLE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_MEMBER ON F_DEDUCTIBLE.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN L_STATES ON F_DEDUCTIBLE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_DEDUCTIBLE.INT_MEMBER_ID IS NOT NULL AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(E_MEMBER.TXT_MEMBER_NAME,'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(E_MEMBER.TXT_ADDR1,'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(E_MEMBER.TXT_ADDR2,'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(E_MEMBER.TXT_CITY,'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(E_MEMBER.INT_STATE_ID,'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_PAYMENTS.INT_PAYMENT_ID AS SOURCE_PK, F_PAYMENTS.INT_VENDOR_ID, F_PAYMENTS.INT_MEMBER_ID, F_PAYMENTS.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_PAYMENTS INNER JOIN F_LINE_ITEM ON F_PAYMENTS.INT_PAYMENT_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_PAYMENTS.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_PAYMENTS.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_PAYMENTS.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_PAYMENTS.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_PAYMENTS.INT_REMIT_STATE_ID = L_STATES.INT_STATE_ID WHERE (F_PAYMENTS.INT_VENDOR_ID IS NOT NULL OR F_PAYMENTS.INT_MEMBER_ID IS NOT NULL OR F_PAYMENTS.INT_PERSON_ID IS NOT NULL) AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'')) AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_RECOVERY.INT_RECOVERY_ID AS SOURCE_PK, F_RECOVERY.INT_VENDOR_ID, F_RECOVERY.INT_MEMBER_ID, F_RECOVERY.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_RECOVERY INNER JOIN F_LINE_ITEM ON F_RECOVERY.INT_RECOVERY_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_RECOVERY.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_RECOVERY.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_RECOVERY.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_RECOVERY.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_RECOVERY.INT_REMIT_STATE_ID = L_STATES.INT_STATE_ID WHERE (F_RECOVERY.INT_VENDOR_ID IS NOT NULL OR F_RECOVERY.INT_MEMBER_ID IS NOT NULL OR F_RECOVERY.INT_PERSON_ID IS NOT NULL) AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'')) AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_INVOICE.INT_INVOICE_ID AS SOURCE_PK, F_INVOICE.INT_VENDOR_ID, NULL AS INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_INVOICE INNER JOIN F_LINE_ITEM ON F_INVOICE.INT_INVOICE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_INVOICE.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_INVOICE.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_INVOICE.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN L_STATES ON F_INVOICE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_INVOICE.INT_VENDOR_ID IS NOT NULL AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(E_VENDOR.TXT_VENDOR_NAME,'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(E_VENDOR_LOCATION.TXT_CITY,'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,'')) AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_DEDUCTIBLE.INT_DEDUCTIBLE_ID AS SOURCE_PK, NULL AS INT_VENDOR_ID, F_DEDUCTIBLE.INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_DEDUCTIBLE INNER JOIN F_LINE_ITEM ON F_DEDUCTIBLE.INT_DEDUCTIBLE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_MEMBER ON F_DEDUCTIBLE.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN L_STATES ON F_DEDUCTIBLE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_DEDUCTIBLE.INT_MEMBER_ID IS NOT NULL AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(E_MEMBER.TXT_MEMBER_NAME,'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(E_MEMBER.TXT_ADDR1,'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(E_MEMBER.TXT_ADDR2,'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(E_MEMBER.TXT_CITY,'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(E_MEMBER.INT_STATE_ID,'')) AND INT_LOCKED_BY=1219 )) AS SOURCE ORDER BY SOURCE_PK, INT_VENDOR_ID, INT_MEMBER_ID, INT_PERSON_ID) AS SOURCE INNER JOIN E_VENDOR AS E_VS ON SOURCE.INT_VENDOR_ID=E_VS.INT_VENDOR_ID INNER JOIN E_VENDOR AS E_VD ON E_VS.INT_LIEN_VENDOR_ID=E_VD.INT_VENDOR_ID INNER JOIN E_VENDOR_LOCATION AS E_VDL ON E_VS.INT_LIEN_LOCATION_ID=E_VDL.INT_LOCATION_ID LEFT OUTER JOIN L_STATES ON E_VDL.INT_STATE_ID=L_STATES.INT_STATE_ID WHERE E_VS.BLN_LIEN=1 UNION ALL SELECT SOURCE.*, NULL AS INT_LIEN_ORIG_VENDOR_ID FROM (SELECT * FROM (( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, F_PAYMENTS.INT_VENDOR_ID, F_PAYMENTS.INT_MEMBER_ID, F_PAYMENTS.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_PAYMENTS INNER JOIN F_LINE_ITEM ON F_PAYMENTS.INT_PAYMENT_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_PAYMENTS.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_PAYMENTS.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_PAYMENTS.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_PAYMENTS.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_PAYMENTS.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE (F_PAYMENTS.INT_VENDOR_ID IS NOT NULL OR F_PAYMENTS.INT_MEMBER_ID IS NOT NULL OR F_PAYMENTS.INT_PERSON_ID IS NOT NULL) AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, F_RECOVERY.INT_VENDOR_ID, F_RECOVERY.INT_MEMBER_ID, F_RECOVERY.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_RECOVERY INNER JOIN F_LINE_ITEM ON F_RECOVERY.INT_RECOVERY_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_RECOVERY.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_RECOVERY.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_RECOVERY.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_RECOVERY.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_RECOVERY.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE (F_RECOVERY.INT_VENDOR_ID IS NOT NULL OR F_RECOVERY.INT_MEMBER_ID IS NOT NULL OR F_RECOVERY.INT_PERSON_ID IS NOT NULL) AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, F_INVOICE.INT_VENDOR_ID, NULL AS INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_INVOICE INNER JOIN F_LINE_ITEM ON F_INVOICE.INT_INVOICE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_INVOICE.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_INVOICE.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_INVOICE.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN L_STATES ON F_INVOICE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_INVOICE.INT_VENDOR_ID IS NOT NULL AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(E_VENDOR.TXT_VENDOR_NAME,'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(E_VENDOR_LOCATION.TXT_CITY,'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, -1 AS SOURCE_PK, NULL AS INT_VENDOR_ID, F_DEDUCTIBLE.INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_DEDUCTIBLE INNER JOIN F_LINE_ITEM ON F_DEDUCTIBLE.INT_DEDUCTIBLE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_MEMBER ON F_DEDUCTIBLE.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN L_STATES ON F_DEDUCTIBLE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_DEDUCTIBLE.INT_MEMBER_ID IS NOT NULL AND IFNULL(TXT_REMIT_NAME,'')=IFNULL(E_MEMBER.TXT_MEMBER_NAME,'') AND IFNULL(TXT_REMIT_ADDR1,'')=IFNULL(E_MEMBER.TXT_ADDR1,'') AND IFNULL(TXT_REMIT_ADDR2,'')=IFNULL(E_MEMBER.TXT_ADDR2,'') AND IFNULL(TXT_REMIT_CITY,'')=IFNULL(E_MEMBER.TXT_CITY,'') AND IFNULL(INT_REMIT_STATE_ID,'')=IFNULL(E_MEMBER.INT_STATE_ID,'') AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_PAYMENTS.INT_PAYMENT_ID AS SOURCE_PK, F_PAYMENTS.INT_VENDOR_ID, F_PAYMENTS.INT_MEMBER_ID, F_PAYMENTS.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_PAYMENTS INNER JOIN F_LINE_ITEM ON F_PAYMENTS.INT_PAYMENT_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_PAYMENTS.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_PAYMENTS.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_PAYMENTS.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_PAYMENTS.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_PAYMENTS.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_PAYMENTS.INT_REMIT_STATE_ID = L_STATES.INT_STATE_ID WHERE (F_PAYMENTS.INT_VENDOR_ID IS NOT NULL OR F_PAYMENTS.INT_MEMBER_ID IS NOT NULL OR F_PAYMENTS.INT_PERSON_ID IS NOT NULL) AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'')) AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_RECOVERY.INT_RECOVERY_ID AS SOURCE_PK, F_RECOVERY.INT_VENDOR_ID, F_RECOVERY.INT_MEMBER_ID, F_RECOVERY.INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_RECOVERY INNER JOIN F_LINE_ITEM ON F_RECOVERY.INT_RECOVERY_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_RECOVERY.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_RECOVERY.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN E_MEMBER ON F_RECOVERY.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN C_EVENT_PERSON ON F_RECOVERY.INT_PERSON_ID=C_EVENT_PERSON.INT_PERSON_ID AND F_RECOVERY.INT_CLAIM_ID=C_EVENT_PERSON.INT_CLAIM_ID LEFT OUTER JOIN L_STATES ON F_RECOVERY.INT_REMIT_STATE_ID = L_STATES.INT_STATE_ID WHERE (F_RECOVERY.INT_VENDOR_ID IS NOT NULL OR F_RECOVERY.INT_MEMBER_ID IS NOT NULL OR F_RECOVERY.INT_PERSON_ID IS NOT NULL) AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(IFNULL(E_VENDOR.TXT_VENDOR_NAME,IFNULL(E_MEMBER.TXT_MEMBER_NAME,CONCAT(C_EVENT_PERSON.TXT_NAME_FIRST,CONCAT(' ',C_EVENT_PERSON.TXT_NAME_LAST)))),'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,IFNULL(E_MEMBER.TXT_ADDR1,C_EVENT_PERSON.TXT_ADDR1)),'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,IFNULL(E_MEMBER.TXT_ADDR2,C_EVENT_PERSON.TXT_ADDR2)),'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.TXT_CITY,IFNULL(E_MEMBER.TXT_CITY,C_EVENT_PERSON.TXT_CITY)),'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,IFNULL(E_MEMBER.INT_STATE_ID,C_EVENT_PERSON.INT_STATE_ID)),'')) AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_INVOICE.INT_INVOICE_ID AS SOURCE_PK, F_INVOICE.INT_VENDOR_ID, NULL AS INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_INVOICE INNER JOIN F_LINE_ITEM ON F_INVOICE.INT_INVOICE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_VENDOR ON F_INVOICE.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID LEFT OUTER JOIN E_VENDOR_LOCATION ON F_INVOICE.INT_VENDOR_ID=E_VENDOR_LOCATION.INT_VENDOR_ID AND F_INVOICE.INT_LOCATION_ID=E_VENDOR_LOCATION.INT_LOCATION_ID LEFT OUTER JOIN L_STATES ON F_INVOICE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_INVOICE.INT_VENDOR_ID IS NOT NULL AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(E_VENDOR.TXT_VENDOR_NAME,'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(E_VENDOR_LOCATION.TXT_ADDR1,'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(E_VENDOR_LOCATION.TXT_ADDR2,'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(E_VENDOR_LOCATION.TXT_CITY,'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(E_VENDOR_LOCATION.INT_STATE_ID,'')) AND INT_LOCKED_BY=1219 ) UNION ( SELECT INT_LINE_ITEM_ID, F_DEDUCTIBLE.INT_DEDUCTIBLE_ID AS SOURCE_PK, NULL AS INT_VENDOR_ID, F_DEDUCTIBLE.INT_MEMBER_ID, NULL AS INT_PERSON_ID, FLT_MAXIMUM_ALLOWED, TXT_REMIT_NAME, TXT_REMIT_ADDR1, TXT_REMIT_ADDR2, TXT_REMIT_ADDR3, TXT_REMIT_CITY, INT_REMIT_STATE_ID, L_STATES.TXT_STATE_SCODE AS TXT_REMIT_STATE_SCODE, TXT_REMIT_ZIP_5, TXT_REMIT_ZIP_4, TXT_REMIT_ZIP_INTL, TXT_REMIT_COUNTRY FROM F_DEDUCTIBLE INNER JOIN F_LINE_ITEM ON F_DEDUCTIBLE.INT_DEDUCTIBLE_ID=F_LINE_ITEM.INT_PARENT_ID LEFT OUTER JOIN E_MEMBER ON F_DEDUCTIBLE.INT_MEMBER_ID=E_MEMBER.INT_MEMBER_ID LEFT OUTER JOIN L_STATES ON F_DEDUCTIBLE.INT_REMIT_STATE_ID=L_STATES.INT_STATE_ID WHERE F_DEDUCTIBLE.INT_MEMBER_ID IS NOT NULL AND (IFNULL(TXT_REMIT_NAME,'')<>IFNULL(E_MEMBER.TXT_MEMBER_NAME,'') OR IFNULL(TXT_REMIT_ADDR1,'')<>IFNULL(E_MEMBER.TXT_ADDR1,'') OR IFNULL(TXT_REMIT_ADDR2,'')<>IFNULL(E_MEMBER.TXT_ADDR2,'') OR IFNULL(TXT_REMIT_CITY,'')<>IFNULL(E_MEMBER.TXT_CITY,'') OR IFNULL(INT_REMIT_STATE_ID,'')<>IFNULL(E_MEMBER.INT_STATE_ID,'')) AND INT_LOCKED_BY=1219 )) AS SOURCE ORDER BY SOURCE_PK, INT_VENDOR_ID, INT_MEMBER_ID, INT_PERSON_ID) AS SOURCE LEFT OUTER JOIN E_VENDOR ON SOURCE.INT_VENDOR_ID=E_VENDOR.INT_VENDOR_ID WHERE E_VENDOR.BLN_LIEN=0 OR SOURCE.INT_VENDOR_ID IS NULL

[Guava Jelly]

16. I can turn Wine into Water

(warm slightly yellow water) :hide: I know TMI
:rofl:

[Pacifist Patriot]

17. I can post at DU, watch Charmed, nurse a hot toddy and ignore my kids...

all while thinking about how not to have to make dinner and print sudoku puzzles.