Advertising-legacySELECT DISTINCT companies.*, SUM(cc.weight) AS catsum FROM companies LEFT JOIN company_categories AS cc ON cc.company_id = companies.id LEFT JOIN categories AS cat ON cc.category_id = cat.id LEFT JOIN categories AS pcat ON pcat.id = cat.parent_category_id WHERE DATE(companies.date_published) <= '2020-10-20' AND (companies.date_expires >= '2020-10-20' OR companies.date_expires IS null) AND companies.date_rejected IS null AND (cat.urlname IN ('Advertising-legacy') OR pcat.urlname IN ('Advertising-legacy')) GROUP BY companies.id ORDER BY catsum DESC, date_modified DESC, date_added DESC Currently Available Advertising Agencies & Freelancers in Asia | CreativeHunt

Join CreativeHunt

Asia's largest creative industry network & guide

  • POST JOB VACANCIES

  • LIST YOUR AGENCY

  • APPLY FOR JOBS

  • CREATE ALERTS

  • REQUEST QUOTATIONS

  • CONNECT WITH OTHERS

Create an Account

Already have an account? Sign In

Creative Directory

526 Currently Available Agencies and Freelancers

Directory > Advertising 158 Listings Found

Get Listed