hightlights query v2

SELECT *
FROM (
	SELECT * FROM (
		SELECT history.id AS historyID, history.url AS url, history.title AS title, NULL AS latest, (SELECT count(1) FROM visits WHERE visits.siteID = history.id) as visitCount
		FROM (
			SELECT bmkUri 
			FROM view_bookmarksLocal_on_mirror
			WHERE view_bookmarksLocal_on_mirror.server_modified > 1472836869199 OR view_bookmarksLocal_on_mirror.local_modified > 1472836869199
		)
		LEFT JOIN history ON history.url = bmkUri
		WHERE visitCount >= 3 AND history.title NOT NULL and history.title != ''
		LIMIT 1
	)


	UNION

	SELECT * FROM (
		SELECT history.id as historyID, url, title, latest, (SELECT COUNT(1) FROM visits WHERE s = visits.siteID) AS visitCount
		FROM (
			SELECT siteID AS s, max(date) AS latest
			FROM visits
			WHERE date > 1472836866607250
			GROUP BY siteID
		)
		LEFT JOIN history ON history.id = s
		WHERE visitCount <= 3 AND title NOT NULL AND title != ''
		LIMIT 19
	)
)