{"action":"opened","issue":{"url":"https://api.github.com/repos/jfax/rex-news/issues/6","labels_url":"https://api.github.com/repos/jfax/rex-news/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/jfax/rex-news/issues/6/comments","events_url":"https://api.github.com/repos/jfax/rex-news/issues/6/events","html_url":"https://github.com/jfax/rex-news/issues/6","id":65709632,"number":6,"title":"Fehler in Sprachfilterung bei Liste (Letzte Version vom 2 Apr 2014)","user":{"login":"elektromanager","id":8725818,"avatar_url":"https://avatars.githubusercontent.com/u/8725818?v=3","gravatar_id":"","url":"https://api.github.com/users/elektromanager","html_url":"https://github.com/elektromanager","followers_url":"https://api.github.com/users/elektromanager/followers","following_url":"https://api.github.com/users/elektromanager/following{/other_user}","gists_url":"https://api.github.com/users/elektromanager/gists{/gist_id}","starred_url":"https://api.github.com/users/elektromanager/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elektromanager/subscriptions","organizations_url":"https://api.github.com/users/elektromanager/orgs","repos_url":"https://api.github.com/users/elektromanager/repos","events_url":"https://api.github.com/users/elektromanager/events{/privacy}","received_events_url":"https://api.github.com/users/elektromanager/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-01T15:16:02Z","updated_at":"2015-04-01T15:16:02Z","closed_at":null,"body":"Wenn man wie in meinem Fall 3 Sprachen aktiv hat und nun auf der Startseite News \"nur für aktuelle Sprache\" ausgibt werden trotzdem News aus anderen Sprachen ausgegeben. Beim Debuggen stellte ich fest, dass der Wert \"language\" gar nicht im SQL-Query berücksichtigt wird.\r\n\r\nQuery: SELECT * ,\r\nCASE \r\nWHEN REPLACE(stickyUntil, \"-\", \"\") > CURDATE() + 0 THEN true\r\nELSE false\r\nEND as st\t\r\n\r\nFROM rex_336_news \r\nWHERE (\r\n((offline_date = \"0000-00-00\") OR (REPLACE(offline_date, \"-\", \"\") > CURDATE() + 0))\r\nAND\r\n((online_date = \"0000-00-00\") OR REPLACE(online_date, \"-\", \"\") <= CURDATE() + 0)\r\n)\r\nAND status = \"1\" AND flag = 1\r\nORDER BY st DESC, online_date DESC LIMIT 0,3\r\nAffected Rows: 3\r\n\r\n"}}