{"id":1938,"date":"2020-07-12T11:45:54","date_gmt":"2020-07-12T08:45:54","guid":{"rendered":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/?page_id=1938"},"modified":"2023-05-20T21:30:15","modified_gmt":"2023-05-20T18:30:15","slug":"vakka-tour-2020-ctp-kisa","status":"publish","type":"page","link":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/vakka-tour-2020-ctp-kisa\/","title":{"rendered":"Vakka Tour 2020 CTP-kisa"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.wirmodiscgolf.fi\/wordpress\/vakkatour-tilanne?vuosi=2020\">Tourin pistetilanne<\/a>.<\/p>\n\n\n\n<p>CTP-kisan pistetilanne:<\/p>\n\n\n<div id=\"error\"><p class=\"wpdberror\"><strong>WordPressin tietokantavirhe:<\/strong> [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#039;) group by userid having Pisteet &gt; 0) as cp on cp.userid = c.userid where c.c...&#039; at line 1]<br \/><code>SELECT c.userID, userName, name,ck.hole,result,  points,Pisteet, resCount FROM `CTP` as c join CTPkisat as ck on c.compid = ck.compid and points &gt; 0  join (SELECT userid, sum(points) as Pisteet, count(*) as resCount FROM `CTP` where status = &#039;New&#039; and points &gt; 0 and compID in (select skoorinID from wdgm_vakkatour_kisat where year = ) group by userid having Pisteet &gt; 0) as cp on cp.userid = c.userid where c.compID in (select skoorinID from wdgm_vakkatour_kisat where year = ) order by Pisteet desc,c.userid, date desc<\/code><\/p><\/div><table class=\"BestResult\"><tr><td style=\"text-align: center;\">Sijoitus<\/td><td style=\"text-align: center;\">Nimi<\/td><td style=\"text-align: center;\">Kisa<\/td><td style=\"text-align: center;\">V\u00e4yl\u00e4<\/td><td style=\"text-align: center;\">Tulos<\/td><td style=\"text-align: center;\">Pisteet<\/td><td style=\"text-align: center;\">Total<\/td><\/tr><\/table>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tourin pistetilanne. CTP-kisan pistetilanne:<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1938","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/pages\/1938","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/comments?post=1938"}],"version-history":[{"count":4,"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/pages\/1938\/revisions"}],"predecessor-version":[{"id":2305,"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/pages\/1938\/revisions\/2305"}],"wp:attachment":[{"href":"https:\/\/www.wirmodiscgolf.fi\/wordpress\/wp-json\/wp\/v2\/media?parent=1938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}