58 queries executed
1
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 99999999 )
 ORDER BY menuid DESC
 LIMIT 1--------------------------------------------------------------------------------2
DELETE FROM jos_session
 WHERE (
 ( time < '1152269710' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1152269710' )
 AND guest = 1
 AND userid = 0
 )--------------------------------------------------------------------------------3
SELECT *
 FROM jos_session
 WHERE session_id = 'ccd33542e1b61d67603915736232dfc8'--------------------------------------------------------------------------------4
UPDATE jos_session SET `time`='1152270610',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='ccd33542e1b61d67603915736232dfc8'--------------------------------------------------------------------------------5
SELECT params
 FROM jos_mambots
 WHERE element = 'jfdatabase.systembot'
 AND folder = 'system'--------------------------------------------------------------------------------6
SELECT * FROM jos_languages WHERE iso='ru'--------------------------------------------------------------------------------7
SELECT joomlatablename,tablepkID FROM `jos_jf_tableinfo`--------------------------------------------------------------------------------8
SELECT *
 FROM jos_menu
 WHERE link LIKE 'index.php?option=com_comprofiler&task=userProfile%'--------------------------------------------------------------------------------9
SELECT * FROM jos_comprofiler c, jos_users u WHERE c.id=u.id AND c.id=70--------------------------------------------------------------------------------10
SELECT id,folder, element, published,type,params, CONCAT_WS('/',folder,element) AS lookup
FROM jos_comprofiler_plugin
WHERE published >= 1 AND access <= 0 AND type='user'  
ORDER BY ordering--------------------------------------------------------------------------------11
SELECT g1.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.group_id =24
 ORDER BY g1.name--------------------------------------------------------------------------------12
SELECT gid FROM jos_users WHERE id = '70'--------------------------------------------------------------------------------13
SELECT g1.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.group_id =24
 ORDER BY g1.name--------------------------------------------------------------------------------14
SELECT * FROM jos_comprofiler_tabs t
 WHERE t.enabled=1
 ORDER BY t.position, t.ordering--------------------------------------------------------------------------------15
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1--------------------------------------------------------------------------------16
SELECT jos_menu.id, id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1--------------------------------------------------------------------------------17
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1--------------------------------------------------------------------------------18
SELECT jos_menu.id, id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1--------------------------------------------------------------------------------19
SELECT id
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
 LIMIT 1--------------------------------------------------------------------------------20
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(1)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------21
SELECT g1.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.group_id =24
 ORDER BY g1.name--------------------------------------------------------------------------------22
SELECT count(*)
 FROM jos_comprofiler_plug_profilegallery
 WHERE userid=70
 
 AND pgitempublished=1
 AND pgitemapproved=1--------------------------------------------------------------------------------23
SELECT *
 FROM jos_comprofiler_plug_profilegallery
 WHERE userid=70
 
 AND pgitempublished=1
 AND pgitemapproved=1
 ORDER BY pgitemorder
 ,pgitemdate desc
 LIMIT 0,5--------------------------------------------------------------------------------24
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(11,9,8,7,6)
   AND jf_content.reference_table='comprofiler_plug_profilegallery'
	AND languages.code='russian'--------------------------------------------------------------------------------25
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1--------------------------------------------------------------------------------26
SELECT jos_menu.id, id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1--------------------------------------------------------------------------------27
select id from jos_menu where link='index.php?option=com_marketplace' AND published=1--------------------------------------------------------------------------------28
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(4)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------29
SELECT id, user, userid, ad_kindof, ad_headline, ad_text, ad_image, ad_price,
							date_format(date_created, '%m/%d/%Y' ) as date_created, views
							FROM jos_marketplace_ads
							WHERE userid=70
							ORDER BY id DESC
							LIMIT 20--------------------------------------------------------------------------------30
SELECT a.id, a.title, a.hits,a.created, a.state,  ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count, u.username, u.name, sec.title AS sec_title, cat.title AS cat_title FROM jos_content AS a LEFT JOIN jos_content_rating AS r ON r.content_id=a.id LEFT JOIN jos_users AS u ON u.id=a.created_by LEFT JOIN jos_sections   AS sec ON sec.id=a.sectionid LEFT JOIN jos_categories AS cat ON cat.id=a.catid WHERE a.created_by ='70' ORDER BY a.publish_up DESC, a.created DESC, a.id DESC--------------------------------------------------------------------------------31
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 14 
 ORDER BY f.ordering--------------------------------------------------------------------------------32
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 15 
 ORDER BY f.ordering--------------------------------------------------------------------------------33
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 3 
 ORDER BY f.ordering--------------------------------------------------------------------------------34
SELECT * FROM jos_comprofiler_fields f
 WHERE f.published=1 AND f.profile=1 AND f.tabid = 32 
 ORDER BY f.ordering--------------------------------------------------------------------------------35
SELECT * FROM jos_comprofiler_views WHERE viewer_id = 0 AND profile_id = 70 AND lastip = '195.69.188.126'--------------------------------------------------------------------------------36
INSERT INTO jos_bsq_hit (remote_ip,country,language,domain,referer,resource,user_agent,platform,browser,version,dt, user_id) 
				  VALUES ('195.69.188.126','','ja','','','/index.php?option=com_comprofiler&task=userProfile&user=70','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MRA 4.6 (build 01425))','Windows','Internet Explorer','6.0',1152270610, '0')--------------------------------------------------------------------------------37
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'--------------------------------------------------------------------------------38
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1--------------------------------------------------------------------------------39
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 99999999 )
 ORDER BY ordering--------------------------------------------------------------------------------40
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(3,15,16,47,50,31,67,45,46,8,60,48)
   AND jf_content.reference_table='modules'
	AND languages.code='russian'--------------------------------------------------------------------------------41
SELECT a.*, b.club, b.city
FROM jos_eventlist_dates AS a
LEFT JOIN jos_eventlist_locate AS b ON b.id = a.locid
LEFT JOIN jos_eventlist_categories AS c ON c.id = a.catsid
WHERE a.published = 1
AND c.access <= 0
ORDER BY a.dates
LIMIT 3--------------------------------------------------------------------------------42
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(4,5,6)
   AND jf_content.reference_table='eventlist_dates'
	AND languages.code='russian'--------------------------------------------------------------------------------43
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(4,5,6)
   AND jf_content.reference_table='eventlist_locate'
	AND languages.code='russian'--------------------------------------------------------------------------------44
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering--------------------------------------------------------------------------------45
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(22,29,23,17,18,20,1,28,42,13,39,10,14,24,4,37,16,30,41,44)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------46
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering--------------------------------------------------------------------------------47
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(1,28,42,13,39,10)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------48
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'marketrmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering--------------------------------------------------------------------------------49
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(14,24,4,37)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------50
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'buslib'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering--------------------------------------------------------------------------------51
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(22,29,23)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------52
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'samarqand'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering--------------------------------------------------------------------------------53
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(16,30,41)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------54
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'chamber'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering--------------------------------------------------------------------------------55
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content,
   jos_languages as languages
WHERE jf_content.language_id=languages.id
	AND jf_content.published=1
   AND jf_content.reference_id IN(17,18,20)
   AND jf_content.reference_table='menu'
	AND languages.code='russian'--------------------------------------------------------------------------------56
SELECT * FROM jos_languages WHERE active=1 order by ordering--------------------------------------------------------------------------------57
SELECT guest, usertype
 FROM jos_session--------------------------------------------------------------------------------58
SELECT DISTINCT a.username, a.userid, u.name
 FROM jos_session AS a, jos_users AS u
 WHERE (a.userid=u.id) AND (a.guest = 0) AND (NOT ( a.usertype is NULL OR a.usertype = '' ))
 ORDER BY a.username ASC