{"action":"created","issue":{"url":"https://api.github.com/repos/lionel-m/newsletter-export/issues/1","labels_url":"https://api.github.com/repos/lionel-m/newsletter-export/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/lionel-m/newsletter-export/issues/1/comments","events_url":"https://api.github.com/repos/lionel-m/newsletter-export/issues/1/events","html_url":"https://github.com/lionel-m/newsletter-export/issues/1","id":63549185,"number":1,"title":"Export Name as well, if exists, from Member Table","user":{"login":"emkayy","id":731228,"avatar_url":"https://avatars.githubusercontent.com/u/731228?v=3","gravatar_id":"","url":"https://api.github.com/users/emkayy","html_url":"https://github.com/emkayy","followers_url":"https://api.github.com/users/emkayy/followers","following_url":"https://api.github.com/users/emkayy/following{/other_user}","gists_url":"https://api.github.com/users/emkayy/gists{/gist_id}","starred_url":"https://api.github.com/users/emkayy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emkayy/subscriptions","organizations_url":"https://api.github.com/users/emkayy/orgs","repos_url":"https://api.github.com/users/emkayy/repos","events_url":"https://api.github.com/users/emkayy/events{/privacy}","received_events_url":"https://api.github.com/users/emkayy/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-22T16:24:12Z","updated_at":"2015-03-30T11:32:54Z","closed_at":"2015-03-30T11:32:54Z","body":"\r\n\\system\\modules\\newsletter_export\\classes\\NewsletterExport.php line 45:\r\n``` $objRow = $this->Database->prepare(\"SELECT (SELECT CONCAT_WS(' ', firstname, lastname) FROM tl_member WHERE email = n.email),email,active FROM tl_newsletter_recipients AS n WHERE pid=? ORDER by email\") ```\r\n\r\nLine 64:\r\n``` $output .= '\"Name\",\"E-mail\",\"Active\"'. \"\\n\" ; ```\r\n\r\nMaybe you could even split it in 2 or include more fields like gender etc. for real personalized emails."},"comment":{"url":"https://api.github.com/repos/lionel-m/newsletter-export/issues/comments/87640291","html_url":"https://github.com/lionel-m/newsletter-export/issues/1#issuecomment-87640291","issue_url":"https://api.github.com/repos/lionel-m/newsletter-export/issues/1","id":87640291,"user":{"login":"lionel-m","id":814476,"avatar_url":"https://avatars.githubusercontent.com/u/814476?v=3","gravatar_id":"","url":"https://api.github.com/users/lionel-m","html_url":"https://github.com/lionel-m","followers_url":"https://api.github.com/users/lionel-m/followers","following_url":"https://api.github.com/users/lionel-m/following{/other_user}","gists_url":"https://api.github.com/users/lionel-m/gists{/gist_id}","starred_url":"https://api.github.com/users/lionel-m/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lionel-m/subscriptions","organizations_url":"https://api.github.com/users/lionel-m/orgs","repos_url":"https://api.github.com/users/lionel-m/repos","events_url":"https://api.github.com/users/lionel-m/events{/privacy}","received_events_url":"https://api.github.com/users/lionel-m/received_events","type":"User","site_admin":false},"created_at":"2015-03-30T11:32:54Z","updated_at":"2015-03-30T11:32:54Z","body":"I closed the ticket in favor of the PR #2"}}