SELECT *
FROM pvdb_session
WHERE session_id = '741t9jik0fo02c3bo1eakhesu5'
DELETE
FROM pvdb_session
WHERE ( time < '1280583161' )
SELECT *
FROM pvdb_session
WHERE session_id = '741t9jik0fo02c3bo1eakhesu5'
INSERT INTO `pvdb_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '741t9jik0fo02c3bo1eakhesu5','1280584061','','0','1','0' )
SELECT *
FROM pvdb_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM pvdb_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM pvdb_menu AS m
LEFT JOIN pvdb_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM pvdb_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM pvdb_jcomments_settings
SELECT id, setting_name, setting_value
FROM pvdb_jdownloads_config
SELECT *
FROM pvdb_jdownloads_templates
WHERE template_typ = '1'
AND template_active = 1
SELECT *
FROM pvdb_jdownloads_templates
WHERE template_typ = '2'
AND template_active = 1
SELECT *
FROM pvdb_jdownloads_templates
WHERE template_typ = '3'
AND template_active = 1
SELECT *
FROM pvdb_jdownloads_templates
WHERE template_typ = '4'
AND template_active = 1
SELECT id
FROM pvdb_jdownloads_templates
WHERE template_typ = '4'
AND locked = 1
SELECT *
FROM pvdb_jdownloads_templates
WHERE template_typ = '5'
AND template_active = 1
SELECT count(*)
FROM pvdb_jdownloads_cats
WHERE published = 1
AND parent_id = 0
AND cat_access <= '01'
SELECT *
FROM pvdb_jdownloads_cats
WHERE published = 1
AND parent_id = 0
AND cat_access <= '01'
ORDER BY ordering
LIMIT 0, 10
SELECT cat_id AS id, parent_id AS parent, cat_title AS name
FROM pvdb_jdownloads_cats
WHERE published = 1
AND cat_access <= '01'
SELECT count(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '3'
SELECT count(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '4'
SELECT count(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '5'
SELECT count(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '6'
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '6'
SELECT *
FROM pvdb_jdownloads_cats
WHERE parent_id = '6'
AND published = 1
AND cat_access <= '01'
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '5'
SELECT *
FROM pvdb_jdownloads_cats
WHERE parent_id = '5'
AND published = 1
AND cat_access <= '01'
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '4'
SELECT *
FROM pvdb_jdownloads_cats
WHERE parent_id = '4'
AND published = 1
AND cat_access <= '01'
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE published = 1
AND cat_id = '3'
SELECT *
FROM pvdb_jdownloads_cats
WHERE parent_id = '3'
AND published = 1
AND cat_access <= '01'
SELECT cat_id AS id, parent_id AS parent, cat_title AS name
FROM pvdb_jdownloads_cats
WHERE published = 1
AND cat_access <= '01'
ORDER BY ordering
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE cat_id = '6'
AND published = 1
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE cat_id = '5'
AND published = 1
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE cat_id = '4'
AND published = 1
SELECT COUNT(*)
FROM pvdb_jdownloads_files
WHERE cat_id = '3'
AND published = 1
