|
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=157142
) 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=154722
) 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=154527
) 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=154482
) 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=153834
) as subquery
Link TV
<< Back to organisation profile
Features
23.01.2008
Despite President Bush's optimism at the end of his Middle East peace tour, analyst Jamal Dajani paints a very different picture, citing recent bouts of violence between Israelis and Palestinians, as well as political complexities within their respective governments.
Story link
Related topics/regions:
[Israel]
[Palestine]
[United States]
Related links
01.11.2007
Explore, through this video, the daily routine of one doctor in a small, isolated village in Southern Mali as he tends to the medical needs of over 40,000 patients.
Story link
Related topics/regions:
[Mali]
Related links
26.10.2007
The majority of the 42 million people with HIV live in Africa, but the fastest growing HIV infection rate in the world is in Russia where prostitution and drug use with unsanitary needles is driving the epidemic.
Story link
Related topics/regions:
[Russian Federation]
Related links
25.10.2007
Ibstisam Mara'ana was destined to be married off in a deal along with her brother because she was "too old and dark, and too ugly," but she refused. Then she made this documentary exposing the process of "badal" marriages, agreements aimed to secure a husband for daughters believed to be "less marriageable."
Story link
Related topics/regions:
[Palestine]
Related links
04.10.2007
A Link TV special looks at the treatment of United States' war veterans, including homeless vets from Iraq and Vietnam and a paralyzed 25-year-old who finds his voice against today's war. Discover their stories and find out how you can get involved.
Story link
Related topics/regions:
[United States]
Related links
<< Previous
| 1
| 2
| 3
| 4
| Next >>
|
|
|
|
