Change Password
Logout
SIDEBAR SKINS
Light
Dark
HEADER SKINS
Welcome
Dashboard
Purchase Order
Member
Judging
Judges
Judges Display Order
Scores
Scores (Without Thumbnail)
Re-Evaluation
Entry
Submitted Entries
Revision Entries
Draft & Unpaid Entries
Inquiry
Newsletter Subscriber
Marketing Reports
Member Analytics
Member Past Winner
Members States
Member Summary
Categories Analytics
Subcategory Analytics
Categories Summary
Reports
Sales Report
Entry By Category
Entry By Agent
Sales By Country
Entries By Country
How Find TITAN
Store Orders
Winners Report
Winners By Entry Report
Sales Summary Report
Entry Sales Report
Winner's Package
Jury Judging Report
Annual Invoice
E-Invoice Report
Nomination Friends
Top Agency
Agent Commission
Endorsement Letter
Interview Report
Video Interview Report
Media Package
Media Package Report
Media Package Orders
Media Package Items Status
Media Package
Industry Channel
Special Discount
Discount Report
Cross-Promotion Code
Discount Code
Discount Type
Featured Awards
System
Awards Banner
Banner
Brands
Category
Competition
Country
Delivery
Gallery
Featured Juror
Featured Winner
TITAN Highlighted Winner
Product
Rating Criteria
Content
Testimonial
Event Gallery
Interview Questions
Media
SEO
Users
Competition
Competition
Edit
Season
Season 1
Season 2
Year
Season
PO Code
Entry Code
Entry Date
From
To
Judging
From
To
Early Results Date
Results Date
Results Date Display
Number of Entries
Number of Countries
Display Early Results (Deadlines & Fees Table)
Display
Hide
Display Last Minute / Optima (Deadlines & Fees Table)
Display
Hide
Publish Winner (Winner Page)
Publish
Hide
Publish Judge (Grand Jury Panel)
Publish
Hide
Re-Evaluation Status
Active
Inactive
Early Bird
Display Date
Dateline (Display)
From
To
Entry Submission Date
From
To
Single (Website)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Campaign (Business)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Regular
Display Date
Dateline (Display)
From
To
Entry Submission Date
From
To
Single (Website)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Campaign (Business)
Professional
$
.00
Professional Additional Category
$
.00
Professional
$
.00
Agent Additional Category
$
.00
Final
Display Date
Dateline (Display)
From
To
Entry Submission Date
From
To
Single (Website)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Campaign (Business)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Final Extension
Display Date
Dateline (Display)
From
To
Entry Submission Date
From
To
Single (Website)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Campaign (Business)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Last Minute / Optima
Display Date
Dateline (Display)
From
To
Entry Submission Date
From
To
Single (Website)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Campaign (Business)
Professional
$
.00
Professional Additional Category
$
.00
Agent
$
.00
Agent Additional Category
$
.00
Admin Fee
Admin Fee (First Entry)
$
.00
Winner Package
Winner Pack
$
.00
Winner Pack Worth
$
.00
Winner Pack Desc
Express Judging
Express Judging Status
Active
Inactive
Express Judging
$
.00
Entry Re-Evaluation
Re-Evaluation Status
Active
Inactive
Re-Evaluation Per Entry
$
.00
Special Discount
Special Discount Status
Active
Inactive
Award Featuring (Cross-Promotion)
Active
Inactive
Most Awarded Companies
Most Awarded Companies
$
.00
Ranking Status
Publish
Leading
Hide
Title
Sub title
SQL Select
SELECT sum(a.score) as total, a.competition_id, a.entry_id, a.member_id, a.result_id, m.first_name, m.last_name, m.company, m.display_company, m.country, m.facebook, m.twitter, m.behance, m.instagram, m.linkedin, m.website, m.writeup, m.logo FROM bs_agency a left join bs_member m on a.member_id = m.id WHERE a.competition_id = '2' and a.member_id in (SELECT member_id FROM bs_po where agency=1 and status=1 and competition_id = '2' group by member_id) group by a.member_id ORDER BY sum(a.score) DESC limit 10
Content
<p> Every year, the TITAN Business Awards selects 10 outstanding companies who participated and won the most categories in the TITAN Business Awards based on specified criteria set by the International Awards Associate (IAA). These 10 companies are the epitome of creativity, strategy and expertise, where their unique understanding in business strategies allow them to think outside the box and into the realm of near perfection. </p> <p class="mt-md"> The curated list represents an influential mix of companies that flourishes under the spotlight – titans of the industry, organizations, entrepreneurs, independent creative professionals, PR & communications firms, and marketers. In a world filled with pockets of creativity, the best creatives will find their inner TITAN and craft operations that will elevate the entirety of humanity. </p>
Cancel