Recovery Lic# R 9500016 | Investigative Lic# A 9600149 Monday, 06 February 2012   Home Our Services Coverage Areas Legal Docs State Laws Contact Info Recovery Order
Home Legal Docs Licenses, Insurance and Certifications Click image for viewable version of document:  Recovery License # R 9500016  Investigative License # A 9600149 National Finance Adjusters Bond Click here to download our Florida W-9 Click here to for our Rhode Island W-9 Insurance Certificates  For a copy of a current Acord, contact: Walter P. Geoghan Agency 631.472.5000 [ 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 template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='28' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1328554571)
4
SELECT * FROM mos_session WHERE session_id='44843f608a963562ad48143bfab76af6'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('0b4c0e9c523b8d4ed7874a8ef1cc0a7e')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'df8bfe8f94ecab9619b850bd1c9c435b','1328555471','','0','1' )
7
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
8
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
9
SELECT access FROM mos_menu WHERE id='28'
10
SELECT * FROM mos_menu WHERE id='28'
11
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, g.name AS groups, cc.name AS category
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 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_sections AS s ON a.sectionid = s.id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-06 14:11:11' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-06 14:11:11' )
 AND a.access <= '0'
 AND a.catid IN ( 14 ) 
 AND s.access <= 0
 ORDER BY a.created DESC
12
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'
13
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'
14
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
15
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
16
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
17
SELECT * FROM mos_mambots WHERE id='16'
18
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=13
19
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_blog_section' AND m.published='1' AND i.id=13
20
SELECT 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' AND i.id=13
21
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
22
SELECT * FROM mos_components WHERE id='17'
23
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 = '28' OR mm.menuid = '0')
ORDER BY ordering
24
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
25
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
26
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering