When you use union to combine queries, get results and order them or apply limit : it doesn't work as expect. Check the code below