Advertisement
Guest User

Untitled

a guest
May 29th, 2017
749
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.90 KB | None | 0 0
  1. root@localhost:~
  2. -> mysql simplifymd_production
  3. Reading table information for completion of table and column names
  4. You can turn off this feature to get a quicker startup with -A
  5.  
  6. Welcome to the MySQL monitor. Commands end with ; or \g.
  7. Your MySQL connection id is 8
  8. Server version: 5.0.88-community MySQL Community Edition (GPL)
  9.  
  10. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  11.  
  12. mysql> select
  13. -> concat(p.first_name,', ',p.last_name) as 'Name (Last, First)',
  14. -> c0.address as 'Email Address',
  15. -> c1.phone_number as 'Home Phone',
  16. -> c2.phone_number as 'Mobile Phone',
  17. -> concat(c3.address,', ',c3.state_abbreviation,' ',c3.postal_code) as 'Postal Address'
  18. -> from party p
  19. -> left join communication_channel c0 on c0.type='EmailAddress' and c0.party_id=p.id
  20. -> left join communication_channel c1 on c1.phone_number_type_id=1 and c1.party_id=p.id
  21. -> left join communication_channel c2 on c2.phone_number_type_id=14 and c2.party_id=p.id
  22. -> left join communication_channel c3 on c3.type='PostalAddress' and c3.party_id=p.id
  23. -> where p.type='Patient';
  24. +--------------------+--------------------------------+--------------+--------------+----------------------------------+
  25. | Name (Last, First) | Email Address | Home Phone | Mobile Phone | Postal Address |
  26. +--------------------+--------------------------------+--------------+--------------+----------------------------------+
  27. | Emma, Peel | emma.peel.sMD@gmail.com | 770-965-1122 | 770-965-2255 | 831 Arlene Ave., GA 30071 |
  28. | Martha, Smith | martha.smith.sMD@gmail.com | 678-965-5431 | 706-765-3877 | 6538 West Dover, GA 30024 |
  29. | Richard, Johnson | richard.johnson.sMD@gmail.com | 770-429-5243 | 770-981-9821 | 215 Wilson St., GA 30040 |
  30. | Jackie, Roberts | jackie.roberts.sMD@hotmail.com | 404-556-8734 | 219-998-0265 | 4190 Park Place, GA 30269 |
  31. | Timothy, Burnett | NULL | 770-456-3920 | NULL | 3436 Phillips Ave., GA 30281 |
  32. | Kimberly, Wellman | kimberly.wellman.sMD@gmail.com | 770-898-2457 | 219-766-5541 | 1128 S. St. Rd. 49, GA 39870 |
  33. | Lee, Adams | NULL | 770-879-2354 | 770-932-4040 | 7543 Summer Dr., GA 30004 |
  34. | Mary Anne, Jones | NULL | 770-998-4231 | 219-874-3498 | 575 East Ridge Road, GA 30281 |
  35. | Cam, Piaz | NULL | 312-755-5588 | NULL | 87063 Westbrook Place, GA 30337 |
  36. | Candice, Harper | candice.harper.sMD@gmail.com | 219-998-2211 | 219-996-2020 | 7765 Highbrook Ct., GA 30252 |
  37. | Angela, Mason | hlinak@gmail.com | 455-663-1190 | 456-663-1110 | 1285 Hodges Lane, GA 30075 |
  38. | Brandon, Willis | brandon.willis.sMD@gmail.com | 489-232-1595 | 480-232-7385 | 967 Lake Hills Dr., GA 30062 |
  39. | Ginny, Smith | numeraltwo@yahoo.com | 956-548-5000 | 956-546-4021 | 8 Finnigan Trail, TX 78520 |
  40. | June, Murray | NULL | 770-939-7879 | NULL | 215 Quail Run, GA 30076 |
  41. | Greta, Stuart | NULL | 770-939-9787 | 678-939-9393 | 2 Crabapple Meadow, GA 30004 |
  42. | Matt, Ellington | NULL | 770-644-4848 | 678-433-4227 | 47 Ripplewood Drive, GA 30005 |
  43. | Lester, Waters | NULL | 439-556-3030 | 439-232-5050 | 2834 Oakwood Park, GA 30026 |
  44. | EOB, EOB | NULL | NULL | NULL | NULL |
  45. | Invoices, Invoices | NULL | NULL | NULL | NULL |
  46. +--------------------+--------------------------------+--------------+--------------+----------------------------------+
  47. 19 rows in set (0.01 sec)
  48.  
  49. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement