I am the Greyjoy, Lady Reaper of Pyke, Queen of Salt and Rock, Daughter of the Sea Wind, and no man gives me a crown. I pay the iron price. I will take my crown, as Urron Redhand did five thousand years ago.

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='11971'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12066'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12146'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12153'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12157'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12182'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12191'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12198'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12377'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12555'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12576'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='12593'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='13563'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='13587'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='13637'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='13648'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='13660'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='13694'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='14591'

SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='14594'