North Carolina Association of Chiefs of Police Buyers Guide :: Listings

PDOStatement Object ( [queryString] => SELECT adv_id, adv_gui_id, adv_associate, adv_basic, adv_priority, adv_featured, adv_company_name, REPLACE(adv_company_name,'The ','') AS adv_company_AZ_name, adv_address1, adv_address2, adv_city, adv_state, adv_zip, adv_zip_ext, adv_first_name, adv_last_name, adv_showaddr, adv_phone, adv_phone2, adv_url, adv_company_desc, adv_company_desc_plain, adv_image_logo, adv_spr_id, adv_car_id, adv_url_display, adv_tamem, adv_sponsor, adv_size_upgrade, isnull(adv_sponsor_type,0) as adv_sponsor_type, adv_intl_phone, adv_phone_ext, adv_phone2_ext, adv_company_desc_textonly, adv_rank, gui_tamem_image_location, adv_twiter, adv_pintrest,adv_google,adv_facebook,adv_LinkedIn,adv_Instagram, adv_Youtube,adv_in, adv_email FROM advertisers JOIN Guide ON gui_id = adv_gui_id WHERE adv_gui_id=31976476 AND adv_id not in (SELECT adv1.adv_id FROM advertisers as adv1 JOIN mappings on map_adv_id = adv1.adv_id JOIN wscategory on wsc_id = map_wsc_id JOIN wcategory on wca_id = wsc_wca_id JOIN wsection on wse_id = wca_wse_id JOIN guide on gui_id = wse_gui_id WHERE map_wsc_id = wsc_id and ( wca_wse_id in (SELECT wse_id FROM wsection where wse_gui_id=31976476 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_company_AZ_name] ASC ) North Carolina Association of Chiefs of Police Buyers Guide :: Listings

North Carolina Association of Chiefs of Police Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

SaferWatch

(844) 449-2824

View More...

SaferWatch

(407) 376-4808

View More...

Smith Rodgers & Aldridge

Post Office Box 4803, Greensboro, NC 27404
(336) 932-1331

View More...

Smith Rodgers & Aldridge

Post Office Box 4803, Greensboro, NC 27404
(828) 606-3192

View More...

Smith Rodgers & Aldridge

Post Office Box 4803, Greensboro, NC 27404
(336) 691-7058

View More...

Southern Software

(910) 695-0005

View More...

Southern Software, Inc.

(910) 638-1935

View More...

Stanard & Associates, Inc.

309 W Washington Street, Suite 1000, Chicago, IL 60606
(800) 367-6919

View More...

SYMBOLARTS

(435) 881-5401

View More...

SYMBOLARTS

6083 S 1550 E, Ogden, UT 84405
(801) 475-6000

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Brooks Network

Capital Ford Inc

Capital Ford Inc

Off Duty Management

Off Duty Management

Dana Safety Supply

Dana Safety Supply

To Top

×

Brooks Public Safety

20 Continue to site →