SELECT *
FROM pz_session
WHERE session_id = '95cd43e83ecd483838cc97e52da18162'
DELETE
FROM pz_session
WHERE ( TIME < '1685294674' )
SELECT *
FROM pz_session
WHERE session_id = '95cd43e83ecd483838cc97e52da18162'
INSERT INTO `pz_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '95cd43e83ecd483838cc97e52da18162','1685300074','','0','1','0' )
SELECT *
FROM pz_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM pz_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM pz_menu AS m
LEFT JOIN pz_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM pz_templates_menu
WHERE client_id = '0'
LIMIT 1
SELECT template
FROM pz_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 180)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT i.*, c.id AS ccategory_id, p.id AS pproducer_id, c.name AS category, p.name AS producer, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(":", i.id, i.alias) ELSE i.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END AS prodslug
FROM pz_djc2_items AS i
LEFT JOIN pz_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN pz_djc2_producers AS p
ON p.id = i.producer_id
WHERE i.cat_id = 45
AND i.published = 1
AND c.published = 1
ORDER BY i.ordering , c.ordering ASC
LIMIT 0, 100
SELECT i.*, c.id AS ccategory_id, p.id AS pproducer_id, c.name AS category, p.name AS producer, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(":", i.id, i.alias) ELSE i.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END AS prodslug
FROM pz_djc2_items AS i
LEFT JOIN pz_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN pz_djc2_producers AS p
ON p.id = i.producer_id
WHERE i.cat_id = 45
AND i.published = 1
AND c.published = 1
ORDER BY i.ordering , c.ordering ASC
SELECT *, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(":", id, alias) ELSE id END AS catslug
FROM pz_djc2_categories
WHERE published=1
ORDER BY name
SELECT name AS text, published AS disabled, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(":", id, alias) ELSE id END AS VALUE
FROM pz_djc2_producers
ORDER BY text
SELECT *
FROM pz_djc2_categories
WHERE id = '45'
SELECT *, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(":", id, alias) ELSE id END AS catslug
FROM pz_djc2_categories
WHERE parent_id="45"
AND published=1
ORDER BY ordering
SELECT m.*, am.params AS adv_params
FROM pz_modules AS m
LEFT JOIN pz_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 params
FROM pz_advancedmodules
WHERE moduleid = 35
LIMIT 1
SELECT parent
FROM pz_menu
WHERE id = 180
LIMIT 1
SELECT parent
FROM pz_menu
WHERE id = 180
LIMIT 1