estorus

this is the problem code:

SELECT saeeposts . *
FROM saeeposts
LEFT JOIN saeeterm_relationships ON ( saeeposts.ID = saeeterm_relationships.object_id )
LEFT JOIN saeeterm_relationships AS tt1 ON ( saeeposts.ID = tt1.object_id )
INNER JOIN saeepostmeta ON ( saeeposts.ID = saeepostmeta.post_id )
INNER JOIN saeepostmeta AS mt1 ON ( saeeposts.ID = mt1.post_id )
INNER JOIN saeepostmeta AS mt2 ON ( saeeposts.ID = mt2.post_id )
INNER JOIN saeepostmeta AS mt3 ON ( saeeposts.ID = mt3.post_id )
INNER JOIN saeepostmeta AS mt4 ON ( saeeposts.ID = mt4.post_id )
INNER JOIN saeepostmeta AS mt5 ON ( saeeposts.ID = mt5.post_id )
INNER JOIN saeepostmeta AS mt6 ON ( saeeposts.ID = mt6.post_id )
INNER JOIN saeepostmeta AS mt7 ON ( saeeposts.ID = mt7.post_id )
INNER JOIN saeepostmeta AS mt8 ON ( saeeposts.ID = mt8.post_id )
INNER JOIN saeepostmeta AS mt9 ON ( saeeposts.ID = mt9.post_id )
INNER JOIN saeepostmeta AS mt10 ON ( saeeposts.ID = mt10.post_id )
WHERE 1 =1
AND (
saeeterm_relationships.term_taxonomy_id
IN ( 470 )
AND tt1.term_taxonomy_id
IN ( 468 )
)
AND (
(
saeepostmeta.meta_key = 'sp_format'
AND saeepostmeta.meta_value
IN (
'league'
)
)
AND (
(
mt1.meta_key = 'sp_team'
AND mt1.meta_value
IN (
'7896'
)
)
AND (
mt2.meta_key = 'sp_team'
AND mt2.meta_value
IN (
'12445'
)
)
AND (
mt3.meta_key = 'sp_team'
AND mt3.meta_value
IN (
'12446'
)
)
AND (
mt4.meta_key = 'sp_team'
AND mt4.meta_value
IN (
'12447'
)
)
AND (
mt5.meta_key = 'sp_team'
AND mt5.meta_value
IN (
'7904'
)
)
AND (
mt6.meta_key = 'sp_team'
AND mt6.meta_value
IN (
'12448'
)
)
AND (
mt7.meta_key = 'sp_team'
AND mt7.meta_value
IN (
'12449'
)
)
AND (
mt8.meta_key = 'sp_team'
AND mt8.meta_value
IN (
'7891'
)
)
AND (
mt9.meta_key = 'sp_team'
AND mt9.meta_value
IN (
'7898'
)
)
AND (
mt10.meta_key = 'sp_team'
AND mt10.meta_value
IN (
'12450'
)
)
)
)
AND saeeposts.post_type = 'sp_event'
AND (
(
saeeposts.post_status = 'publish'
OR saeeposts.post_status = 'future'
)
)
GROUP BY saeeposts.ID
ORDER BY saeeposts.post_date DESC