Switch to Seanad

Dáil Éireann Members' Directory

Search Members

within Dáil


House Number: 30th
Period: 14 June 2007 – 01 February 2011
Seats: 166

line 60 select m.id , m.title, m.FirstNameEN, m.LastNameEN, m.FirstNameGA, m.LastNameGA,t.constituencyID as CID, C.NameEN,C.NameGA, H.HouseNum, p.NameEN, P.NameGA, P.ID, P.URL, m.URL as 'MemberURL', m.Email as 'MemberMail' from termofoffice t left join members m on m.Id= t.memberID left join HouseNums H on t.HouseId = h.id left join Constituency C on C.ID=t.constituencyID left OUTER join Parties P on P.ID=t.partyID where h.HouseType = 0 and h.HouseNum=30 order by m.LastNameEN