TannerRitchie Publishing

With new titles appearing every week, TannerRitchie Publishing provides an extensive range of rare historical titles used by researchers, historians and genealogists around the world. Buy a single title, or subscribe to our entire catalogue - the choice is yours.

Experience the power of Medieval and Early Modern Sources Online (MEMSO)

  • Our virtual desktop and windowing system lets you conduct multiple searches and work with as many books as you like simultaneously
  • Access our entire collection and keep ebooks permanently at the end of your access period.

It’s not just about the books, but how you can use them.

Learn about the power of MEMSO

Buy short term access to MEMSO

Search our Entire Catalogue in MEMSO now!

Enter search terms to see sample results from MEMSO

RECENTLY PUBLISHED
MOST POPULAR SERIES
  1. Letters and Papers, Foreign and Domestic, Reign of Henry VIII
  2. Calendar of State Papers, Domestic
  3. Calendar of the Patent Rolls
  4. Acts of the Privy Council of England
  5. Calendar of the Manuscripts of the Marquis of Salisbury: The Cecil Manuscripts
  6. Register of the Privy Council of Scotland, First Series
  7. Calendar of Papal Registers - Papal Letters
  8. Calendar of Letters, Papers and State Papers Relating to England and Spain
  9. Foedera, Conventiones, Litteræ, et cujuscunque generis Acta Publica inter Reges Angliæ et alios etc. [Treaties, Agreements, Letters and Public Acts made between the Kings of England and others etc.]
  10. Calendar of State Papers, Venice and Northern Italy
  11. Calendar of State Papers Relating to Ireland
  12. Calendar of Documents Relating to Scotland
  13. Calendar of the Close Rolls
  14. Calendar of Documents Relating to Ireland
  15. Rotuli Litterarum Clausarum [The Close Rolls]
  16. HMC General Reports
  17. Statutes of the Realm
  18. Calendar of State Papers, Colonial, America and West Indies
  19. Collection of State Papers of John Thurloe
  20. Register of the Privy Council of Scotland, Second Series

Total queries: 6
query 1
rows returned: 20
time: 7.60555267334E-5 seconds
oneLiner: SELECT b.id as bid, s.name, s.id as sid, b.volume, count(uti.paypal_item_number) as sales FROM users_transactions_items uti LEFT JOIN books b ON uti.paypal_item_number = b.id LEFT JOIN series s ON b.series_id=s.id WHERE s.name IS NOT NULL GROUP BY s.id ORDER BY sales DESC LIMIT 0, 20 ; 
				SELECT
					b.id as bid,
					s.name,
					s.id as sid,
					b.volume,
					count(uti.paypal_item_number) as sales
				FROM
					users_transactions_items uti
				LEFT JOIN
					books b ON uti.paypal_item_number = b.id
				LEFT JOIN
					series s ON b.series_id=s.id
				WHERE
					s.name IS NOT NULL
				GROUP BY
					s.id
				ORDER BY sales DESC
				LIMIT 0, 20
query 2
rows returned: 49
time: 0.00264000892639 seconds
oneLiner: SELECT b.id as bid, s.id as sid, b.startdate, b.enddate, b.volume, b.pages, b.price, b.price_cd, b.short_title, s.name, s.description, s.shop_page, b.date_created FROM books b LEFT JOIN series s on b.series_id = s.id WHERE b.date_created > 1311956586 AND b.is_active = 1 ORDER BY b.date_created DESC, s.name ASC, b.orderindex, b.volume ASC, b.startdate ASC ; 
				SELECT
					b.id as bid,
					
					s.id as sid,
					b.startdate,
					b.enddate,
					b.volume,
					b.pages,
					b.price,
					b.price_cd,
					b.short_title,
					s.name,
					s.description,
					s.shop_page,
					b.date_created
				FROM
					books b
				LEFT JOIN series s on b.series_id = s.id
				WHERE
					b.date_created > 1311956586
				AND
					b.is_active = 1
				
				ORDER BY
					b.date_created DESC, s.name ASC, b.orderindex, b.volume ASC, b.startdate ASC
query 3
rows returned: 1
time: 0.000257968902588 seconds
oneLiner: SELECT institution_id FROM institution_ips WHERE 644592628 >= ip_range_start AND 644592628 <= ip_range_end LIMIT 1; 
SELECT institution_id FROM institution_ips WHERE 644592628 >= ip_range_start AND 644592628 <= ip_range_end LIMIT 1
query 4
rows returned: 1
time: 0.0123279094696 seconds
oneLiner: SELECT id, name, memso_subscriber, renewal_date, image FROM institutions WHERE `id`='41'; 
SELECT id, name, memso_subscriber, renewal_date, image FROM institutions WHERE `id`='41'
query 5
rows returned: 1
time: 0.0123279094696 seconds
oneLiner: INSERT INTO users_log set `user_id`=41, `ip`=644592628, `time`=1327735049, `referrer`='', `user_type`='athens' ; 
INSERT INTO users_log set `user_id`=41, `ip`=644592628, `time`=1327735049, `referrer`='', `user_type`='athens'
query 6
rows returned: 987
time: 0.000765085220337 seconds
oneLiner: SELECT b.id as book_id, s.id as series_id, b.file, s.name, b.startdate, b.enddate, b.volume, b.tags, b.editors, b.price, b.isbn13, ss.id AS superseries_id, ss.name AS superseries FROM books b INNER JOIN series s ON b.series_id = s.id LEFT OUTER JOIN series ss ON b.super_series_id = ss.id WHERE b.is_active = 1 ORDER BY s.name ; 
				SELECT
					b.id as book_id,
					s.id as series_id,
					b.file,
					s.name,
					b.startdate,
					b.enddate,
					b.volume,
					b.tags,
					b.editors,
					b.price,
					b.isbn13,
					ss.id AS superseries_id,
					ss.name AS superseries
				FROM
					books b
				INNER JOIN
					series s ON b.series_id = s.id
				LEFT OUTER JOIN
					series ss ON b.super_series_id = ss.id
				WHERE b.is_active = 1 
				ORDER BY
					s.name