/*SQLS_kisi_detay();*/

select
v.id as varlik_id,v.ziyaret_sayisi as ziyaret_sayisi,
d.tip,d.nitelik,d.deger,d.deger2,d.deger_url,d.kontrol1,d.kontrol2,
v.foto,@v_id:=v.id
from varliklar as v
LEFT JOIN degerler as d on v.id=d.varlik_id and d.tip='kisi'
WHERE
v.seo_url='andy_murray' and v.tip='kisi';

update varliklar set ziyaret_sayisi=ziyaret_sayisi+1 where id=@v_id;
insert into ziyaret (varlik_id,full_url,ip,tarih) values (@v_id,'https://www.xwhos.com/person/andy_murray-whois.html','34.229.76.193',now());

select d.id,'news' as index_tip,v.id as varlik_id,kelime,seo_url,eklenme_tarihi,d.deger as foto,ziyaret_sayisi,'x',dd.deger2 as ozet
from varliklar as v
LEFT JOIN degerler as d on d.nitelik='resimler' and d.tip='news' and d.varlik_id=v.id
LEFT JOIN degerler as dd on dd.tip='Kisi' and dd.nitelik='News' and dd.deger=404439 and dd.varlik_id=404439

where v.id in (select deger as id from degerler where tip='Kisi' and nitelik='News' and varlik_id=404439)
GROUP BY v.id desc
limit 10
Andy Murray Whois?
  • About

    Sir Andrew Barron Murray OBE is a British professional tennis player from Scotland currently ranked No. 223 in men's singles as of 4 February 2019.

  • Photos
    Andy Murray - British tennis player
    Andy Murray - British tennis player
    Andy Murray - British tennis player
    Andy Murray - British tennis player
    Andy Murray - British tennis player
    Andy Murray - British tennis player
  • 1 news
    News
      ......
© 2015 xwhos.com
About us Help