The Petroleum Alliance of Oklahoma 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=31975071 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=31975071 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_company_AZ_name] ASC ) The Petroleum Alliance of Oklahoma Buyers Guide :: Listings

The Petroleum Alliance of Oklahoma Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

Insperity

101 Park Avenue, Suite 1400, Oklahoma City, OK 73102
(405) 807-6029

View More...

Insurance One Agency, Inc.

1214 N Highway 81, Suite 106, Duncan, OK 73533
(580) 255-0001

View More...

Insurance Risk Partners

914 N Broadway Avenue, #100, Oklahoma City, OK 73102
(405) 246-0261

View More...

Insurica

406 S Boulder Avenue, Suite 600, Tulsa, OK 74103
(918) 346-6965

View More...

Insurica

5100 N Classen Blvd, Suite 300, Oklahoma City, OK 73118
(405) 556-2322

View More...

Insurica

5100 N Classen Blvd, Suite 300, Oklahoma City, OK 73118
(405) 556-2378

View More...

Insurica

5100 N Classen Blvd, Suite 300, Oklahoma City, OK 73118
(405) 556-2227

View More...

Insurica

5100 N Classen Blvd, Suite 300, Oklahoma City, OK 73118
(405) 556-2370

View More...

Insurica

5100 N Classen Blvd, Suite 300, Oklahoma City, OK 73118
(405) 850-3585

View More...

Insurica

406 S Boulder Avenue, Suite 600, Tulsa, OK 74103
(918) 346-6984

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

The Bramlett Agency

The Bramlett Agency

Trinity Consultants

Trinity Consultants

OSU Fire Service Training

OSU Fire Service Training

High Spring Land Company, LLC

High Spring Land Company, LLC

Tres Management, Inc.

Tres Management, Inc.

To Top

×

Marabou Midstream Services, LLC

20 Continue to site →