SELECT companies id companies name IF franchise id franchise id as fra

SELECT
	companies.id,
	companies.name,
	IF (franchise.id > 0, franchise.id, 0) as franchise,
	COUNT(DISTINCT comp_tags.tid) as q
FROM
	cities,
	city_delivery,
	districts,
	companies LEFT JOIN franchise ON (
		companies.parent = franchise.id
	),
	comp_tags
WHERE
	cities.id IN (10)
		AND
	cities.id = districts.cid
		AND
	districts.id = city_delivery.district
		AND
	city_delivery.cid = companies.id
		AND
	companies.id = comp_tags.cid
		AND
	comp_tags.tid IN (16,17)
GROUP BY
	IF (franchise.id > 0, companies.name, companies.id)
HAVING
	IF (0, q = 2, 1)