SELECT k1.*, k2.* FROM UyeKayitlar k1, UyeKisisel k2 WHERE k1.UyelikTuru=4 AND k1.UyeId = k2.UyeId AND k1.strTarih = (SELECT MAX(strTarih) FROM UyeKayitlar k3 WHERE k1.UyeId = k3.UyeId) ORDER BY k1.UyeId DESC