News

• NY Law Firm of the Year
    - Benchmark Litigation
• Litigation Boutiques Hot List
    - The National Law Journal
• Women Worth Watching
    - Profiles in Diversity Journal
  
• Litigation Trailblazers 
  - The National Law Journal

Debugging info

---

select if (length(items.urlpart), items.urlpart, items.news_id) as id,
	items.news_id as news_id,
	title,
	publication,
	itemdate,
	itemdate_datehide,
	altdate,
	exturl,
	if (length(items.content), 1, 0) as has_content,
	items.attachment_attachcount as attachcount,
	sp_a.sp_attachment_id as sp_attachment_id,
	sp_a.filename as sp_filename,
	sp_a.mimetype as sp_mimetype
from news items
left outer join sp_attachment sp_a on (
						items.attachment_attachcount = 1
						and items.news_id = sp_a.item_id
						and sp_a.table_tag = 'news'
						and sp_a.field_tag = 'attachment'
						)
where (items.bioonly != 1)
and (to_days(current_date) - to_days(itemdate) < 3650)
and (items.deactivated = 0)
and (items.draft_of = 0)
order by itemdate DESC, seq
limit 0, 9999999