اشکال یابی جوملا
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ d2392b91b37e17bc78fc62b0e7f93b21
6.37 MB (6,675,392 Bytes)
115 پرس و جو ثبت شده
SELECT `data`
FROM `koybq_session`
WHERE `session_id` = '45893a8d552fd1ffea6f4852202cb928'
DELETE
FROM `koybq_session`
WHERE `time` < '1550744267'
SELECT `session_id`
FROM `koybq_session`
WHERE `session_id` = '45893a8d552fd1ffea6f4852202cb928'
LIMIT 0, 1
INSERT INTO `koybq_session`
(`session_id`, `client_id`, `time`)
VALUES
('45893a8d552fd1ffea6f4852202cb928', 0, '1550745167')
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM koybq_usergroups AS a
LEFT JOIN koybq_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `koybq_viewlevels`
SELECT folder AS type, element AS name, params
FROM koybq_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_zoo'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM koybq_menu AS m
LEFT JOIN koybq_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT `userid`
FROM `koybq_community_users`
WHERE `alias`='groups'
SELECT `userid`
FROM `koybq_community_users`
WHERE `alias`='groups'
SELECT *
FROM koybq_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM koybq_template_styles as s
LEFT JOIN koybq_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_community'
SHOW FULL COLUMNS
FROM `koybq_community_config`
SELECT *
FROM koybq_community_config
WHERE `name` = 'config'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM koybq_modules AS m
LEFT JOIN koybq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN koybq_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-21 10:32:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-21 10:32:47')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 108 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `koybq_community_users` as a
LEFT JOIN `koybq_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `koybq_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'
SHOW FULL COLUMNS
FROM `koybq_community_profiles`
SELECT `id`
FROM `koybq_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `koybq_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '0'
SHOW FULL COLUMNS
FROM `koybq_community_groups_category`
SELECT *
FROM koybq_community_groups_category
WHERE `id` = '22'
SELECT `id`
FROM `koybq_menu`
WHERE `link` LIKE '%option=com_community&view=groups%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `koybq_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT a.rules
FROM koybq_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SHOW FULL COLUMNS
FROM `koybq_assets`
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT b.rules
FROM koybq_assets AS a
LEFT JOIN koybq_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SHOW FULL COLUMNS
FROM `koybq_community_groups`
SELECT COUNT(*)
FROM `koybq_community_groups_members`
WHERE `groupid`=''
AND `memberid`='0'
AND `permissions`='-1'
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT c.id, c.parent, c.name, count(g.id) AS total, c.description
FROM `koybq_community_groups_category` AS c
LEFT JOIN `koybq_community_groups` AS g
ON g.categoryid = c.id
AND g.`published`='1'
GROUP BY c.id
ORDER BY c.name
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT *
FROM `koybq_community_groups_category`
SELECT *
FROM `koybq_community_groups` as a
WHERE a.`published`='1'
AND a.`categoryid` IN(22)
ORDER BY a.`created` DESC
LIMIT 0 , 20
SELECT COUNT(*)
FROM koybq_community_groups_members a
JOIN koybq_users b
ON a.memberid=b.id
WHERE `approved`='1'
AND b.block=0
AND groupid='3'
SELECT COUNT(*)
FROM koybq_community_groups_members a
JOIN koybq_users b
ON a.memberid=b.id
WHERE `approved`='1'
AND b.block=0
AND groupid='1'
SELECT COUNT(*)
FROM `koybq_community_groups` AS a
WHERE a.`published`='1'
AND a.`categoryid` IN(22)
SELECT *
FROM `koybq_community_featured`
WHERE `type`='groups'
ORDER BY `id` DESC
LIMIT 0,15
SELECT COUNT(1)
FROM `koybq_community_groups_members` AS a JOIN `koybq_users` AS b
ON a.`memberid`=b.`id`
AND b.`block`=0
WHERE `groupid`='3'
AND `approved`='1'
AND permissions!='-1'
SELECT COUNT(1)
FROM `koybq_community_groups_discuss`
WHERE `groupid`='3'
SELECT COUNT(1)
FROM `koybq_community_activities`
WHERE `cid`='3'
AND `app`='groups.wall'
SELECT COUNT(1)
FROM `koybq_community_groups_members` AS a JOIN `koybq_users` AS b
ON a.`memberid`=b.`id`
AND b.`block`=0
WHERE `groupid`='1'
AND `approved`='1'
AND permissions!='-1'
SELECT COUNT(1)
FROM `koybq_community_groups_discuss`
WHERE `groupid`='1'
SELECT COUNT(1)
FROM `koybq_community_activities`
WHERE `cid`='1'
AND `app`='groups.wall'
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT *
FROM koybq_community_groups
WHERE `id` = '3'
SELECT *
FROM koybq_community_groups
WHERE `id` = '3'
SELECT *
FROM koybq_community_groups
WHERE `id` = '1'
SELECT *
FROM koybq_community_groups
WHERE `id` = '1'
SELECT *
FROM `koybq_community_featured`
WHERE `type`='groups'
ORDER BY `id` DESC
LIMIT 0,15
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT a.`id`, a.`groupid`, a.`creator`, a.`title`,a.`message`, a.`lastreplied`
FROM `koybq_community_groups_discuss` AS a JOIN ( SELECT b.`id`
FROM `koybq_community_groups` AS b
WHERE b.`published` = 1
AND b.`approvals` = 0 ) AS c
ON c.`id` = a.`groupid`
order by a.`lastreplied` desc
LIMIT 20
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `koybq_community_users` as a
LEFT JOIN `koybq_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `koybq_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1028'
SELECT `id`
FROM `koybq_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `koybq_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '1028'
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='14'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `koybq_community_users` as a
LEFT JOIN `koybq_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `koybq_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='442'
SELECT `id`
FROM `koybq_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `koybq_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '442'
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='13'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `koybq_community_users` as a
LEFT JOIN `koybq_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `koybq_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='764'
SELECT `id`
FROM `koybq_community_fields`
WHERE `fieldcode`='FIELD_GENDER'
SELECT `value`
FROM `koybq_community_fields_values`
WHERE `field_id` = '2'
AND `user_id` = '764'
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='12'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='11'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='10'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='9'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='8'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='7'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='6'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='5'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='4'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='3'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='2'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT *
FROM `koybq_community_wall`
WHERE `contentid`='1'
AND `type`='discussions'
ORDER BY `date` DESC
LIMIT 1
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SHOW FULL COLUMNS
FROM `koybq_community_groups_discuss`
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '14'
SELECT `id`
FROM `koybq_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '13'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '12'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '11'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '10'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '9'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '8'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '7'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '6'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '5'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '4'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '3'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '2'
SELECT *
FROM koybq_community_groups_discuss
WHERE `id` = '1'
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT a.`params`, a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script
FROM `koybq_menu` AS a
LEFT JOIN `koybq_menu` AS b
ON b.`id`=a.`parent_id`
AND b.`published`='1'
WHERE a.`published`='1'
AND a.`menutype`='jomsocial'
AND a.`access`='0'
ORDER BY a.`lft`
SELECT id
FROM koybq_assets
WHERE parent_id = 0
SELECT params
FROM koybq_extensions AS e
WHERE e.element='com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM koybq_kunena_configuration
WHERE id=1
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_jvsocial_publish'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
UPDATE `koybq_session`
SET `data` = 'wZLYMzfFJ9sSbdLmcyivI3q1OOPYUD-H9_ffQLhD_SMoxMS_CO5rolBinlYPkK5Mtar2-NNjOLW54oE_5yC2y1YmwUdk456QADTneluFlPdNWeHT3InT9irH3GzGHrOtBntf74zDnlCsUu9luDTs6lChipgDCFGdJwuA_-YuP90Vv7k6BDm7QMatKG1gStd0nYodWew_v0OY2AmDDaesS94BFF0NEvrZGTYhIzJ-Fo40hiVNpbJndRT9svxLae3n_tuS1eUaRGcIksubprG2p8G6VTzJfPgjFPBF9mVdlaNzq3h9yFsehbBQBkRCv2mmX0w7s8bRC_lT_p7bR25qhdHLvx5yYdpJncbEgzf496cwo9GjLKxTA2h3m5r8wInyUkO-637y6D5G_pM3CsqA77SPRTdDFUY9ptu1uIzFqYjx-P5gx81YZmKS61Qr-yMXgo25bx0lYQMS3pTFwgJY-Q7cCwhexzBIKuBmWW0vTi66aKcG8kc3uzBq5W5xpUSDmzCnRH18oyA2k9SUYLmjkTGmRHmI4cswFQzLJF9I-rn9CEI5_-5-H0F-L6ZJiFUPW4iHsZTeD5LTbPEq81i2VGUtGKUEDLeOwRUixjq46idIRoDLQia-8-mDY9Xv_oAMiJU3fQLnfM_cnD6XhFCpXXKBBrTyN71NNuhsNePiMOI1hhsVLXKr41W4Bath8MlQxsjLc3gj98_vsMWQGzrhR9BP3iZ9yZRUptrEmxkMZhF5lQVwxDE1nu8E766MPuFoFrGwDEX-qrSM14OGK4KffS8fGjYp1P05Wh7S6MZsKjms934chsr5-RbIGU_J4p-IQV2-4pRyR-q-0UaTcnq1tuff_qrJPD9pJBgLJq5TdnpD2Q4Q3knkpWvyXg0vpUjndkde5Z5Sj3FYpusID4lEM7_8gdRkYw33JDpwe_t4GBxqc35TQpy5XZzZe_IMColwXT6lbKBhqiVoW4uKEuVXNipakcU8FRx0td_Ja_e3y24hWfIiDMsSdc6EMaCkRdDk4dpaf7MowT6AJ6HWrBxd5JhCV_03R_ysUz5gIZSCuuK5XyD1VYOPNbo2YhZvo4MyeMT1J02nwL06LBbS-ROUZy8GUBb243AIeIoN3FZlCZ_rMmcVeIGNTAj4a5Q8nhZhln8b7Risu1DEltCnAwAHmbedrGHlrc6oa76aIgKa5x06lRFO3VJdd4hJQWeLiCuuON7pn_678fX0bIrJxKeGuu8WPRn2ZSEeAhBqh0-SyNdCLiB32qPLJNZQzps1ws3g3Sw81D89QBDVCkjlaXOKSRjXijOZ5Mnt5Dzcu5o3Igo.'
, `time` = '1550745167'
WHERE `session_id` = '45893a8d552fd1ffea6f4852202cb928'
46 نوع پرس و جو ثبت شده
انتخاب جداول:
14 × SELECT *
FROM koybq_community_groups_discuss
14 × SELECT *
FROM `koybq_community_wall`
14 × SELECT id
FROM koybq_assets
11 × SELECT extension_id AS id, element AS "option", params, enabled
FROM koybq_extensions
4 × SELECT *
FROM koybq_community_groups
4 × SELECT `value`
FROM `koybq_community_fields_values`
4 × SELECT `id`
FROM `koybq_community_fields`
4 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `koybq_community_users` as a
LEFT JOIN `koybq_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `koybq_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
3 × SELECT `id`
FROM `koybq_menu`
2 × SELECT COUNT(1)
FROM `koybq_community_groups_members` AS a JOIN `koybq_users` AS b
ON a.`memberid`=b.`id`
AND b.`block`=0
2 × SELECT COUNT(1)
FROM `koybq_community_groups_discuss`
2 × SELECT *
FROM `koybq_community_featured`
2 × SELECT COUNT(1)
FROM `koybq_community_activities`
2 × SELECT COUNT(*)
FROM koybq_community_groups_members a JOIN koybq_users b
ON a.memberid=b.id
2 × SELECT `userid`
FROM `koybq_community_users`
1 × SELECT COUNT(*)
FROM `koybq_community_groups` AS a
1 × SELECT *
FROM koybq_kunena_configuration
1 × SELECT a.`id`, a.`groupid`, a.`creator`, a.`title`,a.`message`, a.`lastreplied`
FROM `koybq_community_groups_discuss` AS a JOIN ( SELECT b.`id`
FROM `koybq_community_groups` AS b
1 × SELECT a.`params`, a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script
FROM `koybq_menu` AS a
LEFT JOIN `koybq_menu` AS b
ON b.`id`=a.`parent_id`
AND b.`published`='1'
1 × SELECT *
FROM `koybq_community_groups` as a
1 × SELECT params
FROM koybq_extensions AS e
1 × SELECT `session_id`
FROM `koybq_session`
1 × SELECT b.rules
FROM koybq_assets AS a
LEFT JOIN koybq_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params
FROM koybq_template_styles as s
LEFT JOIN koybq_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM koybq_community_config
1 × SELECT *
FROM koybq_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM koybq_menu AS m
LEFT JOIN koybq_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, rules
FROM `koybq_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM koybq_extensions
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM koybq_modules AS m
LEFT JOIN koybq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN koybq_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM koybq_community_groups_category
1 × SELECT COUNT(*)
FROM `koybq_community_groups_members`
1 × SELECT c.id, c.parent, c.name, count(g.id) AS total, c.description
FROM `koybq_community_groups_category` AS c
LEFT JOIN `koybq_community_groups` AS g
ON g.categoryid = c.id
AND g.`published`='1'
GROUP BY c.id
1 × SELECT b.id
FROM koybq_usergroups AS a
LEFT JOIN koybq_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `data`
FROM `koybq_session`
1 × SELECT a.rules
FROM koybq_assets AS a
1 × SELECT *
FROM `koybq_community_groups_category
سایر جداول:
1 × SHOW FULL COLUMNS
FROM `koybq_community_groups
1 × SHOW FULL COLUMNS
FROM `koybq_community_groups_discuss
1 × UPDATE `koybq_session`
SET `data` = 'wZLYMzfFJ9sSbdLmcyivI3q1OOPYUD-H9_ffQLhD_SMoxMS_CO5rolBinlYPkK5Mtar2-NNjOLW54oE_5yC2y1YmwUdk456QADTneluFlPdNWeHT3InT9irH3GzGHrOtBntf74zDnlCsUu9luDTs6lChipgDCFGdJwuA_-YuP90Vv7k6BDm7QMatKG1gStd0nYodWew_v0OY2AmDDaesS94BFF0NEvrZGTYhIzJ-Fo40hiVNpbJndRT9svxLae3n_tuS1eUaRGcIksubprG2p8G6VTzJfPgjFPBF9mVdlaNzq3h9yFsehbBQBkRCv2mmX0w7s8bRC_lT_p7bR25qhdHLvx5yYdpJncbEgzf496cwo9GjLKxTA2h3m5r8wInyUkO-637y6D5G_pM3CsqA77SPRTdDFUY9ptu1uIzFqYjx-P5gx81YZmKS61Qr-yMXgo25bx0lYQMS3pTFwgJY-Q7cCwhexzBIKuBmWW0vTi66aKcG8kc3uzBq5W5xpUSDmzCnRH18oyA2k9SUYLmjkTGmRHmI4cswFQzLJF9I-rn9CEI5_-5-H0F-L6ZJiFUPW4iHsZTeD5LTbPEq81i2VGUtGKUEDLeOwRUixjq46idIRoDLQia-8-mDY9Xv_oAMiJU3fQLnfM_cnD6XhFCpXXKBBrTyN71NNuhsNePiMOI1hhsVLXKr41W4Bath8MlQxsjLc3gj98_vsMWQGzrhR9BP3iZ9yZRUptrEmxkMZhF5lQVwxDE1nu8E766MPuFoFrGwDEX-qrSM14OGK4KffS8fGjYp1P05Wh7S6MZsKjms934chsr5-RbIGU_J4p-IQV2-4pRyR-q-0UaTcnq1tuff_qrJPD9pJBgLJq5TdnpD2Q4Q3knkpWvyXg0vpUjndkde5Z5Sj3FYpusID4lEM7_8gdRkYw33JDpwe_t4GBxqc35TQpy5XZzZe_IMColwXT6lbKBhqiVoW4uKEuVXNipakcU8FRx0td_Ja_e3y24hWfIiDMsSdc6EMaCkRdDk4dpaf7MowT6AJ6HWrBxd5JhCV_03R_ysUz5gIZSCuuK5XyD1VYOPNbo2YhZvo4MyeMT1J02nwL06LBbS-ROUZy8GUBb243AIeIoN3FZlCZ_rMmcVeIGNTAj4a5Q8nhZhln8b7Risu1DEltCnAwAHmbedrGHlrc6oa76aIgKa5x06lRFO3VJdd4hJQWeLiCuuON7pn_678fX0bIrJxKeGuu8WPRn2ZSEeAhBqh0-SyNdCLiB32qPLJNZQzps1ws3g3Sw81D89QBDVCkjlaXOKSRjXijOZ5Mnt5Dzcu5o3Igo.' , `time` = '1550745167'
1 × SHOW FULL COLUMNS
FROM `koybq_assets
1 × SHOW FULL COLUMNS
FROM `koybq_community_groups_category
1 × INSERT INTO `koybq_session` (`session_id`, `client_id`, `time`)
VALUES ('45893a8d552fd1ffea6f4852202cb928', 0, '1550745167'
1 × SHOW FULL COLUMNS
FROM `koybq_community_config
1 × SHOW FULL COLUMNS
FROM `koybq_community_profiles
1 × DELETE
FROM `koybq_session`