SELECT *
FROM stanza_session
WHERE session_id = 'f14vndvao7r63lpbm38gk89jl6'
DELETE
FROM stanza_session
WHERE ( TIME < '1659982225' )
SELECT *
FROM stanza_session
WHERE session_id = 'f14vndvao7r63lpbm38gk89jl6'
INSERT INTO `stanza_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'f14vndvao7r63lpbm38gk89jl6','1659984025','','0','1','0' )
SELECT *
FROM stanza_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM stanza_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM stanza_migration_backlinks
WHERE url LIKE '63-La-stanza-di-Virginia/124-Numero-17/author/120-Alberto-Piccini%' OR sefurl LIKE '63-La-stanza-di-Virginia/124-Numero-17/author/120-Alberto-Piccini%'
SELECT m.*, c.`option` AS component
FROM stanza_menu AS m
LEFT JOIN stanza_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT a.id
FROM stanza_menu a , stanza_components b
WHERE b.id=a.componentid
AND b.name='.iJoomla Magazine'
LIMIT 1
SELECT content
FROM stanza_magazine_layout
WHERE name='full_profile'
SELECT content
FROM stanza_magazine_layout
WHERE name='full_profile'
SELECT *
FROM stanza_users AS A, stanza_magazine_users AS B
WHERE A.id = '120'
AND A.id = B.userid
GROUP BY A.id
LIMIT 1
SELECT DISTINCT C.id, C.*, CASE WHEN CHAR_LENGTH(C.alias) THEN CONCAT_WS(":", C.id, C.alias) ELSE C.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM stanza_content AS C
LEFT JOIN stanza_categories AS cc
ON cc.id = C.catid
WHERE C.state=1
AND C.access <= 0
AND C.created_by = 120
AND (C.created_by_alias = 'Alberto Piccini' OR C.created_by_alias='')
AND C.title <> "404"
AND cc.published=1
GROUP BY C.id
ORDER BY C.created DESC
LIMIT 2
SELECT DISTINCT C.id, C.*, CASE WHEN CHAR_LENGTH(C.alias) THEN CONCAT_WS(":", C.id, C.alias) ELSE C.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM stanza_content AS C
LEFT JOIN stanza_categories AS cc
ON cc.id = C.catid
WHERE C.state=1
AND C.access <= 0
AND C.created_by = 120
AND (C.created_by_alias = 'Alberto Piccini' OR C.created_by_alias='')
AND C.title <> "404"
AND cc.published=1
GROUP BY C.id
ORDER BY C.created DESC
LIMIT 2
SELECT name
FROM stanza_users
WHERE id=120
SELECT name
FROM stanza_users
WHERE id=120
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT name
FROM stanza_users
WHERE id=120
SELECT name
FROM stanza_users
WHERE id=120
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT DISTINCT C.id, C.*, CASE WHEN CHAR_LENGTH(C.alias) THEN CONCAT_WS(":", C.id, C.alias) ELSE C.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM stanza_content AS C
LEFT JOIN stanza_categories AS cc
ON cc.id = C.catid
WHERE C.state=1
AND C.access <= 0
AND C.created_by = 120
AND (C.created_by_alias = 'Alberto Piccini' OR C.created_by_alias='')
AND C.title <> "404"
AND cc.published=1
GROUP BY C.id
ORDER BY C.hits DESC
LIMIT 2
SELECT DISTINCT C.id, C.*, CASE WHEN CHAR_LENGTH(C.alias) THEN CONCAT_WS(":", C.id, C.alias) ELSE C.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM stanza_content AS C
LEFT JOIN stanza_categories AS cc
ON cc.id = C.catid
WHERE C.state=1
AND C.access <= 0
AND C.created_by = 120
AND (C.created_by_alias = 'Alberto Piccini' OR C.created_by_alias='')
AND C.title <> "404"
AND cc.published=1
GROUP BY C.id
ORDER BY C.hits DESC
LIMIT 2
SELECT name
FROM stanza_users
WHERE id=120
SELECT name
FROM stanza_users
WHERE id=120
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT name
FROM stanza_users
WHERE id=120
SELECT name
FROM stanza_users
WHERE id=120
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT link_profile
FROM stanza_magazine_users mu,stanza_users u
WHERE u.id=120
AND u.id=mu.userid
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_sections
WHERE id=1
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT catid_default
FROM stanza_magazine_sections
WHERE
id='1'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND published_down>='2022-08-08 18:40:25'
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT *
FROM stanza_magazine_categories
WHERE
id='19'
AND published='1'
AND published_up<='2022-08-08 18:40:25'
AND (published_down>='2022-08-08 18:40:25' OR published_down='9999-00-00')
ORDER BY ordering ASC
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT id
FROM stanza_menu
WHERE link='index.php?option=com_magazine&func=show_edition&id=19'
LIMIT 1
SELECT template
FROM stanza_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 124)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT template
FROM stanza_templates_menu
WHERE client_id = 0
AND menuid = 0