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 jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(20,218,227,51,52,230,24,219,54,228,225,224,229,233,221)
AND jf_content.reference_table='menu'
SELECT *
FROM `jos_rsform_config`
SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou
FROM jos_rsform_forms
WHERE FormId='10'
SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM jos_rsform_forms
WHERE FormId='10'
AND `Published`='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='10'
AND Published='1'
SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
ORDER
FROM jos_rsform_properties p
LEFT JOIN jos_rsform_components c
ON (c.ComponentId=p.ComponentId)
LEFT JOIN jos_rsform_component_types ct
ON (ct.ComponentTypeId=c.ComponentTypeId)
WHERE c.FormId='10'
AND p.PropertyName='NAME'
AND c.Published='1'
ORDER BY c.
ORDER
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM jos_rsform_properties
WHERE `ComponentId` IN (170,165,169,166,168)
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='41'
AND FormId='10'
AND Published='1'
SELECT params
FROM jos_components AS c
WHERE c.OPTION='com_widgetkit'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 221)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT m.*, am.params AS adv_params
FROM jos_modules AS m
LEFT JOIN jos_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
ORDER BY m.ordering, m.id
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1,294,308,309,340,341,353,29,134,255,333,348,291,301,337)
AND jf_content.reference_table='modules'
SELECT params
FROM jos_advancedmodules
WHERE moduleid = 134
SELECT *
FROM jos_languages
WHERE active=1
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 jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(20,218,227,51,52,230,24,219,54,228,225,224,229,233,221)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(221)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=3
AND jf_content.published=1
AND jf_content.reference_id IN(221)
AND jf_content.reference_table='menu'
