
|

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=50405
) 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=60612
) 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=59638
) 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=60137
) 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=59663
) as subquery
Connect for Kids
<< Back to organisation profile
Features
28.01.2003
The U.S. government is considering striking down regulations prohibiting media organizations from owning several types of media outlets in a single market. 11 year old Children's Pressline reporter Natasha Kirtchuck says such a rules change will limit the diversity of ideas children need to grow into good citizens.
Story link
Related topics/regions:
[United States]
27.01.2003
Committed adoption workers are raising money and finding homes for American teenagers despite numerous difficulties. In finding homes for teenagers to be adopted, workers have to fight against notions that teenagers are too grown up to be adopted. Read on for interesting case studies.
Story link
Related topics/regions:
[United States]
Image: Statue of Liberty, US
31.12.2002
The number of youth courts or teen courts have gone up in the US once it was found that these are a promising alternative to the juvenile justice system. Such courts work as both an intervention and prevention program.
Story link
Related topics/regions:
[United States]
02.12.2002
More and more children are falling prey to depression, not only because of better diagnostic tools, but also because of stress. The inability of children to deal with stress is exacerbating the problem of depression. Read more from an adult who suffered depression during youth.
Story link
Related topics/regions:
[United States]
15.11.2002
An American initiative in New Hampshire has found 40 families willing to act as foster parents for children. These families help build communication with a child's birth parents. The foster families, also called resource families, work with sponsoring agencies and the child's family toward reunification of the child.
Story link
Related topics/regions:
[United States]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| < 9 >
| 10
| 11-17
| Next >>
|
 |


|
 |