DELETE
FROM jom__session
WHERE ( time < '1503125933' )
SELECT *
FROM jom__session
WHERE session_id = 'kolqbg0n8m07dunc57img1u3f1'
INSERT INTO `jom__session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'kolqbg0n8m07dunc57img1u3f1','1503126833','','0','1','0' )
SELECT *
FROM jom__components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jom__plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jom__menu AS m
LEFT JOIN jom__components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jom__templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 300158)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT s.id, s.title, s.image, s.image_position, s.description, s.metakey, s.metadesc
FROM jom__phocadownload_sections AS s
WHERE s.id= 1
AND s.access <= 0
AND s.published = 1
ORDER BY s.ordering
LIMIT 0, 1
SELECT cc.id, cc.title, cc.alias, cc.access, cc.accessuserid, COUNT(c.id) AS numdoc
FROM jom__phocadownload_categories AS cc
LEFT JOIN jom__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 c.id, c.title, c.alias, c.filename, c.date, c.hits, c.image_filename, s.title AS sectiontitle, cc.id AS categoryid, cc.access AS cataccess, cc.accessuserid AS cataccessuserid, cc.title AS categorytitle, cc.alias AS categoryalias
FROM jom__phocadownload AS c, jom__phocadownload_sections AS s, jom__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 s.id= 1
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2017-08-19 07:13:53' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2017-08-19 07:13:53' )
ORDER BY c.hits DESC
LIMIT 5
SELECT st.value
FROM jom__phocadownload_settings AS st
WHERE st.title ='absolute_path'
ORDER BY st.id
SELECT st.value
FROM jom__phocadownload_settings AS st
WHERE st.title ='download_folder'
ORDER BY st.id
SELECT id, title, module, position, content, showtitle, control, params
FROM jom__modules AS m
LEFT JOIN jom__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 = 300158 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT o.*, COUNT(v.id) AS hits,
(SELECT COUNT(id)
FROM `jom__mijopolls_votes`
WHERE poll_id=5) AS votes
FROM `jom__mijopolls_options` AS o
LEFT JOIN `jom__mijopolls_votes` AS v
ON (o.id = v.option_id
AND v.poll_id = 5)
WHERE o.poll_id=5
AND o.text <> ''
GROUP BY o.id
ORDER BY o.ordering
SELECT *
FROM jom__mijopolls_polls
WHERE id = '5'
SELECT date
FROM `jom__mijopolls_votes`
WHERE poll_id=5
AND user_id=0
SELECT ip
FROM `jom__mijopolls_votes`
WHERE poll_id=5
AND ip = '915540744'
SELECT o.id, o.text, o.ordering
FROM `jom__mijopolls_options` AS o
WHERE o.poll_id = 5
AND o.text <> ''
ORDER BY o.ordering
SELECT SUM( hits ) AS count_hits
FROM jom__content
WHERE state = "1"
SELECT guest, usertype, client_id
FROM jom__session
WHERE client_id = 0
