select v.* from virtual_assistants.virtual_assistants v , virtual_assistants.choice_subcategories cs where v.id=cs.virtual_assistant_id GROUP BY v.name order by v.nameSELECT command denied to user 'root'@'roo.deskdemon.com' for table 'virtual_assistants'