SELECT *
FROM jos_session
WHERE session_id = '017e334a1fecbc157bf0d31a6d4601a5'
DELETE
FROM jos_session
WHERE ( TIME < '1596507429' )
SELECT *
FROM jos_session
WHERE session_id = '017e334a1fecbc157bf0d31a6d4601a5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '017e334a1fecbc157bf0d31a6d4601a5','1596508329','','0','1','0' )
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 `a`.`vars`, `u`.`sefurl`
FROM `jos_sefaliases` AS `a`
INNER JOIN `jos_sefurls` AS `u`
ON `u`.`id` = `a`.`url`
WHERE `a`.`alias` = 'chi-siamo/download.html'
AND `u`.`trashed` = '0'
SELECT `file`, `params`
FROM `jos_sefexts`
SELECT *
FROM `jos_sefurls`
WHERE ((`sefurl` = 'chi-siamo/download.html') OR (`sefurl` = 'chi-siamo/download.html/'))
AND (`origurl` != '')
AND (`trashed` = '0')
ORDER BY `priority`
LIMIT 1
SELECT *
FROM `jos_sefmoved`
WHERE (`old` = 'chi-siamo/download.html') OR (`old` = 'chi-siamo/download.html/')
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 *
FROM jos_rokcandy
WHERE published=1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 186)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT s.id, s.title, s.alias, COUNT(cc.id) AS numcat, '' AS categories
FROM jos_phocadownload_sections AS s, jos_phocadownload_categories AS cc
WHERE s.published = 1
AND cc.published = 1
AND s.id = cc.SECTION
AND s.access <= 0
GROUP BY s.id
ORDER BY s.ordering ASC
SELECT cc.id, cc.title, cc.alias, cc.access, cc.accessuserid, COUNT(c.id) AS numdoc
FROM jos_phocadownload_categories AS cc
LEFT JOIN jos_phocadownload AS c
ON c.catid = cc.id
AND c.published = 1
AND c.textonly = 0
WHERE cc.SECTION= 1
AND cc.access <= 0
AND cc.published = 1
GROUP BY cc.id
ORDER BY cc.ordering ASC
SELECT cc.id, cc.title, cc.alias, cc.access, cc.accessuserid, COUNT(c.id) AS numdoc
FROM jos_phocadownload_categories AS cc
LEFT JOIN jos_phocadownload AS c
ON c.catid = cc.id
AND c.published = 1
AND c.textonly = 0
WHERE cc.SECTION= 2
AND cc.access <= 0
AND cc.published = 1
GROUP BY cc.id
ORDER BY cc.ordering ASC
SELECT c.id, c.title, c.alias, c.filename, c.DATE, c.hits, c.image_filename, s.title AS sectiontitle, s.id AS sectionid, cc.id AS categoryid, cc.access AS cataccess, cc.accessuserid AS cataccessuserid, cc.title AS categorytitle, cc.alias AS categoryalias
FROM jos_phocadownload AS c, jos_phocadownload_sections AS s, jos_phocadownload_categories AS cc
WHERE c.sectionid= s.id
AND c.catid= cc.id
AND c.published= 1
AND c.approved= 1
AND c.textonly= 0
AND c.access <= 0
AND s.access <= 0
AND cc.access <= 0
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2020-08-04 02:32:09' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2020-08-04 02:32:09' )
ORDER BY c.hits DESC
LIMIT 5
SELECT st.VALUE
FROM jos_phocadownload_settings AS st
WHERE st.title ='description'
ORDER BY st.id
SELECT st.VALUE
FROM jos_phocadownload_settings AS st
WHERE st.title ='absolute_path'
ORDER BY st.id
SELECT st.VALUE
FROM jos_phocadownload_settings AS st
WHERE st.title ='download_folder'
ORDER BY st.id
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 = 186 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=69&view=category'
AND (`trashed` = '0')
LIMIT 2
SELECT `catid`
FROM `jos_content`
WHERE `id` = '46'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '137'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '21'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '667'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '657'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '124'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '104'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '359'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '168'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '359'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '247'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '169'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '181'
SELECT *
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&view=frontpage'
AND (`trashed` = '0')
LIMIT 2
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 5
AND catid = 72
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 11
SELECT *
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=11&task=click'
AND (`trashed` = '0')
LIMIT 2
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 4
AND catid = 58
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 9
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 6
AND catid = 73
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 12
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 54
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT id, accountID, accountName, profileID, profileName, webPropertyId, startDate
FROM jos_ganalytics_profiles
WHERE id = 1
SELECT `catid`
FROM `jos_content`
WHERE `id` = '57'
