36 Registro Consultas

1. SELECT `data`
  FROM `w47fa_session`
  WHERE `session_id` = 'ans4eesdeofs98bqm1lbp0rqt4'
2. SELECT `session_id`
  FROM `w47fa_session`
  WHERE `session_id` = 'ans4eesdeofs98bqm1lbp0rqt4'
  LIMIT 0, 1
3. INSERT INTO `w47fa_session` (`session_id`, `client_id`, `time`)
  VALUES ('ans4eesdeofs98bqm1lbp0rqt4', 0, '1696255442')
4. SELECT b.id
  FROM w47fa_usergroups AS a
  LEFT JOIN w47fa_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `w47fa_viewlevels`
6. 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 w47fa_menu AS m
  LEFT JOIN w47fa_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
7. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM w47fa_modules AS m
  LEFT JOIN w47fa_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN w47fa_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 <= '2023-10-02 14:04:02')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-02 14:04:02')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 622 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
8. SELECT m.*
  FROM w47fa_modules AS m
  LEFT JOIN w47fa_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.client_id = 0
  AND m.id = 2142
  AND m.access IN (1,1)
  AND m.published = 1
  AND e.enabled = 1
  ORDER BY m.ordering
9. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM w47fa_k2_items as i
  LEFT JOIN w47fa_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-10-02 14:04:02' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-10-02 14:04:02' )
  AND i.catid IN(3093)
  ORDER BY i.created DESC
  LIMIT 0, 1
10. SHOW FULL COLUMNS
  FROM `w47fa_users`
11. SELECT *
  FROM `w47fa_users`
  WHERE `id` = 75
12. SELECT `g`.`id`,`g`.`title`
  FROM `w47fa_usergroups` AS g
  INNER JOIN `w47fa_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 75
13. SELECT `description`, `gender`
  FROM w47fa_k2_users
  WHERE userID=75
  LIMIT 0, 1
14. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM w47fa_k2_users
  WHERE userID=75
15. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM w47fa_k2_categories AS c
  LEFT JOIN w47fa_k2_items AS content
  ON c.id = content.catid
  AND content.language IN ("*", "es-ES")
  WHERE 1=1
  AND ( c.id = 3035 OR c.id = 3791 OR c.id = 3792 OR c.id = 3793 OR c.id = 3293 OR c.id = 3291 OR c.id = 3292 OR c.id = 4029 OR c.id = 4032 OR c.id = 4030 OR c.id = 4031 OR c.id = 3769 OR c.id = 3771 OR c.id = 3770 OR c.id = 1285 OR c.id = 3072 OR c.id = 3961 OR c.id = 3962 OR c.id = 989 OR c.id = 925 OR c.id = 3995 OR c.id = 1251 OR c.id = 3188 OR c.id = 988)
  AND c.published = 1
  AND c.language IN ("*", "es-ES")
  AND c.access <= 1;
16. SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
  FROM w47fa_k2_items AS content
  WHERE content.trash = 0
  AND content.access <= 1
  AND content.published = 1
  AND content.language IN ("*", "es-ES")
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-10-02 14:04:02' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-10-02 14:04:02' )
  AND ( content.catid = 989 OR content.catid = 1251 OR content.catid = 3791 OR content.catid = 3035 OR content.catid = 3072 OR content.catid = 1285 OR content.catid = 3793 OR content.catid = 925 OR content.catid = 988 OR content.catid = 3188 OR content.catid = 3792 OR content.catid = 3291 OR content.catid = 3293 OR content.catid = 3769 OR content.catid = 3770 OR content.catid = 3771 OR content.catid = 3995 OR content.catid = 4032 OR content.catid = 4031 OR content.catid = 4029 OR content.catid = 3292 OR content.catid = 3961 OR content.catid = 3962 OR content.catid = 4030 )
  ORDER BY content.created DESC
  LIMIT 0,5;
17. SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_categories AS cats
  ON cats.id = content.catid
  AND cats.language IN ("*", "es-ES")
  LEFT JOIN w47fa_users AS users
  ON users.id = content.created_by
  LEFT JOIN w47fa_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE 1=1
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 51671 OR content.id = 51456 OR content.id = 51284 OR content.id = 50595 OR content.id = 49682)
  ORDER BY content.created DESC
18. SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_comments AS comments
  ON comments.itemID = content.id
  WHERE comments.published
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 51671 OR content.id = 51456 OR content.id = 51284 OR content.id = 50595 OR content.id = 49682 )
  GROUP BY comments.itemID ;
19. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM w47fa_k2_users
  WHERE userID=122
20. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM w47fa_k2_categories AS c
  LEFT JOIN w47fa_k2_items AS content
  ON c.id = content.catid
  AND content.language IN ("*", "es-ES")
  WHERE 1=1
  AND ( c.id = 1241 OR c.id = 1663 OR c.id = 1209 OR c.id = 1665 OR c.id = 1666 OR c.id = 1669 OR c.id = 1658 OR c.id = 1659 OR c.id = 1670 OR c.id = 1244 OR c.id = 1667 OR c.id = 1675 OR c.id = 1203 OR c.id = 1243 OR c.id = 1220 OR c.id = 3090 OR c.id = 1660 OR c.id = 1661 OR c.id = 3237 OR c.id = 1237 OR c.id = 3016 OR c.id = 1246 OR c.id = 1196 OR c.id = 1671 OR c.id = 1232 OR c.id = 1662 OR c.id = 1190 OR c.id = 2838 OR c.id = 3003)
  AND c.published = 1
  AND c.language IN ("*", "es-ES")
  AND c.access <= 1;
21. SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
  FROM w47fa_k2_items AS content
  WHERE content.trash = 0
  AND content.access <= 1
  AND content.published = 1
  AND content.language IN ("*", "es-ES")
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-10-02 14:04:02' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-10-02 14:04:02' )
  AND ( content.catid = 1196 OR content.catid = 1243 OR content.catid = 1241 OR content.catid = 1244 OR content.catid = 1220 OR content.catid = 1209 OR content.catid = 1675 OR content.catid = 1246 OR content.catid = 1665 OR content.catid = 1190 OR content.catid = 1203 OR content.catid = 1237 OR content.catid = 1659 OR content.catid = 1666 OR content.catid = 3003 OR content.catid = 1232 OR content.catid = 3016 OR content.catid = 3090 OR content.catid = 3237 OR content.catid = 1671 OR content.catid = 1667 OR content.catid = 1663 OR content.catid = 1658 OR content.catid = 1660 OR content.catid = 1661 OR content.catid = 1662 OR content.catid = 1669 OR content.catid = 1670 OR content.catid = 2838 )
  ORDER BY content.created DESC
  LIMIT 0,12;
22. SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_categories AS cats
  ON cats.id = content.catid
  AND cats.language IN ("*", "es-ES")
  LEFT JOIN w47fa_users AS users
  ON users.id = content.created_by
  LEFT JOIN w47fa_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE 1=1
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 19613 OR content.id = 19582 OR content.id = 19553 OR content.id = 19552 OR content.id = 19549 OR content.id = 19512 OR content.id = 19506 OR content.id = 19494 OR content.id = 19468 OR content.id = 19461 OR content.id = 19454 OR content.id = 19443)
  ORDER BY content.created DESC
23. SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_comments AS comments
  ON comments.itemID = content.id
  WHERE comments.published
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 19613 OR content.id = 19582 OR content.id = 19553 OR content.id = 19552 OR content.id = 19549 OR content.id = 19512 OR content.id = 19506 OR content.id = 19494 OR content.id = 19468 OR content.id = 19461 OR content.id = 19454 OR content.id = 19443 )
  GROUP BY comments.itemID ;
24. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM w47fa_k2_categories AS c
  LEFT JOIN w47fa_k2_items AS content
  ON c.id = content.catid
  AND content.language IN ("*", "es-ES")
  WHERE 1=1
  AND ( c.id = 3296 OR c.id = 3295 OR c.id = 3294 OR c.id = 1014 OR c.id = 1970 OR c.id = 1975 OR c.id = 1973 OR c.id = 1976 OR c.id = 1972 OR c.id = 1968 OR c.id = 1971 OR c.id = 1977 OR c.id = 1974 OR c.id = 1969 OR c.id = 1396 OR c.id = 1393 OR c.id = 1399 OR c.id = 1253 OR c.id = 1359 OR c.id = 1951 OR c.id = 134 OR c.id = 2265 OR c.id = 2263 OR c.id = 2262 OR c.id = 2264)
  AND c.published = 1
  AND c.language IN ("*", "es-ES")
  AND c.access <= 1;
25. SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
  FROM w47fa_k2_items AS content
  WHERE content.trash = 0
  AND content.access <= 1
  AND content.published = 1
  AND content.language IN ("*", "es-ES")
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-10-02 14:04:02' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-10-02 14:04:02' )
  AND ( content.catid = 1977 OR content.catid = 1973 OR content.catid = 134 OR content.catid = 1359 OR content.catid = 3294 OR content.catid = 1969 OR content.catid = 1974 OR content.catid = 1971 OR content.catid = 1972 OR content.catid = 1970 OR content.catid = 1253 OR content.catid = 1951 OR content.catid = 3295 OR content.catid = 1014 OR content.catid = 1393 OR content.catid = 1396 OR content.catid = 1399 OR content.catid = 1968 OR content.catid = 1975 OR content.catid = 1976 OR content.catid = 2262 OR content.catid = 2263 OR content.catid = 2264 OR content.catid = 2265 OR content.catid = 3296 )
  ORDER BY content.created DESC
  LIMIT 0,12;
26. SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_categories AS cats
  ON cats.id = content.catid
  AND cats.language IN ("*", "es-ES")
  LEFT JOIN w47fa_users AS users
  ON users.id = content.created_by
  LEFT JOIN w47fa_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE 1=1
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 35246 OR content.id = 19611 OR content.id = 19513 OR content.id = 19505 OR content.id = 19459 OR content.id = 19262 OR content.id = 19242 OR content.id = 19129 OR content.id = 19081 OR content.id = 19011 OR content.id = 18952 OR content.id = 18663)
  ORDER BY content.created DESC
27. SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_comments AS comments
  ON comments.itemID = content.id
  WHERE comments.published
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 35246 OR content.id = 19611 OR content.id = 19513 OR content.id = 19505 OR content.id = 19459 OR content.id = 19262 OR content.id = 19242 OR content.id = 19129 OR content.id = 19081 OR content.id = 19011 OR content.id = 18952 OR content.id = 18663 )
  GROUP BY comments.itemID ;
28. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM w47fa_k2_categories AS c
  LEFT JOIN w47fa_k2_items AS content
  ON c.id = content.catid
  AND content.language IN ("*", "es-ES")
  WHERE 1=1
  AND ( c.id = 1979 OR c.id = 1980 OR c.id = 2260 OR c.id = 2261)
  AND c.published = 1
  AND c.language IN ("*", "es-ES")
  AND c.access <= 1;
29. SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
  FROM w47fa_k2_items AS content
  WHERE content.trash = 0
  AND content.access <= 1
  AND content.published = 1
  AND content.language IN ("*", "es-ES")
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-10-02 14:04:02' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-10-02 14:04:02' )
  AND ( content.catid = 2261 OR content.catid = 1979 OR content.catid = 1980 OR content.catid = 2260 )
  ORDER BY content.created DESC
  LIMIT 0,8;
30. SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_categories AS cats
  ON cats.id = content.catid
  AND cats.language IN ("*", "es-ES")
  LEFT JOIN w47fa_users AS users
  ON users.id = content.created_by
  LEFT JOIN w47fa_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE 1=1
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 19202)
  ORDER BY content.created DESC
31. SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_comments AS comments
  ON comments.itemID = content.id
  WHERE comments.published
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 19202 )
  GROUP BY comments.itemID ;
32. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM w47fa_k2_categories AS c
  LEFT JOIN w47fa_k2_items AS content
  ON c.id = content.catid
  AND content.language IN ("*", "es-ES")
  WHERE 1=1
  AND ( c.id = 135 OR c.id = 1064 OR c.id = 1063 OR c.id = 1979 OR c.id = 1980 OR c.id = 721)
  AND c.published = 1
  AND c.language IN ("*", "es-ES")
  AND c.access <= 1;
33. SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
  FROM w47fa_k2_items AS content
  WHERE content.trash = 0
  AND content.access <= 1
  AND content.published = 1
  AND content.language IN ("*", "es-ES")
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-10-02 14:04:02' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-10-02 14:04:02' )
  AND ( content.catid = 135 OR content.catid = 721 OR content.catid = 1063 OR content.catid = 1064 OR content.catid = 1979 OR content.catid = 1980 )
  ORDER BY content.created DESC
  LIMIT 0,14;
34. SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_categories AS cats
  ON cats.id = content.catid
  AND cats.language IN ("*", "es-ES")
  LEFT JOIN w47fa_users AS users
  ON users.id = content.created_by
  LEFT JOIN w47fa_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE 1=1
  AND content.language IN ("*", "es-ES")
  ORDER BY content.created DESC
35. SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_comments AS comments
  ON comments.itemID = content.id
  WHERE comments.published
  AND content.language IN ("*", "es-ES")
  AND ( content.id = 12 )
  GROUP BY comments.itemID ;
36. UPDATE `w47fa_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696255442;s:18:\"session.timer.last\";i:1696255442;s:17:\"session.timer.now\";i:1696255442;s:24:\"session.client.forwarded\";s:14:\"44.192.115.114\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ab7aa235a7c17ccccb2adc10b90077d7\";}' , `time` = '1696255447'
  WHERE `session_id` = 'ans4eesdeofs98bqm1lbp0rqt4'

19 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 5 × SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM w47fa_k2_categories AS c
  LEFT JOIN w47fa_k2_items AS content
  ON c.id = content.catid
  AND content.language IN ("*", "es-ES")
2. 5 × SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_categories AS cats
  ON cats.id = content.catid
  AND cats.language IN ("*", "es-ES")
  LEFT JOIN w47fa_users AS users
  ON users.id = content.created_by
  LEFT JOIN w47fa_k2_rating AS content_rating
  ON content.id = content_rating.itemID
3. 5 × SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
  FROM w47fa_k2_items AS content
4. 5 × SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM w47fa_k2_items AS content
  LEFT JOIN w47fa_k2_comments AS comments
  ON comments.itemID = content.id
5. 2 × SELECT id, gender, description, image, url, `
  group`, plugins
  FROM w47fa_k2_users
6. 1 × SELECT `g`.`id`,`g`.`title`
  FROM `w47fa_usergroups` AS g
  INNER JOIN `w47fa_user_usergroup_map` AS m
  ON m.group_id = g.id
7. 1 × SELECT `description`, `gender`
  FROM w47fa_k2_users
8. 1 × SELECT *
  FROM `w47fa_users`
9. 1 × SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM w47fa_k2_items as i
  LEFT JOIN w47fa_k2_categories c
  ON c.id = i.catid
10. 1 × SELECT b.id
  FROM w47fa_usergroups AS a
  LEFT JOIN w47fa_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
11. 1 × SELECT `session_id`
  FROM `w47fa_session`
12. 1 × SELECT id, rules
  FROM `w47fa_viewlevels
13. 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 w47fa_menu AS m
  LEFT JOIN w47fa_extensions AS e
  ON m.component_id = e.extension_id
14. 1 × SELECT m.*
  FROM w47fa_modules AS m
  LEFT JOIN w47fa_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM w47fa_modules AS m
  LEFT JOIN w47fa_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN w47fa_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
16. 1 × SELECT `data`
  FROM `w47fa_session`

OTRAS Tablas:

1. 1 × UPDATE `w47fa_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696255442;s:18:\"session.timer.last\";i:1696255442;s:17:\"session.timer.now\";i:1696255442;s:24:\"session.client.forwarded\";s:14:\"44.192.115.114\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ab7aa235a7c17ccccb2adc10b90077d7\";}' , `time` = '1696255447'
2. 1 × SHOW FULL COLUMNS
  FROM `w47fa_users
3. 1 × INSERT INTO `w47fa_session` (`session_id`, `client_id`, `time`)
  VALUES ('ans4eesdeofs98bqm1lbp0rqt4', 0, '1696255442'