select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=144048
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=141237
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=141209
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=136867
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=123158
) as subquery
20.12.2006
Joseph Williams is working to help reduce criminal recidivism in the United States while Caroline Casey is helping promote the contributions people with disabilities make to business in Ireland. Wayan Patut is helping conserve coral reefs in Indonesia, Abdellah Aboulharjan is fostering entrepreneurship in France's immigrant communities...the list goes on and on and on...
21.10.2006
Ashoka supports remarkable leaders finding creative solutions to society's toughest problems--poverty, corruption, instability, and more. Discover their stories.
20.10.2006
Ashoka supports remarkable leaders finding creative solutions to society's toughest problems--poverty, corruption, instability, and more. Discover their stories.
24.07.2006
Three citizen organizations in India have joined forces to help slum residents organize themselves to gain the skills they need to be powerful advocates for their own interests. Writer activist Arundhati Ray writes how these organisations, with the cooperation of local government agencies and banks, have taken control of real estate in Indian cities.
Harvard University's Center for Public Leadership and U.S. News & World Report named Bill Drayton as one of America's Best Leaders, along with 24 other individuals including Colin Powell, Bill and Melinda Gates and Oprah Winfrey. All 25 leaders share a clearly articulated vision, measurable results, and, in the words of one management guru, Big Hairy Audacious Goals.
