|
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=101048
) 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=100879
) 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=93886
) as subquery
Consumer Online Foundation
<< Back to organisation profile
Features
10.01.2005
The Indian state of Maharashtra has served show cause notices to the manufacturers of chewing tobacco asking them to reveal the contents of their product. The manufacturers face cancellation of licences if their products contain magnesium carbonate, prolonged use of which can cause oral cancer.
Story link
Related topics/regions:
[India]
05.01.2005
The Supreme Court of India issued a notice to the government on a Public Interest Litigation (PIL) seeking directions for laying down strict guidelines on the manufacture of aerated drinks in India.
Story link
Related topics/regions:
[India]
13.09.2004
The Indian government has prepared a manual that shows a guide on how to make submissions to appropriate courts against fraudulent companies in case of prosecution.
Related topics/regions:
[India]
<< Previous
| 1
| 2
|
|
|
|
|
