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

Insurica

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

View More...

International Insurance Brokers, Ltd.

P O Box 35487, Tulsa, OK 74153
(918) 477-4124

View More...

International Insurance Brokers, Ltd.

3300 MidContinent Tower, 401 South Boston Avenue, Tulsa, OK 74103
(918) 592-4200

View More...

Intrust Bank

1450 S Kelly Avenue, Edmond, OK 73003
(405) 409-4998

View More...

ITC Pipe

4951 S Mingo Road, Tulsa, OK 74146
(918) 496-2476

View More...

iWell

3246 Centennial Blvd, Suite #214, Colorado Springs, CO 80907
(800) 219-0141

View More...

J&L Oilfield Services

1722 S Main Street, Shattuck, OK 73858
(580) 938-2205

View More...

J-W Power Company

15505 Wright Brothers Drive, Addison, TX 75001
(972) 661-4787

View More...

J-W Power Company

15201 NW 34th Street, Yukon, OK 73099
(405) 350-2915

View More...

J-W Power Company

15201 NW 34th Street, Yukon, OK 73099
(405) 350-2919

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

OSU Fire Service Training

OSU Fire Service Training

Trinity Consultants

Trinity Consultants

Tres Management, Inc.

Tres Management, Inc.

High Spring Land Company, LLC

High Spring Land Company, LLC

The Bramlett Agency

The Bramlett Agency

To Top

×

Baseline Minerals, LLC

20 Continue to site →