Untitled

SELECT `t`.*, TRUNCATE((COUNT(`t`.`title`) / (SELECT COUNT(*) FROM `tags` AS `t` LEFT JOIN `markers` AS `m` ON t.markers_id = m.id LEFT JOIN `polylines` AS `pl` ON t.polylines_id = pl.id LEFT JOIN `polygones` AS `pg` ON t.polygones_id = pg.id WHERE (m.active = 1) OR (pl.active = 1) OR (pg.active = 1))) * 100, 0) AS `weight` FROM `tags` AS `t` LEFT JOIN `markers` AS `m` ON t.markers_id = m.id LEFT JOIN `polylines` AS `pl` ON t.polylines_id = pl.id LEFT JOIN `polygones` AS `pg` ON t.polygones_id = pg.id WHERE (m.active = 1) OR (pl.active = 1) OR (pg.active = 1) GROUP BY `title` ORDER BY `weight` ASC