[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.
×
Need Help?
Shortlister helps thousands of employers find the right vendor every year. We efficiently and accurately identify the shortlist of vendors that can meet your program goals and guide you through the selection process.
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
[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’
‘;}}
[/insert_php]