SELECT *, t.votes_up + t.votes_down AS votes_total, t.votes_up / (t.votes_up + t.votes_down) * 100 AS votes_pct_up
FROM `thumbsup_items` as t
JOIN `hh_videos` as r ON SUBSTRING(`t`.`name`, 7) = `r`.`id`
WHERE `r`.`active` =  '1'
AND `r`.`release` >= '2016-04-02'
AND  r.title  LIKE '%(2016)%'
AND  t.name  LIKE 'video-%'
ORDER BY votes_pct_up DESC
LIMIT 7 OFFSET 42