SELECT b.id
FROMj25_usergroupsAS a
LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `j25_viewlevels`
SELECT folder AS type, element AS name, params
FROMj25_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDERBY ordering
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
FROMj25_menuAS m
LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SHOWFULLCOLUMNS FROM `j25_easyblog_configs`
SELECT* FROMj25_easyblog_configs WHERE `name` = 'config'
SHOWFULLCOLUMNS FROM `j25_easyblog_post`
SELECT a.`id` FROMj25_easyblog_post as a WHERE a.`permalink` = 'c:dnem-sistemnogo-administratora'
SELECT a.`id` FROMj25_easyblog_post as a WHERE a.`permalink` = 'c-dnem-sistemnogo-administratora'
SELECT* FROMj25_easyblog_post WHERE `id` = '542'
SELECT id, home, template, s.params
FROMj25_template_styles as s
LEFTJOINj25_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
13 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT a.`id` FROMj25_easyblog_post as a
1 × SELECT* FROMj25_easyblog_post
1 × SELECT id, home, template, s.params FROMj25_template_styles as s LEFTJOINj25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT* FROMj25_easyblog_configs
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 FROMj25_menuAS m LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT b.id FROMj25_usergroupsAS a LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `j25_viewlevels
1 × SELECT folder AS type, element AS name, params FROMj25_extensions