SELECT *
FROM jos_redj
WHERE ('/index.php?option=com_comprofiler&task=usersList' REGEXP fromurl)>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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1,11,28,40,44,12,38,29,45,13,18,43,46,53,14,30,47,57,58,15,64,66,75,16,55,65,78,17,51,60,52,67,71,72,24,77,54,56,80,68,61,62,63,82,41,74,81)
AND jf_content.reference_table='menu'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_jcomments_settings
WHERE lang = 'en-GB'
SELECT g1.id AS group_id, g1.name
FROM jos_core_acl_aro_groups g1
LEFT JOIN jos_core_acl_aro_groups g2
ON g2.lft >= g1.lft
WHERE g2.id =0
ORDER BY g1.name
SELECT listid, title
FROM jos_comprofiler_lists
WHERE published=1
AND useraccessgroupid IN (-2)
ORDER BY ordering
SELECT listid
FROM jos_comprofiler_lists
WHERE `default`=1
AND published=1
AND useraccessgroupid IN (-2)
SELECT *
FROM `jos_comprofiler_lists`
WHERE `listid` = '4'
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 0
AND type = 'user'
ORDER BY ordering
SELECT f.*
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND ( f.profile != 0 OR f.name = 'username')
AND t.enabled = 1
AND t.useraccessgroupid IN (-2)
ORDER BY t.position, t.ordering, f.ordering
SELECT COUNT(*)
FROM jos_comprofiler ue, jos_users u
WHERE u.block = 0
AND ue.approved = 1
AND ue.confirmed = 1
AND ue.banned = 0
AND u.`id` = ue.`id`
AND (`lastvisitDate` !='0')
SELECT ue.*, u.*, '' AS 'NA'
FROM jos_comprofiler ue, jos_users u
WHERE u.block = 0
AND ue.approved = 1
AND ue.confirmed = 1
AND ue.banned = 0
AND u.`id` = ue.`id`
AND (`lastvisitDate` !='0')
ORDER BY `lastvisitDate` DESC, `username` ASC, `lastupdatedate` DESC, `registerDate` DESC
LIMIT 0, 25
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access = 0
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler&task=usersList'
AND published=1
AND access = 0
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM jos_comprofiler_field_values
WHERE fieldid = 59
ORDER BY ordering
SELECT username
FROM jos_users
WHERE id = 843
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 843
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1162
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1162
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1125
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1125
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1117
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1117
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1148
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1148
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 425
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 425
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1118
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1118
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1098
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1098
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1158
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1158
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1084
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1084
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1044
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1044
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1151
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1151
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1161
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1161
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 63
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 63
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 182
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 182
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 162
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 162
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1142
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1142
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 495
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 495
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 69
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 69
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 563
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 563
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 869
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 869
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 967
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 967
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 617
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 617
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1019
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1019
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 843
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1162
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1125
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1117
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1148
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 425
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1118
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1098
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1158
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1084
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1044
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1151
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1161
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 63
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 182
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 162
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1142
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 495
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 69
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 563
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 869
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 967
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 617
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 1019
LIMIT 0, 1
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 0
AND type = 'templates'
ORDER BY ordering