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=940001954
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=940001954 and wse_displayflag=4)))
ORDER BY (case when [adv_priority]=1 or [adv_sponsor_type]=1 then 1 when [adv_sponsor_type]=2 then 2 when [adv_sponsor_type]=4 then 3 when (isnull([adv_tamem],0)=0 and [adv_basic]=1) then 3 when (isnull([adv_sponsor_type],0)=0 and [adv_basic]=1) then 4 when [adv_sponsor_type]=8 then 5 else 6 end) ASC, [adv_associate] DESC, [adv_company_AZ_name] ASC
)
From our modest beginnings as a regional claims administrator founded in 1969, Sedgwick has grown into a leading global provider of technology-enabled risk, benefits and integrated business solutions with 30,000+...
Sedgwick Managed Care Ohio (MCO) is a workers’ compensation managed care organization focused on helping injured employees return to work safely and quickly. We provide seamless solutions to...
100 California Street, Suite 900, San Francisco, CA 94111
(887) 814-4102
SpotOn is a cutting-edge point-of-sale and software company that empowers business operators with the tools and service they deserve—tools to save time, cut labor costs, connect with...
For generations, Sugardale has been committed to providing the best quality meats for you, your family and friends. Whether it's crispy bacon for family brunch, a delicious hot...
Sysco is the global leader in selling, marketing and distributing food products to restaurants, healthcare and educational facilities, lodging establishments and other customers who prepare meals away from...
Celebrating over 70 years of excellence, Triple A Pro Services is a trailblazer in environmentally responsible services. Specializing in septic systems, grease traps, and food and oil wastewater, our...
UnitedHealth Group (NYSE: UNH) is a health care and well-being company with a mission to help people live healthier lives and help make the health system work better...
Based in Columbus Ohio, The Wasserstrom Company is one of the nation’s leading distributors of foodservice supplies and equipment. From single-unit operations to restaurant chains, healthcare facilities,...
We believe in providing coverage options that are right for you, not everyone else. We have a clear purpose, values instilled in our company and a long, rich...
Burkett Restaurant Equipment & Supplies is a nationally known food-service equipment and supplies dealer, headquartered in Perrysburg, Ohio, USA. Founded by Jameel Burkett and Mike Burkett, the company has...