{"id":54840,"date":"2023-08-04T17:16:22","date_gmt":"2023-08-04T17:16:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=54840"},"modified":"2023-08-04T17:17:40","modified_gmt":"2023-08-04T17:17:40","slug":"postgresql-outer-join","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/","title":{"rendered":"PostgreSQL Outer Join"},"content":{"rendered":"<p>In today&#8217;s article, I will be explaining what Outer Join is and its types in PostgreSQL.<\/p>\n<p>It is a join type that contains several join types in OUTER JOIN.<\/p>\n<p>Retrieves common records by using interrelated columns between tables such as INNER JOIN.<\/p>\n<p>Its difference from INNER JOIN may vary depending on the outer join type used instead of fetching common columns.<\/p>\n<p>The outer join is divided into three:<\/p>\n<p>-Left Join<br \/>\n-Right Join<br \/>\n-Full Outer Join<\/p>\n<p>You cannot use OUTER JOIN alone by typing OUTER JOIN.<\/p>\n<p>You can use it as LEFT OUTER JOIN, RIGHT OUTER JOIN or FULL OUTER JOIN.<\/p>\n<h3>Left Outer Join:<\/h3>\n<p>It is called LEFT OUTER JOIN or LEFT JOIN, as the name suggests, it performs the join operation based on the left table.<\/p>\n<p>The records in the first table are listed completely, then if the record in the first table does not exist in the second table, its value in the second table returns empty.<\/p>\n<p>For example, in the example we did in my INNER JOIN article, we entered Gaziantep in the sehirler table, but since we did not enter a record about Gaziantep in the MeshurYiyecek table, it was not listed in the INNER JOIN.<\/p>\n<p>Let&#8217;s run the same query by typing LEFT JOIN or LEFT OUTER JOIN where it says INNER JOIN.<\/p>\n<pre class=\"lang:default decode:true \">SELECT s.sehirismi,my.yiyecekismi FROM sehirler as s LEFT JOIN meshuryiyecekler as my ON s.id=my.sehirid;\r\n<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/leftjoin1.png\" \/><\/p>\n<p>As you can see above, the Gaziantep value is returned and the YiyecekIsmi column in the MeshurYiyecek table is null because there is no record.<\/p>\n<p>You can meet your different needs by filtering this query in the &#8216;where&#8217; condition.<\/p>\n<p>For example, let&#8217;s enter the sehirismi, but if we want to list the records that do not have famous food related to this city or that have not been entered, we can write the following query.<\/p>\n<pre class=\"lang:default decode:true \">SELECT s.sehirismi,my.yiyecekismi FROM sehirler as s LEFT JOIN meshuryiyecekler as my ON s.id=my.sehirid WHERE my.sehirid is null;\r\n<\/pre>\n<p id=\"dbYAlBH\"><img loading=\"lazy\" decoding=\"async\" width=\"1132\" height=\"79\" class=\"alignnone size-full wp-image-54842 \" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/img_64cd2eb6c86b8.png\" alt=\"\" \/><\/p>\n<h3>Right Outer Join:<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/right.png\" \/><\/p>\n<p>It is called RIGHT OUTER JOIN or RIGHT JOIN, as the name suggests, it performs the join operation based on the right table.<\/p>\n<p>It returns all records belonging to table B in the picture above.<\/p>\n<p>In the picture above, only the ones in table B will not return the values in table A.<\/p>\n<pre class=\"lang:default decode:true \">SELECT s.sehirismi,my.yiyecekismi FROM sehirler as s RIGHT JOIN meshuryiyecekler as my ON s.id=my.sehirid WHERE s.id is null;\r\n<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/right1.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54840\" class=\"pvc_stats all  \" data-element-id=\"54840\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in OUTER JOIN. Retrieves common records by using interrelated columns between tables such as INNER JOIN. Its difference from INNER JOIN may vary depending on the outer join type &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54840\" class=\"pvc_stats all  \" data-element-id=\"54840\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":54845,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-54840","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL Outer Join - Database Tutorials<\/title>\n<meta name=\"description\" content=\"I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in Outer Join.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Outer Join - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in Outer Join.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-04T17:16:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-04T17:17:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png\" \/>\n\t<meta property=\"og:image:width\" content=\"593\" \/>\n\t<meta property=\"og:image:height\" content=\"328\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL Outer Join\",\"datePublished\":\"2023-08-04T17:16:22+00:00\",\"dateModified\":\"2023-08-04T17:17:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\"},\"wordCount\":352,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\",\"name\":\"PostgreSQL Outer Join - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png\",\"datePublished\":\"2023-08-04T17:16:22+00:00\",\"dateModified\":\"2023-08-04T17:17:40+00:00\",\"description\":\"I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in Outer Join.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png\",\"width\":593,\"height\":328},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Outer Join\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL Outer Join - Database Tutorials","description":"I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in Outer Join.","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:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Outer Join - Database Tutorials","og_description":"I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in Outer Join.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/","og_site_name":"Database Tutorials","article_published_time":"2023-08-04T17:16:22+00:00","article_modified_time":"2023-08-04T17:17:40+00:00","og_image":[{"width":593,"height":328,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL Outer Join","datePublished":"2023-08-04T17:16:22+00:00","dateModified":"2023-08-04T17:17:40+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/"},"wordCount":352,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/","url":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/","name":"PostgreSQL Outer Join - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png","datePublished":"2023-08-04T17:16:22+00:00","dateModified":"2023-08-04T17:17:40+00:00","description":"I will be explaining what Outer Join is and its types in PostgreSQL. It is a join type that contains several join types in Outer Join.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/08\/Ekran-goruntusu-2023-08-04-201253.png","width":593,"height":328},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/08\/04\/postgresql-outer-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Outer Join"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54840"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54840\/revisions"}],"predecessor-version":[{"id":54846,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54840\/revisions\/54846"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54845"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}