select aoldata.querydata.query,
count(aoldata.querydata.query) as Anzahl
FROM aoldata.querydata
WHERE aoldata.querydata.query LIKE '%indiana%flood%' or aoldata.querydata.query LIKE '%flood%indiana%' or aoldata.querydata.query LIKE '%flood%indiana%'
or aoldata.querydata.query LIKE '%flood%minnesota%' or aoldata.querydata.query LIKE '%minnesota%flood%'
or aoldata.querydata.query LIKE '%flood%north dakota%' or aoldata.querydata.query LIKE '%north dakota%flood%'
GROUP BY aoldata.querydata.query
order by Anzahl desc;