SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 30)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.section
WHERE c.id = 79
LIMIT 0, 1
SELECT cc.title AS category, a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 79
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-11-21 18:07:57' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-11-21 18:07:57' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 9
SELECT cc.title AS category, a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 79
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-11-21 18:07:57' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-11-21 18:07:57' )
ORDER BY a.created DESC, a.created DESC
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 30 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-21 18:07:57' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-21 18:07:57' )
AND cc.id = 67
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
The Laguna Lake Development Authority (LLDA) and Philippines's National
Meat Inspection Service (NMIS) organized an orientation for regulators
at the Compliance Assistance Center (CAC)Â for Slaughterhouses in the
Laguna de Bay Region in Calauan, Philippines on March 7, 2008. As one
of the CAC's first activities, the workshop involved briefing
regulators on the CAC's services and the relationship between the CAC
and the implementation of environmental laws. Â Over 90 participants
from local government agencies engaged CAC representatives in a
discussion to learn how the center can improve compliance among the
regulated community. The workshop also provided participants an
opportunity to discuss improving coordination and ensuring consistent
information exchange to strengthen enforcement at different levels and
to promote compliance in the slaughterhouse industry. As part of an
overarching compliance assistance program, AECEN supports members in
the Philippines and Thailand strengthen compliance promotion in the
slaughterhouse and hog-farm sectors. A formal launch of the
Philippines's slaughterhouse and hog-farm assistance centers is planned
for April 29, 2008.
Links
