Recovery Lic# R 9500016 | Investigative Lic# A 9600149 Sunday, 20 May 2012   Home Our Services Coverage Areas Legal Docs State Laws Contact Info Recovery Order
Home NERS News Welcome to the all new NERSrecovery.com! We hope that you will enjoy our updated look and find the site to be informative and useful.  Some of the key features are: Searchable database of All NERS coverage areas. Downloadable and printable catalog of all NERS coverage areas Direct login access to the NERS database Viewable and printable versions of our licenses, insurance and certificates NEW!!  Rhode Island Legal Changes, Click Here To See About Us At NERS, our philisophy has always been to serve the finance industry with loyalty, efficiency and quality. Since its incorporation, NERS has grown from our corporate office in East Providence, Rhode Island to branch offices in Massachusetts and Florida. In addition we offer a wide variety of services, which includes; nationwide forwarding, remarketing, skip tracing, secure indoor storage facilities, timely updates, comprehensive condition reports and transportation of your collateral to your choice of destination within our coverage area. Trust a company that has been in business for over 30 years. Trust NERS. Contact us at 1-800-301-NERS. [ Back ]	Search Our Site Login to the NERS Database Login  Pass  ID Code    We Are Proud Members of: Insurance by Walter P. Geoghan Agency 631.472.5000
©Copyright 2005. All rights reserved. NERS Collateral Recovery Specialists, LLC Site Designed By Brady Stone designs

Username Password Remember me Forgotten your password?

1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1337542119)
5
SELECT * FROM mos_session WHERE session_id='aaed28cb818cb050448cf224f2fd1736'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('972710fdfe391b0e55601f0da4ed03c3')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '4fa3f573aa228a340081d888a0c7bc5d','1337543019','','0','1' )
8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
9
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
10
SELECT access FROM mos_menu WHERE id='1'
11
SELECT * FROM mos_menu WHERE id='1'
12
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-05-20 15:43:39'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-05-20 15:43:39' )
 ORDER BY f.ordering
13
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
14
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
15
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
16
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
17
SELECT id FROM mos_mambots WHERE element = 'mosimage' AND folder = 'content'
18
SELECT * FROM mos_mambots WHERE id='1'
19
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
20
SELECT * FROM mos_mambots WHERE id='16'
21
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=1
22
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
23
SELECT * FROM mos_components WHERE id='17'
24
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
25
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
26
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
27
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
28
SELECT a.id
 FROM mos_content AS a
 INNER JOIN mos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access <= '0' AND b.access <= '0'
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 15:43:39') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 15:43:39')
 AND catid='3' 
 ORDER BY a.ordering
29
SELECT * FROM mos_content WHERE id='2'
30
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
31
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
32
SELECT * FROM mos_mambots WHERE id='16'
33
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=2