{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"Alt Sorgular (Subqueries): Veritaban\u0131 Sorgulamalar\u0131nda G\u00fc\u00e7l\u00fc Bir Ara\u00e7","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"yoBBLad58W\"><a href=\"https:\/\/fatihsoysal.com\/blog\/alt-sorgular-subqueries-veritabani-sorgulamalarinda-guclu-bir-arac\/\">Alt Sorgular (Subqueries): Veritaban\u0131 Sorgulamalar\u0131nda G\u00fc\u00e7l\u00fc Bir Ara\u00e7<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/alt-sorgular-subqueries-veritabani-sorgulamalarinda-guclu-bir-arac\/embed\/#?secret=yoBBLad58W\" width=\"600\" height=\"338\" title=\"&#8220;Alt Sorgular (Subqueries): Veritaban\u0131 Sorgulamalar\u0131nda G\u00fc\u00e7l\u00fc Bir Ara\u00e7&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"yoBBLad58W\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Merhaba! Fatih Soysal olarak, bug\u00fcn sizlerle veritaban\u0131 sorgulamalar\u0131nda olduk\u00e7a g\u00fc\u00e7l\u00fc ve kullan\u0131\u015fl\u0131 bir teknik olan alt sorgular (subqueries) hakk\u0131nda detayl\u0131 bir makale payla\u015faca\u011f\u0131m. Alt sorgular, ana sorgu i\u00e7inde yer alan ve kendi ba\u015f\u0131na bir sorgu gibi \u00e7al\u0131\u015fan ba\u011f\u0131ms\u0131z sorgulamalard\u0131r. Bu sayede karma\u015f\u0131k veritaban\u0131 i\u015flemlerini daha d\u00fczenli ve anla\u015f\u0131l\u0131r bir \u015fekilde ger\u00e7ekle\u015ftirebilirsiniz. \u00d6ncelikle, alt sorgular\u0131n ne oldu\u011funu ve neden kullan\u0131ld\u0131\u011f\u0131n\u0131 a\u00e7\u0131klayarak ba\u015flayal\u0131m."}