Counting a row in multiple tables

[xoligy]

Is it possible to count the rows of 5/6 tables and then return the result? Everything ive looked at dont look right lol all the tables are identicle just the names and the data entered is different.

 

Here is how the db looks

Table > setup

Melee - id, item, att, def, limited

Guns - id, item, att, def, limited

another

anothre

 

Break down:

id - primary key, auto inc.

item - name

att/def numbers

limited - is either blank, favor, blackmarket etc etc

 

Now i want to count all records in limited that are = to "favor" in all tables, is this possible or am i going to need seperate querys then add them up? Just thought maybe db doing it be better tho i could be wrong 

[fenway]

UNION then COUNT(*)?