Mysqli: how to make a sample with the limit value pairs IN?

There is a table contacts with fields id|city_id|category_id|email
Now the query is this:
"SELECT (id,email) FROM contacts WHERE city_id IN (".implode(',', $arrCity).") AND category_id IN (".implode(',', $arrCategory).")"

How to make for each pair city->category was chosen by 10 entries?
June 14th 19 at 18:55
2 answers
June 14th 19 at 18:57
IMHO, just across the UNION of subqueries for each pair
June 14th 19 at 18:59
I agree with Rsa97, do 2 queries with limits and ayedina their UNION is ω.

Find more questions by tags MySQL