Guest User

Untitled

a guest
May 31st, 2016
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.63 KB | None | 0 0
  1. activities table:
  2.  
  3. mysql> select id, activity_type_id, signup_id, author_id, created_at from activities where external_id = 79222 and activity_type_id = 109;
  4. +---------+------------------+-----------+-----------+---------------------+
  5. | id | activity_type_id | signup_id | author_id | created_at |
  6. +---------+------------------+-----------+-----------+---------------------+
  7. | 1645265 | 109 | 241675 | 269327 | 2015-05-06 13:51:29 |
  8. +---------+------------------+-----------+-----------+---------------------+
  9. 1 row in set (0.05 sec)
  10.  
  11.  
  12.  
  13. signups table:
  14.  
  15. mysql> select id, first_name, last_name, email1 from signups where id IN (241675, 269327);
  16. +--------+------------+-----------+-------------------------+
  17. | id | first_name | last_name | email1 |
  18. +--------+------------+-----------+-------------------------+
  19. | 241675 | Cecil | O'Neal | onealcandu@verizon.net |
  20. | 269327 | naomi | pena | naomimichelle@gmail.com |
  21. +--------+------------+-----------+-------------------------+
  22. 2 rows in set (0.00 sec)
  23.  
  24.  
  25.  
  26.  
  27. activity_datas table:
  28.  
  29. ---
  30. email:
  31. subject: 'RE: A faster way to deal with money in elections'
  32. body: "Dear Mr. O'Neil,\n\nThank you very much for sending the documents. I read
  33. with particular interest the article by Rob Hager and James Leas regarding use
  34. of Article I sections 4 and 5 and Article III section 2.\nIt seems to me personally
  35. (not speaking for Move to Amend) that these sections of the Constitutiuon could
  36. provide a promising avenue to deal with money in elections. However, to effectuate
  37. this, as any other remedy, will require massive pressure on the part of citizens,
  38. which brings me to Move to Amend's position.\n\nMove to Amend (MTA) has two goals:
  39. to create a nation-wide democracy movement and to amend the Constitution. In
  40. fact, MTA believes that without massive, nation-wide pressure no amendment will
  41. be enacted. Therefore, MTA holds that building such a movement is primary. \n\nIn
  42. regard to an amendment, MTA is committed to an amendment stipulating that the
  43. Consitution does not grant rights to corporations. Such an amendment goes far
  44. beyond the \"money in politics\" issue. It addresses the significant problems
  45. that have evolved from corporations being granted protection from \"takings\"
  46. and \"search and seizure\" as well as their use of \"due process\". All of these
  47. have contributed to the inability of states to regulate corporations. While the
  48. Supreme Court may well have exceeded its authority in granting \"personhood\"
  49. rights to corporations, Article I would not be useful for addressing this problem.
  50. One would have to rely only on the Article III Exceptions clause and possibly
  51. state sovereignty. Not being a lawyer, I can not evaluate the potential of this
  52. approach.\n\nI will bring the Article I and Article III approach to the attention
  53. of MTA staff. However, given MTA's small staff and existing commitments I do
  54. not know whether MTA will be able to integrate this into their work program. \n\nI
  55. am located in the DC area and if you would like to meet to discuss how the approach
  56. described in the Hager and Leas article might be promoted, please feel free to
  57. contact me at: naomimichelle@gmail.com\n\nNa"
  58. to: onealcandu@verizon.net
  59. cc: ''
  60. bcc: " Move to Amend <info@movetoamend.org>"
  61. id: 79222
  62. attachments: []
  63. signup_call:
  64. contact_id: 49022
  65. contact_method_id: 3
  66. contact_method_name: Email
  67. contact_status_id: 3
  68. contact_status_name: Left message
  69. type_name: zz-national-0-General Inquiry
  70. type_id: 2
  71. support_level:
  72. priority_level:
  73. note:
  74.  
  75.  
  76.  
  77. emails table:
  78.  
  79. mysql> select `from`,`to`,cc,bcc,subject from emailsddd where id = 79222;
  80. +-----------------------------------------+------------------------+------+---------------------------------------+--------------------------------------------------+
  81. | from | to | cc | bcc | subject |
  82. +-----------------------------------------+------------------------+------+---------------------------------------+--------------------------------------------------+
  83. | " Move to Amend" <info@movetoamend.org> | onealcandu@verizon.net | NULL | Move to Amend <info@movetoamend.org> | RE: A faster way to deal with money in elections |
  84. +-----------------------------------------+------------------------+------+---------------------------------------+--------------------------------------------------+
  85. 1 row in set (1.08 sec)
Add Comment
Please, Sign In to add comment