{"id":187,"date":"2010-08-14T23:24:45","date_gmt":"2010-08-14T21:24:45","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=187"},"modified":"2017-04-16T14:40:43","modified_gmt":"2017-04-16T12:40:43","slug":"dml-devam","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/","title":{"rendered":"DML devam"},"content":{"rendered":"<p style=\"font-family: Arial, Helvetica, sans-serif;\">Bu konu Northwind database ile ilgili oldu\u011fundan dolay\u0131 database&#8217;i indirip restore etmeyi unutmay\u0131n\u0131z.<br \/>\n<a href=\"http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/NorthWind.zip\">http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/NorthWind.zip<\/a><\/p>\n<pre class=\"brush:sql\">-- Employees tablosundan cal\u0131\u015fanlar\u0131n adlar\u0131n\u0131(FirstName) soyadlar\u0131n\u0131(LastName) ve ya\u015flar\u0131n\u0131 listeleyin\r\n\r\nselect FirstName,LastName,\r\nDATEDIFF(YYYY,BirthDate,GETDATE())\r\nfrom Employees\r\n\r\nselect FirstName,LastName,\r\nYEAR(GETDATE())-YEAR(BirthDate) as Yas\r\nfrom Employees\r\norder by Yas asc-- 0 dan 100000...\r\n                -- a dan z ye\r\n\r\nselect FirstName,LastName,\r\nYEAR(GETDATE())-YEAR(BirthDate) as Yas\r\nfrom Employees\r\norder by Yas desc,FirstName asc\r\n\r\n-- en eski 3 personeli getirin\r\nselect top 3 FirstName,LastName,HireDate\r\nfrom Employees\r\norder by HireDate -- default olarak asc dir\r\n\r\n-- en yeni 4 personeli getirin\r\nselect top 4 FirstName,LastName,HireDate\r\nfrom Employees\r\norder by HireDate desc\r\n\r\n-- en ya\u015fl\u0131 \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 ve ya\u015f\u0131n\u0131 getirin\r\nselect top 1 FirstName,LastName,\r\nYEAR(GETDATE())-YEAR(BirthDate) as Yas\r\nfrom Employees\r\norder by Yas desc\r\n\r\n-- Margaret ile ayn\u0131 tarihte do\u011fmu\u015f bir personel ekleyelim\r\ninsert into Employees(FirstName,LastName,BirthDate)\r\nvalues('Yunus','Ard\u0131c',\r\n  (\r\n    select BirthDate from Employees where FirstName ='Margaret'\r\n  )\r\n)\r\n\r\nselect * from Employees order by BirthDate asc\r\n\r\n-- en ya\u015fl\u0131 \u00e7al\u0131\u015fanlar\u0131n adlar\u0131n\u0131, soyadlar\u0131n\u0131 ve yaslar\u0131n\u0131 getirin\r\nselect FirstName,LastName,DATEDIFF(YYYY,BirthDate,GETDATE()) as Yas\r\nfrom Employees\r\nwhere DATEDIFF(YYYY,BirthDate,GETDATE())=\r\n(\r\n   select Top 1 DATEDIFF(YYYY,BirthDate,GETDATE()) as   Yas from Employees order by Yas desc\r\n)\r\n\r\n-- hangi \u00fclkelerle i\u015f yap\u0131yoruz\r\nselect distinct Country\r\nfrom Customers \r\n\r\n-- \u00d6dev 1) Tost seven \u00e7al\u0131\u015fanlar\u0131n ad\u0131 soyad\u0131 ve not bilgilerini getirin\r\n-- Employees tablosu\r\n-- Yunus a \u00f6zel: O verinin uzunlu\u011funu ve kac\u0131nc\u0131 indekste yaz\u0131ld\u0131\u011f\u0131n\u0131 bulacak \"toast\"\r\n-- \u00d6dev 2) Beverages adl\u0131 kategorideki \u00fcr\u00fcnlerin adlar\u0131n\u0131 getirin\r\n-- Categories tablosundaki CategoryName kolonu. Products tablosu ProductName kolonu\r\n-- \u00d6dev 3) Mayumi's isimli tedarikci(Supplier) \u0131n getirdi\u011fi \u00fcr\u00fcnlerin(Product) adlar\u0131n\u0131(ProductName) getirin \r\n\r\n-- Aggreagte Function\r\n-- max,min,avg,sum,count\r\n--&gt; max =&gt; en b\u00fcy\u00fck de\u011fer\r\n--&gt; min =&gt; en k\u00fc\u00e7\u00fck de\u011fer\r\n--&gt; avg =&gt; ortalama\r\n--&gt; sum(h\u00fccre de\u011ferlerinin toplam\u0131)\r\n--&gt; count null olmayan sat\u0131r say\u0131s\u0131\r\n\/*\r\n    ID   Ad Yas  Hede\r\n    ------------------\r\n    1    a   12  NULL\r\n    2    b   13  Veri\r\n\r\n    =&gt; max(Yas) 13\r\n    =&gt; min(Yas) 12\r\n    =&gt; avg(yas)  12.5\r\n    =&gt; avg(ID)    1.5\r\n    =&gt; count(ID)  2\r\n    =&gt; count(Hede) 1\r\n    =&gt; sum(Yas)   25\r\n*\/\r\n\r\n-- birim fiyat\u0131 (UnitPrice) en pahal\u0131 olan \u00fcr\u00fcn\u00fcn(Products) birim fiyat\u0131n\u0131 getirin\r\nselect MAX(UnitPrice)\r\nfrom Products\r\n\r\n-- bu zamana kadar toplam ka\u00e7 sipari\u015f(Orders tablosu) alm\u0131\u015f\u0131m?\r\nselect COUNT(OrderID) as SS from Orders\r\n\r\n-- toplam ka\u00e7 \u00e7al\u0131\u015fan\u0131m var?\r\nselect COUNT(EmployeeID) from\r\nEmployees\r\n\r\n-- Toplam ka\u00e7 \u00e7al\u0131\u015fan\u0131m var ve bu \u00e7al\u0131\u015fanlar\u0131m\u0131n ad\u0131n\u0131 g\u00f6sterin?\r\nselect FirstName, COUNT(EmployeeID)\r\nfrom Employees\r\n\r\n-- Listedeki \u00fcr\u00fcnlerin(products tablosu) ortalama birim fiyat\u0131n\u0131 (UnitPrice) g\u00f6sterin\r\nselect AVG(UnitPrice) from Products\r\n\r\nselect Top 10 * from [Order Details]\r\n\r\n-- sipari\u015f ba\u015f\u0131na ortalama ne kadar para kazanm\u0131\u015f\u0131m?\r\nselect SUM(UnitPrice*Quantity)\/ COUNT(distinct OrderID)\r\nfrom [Order Details]\r\n\r\n-- \u00d6dev 4) Northwind de CategoryuName de\u011feri NULL olan kay\u0131tlar\u0131n CategoryName ini MULL olarak g\u00f6sterecek sorguyu yaz\u0131n\u0131z<\/pre>\n<p style=\"font-family: Arial, Helvetica, sans-serif;\">\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu konu Northwind database ile ilgili oldu\u011fundan dolay\u0131 database&#8217;i indirip restore etmeyi unutmay\u0131n\u0131z. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/NorthWind.zip &#8212; Employees tablosundan cal\u0131\u015fanlar\u0131n adlar\u0131n\u0131(FirstName) soyadlar\u0131n\u0131(LastName)<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[38,37,39,36],"class_list":["post-187","post","type-post","status-publish","format-standard","hentry","category-dml","tag-data-manuplation-language","tag-dml-2","tag-northwind","tag-sql-2","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DML devam | F.Murat ALTINI\u015eIK<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DML devam | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"Bu konu Northwind database ile ilgili oldu\u011fundan dolay\u0131 database&#8217;i indirip restore etmeyi unutmay\u0131n\u0131z. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/NorthWind.zip -- Employees tablosundan cal\u0131\u015fanlar\u0131n adlar\u0131n\u0131(FirstName) soyadlar\u0131n\u0131(LastName)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-14T21:24:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:43+00:00\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"DML devam\",\"datePublished\":\"2010-08-14T21:24:45+00:00\",\"dateModified\":\"2017-04-16T12:40:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\"},\"wordCount\":27,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"data manuplation language\",\"dml\",\"Northwind\",\"sql\"],\"articleSection\":[\"DML\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\",\"name\":\"DML devam | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:24:45+00:00\",\"dateModified\":\"2017-04-16T12:40:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DML devam\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DML devam | F.Murat ALTINI\u015eIK","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/","og_locale":"tr_TR","og_type":"article","og_title":"DML devam | F.Murat ALTINI\u015eIK","og_description":"Bu konu Northwind database ile ilgili oldu\u011fundan dolay\u0131 database&#8217;i indirip restore etmeyi unutmay\u0131n\u0131z. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/NorthWind.zip -- Employees tablosundan cal\u0131\u015fanlar\u0131n adlar\u0131n\u0131(FirstName) soyadlar\u0131n\u0131(LastName)","og_url":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-14T21:24:45+00:00","article_modified_time":"2017-04-16T12:40:43+00:00","author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"DML devam","datePublished":"2010-08-14T21:24:45+00:00","dateModified":"2017-04-16T12:40:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/"},"wordCount":27,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["data manuplation language","dml","Northwind","sql"],"articleSection":["DML"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/dml-devam\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/","url":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/","name":"DML devam | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:24:45+00:00","dateModified":"2017-04-16T12:40:43+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/dml-devam\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/dml-devam\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DML devam"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=187"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/187\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}