Imperial War Museum London

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'imperial war museum london') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'imperial war museum london') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') and keywords like '%imperial%' and keywords like '%war%' and keywords like '%museum%' and keywords like '%london%' ORDER BY Score DESC LIMIT 0, 6