Kansas Independent Oil and Gas Association 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=31976392 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=31976392 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_company_AZ_name] ASC ) Kansas Independent Oil and Gas Association Buyers Guide :: Listings

Kansas Independent Oil and Gas Association Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

Glacier Petroleum, Inc.

825 Commercial Street, Post Office Box 577, Emporia, KS 66801
(620) 342-1148

View More...

Gore Nitrogen Pumping Service

Post Office Box 65 , Seiling, OK 73663
(580) 922-4660

View More...

Gore Oil Company

Post Office Box 2757 , Wichita, KS 67201
(316) 263-3535

View More...

Gore Oil Company

(316) 263-3535

View More...

Grady Bolding Corporation

Post Office Box 486, Ellinwood, KS 67526
(620) 564-2240

View More...

Grand Mesa Operating Company

1700 N Waterfront Pkwy, Suite 600, Wichita, KS 67206
(316) 265-3000

View More...

Great Plains Energy Inc.

3110 N 90th, Lincoln, NE 68507
(785) 475-4299

View More...

Great Plains Energy, Inc.

Post Office Box 23, Wahoo, NE 68066
(402) 443-4340

View More...

Greg's Electric Motor Service

Post Office Box 267, Ransom, KS 67572
(800) 524-2285

View More...

Griffin Management, LLC

Post Office Box 347, Pratt, KS 67124
(620) 672-9700

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

Gore Nitrogen Pumping Service, LLC

Gore Nitrogen Pumping Service, LLC

Victaulic Oil

Forvis Mazars, LLP

Forvis Mazars, LLP

Cathodic Systems Co

Cathodic Systems Co

To Top

×

Bluemark Energy

20 Continue to site →