substitute CASE WHEN query for equivalent using AND and OR clauses that can use indices
substitute CASE WHEN query for equivalent using AND and OR clauses that can use indices

zweidner/hubzero-cms,anthonyfuentes/hubzero-cms,zooley/hubzero-cms,zweidner/hubzero-cms,anthonyfuentes/hubzero-cms,zooley/hubzero-cms,zooley/hubzero-cms,zooley/hubzero-cms,anthonyfuentes/hubzero-cms,anthonyfuentes/hubzero-cms,zweidner/hubzero-cms,zweidner/hubzero-cms