DELETE
FROM jos_session
WHERE ( TIME < '1611525500' )
SELECT *
FROM jos_session
WHERE session_id = 'dlgia22qt0t5m9jv10qcqf7oo6'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'dlgia22qt0t5m9jv10qcqf7oo6','1611532700','','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 setting,VALUE
FROM jos_jfbconnect_config
SELECT `value`
FROM `jos_admintools_storage`
WHERE `key` = 'cparams'
SELECT *
FROM jos_redj
WHERE ( (('/writers-profiles/1026-elizabeth-martin' REGEXP BINARY fromurl)>0
AND case_sensitive<>'0') OR (('/writers-profiles/1026-elizabeth-martin' REGEXP fromurl)>0
AND case_sensitive='0') )
AND published='1'
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 = 257)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 1026
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-24 23:58:20' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-24 23:58:20' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='1026'
SELECT DISTINCT f.id AS fid, f.label AS name, v.id AS vid, v.label
FROM jos_custom_properties AS cp
INNER JOIN jos_custom_properties_fields AS f
ON (cp.field_id = f.id )
INNER JOIN jos_custom_properties_values AS v
ON (cp.value_id = v.id )
WHERE cp.ref_table = 'content'
AND cp.content_id = '1026'
AND f.published = '1'
AND f.access <= '0'
ORDER BY f.ordering, v.ordering
SELECT id
FROM jos_users
WHERE username = 'elizabeth-martin'
LIMIT 0, 1
SELECT a.id AS id, a.title AS title, a.created AS created, a.introtext AS intro, a.catid AS catid, a.sectionid AS sectionid, a.ordering AS ordering, b.title AS SECTION, b.ordering AS sectionorder, c.title AS cat, c.ordering AS catorder, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
FROM jos_content AS a
LEFT JOIN jos_sections AS b
ON b.id = a.sectionid
LEFT JOIN jos_categories AS c
ON c.id = a.catid
WHERE a.sectionid <> '15'
AND ( LOWER(a.created_by_alias) LIKE '%ga=%'
AND LOWER(a.created_by_alias) LIKE '%elizabeth-martin%' )
AND ( a.state = 1 OR a.state = -1 )
ORDER BY a.title ASC
SELECT j_user_id
FROM jos_jfbconnect_user_map
WHERE fb_user_id=''
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 = 257 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND catid = 8
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 30
SELECT `varname`, `value`, `default`
FROM jos_mt_config
SELECT cat_id, cat_name
FROM jos_mt_cats
WHERE cat_approved=1
AND cat_published=1
AND cat_parent = 0
ORDER BY cat_name ASC
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, ev.created AS created
, 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,46,52,53,54,55,56,57,58,59)
AND rpt.endrepeat >= '2021-01-01 00:00:00'
AND rpt.startrepeat <= '2021-01-31 23:59:59'
AND ev.state=1
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
SELECT a.id, a.alias AS username, a.title AS fullname, a.catid, a.sectionid, a.introtext AS intro, u.email AS email, u.id AS user_id, 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_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_users AS u
ON u.username = a.alias
WHERE a.sectionid = 15
AND a.state = 1