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(53,207,352,386,54,208,166,353,223,370,417,419,209,229,354,371,228,301,355,372,242,302,356,373,247,303,357,374,249,304,358,375,248,305,361,376,306,359,377,307,360,378,308,362,380,309,363,379,310,364,381,311,366,382,312,367,383,194,313,334,384,387,193,314,335,385,388,1,336,337,338,389,339,390,340,391,341,392,342,393,343,396,344,411,345,412,346,413,347,414,348,349,350,351,156,157,158,87,88,107,224,225,395,226,231,232,233,234,235,236,237,238,261,262,263,264,265,266,267,268,269,270,230,239,416,240,241,252,250,251,253,254,255,256,257,258,259,260,243,244,245,246,271,272,273,274,275,276,277,278,279,280,281,282,283,284,108,134,145,136,135,140,141,48,142,49,138)
AND jf_content.reference_table='menu'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 53)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.id, a.title, a.alias, 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.images, a.attribs, a.urls, 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, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
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.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
ORDER BY f.ordering
LIMIT 0, 9
SELECT a.id, a.title, a.alias, 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.images, a.attribs, a.urls, 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, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
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.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
ORDER BY f.ordering
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 = 53 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT id, IF(title="","","") AS 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 = 53 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT title
FROM jos_modules
WHERE id=247
SELECT title
FROM jos_modules
WHERE id=266
SELECT *
FROM `jos_rsform_config`
SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou
FROM jos_rsform_forms
WHERE FormId='3'
SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM jos_rsform_forms
WHERE FormId='3'
AND `Published`='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='3'
AND Published='1'
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM jos_rsform_properties
WHERE `ComponentId` IN (41,40)
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='3'
AND p.PropertyName='NAME'
AND c.Published='1'
ORDER BY c.
ORDER
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM jos_rsform_properties
WHERE `ComponentId` IN (30,34,35,36,37,39,38,58,40,41,31,32,33,43,59,42,60)
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='3'
AND Published='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='3'
AND Published='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='41'
AND FormId='3'
AND Published='1'
SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou
FROM jos_rsform_forms
WHERE FormId='6'
SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM jos_rsform_forms
WHERE FormId='6'
AND `Published`='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='6'
AND Published='1'
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM jos_rsform_properties
WHERE `ComponentId` IN (64,63)
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='6'
AND p.PropertyName='NAME'
AND c.Published='1'
ORDER BY c.
ORDER
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM jos_rsform_properties
WHERE `ComponentId` IN (74,70,69,68,67,65,66,75,64,63,73,72,71,61,76,62,77)
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='6'
AND Published='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='6'
AND FormId='6'
AND Published='1'
SELECT ComponentId
FROM jos_rsform_components
WHERE ComponentTypeId='41'
AND FormId='6'
AND Published='1'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=47 OR a.catid=103 OR a.catid=104 OR a.catid=105 OR a.catid=106 OR a.catid=107 OR a.catid=108 OR a.catid=109 OR a.catid=110 OR a.catid=111 OR a.catid=112 OR a.catid=113 OR a.catid=114 OR a.catid=115 OR a.catid=116 OR a.catid=117 OR a.catid=118 OR a.catid=119 OR a.catid=120 OR a.catid=121 OR a.catid=137 OR a.catid=138 OR a.catid=139 OR a.catid=140 OR a.catid=141 OR a.catid=162 )
AND ( a.sectionid=14 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,26
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(145,147,148,149,150,151,152,153,154,155,156,157,158,163,164,165,167,173,169,170,171,174,309,310,166,175)
AND jf_content.reference_table='content'
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.alias) THEN CONCAT_WS(":", cc.id, cc.alias) 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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (s.id=20)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 155
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(317,197,195,287,194,196,318,193)
AND jf_content.reference_table='content'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=82 OR a.catid=83 )
AND ( a.sectionid=15 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,9
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(1420,1419,1418,1417,1416,1415,1414,1413,1412)
AND jf_content.reference_table='content'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=157 )
AND ( a.sectionid=21 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,4
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(737,288,285,290)
AND jf_content.reference_table='content'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:14')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:14' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=158 )
AND ( a.sectionid=22 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,4
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(1345,343,289)
AND jf_content.reference_table='content'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:14')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:14' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=160 )
AND ( a.sectionid=24 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,4
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(1344,875,680,286)
AND jf_content.reference_table='content'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:14')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:14' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=159 )
AND ( a.sectionid=23 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,4
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(874,681,482,316)
AND jf_content.reference_table='content'
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.alias) THEN CONCAT_WS(":", cc.id, cc.alias) 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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=163)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 7
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(687,679,568,537,407,406,405)
AND jf_content.reference_table='content'
SELECT TIME, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND TIME > 1368896400
SELECT session_id, TIME, guest, DATA
FROM jos_session
WHERE '1=1'
AND TIME >= 1368918001
SELECT TIME, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND TIME <= 1368896400
SELECT TIME, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND TIME > 1368810000
AND TIME <= 1368896400
SELECT TIME, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND TIME > 1367341200
AND TIME <= 1368896400
SELECT session_id, TIME, guest, DATA
FROM jos_session
WHERE TIME > 1368917534
SELECT *
FROM jos_acymailing_config
SELECT *
FROM jos_acymailing_list
WHERE TYPE = 'list'
ORDER BY ordering ASC
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.alias) THEN CONCAT_WS(":", cc.id, cc.alias) 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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:13' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=155)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 8
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(317,197,195,287,194,196,318,193)
AND jf_content.reference_table='content'
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 23:07:14')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 23:07:14' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=142 OR a.catid=143 OR a.catid=144 OR a.catid=145 OR a.catid=146 OR a.catid=147 OR a.catid=148 OR a.catid=149 OR a.catid=150 OR a.catid=151 OR a.catid=152 OR a.catid=153 )
AND ( a.sectionid=18 )
AND ((TO_DAYS('2013-05-19') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,15
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(187,186,185,184,183,182,181,180,179,178,177,176)
AND jf_content.reference_table='content'
