SELECT s.name,
       IF(s.country = 'Brasil', s.headquarters,
       CONCAT(s.headquarters, '/', s.country)) headquarters,
       s.url,
       (SELECT CONCAT(GROUP_CONCAT(userid)) FROM ranking_ratings WHERE storeid = s.id AND rating > 0) pos_ratings,
       (SELECT CONCAT(GROUP_CONCAT(userid)) FROM ranking_ratings WHERE storeid = s.id AND rating < 0) neg_ratings,
       ((SELECT COUNT(rating) * -1 FROM ranking_ratings WHERE rating < 0) +
        (SELECT COUNT(rating) FROM ranking_ratings WHERE rating > 0)) rating
FROM   ranking_stores s