/*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='a._j._hinch' 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/a._j._hinch-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=404979 and dd.varlik_id=404979

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

    Andrew Jay Hinch is an American professional baseball coach and former catcher who is currently the manager for the Houston Astros of Major League Baseball.

  • Photos
    A. J. Hinch - American baseball coach
    A. J. Hinch - American baseball coach
    A. J. Hinch - American baseball coach
    A. J. Hinch - American baseball coach
    A. J. Hinch - American baseball coach
    A. J. Hinch - American baseball coach
  • 1 news
    News
      ......
© 2015 xwhos.com
About us Help