Websites de abogados y procuradores


select count(*) as num_reg,provincia from procuradores where www like 'http://www.procuradordelostribunales.net/%' and codprov=47 group by provincia