[insert_php]
$connArr = explode(‘:’, DB_HOST);
$conn = new mysqli($connArr[0], DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn,”utf8″);
$sql = “SELECT a.*, pref + meet + link + videos + snapshots + docs + date3mo + date1mo as score FROM (
SELECT *,
CASE WHEN preferred = 1 THEN 4 ELSE 0 END as pref,
CASE WHEN MAV = 1 THEN 3 ELSE 0 END as meet,
CASE WHEN linkback = 1 THEN 3 ELSE 0 END as link,
CASE WHEN ((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) THEN 1 ELSE 0 END as videos,
CASE WHEN ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) THEN 1 ELSE 0 END as snapshots,
CASE WHEN has_docs > 0 THEN 1 ELSE 0 END as docs,
CASE WHEN last_updated > now()-interval 3 month THEN 1 ELSE 0 END as date3mo,
CASE WHEN last_updated > now()-interval 1 month THEN 1 ELSE 0 END as date1mo
FROM vendor_data vd
WHERE is_active = 1
AND is_public <> 1
AND vd.vendor_id IN (
SELECT MIN(B.vendor_id) as vendor_id FROM vendor_data B
WHERE B.website = vd.website) ) a
ORDER BY score DESC, name”;

$sql2 = “SELECT name FROM (SELECT a.*, pref + meet + link + videos + snapshots + docs + date3mo + date1mo as score FROM (
SELECT *,
CASE WHEN preferred = 1 THEN 4 ELSE 0 END as pref,
CASE WHEN MAV = 1 THEN 3 ELSE 0 END as meet,
CASE WHEN linkback = 1 THEN 3 ELSE 0 END as link,
CASE WHEN ((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) THEN 1 ELSE 0 END as videos,
CASE WHEN ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) THEN 1 ELSE 0 END as snapshots,
CASE WHEN has_docs > 0 THEN 1 ELSE 0 END as docs,
CASE WHEN last_updated > now()-interval 3 month THEN 1 ELSE 0 END as date3mo,
CASE WHEN last_updated > now()-interval 1 month THEN 1 ELSE 0 END as date1mo
FROM vendor_data vd
WHERE is_active = 1
AND is_public <> 1
AND vd.vendor_id IN (
SELECT MIN(B.vendor_id) as vendor_id FROM vendor_data B
WHERE B.website = vd.website) ) a
ORDER BY score DESC, name LIMIT 20) a order by name”;

$result = $conn->query($sql);
$result2 = $conn->query($sql2);
$result3 = $conn->query($sql2);
[/insert_php]

WELLNESS COMPANIES

Shortlister is trusted by employers and employee benefits consultants to identify their optimal vendor based on their budget,
demographics and program goals. Leverage our expertise to save yourself the time and hassle of navigating the crowded vendor marketplace.

Get My Shortlist

 

Did You Know?

Many top employee benefits consultants already use Shortlister and may be able to provide complimentary access. Click below to find out if you qualify.

Click Here

Top 20 Wellness Companies – Q[insert_php]$n = date(‘n’);
if($n < 4){ $asOf = "1 as of January ".date('Y'); } elseif($n > 3 && $n <7){ $asOf = "2 as of April ".date('Y'); } elseif($n >6 && $n < 10){ $asOf = "3 as of July ".date('Y'); } elseif($n >9){
$asOf = “4 as of October “.date(‘Y’);
}echo $asOf;[/insert_php]

Summary list of the top 20 Wellness providers in Shortlister [insert_php]echo substr($asOf, 1);[/insert_php], presented in alphabetical order. For details on each vendor and a comprehensive list of all wellness companies, scroll down.

  • 1. ADURO
  • 2. Asset Health, Inc.
  • 3. Bravo
  • 4. Health Advocate
  • 5. HealthCheck360
  • 6. Interactive Health
  • 7. Limeade
  • 8. Navigate Wellbeing Solutions
  • 9. New Ocean Health, LLC
  • 10. Optum
  • 11. Orthus Health
  • 12. Propel, Inc.
  • 13. Sonic Boom Wellness
  • 14. StayWell
  • 15. Virgin Pulse
  • 16. Vitality Group
  • 17. WebMD Health Services Group, Inc.
  • 18. Wellness IQ
  • 19. WellRight, LLC
  • 20. Wellworks For You

Wellness Companies

[insert_php]
if (count($result)){
while($row = $result->fetch_assoc()){
if(strlen($row[‘summary’]) > 415){
$summary = substr($row[‘summary’], 0, 415).’…’;
}
else{
$summary = $row[‘summary’];
}
echo’

'.$row['name'].'

‘.$summary .’

More info

‘;}}
[/insert_php]

Get Industry Updates