Re: Faster SQL - newbie needs help

[Morgan Gustafsson]

Ok,

I've managed to find a much faster query but trial and error. This one is much faster:

SELECT a.*
FROM jos_zoo_item as a
JOIN(

SELECT d.item_id FROM jos_zoo_search_index as d

JOIN(SELECT b.item_id FROM jos_zoo_search_index as b WHERE b.element_id = '688d9a68-5ce2-4c53-b226-a053499ef634' AND b.value LIKE '%Stockholms län%') as b ON d.item_id = b.item_id
JOIN(SELECT c.item_id FROM jos_zoo_search_index as c WHERE c.element_id = 'b018bdde-dc6e-401a-9619-7c0edfb490a7' AND c.value LIKE '%Data och IT%') as c ON d.item_id = c.item_id

WHERE d.value LIKE '%Britny%'

) as d ON a.id = d.item_id;