Companies under Marketing & Advertising--->Advertising Browse by Category
SELECT current_plan_package,business_name,
business_id,
big_description,
small_description,
address1,
address2,
building_name,
area, city,
nearest_busstop,
state,
country,
zipcode, seo_url,contact_email FROM bd_business_description WHERE mirror='0' AND status='1' AND business_id IN( SELECT business_id FROM bd_business_category WHERE category_id IN (SELECT CategoryID FROM bd_category WHERE Name='Advertising') ) AND office_type='headquarter' ORDER BY current_plan_package DESC
Showing Results 1 - 10 of 10 To get more results, select a specific city, town or area.