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 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
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT b.rules
FROMj25_assetsAS a
LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT guest, usertype, client_id
FROMj25_session WHERE client_id = 0
UPDATE `j25_session`
SET `data` = 'mPBGjL1p0p1HJ_D2xiTvh9j0EPOtwsWVkfYxyhiAoUTjIKV7e5sJdtAxiZeam8qD8CCslx7Mh8-4VJ_uJEJqUrBAa_XX-J2hoNbKpxVWYc3D2ragvnfycZat006VBCZYEW42GRHLoIxCJghaRmoSyZcQwOZH_SUyt9Xx1cjk4IURLjaZrvo7Odt2Q265Ox8HPO8tveZvf0ts9qGLy7YW_rucPXJ5q4lCKGQBBZml6gE6Di2w-35d8g0b-TCGiU2nIGLb90RvIwPN_JNKiw94kRnSVCA5zPhyPbVbBtDr2YxMAlSgEWdGhRPx62x-lZCO3Z2_V1daDCWehU-nqqxCjb7wQkEn-ZwDsVOVIDuPfKPB6tQ-sUz5Zmey776dkVz6baDofwuCRQT2qcTMzMUeuPUkQqwycivdEJ7PgNRoWOkAoDj1kCxz6TwI1y5rxzS6tIkdGS_BwakiLnFHgDYs8LkHqIivlgbrtmdobLZSLN14eTW_Sb0xtvQ7PxI2VNQKBfU6JlQeH4K_kZlZNzLho3RQO9gulBZhiwHj9qhGTZGI0bLHqmAFvB8k5diDjYeCQqjf__wJcXHAtrJEdKJ97eutiW7wWa2cNIewYEloPCairJGF3ExbRjPRe7co5z844vufIDq1USGj4Wbobvjz5yADd_-i7JQM_084W0gyUCarKSQwvNNhAK3RDBqMphco5upuVc54nvC1TIGZZyvXldMN1zA046hn1K68jGocK7XTfB1f_NnizguLItpa6TUka35nSs5gO9Dpf-fVjgtL38WW6oivRKztpRwGn9-aIxFM_Yo9nWmtDZ0EnMz5T7mra6H7ueSgqVK76fIkb7XRs5qYU0SEbwbDM5L80GUaf69YxfytXAGjFH0b9FSLceh6zyW0rot0P9eATCthDl36apoXcAFFzWhrwbQmSu2PG6wrDkHlXxLaHsDKbXq1Cg0s18DmwWtTULeOKHxgshEgKIofvPygDoVtUi_7KF4AGIo6XxXmpbyJRjvK-3QFtEPL6m0r3dDDcd4IfZ7yPrlQ75UbPIDklhrfhkOBo6h4Kewic_u8I03khLOZ1rWplVwDOak1YAYuzB1QBguOiBqVLIVqPmXAYTDpHx8Er53XMek1S20E2ousLt9Zvsk9wEx3iK8ZCp-rSXyAmiDKp3Cm6cz_pt3lcLjPkIlAuAiXHAXmZO0Lp8sK0kUbtb919MNRCsqpezHisZx3AlvAm8KNMShF9BuDejWiTo1Wxwj_ByyP8ihTWcxPwTGm9Qw-E9oMCgVao8vGr2RKL2lFxaGgcFbS28rao-6F8Tlr7PEyJ0tGw2a7wS1WH5q_I44mVzPk'
, `time` = '1550760522'
WHERE `session_id` = 'a790a46a4c97e72c15b42d9de3c0d82c'
11 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:
1 × SELECT a.rules FROMj25_assetsAS a
1 × SELECT b.rules FROMj25_assetsAS a LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt