joomla/joomla-cms — pull request #4144 by nonumber (2014-08-22 07:29:43+00:00)
Title: Fix ineffecient queries: OR => IN

This PR fixes the places where multiple ORs are used instead on an IN.
So instead of doing:
```WHERE id = 1 OR id = 3 OR id = 5```
it should be:
```WHERE id IN (1, 3, 5)```

Using IN vs OR:
* Uses less code
* Easier to maintain
* Easier to understand
* And most importantly: IN is 2 - 3 times faster than OR (depending on indexes, how many ORs, etc)