1select
 2  count(track.id_terminal)
 3, company.name as myResult
 4from  track,detailsForTerminal, client,service,terminal, customer,customerGroup,Location,Item,company_plan,company
 5Where track.id_client = client.client_id
 6and
 7detailsForTerminal.id_terminal = track.id_terminal
 8and
 9detailsForTerminal.id_group = customerGroup.customerGroup_id
10and
11service.id_client = client.client_id
12and
13service.id_rm = terminal.terminal_id
14and
15track.id_customer = customer.customer_id
16and
17customerGroup.id_customer = customer.customer_id
18and terminal.serial = Location.rm_serial
19and
20Location.id_Item = Item.Item_id
21and
22Item. id_plan =  company_plan.companyplan_id
23and company_plan.id_company = company.company_id
24and customer.customer_id = 100
25group by company.name