MySQL query optimalisatie

SELECT
	verzamel.*
FROM
	(SELECT
		a.*,
		b.naam,
		b.latitude,
		b.longitude
	FROM
		(
			SELECT
				c.*
			FROM
				(
				SELECT
					i.*,
					@rn := CASE WHEN @prev = i.item_id THEN @rn + 1 ELSE 1 END AS num,
					@prev := i.item_id
				 FROM
					items AS i,
					(
						SELECT
							@prev:=0, @rn:=0
					) AS d
				WHERE i.active=1 AND ( i.titel LIKE '%test%' OR i.tekst LIKE '%test%') 
				ORDER BY i.item_id, id DESC
				) AS c
				WHERE num <= 4
		) AS a
	INNER JOIN
		gebruiker AS b ON (b.item_id = a.id)
	WHERE 
		FLOOR(GetDistance(52.2900810,5.6260238, b.latitude, b.longitude )*1.606344) <= "25" 
		GROUP BY 
			a.id,b.id 
	) AS verzamel
GROUP BY 
	verzamel.id
ORDER BY 
	GetDistanceMeters(52.2900810,5.6260238, verzamel.latitude, verzamel.longitude), verzamel.id DESC
LIMIT 0,30

SELECT
	verzamel.*
FROM
	(SELECT
		a.*,
		b.naam,
		b.latitude,
		b.longitude
	FROM
		(
			SELECT
				c.*
			FROM
				(
				SELECT
					i.*,
					@rn := CASE WHEN @prev = i.item_id THEN @rn + 1 ELSE 1 END AS num,
					@prev := i.item_id
				 FROM
					items AS i,
					(
						SELECT
							@prev:=0, @rn:=0
					) AS d
				WHERE i.active=1 AND ( i.titel LIKE '%test%' OR i.tekst LIKE '%test%') 
				ORDER BY i.item_id, id DESC
				) AS c
				WHERE num <= 4
		) AS a
	INNER JOIN
		gebruiker AS b ON (b.item_id = a.id)
	WHERE 
		FLOOR(GetDistance(52.2900810,5.6260238, b.latitude, b.longitude )*1.606344) <= "25" 
		GROUP BY 
			a.id,b.id 
	) AS verzamel
GROUP BY 
	verzamel.id
ORDER BY 
	GetDistanceMeters(52.2900810,5.6260238, verzamel.latitude, verzamel.longitude), verzamel.id DESC
LIMIT 0,30