SELECT *
FROM jos_session
WHERE session_id = '9ff30ddda1fb5518f4195e4ea5eb92fe'
DELETE
FROM jos_session
WHERE ( TIME < '1328657744' )
SELECT *
FROM jos_session
WHERE session_id = '9ff30ddda1fb5518f4195e4ea5eb92fe'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '9ff30ddda1fb5518f4195e4ea5eb92fe','1328658644','','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 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 = 6)
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 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
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
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_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 <= '2012-02-07 23:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 23:50:45' )
ORDER BY f.ordering
LIMIT 0, 24
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 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
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
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_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 <= '2012-02-07 23:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 23:50:45' )
ORDER BY f.ordering
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '649'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '648'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '647'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '646'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '645'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '643'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '643'
AND published='1'
AND verify='1'
ORDER BY datetime 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
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.id=643
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '642'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '641'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '640'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '639'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE id = '222'
SELECT *
FROM jos_chrono_comments
WHERE parentid='222'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE id = '223'
SELECT *
FROM jos_chrono_comments
WHERE parentid='223'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE id = '224'
SELECT *
FROM jos_chrono_comments
WHERE parentid='224'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE id = '238'
SELECT *
FROM jos_chrono_comments
WHERE parentid='238'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE id = '242'
SELECT *
FROM jos_chrono_comments
WHERE parentid='242'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE id = '244'
SELECT *
FROM jos_chrono_comments
WHERE parentid='244'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '639'
AND published='1'
AND verify='1'
ORDER BY datetime 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
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.id=639
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 = 6 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT c.id
FROM jos_categories AS c
LEFT JOIN jos_categories AS p
ON p.id=c.parent_id
LEFT JOIN jos_categories AS gp
ON gp.id=p.parent_id
LEFT JOIN jos_categories AS ggp
ON ggp.id=gp.parent_id
WHERE c.access <= 0
AND c.published = 1
AND c.SECTION = 'com_jevents'
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
, YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
, YEAR(rpt.endrepeat ) AS ydn, MONTH(rpt.endrepeat ) AS mdn, DAYOFMONTH(rpt.endrepeat ) AS ddn
, HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
, HOUR(rpt.endrepeat ) AS hdn, MINUTE(rpt.endrepeat ) AS mindn, SECOND(rpt.endrepeat ) AS sdn
FROM jos_jevents_repetition AS rpt
LEFT JOIN jos_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,118)
AND rpt.endrepeat >= '2012-02-01 00:00:00'
AND rpt.startrepeat <= '2012-02-29 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
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 <= '2012-02-07 23:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 23:50:45' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.modified DESC, a.created DESC
LIMIT 0, 10
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
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
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 s.id > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 23:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 23:50:45' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 0, 10
SELECT COUNT(*) AS COUNT
FROM jos_users
WHERE usertype!='Super Administrator'
In ogni paese ci sono persone che, per qualche strana alchimia, sono conosciute da tutti ed esisteranno sempre nel racconto di chi li ha incrociati, anche per poco, sul proprio cammino. Resteranno sepolte e vive, rimarranno come chiese, case o vie nella storia di quel luogo. Basterà citarle per paragonare la loro vita ad altri nella buona o nella cattiva sorte. Come meafora, i loro nomi, i loro visi, saranno presenti sempre tra dicerie e realtà, tra leggende e verità.In ogni paese c’è né uno, o forse più di uno.
ELABORAZIONE GRAFICA 
& 
