tmp.sql

SELECT COUNT(*) AS `count` 
FROM `forms` AS `Form` 
LEFT JOIN forms_tags AS `FormsTags` ON (`Form`.`id` = `FormsTags`.`form_id`) 
LEFT JOIN tags AS `Tag` ON (`FormsTags`.`tag_id` = `Tag`.`id`) 
LEFT JOIN `statuses` AS `Status` ON (`Form`.`status_id` = `Status`.`id`) 
LEFT JOIN `form_types` AS `FormType` ON (`Form`.`form_type_id` = `FormType`.`id`)
LEFT JOIN `summaries` AS `Summary` ON (`Form`.`summary_id` = `Summary`.`id`) 
WHERE ((`Form`.`title` LIKE '%titl%') OR (`Tag`.`title` LIKE '%titl%')) 
GROUP BY `Form`.`id` ;

//Result
+-------+
| count |
+-------+
|     1 |
|     2 |
|     2 |
+-------+

//Desired Result
+-------+
| count |
+-------+
|     3 |
+-------+