MySQL syntax for Wordpress

I need to retrieve data from a Parent > Child > Child relationship category setup. And I have no CLUE as to the proper SQL query syntax for that.

Help?

Thanks, Tomer

You don't have to query the database.

They are called breadcrumbs. There are a lot of plugins you can get for this