{"id":193,"date":"2010-08-14T23:29:17","date_gmt":"2010-08-14T21:29:17","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=193"},"modified":"2017-04-16T14:40:32","modified_gmt":"2017-04-16T12:40:32","slug":"join","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/join\/","title":{"rendered":"Join"},"content":{"rendered":"<p style=\"font-family: Arial, Helvetica, sans-serif;\">Northwind<\/p>\n<pre class=\"brush:sql\">--------------JOIN-----------------\r\n--  Inner Join\r\n--  Sadece e\u015fle\u015fen verileri getirir\r\n\r\nuse master\r\ngo\r\n\r\ncreate  database JoinDB\r\ngo\r\n\r\nuse JoinDB\r\ngo\r\n\r\ncreate table Kategoriler\r\n(\r\n   KategoriID int primary key identity(1,1),\r\n   KategoriAdi varchar(20)\r\n)\r\ngo\r\n\r\ncreate table Urunler\r\n(\r\n   UrunID int primary key identity(1,1),\r\n   UrunAdi varchar(50),\r\n   -- references ile foreign key olu\u015fturuldu\r\n   KategoriID int references Kategoriler(KategoriID),\r\n   BirimFiyat decimal(6,2)\r\n)\r\n\r\n-- kategori ekleyelim\r\ninsert into Kategoriler\r\nvalues('G\u0131da')\r\n\r\ninsert into Kategoriler(KategoriAdi)\r\nvalues('Temizlik')\r\n\r\ninsert into Kategoriler\r\nvalues('Kozmetik')\r\n\r\n-- kategorileri listeleyelim\r\nselect * from Kategoriler\r\n\r\n-- t\u00fcm identity ve veri bilgilrini siler s\u0131f\u0131r tablo olu\u015fturur\r\ntruncate table Kategoriler\r\n\r\ninsert into Urunler\r\nvalues('Tah\u0131l',1,12.3)\r\n\r\ninsert into Urunler\r\n(UrunAdi,KategoriID,BirimFiyat)\r\nvalues('Ace',2,6.7)\r\n\r\ninsert into Urunler\r\n(UrunAdi,BirimFiyat)\r\nvalues('Parf\u00fcm',107.89)\r\n\r\nselect * from Urunler\r\nselect * from Kategoriler\r\n\r\n-- t\u00fcm kategorileri ve \u00fcr\u00fcnlerini listeleyin...\r\n-- on dan sonra yaz\u0131lan e\u015flemenin sa\u011fda solda olmas\u0131n\u0131n  hi\u00e7bir yerde \u00f6nemi yok.\r\n-- Sadece inner join de tablo s\u0131ras\u0131n\u0131n \u00f6nemi yok. Outer join de tablo s\u0131ras\u0131 \u00f6nemli olacak\r\nselect u.UrunAdi,k.KategoriAdi\r\nfrom Urunler as u\r\ninner join Kategoriler k\r\non u.KategoriID=k.KategoriID\r\n\r\n-- Northwind den hangi \u00fcr\u00fcn\u00fc hangi tedarik\u00e7i getiriyor listeleyin\r\n-- ddl lerde go kullan\u0131yoruz.\r\n-- dml lerde gerek yok\r\nuse Northwind\r\ngo\r\n\r\nselect s.CompanyName,p.ProductName\r\nfrom Suppliers s\r\njoin Products p\r\non p.SupplierID=s.SupplierID\r\n\r\n-- hangi \u015firket hangi tarihte sipari\u015f vermi\u015f\r\n-- Customers(M\u00fc\u015fteriler)\r\n-- Orders (Sipari\u015fler)\r\n-- CustomerID\r\nselect c.CompanyName,o.OrderDate\r\nfrom Orders o\r\njoin Customers c on o.CustomerID=c.CustomerID\r\n\r\n-- hangi kategorideki hangi urunu hangi tedarikci getiriyormu\u015f???\r\n-- categories, products, suppliers\r\n-- tablo join tablo on bilmem ne join tablo on bilmem ne\r\nselect p.ProductName '\u00dcr\u00fcn Ad\u0131',\r\ns.CompanyName 'Tedarik\u00e7i',\r\nc.CategoryName 'Kategori'\r\nfrom Products p\r\njoin Categories c on c.CategoryID=p.CategoryID\r\njoin Suppliers s on s.SupplierID=p.SupplierID\r\n\r\n-- hangi \u00e7al\u0131\u015fan\u0131m hangi m\u00fc\u015fteriden hangi tarihte hangi \u00fcr\u00fcnden kac tane sipari\u015f alm\u0131\u015f?\r\nselect p.ProductName,\r\no.OrderDate,\r\nc.CompanyName,\r\ne.FirstName+' '+e.LastName as eleman,\r\nod.Quantity\r\nfrom Orders o\r\njoin Employees e on e.EmployeeID=o.EmployeeID\r\njoin Customers c on c.CustomerID=o.CustomerID\r\njoin [Order Details] od on od.OrderID=o.OrderID\r\njoin Products p on p.ProductID=od.ProductID\r\n\r\n-- her \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 tek kolon olarak, bu \u00e7al\u0131\u015fan\u0131n ya\u015f\u0131n\u0131 ve ald\u0131\u011f\u0131 toplam sipari\u015f say\u0131s\u0131n\u0131 listeleyiniz...\r\n-- Employees, Orders\r\nselect e.FirstName+' '+e.LastName,\r\nCOUNT(o.OrderID) as 'Sipari\u015f Say\u0131s\u0131',\r\nDATEDIFF(YYYY,BirthDate,GETDATE()) as Yas\r\nfrom Employees e\r\njoin Orders o on o.EmployeeID=e.EmployeeID\r\ngroup by e.FirstName+' '+e.LastName,DATEDIFF(YYYY,BirthDate,GETDATE())\r\n\r\n-- her kategorinin ad\u0131n\u0131 o kategorideki en fazla para kazand\u0131ran \u00fcr\u00fcn\u00fcn ad\u0131n\u0131 ve kazand\u0131rd\u0131\u011f\u0131 miktar\u0131 listeleyin\r\n\/*\r\n    G\u0131da : ekmek 4  ve tur\u015fu  8\r\n    temizlik : ace 67  rinso  5\r\n\r\n    c\u0131kt\u0131;\r\n\r\n    G\u0131da      tur\u015fu 8\r\n    temizlik  ace   67\r\n*\/\r\nselect * from\r\n(\r\n   select c.CategoryName,p.ProductName,\r\n   SUM(od.UnitPrice*od.Quantity) as Toplam\r\n   from Categories c\r\n   join Products p on p.CategoryID=c.CategoryID\r\n   join [Order Details] od on p.ProductID=od.ProductID\r\n   group by c.CategoryName,p.ProductName\r\n) as t\r\nwhere Toplam=\r\n(\r\n   select MAX(Toplam) from\r\n   (\r\n      select c.CategoryName,p.ProductName,\r\n      SUM(od.UnitPrice*od.Quantity) as Toplam\r\n      from Categories c\r\n      join Products p on p.CategoryID=c.CategoryID\r\n      join [Order Details] od on p.ProductID=od.          ProductID\r\n      group by c.CategoryName,p.ProductName\r\n   ) as tt\r\n   where tt.CategoryName=t.CategoryName\r\n)\r\n\r\n--hangi kategorideki(CategotyName) hangi \u00fcr\u00fcnden(ProductName) hangi tarihte(OrderDate) hangi m\u00fc\u015fteriye(CompanyName) hangi \u00e7al\u0131\u015fan(FirstName,LastName) taraf\u0131ndan ka\u00e7 tane(Quantity) sat\u0131lm\u0131\u015ft\u0131r?\r\nselect c.CategoryName,\r\np.ProductName,\r\no.OrderDate,\r\nod.Quantity,e.FirstName+' '+e.LastName,\r\ncu.CompanyName\r\nfrom\r\nCategories c\r\njoin Products p on p.CategoryID=c.CategoryID\r\njoin [Order Details] od on od.ProductID=p.ProductID\r\njoin Orders o on o.OrderID=od.OrderID\r\njoin Employees e on e.EmployeeID=o.EmployeeID\r\njoin Customers cu on  cu.CustomerID=o.CustomerID<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Northwind &#8212;&#8212;&#8212;&#8212;&#8211;JOIN&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212; Inner Join &#8212; Sadece e\u015fle\u015fen verileri getirir use master go create database JoinDB go use JoinDB go<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[41,36],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry","category-join-sql","tag-join","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>Join | 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\/join\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Join | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"Northwind --------------JOIN----------------- -- Inner Join -- Sadece e\u015fle\u015fen verileri getirir use master go create database JoinDB go use JoinDB go\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/join\/\" \/>\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:29:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:32+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\/join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Join\",\"datePublished\":\"2010-08-14T21:29:17+00:00\",\"dateModified\":\"2017-04-16T12:40:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join\/\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"join\",\"sql\"],\"articleSection\":[\"Join\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/join\/\",\"name\":\"Join | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:29:17+00:00\",\"dateModified\":\"2017-04-16T12:40:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/join\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Join\"}]},{\"@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":"Join | 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\/join\/","og_locale":"tr_TR","og_type":"article","og_title":"Join | F.Murat ALTINI\u015eIK","og_description":"Northwind --------------JOIN----------------- -- Inner Join -- Sadece e\u015fle\u015fen verileri getirir use master go create database JoinDB go use JoinDB go","og_url":"https:\/\/www.fethimurat.com\/blog\/join\/","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:29:17+00:00","article_modified_time":"2017-04-16T12:40:32+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\/join\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/join\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Join","datePublished":"2010-08-14T21:29:17+00:00","dateModified":"2017-04-16T12:40:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/join\/"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["join","sql"],"articleSection":["Join"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/join\/","url":"https:\/\/www.fethimurat.com\/blog\/join\/","name":"Join | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:29:17+00:00","dateModified":"2017-04-16T12:40:32+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/join\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/join\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Join"}]},{"@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\/193","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=193"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}