SELECT name, street_name, number, phone
FROM(
		SELECT
			ci.id, ci.name, cs.name AS street_name, ci.number, ci.phone, ci.work_time,
			cn.name AS n_name, cn.number AS n_number, cn.phone AS n_phone, cn.work_time AS n_work_time, csn.name AS n_street_name,
			ct.name as tag
		FROM cat_item AS ci
		LEFT JOIN cat_street AS cs ON cs.id = ci.street
		JOIN cat_network AS cn ON cn.parent_id = ci.id
		LEFT JOIN cat_street AS csn ON csn.id = cn.street
		JOIN cat_item_tag AS cit ON cit.item_id = ci.id
		JOIN cat_tag AS ct ON ct.id = cit.tag_id
		WHERE visible = 'Y'
	) AS joined_tbl
WHERE
	MATCH(
		name, street_name, number, phone, work_time,
		n_name, n_number, n_phone, n_work_time, street_name,
		tag
	)
	AGAINST('искомое_слово')
GROUP BY ci.id
LIMIT 0, 50

SELECT
	ci.id, ci.name, cs.name AS street_name, ci.phone, ci.number 
FROM cat_item AS ci
LEFT JOIN cat_street AS cs ON cs.id = ci.street
JOIN cat_network AS cn ON cn.parent_id = ci.id
LEFT JOIN cat_street AS csn ON csn.id = cn.street
JOIN cat_item_tag AS cit ON cit.item_id = ci.id
JOIN cat_tag AS ct ON ct.id = cit.tag_id
WHERE
	visible = 'Y' AND
	CONCAT_WS(' ', ci.name, cs.name, ci.number, ci.phone, ci.work_time, cn.name, cn.number, cn.phone, cn.work_time, csn.name, ct.name)
	LIKE '%аптек%'
GROUP BY ci.id