{"action":"opened","issue":{"url":"https://api.github.com/repos/SpiderLabs/owasp-modsecurity-crs/issues/342","repository_url":"https://api.github.com/repos/SpiderLabs/owasp-modsecurity-crs","labels_url":"https://api.github.com/repos/SpiderLabs/owasp-modsecurity-crs/issues/342/labels{/name}","comments_url":"https://api.github.com/repos/SpiderLabs/owasp-modsecurity-crs/issues/342/comments","events_url":"https://api.github.com/repos/SpiderLabs/owasp-modsecurity-crs/issues/342/events","html_url":"https://github.com/SpiderLabs/owasp-modsecurity-crs/issues/342","id":154858705,"number":342,"title":"Improve potential SQL injection using JOIN statement","user":{"login":"istais","id":2124317,"avatar_url":"https://avatars.githubusercontent.com/u/2124317?v=3","gravatar_id":"","url":"https://api.github.com/users/istais","html_url":"https://github.com/istais","followers_url":"https://api.github.com/users/istais/followers","following_url":"https://api.github.com/users/istais/following{/other_user}","gists_url":"https://api.github.com/users/istais/gists{/gist_id}","starred_url":"https://api.github.com/users/istais/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/istais/subscriptions","organizations_url":"https://api.github.com/users/istais/orgs","repos_url":"https://api.github.com/users/istais/repos","events_url":"https://api.github.com/users/istais/events{/privacy}","received_events_url":"https://api.github.com/users/istais/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-05-14T15:13:28Z","updated_at":"2016-05-14T15:13:28Z","closed_at":null,"body":"It may be possible to perform SQL injection using the following vector:\r\n\r\n`1 right join users on author.id = users.id`\r\n\r\nIn order to perform the attack, the web application must implement an sql command and retrieve all the returned columns as the following:\r\n\r\nselect * from articles left join authors on author.id=$_GET['id']\r\n\r\nand the \"users\" table must contain a known column name (such as \"id\") with a predictable value that matches with the authors ids"}}