Oklahoma Trucking 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=31976570 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=31976570 and wse_displayflag=4))) ORDER BY [adv_priority] DESC,[adv_basic] DESC,[adv_associate] DESC,[adv_company_AZ_name] ASC ) Oklahoma Trucking Association Buyers Guide :: Listings

Oklahoma Trucking Association Buyers Guide

FEATURED COMPANIES

Company Listings All Listings

The CDL School LLC

(305) 638-2200

View More...

Central States Thermo King of Oklahoma, Inc.

P O Box 270543, Oklahoma City, OK 73137
(405) 623-2520

View More...

Central Technology Center

3 Court Circle, Drumright, OK 74030
(918) 352-7312

View More...

CITY TRAILER, INC.

10220 W Reno Avenue, Oklahoma City, OK 73127
(405) 947-4885

View More...

CJ & Company

4075 Saint Croix Drive, Edmond, OK 73025
(405) 401-6929

View More...

Clear View Insurance Services

1901 N Moore Avenue, Suite #20, Moore, OK 73160
(405) 990-8144

View More...

Cline Wood a Marsh & McLennan Agency LLC Co

(913) 451-3900

View More...

Cline Wood, a Marsh & McLennan Agency LLC Company

2301 E Lamar Boulevard, Suite 300, Arlington, TX 76006
(913) 451-3900

View More...

Coffeyville Resources Crude Transportation

(918) 984-6300

View More...

Compliance Resource Group

(405) 943-6465

View More...

...Previous
Next...
Showing results

SPOTLIGHTS

CSTK Oklahoma City

CSTK Oklahoma City

Oklahoma City Tarp and Supply

Oklahoma City Tarp and Supply

Joe's Hand Cleaner

Joe's Hand Cleaner

Spirit Lead Revival Ministries

Spirit Lead Revival Ministries

To Top

×

CITY TRAILER, INC.

20 Continue to site →