Joomla! |
Joomla! session.client.browser ⇒ Opera/9.80 (S60; SymbOS; Opera Mobi/SYB-1104061449; U; da) Presto/2.7.81 Version/11.00. .
Joomla!
session.client.browser ⇒ Opera/9.80 (S60; SymbOS; Opera Mobi/SYB-1104061449; U; da) Presto/2.7.81 Version/11.00.
.
.
.
174 SQL- .
SELECT `data`
WHERE `session_id` = '6d660a90228b73a7a43b3f1b3f6ae5b3' DELETE.
WHERE `session_id` = '6d660a90228b73a7a43b3f1b3f6ae5b3'
LIMIT 0, 1 INSERT INTO ` gjuhi_session ` (`session_id`, `client_id`, `time`)
VALUES ('6d660a90228b73a7a43b3f1b3f6ae5b3', 0, '1503208599') SELECT extension_id AS id, element AS "option", params, enabled.
FROM gjuhi_usergroups AS a.
LEFT JOIN gjuhi_usergroups AS b.
FROM ` gjuhi_viewlevels ` SELECT folder AS type, element AS name, params.
ORDER BY ordering SELECT extension_id AS id, element AS "option", params, enabled.
FROM gjuhi_assets AS a.
GROUP BY a.id, a.rules, a.lft SHOW FULL COLUMNS.
FROM gjuhi_assets AS a.
LEFT JOIN gjuhi_assets AS b.
ORDER BY b.lft 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.
LEFT JOIN gjuhi_extensions AS e.
ON m.component_id = e.extension_id.
ORDER BY m.lft SELECT extension_id AS id, element AS "option", params, enabled.
FROM gjuhi_jcomments_settings SELECT id, home, template, s.params.
FROM gjuhi_template_styles as s.
LEFT JOIN gjuhi_extensions as e.
ORDER BY ordering ASC SELECT b.rules.
FROM gjuhi_assets AS a.
LEFT JOIN gjuhi_assets AS b.
ORDER BY b.lft SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias, ROUND (v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count.
FROM gjuhi_content AS a.
LEFT JOIN gjuhi_categories AS c.
LEFT JOIN gjuhi_users AS u.
LEFT JOIN ( SELECT contact.user_id, MAX (contact.id) AS id, contact.language.
FROM gjuhi_contact_details AS contact.
GROUP BY contact.user_id, contact.language) AS contact.
LEFT JOIN gjuhi_categories as parent.
LEFT JOIN gjuhi_content_rating AS v.
OUTER JOIN ( SELECT cat.id as id.
FROM gjuhi_categories AS cat JOIN gjuhi_categories AS parent.
ON cat.lft BETWEEN parent.lft.
GROUP BY cat.id) AS badcats.
CASE WHEN CHAR_LENGTH (c.alias) THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug.
FROM gjuhi_categories as c.
LEFT JOIN gjuhi_categories AS s.
LEFT JOIN ( SELECT cat.id as id.
FROM gjuhi_categories AS cat JOIN gjuhi_categories AS parent.
ON cat.lft BETWEEN parent.lft.
GROUP BY cat.id) AS badcats.
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id.
ORDER BY c.lft UPDATE gjuhi_content.
WHERE id = 41 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid.
FROM gjuhi_modules AS m.
LEFT JOIN gjuhi_modules_menu AS mm.
LEFT JOIN gjuhi_extensions AS e.
ORDER BY m.position, m.ordering SHOW TABLES LIKE "%virtuemart_configs%" SELECT `config`
WHERE `virtuemart_config_id` = "1"; SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
ORDER BY `group_level` SELECT DISTINCT a.virtuemart_category_id AS id, a.category_description AS description, a.category_name AS name, f.category_parent_id AS parent, 'cat' AS typ, 0 AS productnum.
FROM gjuhi_virtuemart_categories_ru_ru AS a.
LEFT JOIN gjuhi_virtuemart_category_categories AS f.
ON a.virtuemart_category_id = f.category_child_id.
LEFT JOIN gjuhi_virtuemart_categories AS b.
ON a.virtuemart_category_id = b.virtuemart_category_id.
AND a.virtuemart_category_id = f.category_child_id.
ORDER BY b.ordering ASC SELECT extension_id AS id, element AS "option", params, enabled.
where `link` like "index.php?option = com_virtuemart%"
and (language = " * " or language = "ru_ru") SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 36 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 36 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 36 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 7 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 7 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 7 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 37 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 37 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 37 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 8 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 8 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 8 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 9 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 9 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 9 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 11 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 11 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 11 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 10 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 10 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 10 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 39 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 39 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 39 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 19 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 19 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 19 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 20 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 20 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 20 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 40 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 40 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 40 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 42 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 42 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 1 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 42 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 12 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 12 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 12 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 13 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 13 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 13 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 15 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 15 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 15 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 44 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 44 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 44 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 27 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 27 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 2 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 27 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 47 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 47 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 47 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 4 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 4 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 4 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 25 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 4 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 25 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 4 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 25 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 26 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 4 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 26 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 4 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 26 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 18 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 18 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 18 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 30 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 30 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 30 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 48 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 48 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 48 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 31 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 31 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 31 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 45 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 45 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 3 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 45 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 5 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 5 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 5 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 22 SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id` = 22 SELECT `slug` as name.
WHERE `virtuemart_category_id` = 22 SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias, ROUND (v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published.
FROM gjuhi_content AS a.
LEFT JOIN gjuhi_content_frontpage AS fp.
LEFT JOIN gjuhi_categories AS c.
LEFT JOIN gjuhi_users AS ua.
LEFT JOIN gjuhi_users AS uam.
LEFT JOIN ( SELECT contact.user_id, MAX (contact.id) AS id, contact.language.
FROM gjuhi_contact_details AS contact.
GROUP BY contact.user_id, contact.language) AS contact.
LEFT JOIN gjuhi_categories as parent.
LEFT JOIN gjuhi_content_rating AS v.
OUTER JOIN ( SELECT cat.id as id.
FROM gjuhi_categories AS cat JOIN gjuhi_categories AS parent.
ON cat.lft BETWEEN parent.lft.
GROUP BY cat.id ) AS badcats.
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1.
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls.
ORDER BY a.publish_up DESC.
CASE WHEN CHAR_LENGTH (c.alias) THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug.
FROM gjuhi_categories as c.
LEFT JOIN gjuhi_categories AS s.
LEFT JOIN ( SELECT cat.id as id.
FROM gjuhi_categories AS cat JOIN gjuhi_categories AS parent.
ON cat.lft BETWEEN parent.lft.
GROUP BY cat.id) AS badcats.
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id.
ORDER BY c.lft UPDATE ` gjuhi_session `
30 SQL- , .
SELECT:
110 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM gjuhi_virtuemart_category_categories AS `xref` 31 × SELECT `slug` as name.
FROM ` gjuhi_virtuemart_categories_ru_ru ` 4 × SELECT extension_id AS id, element AS "option", params, enabled.
CASE WHEN CHAR_LENGTH (c.alias) THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug.
FROM gjuhi_categories as c.
LEFT JOIN gjuhi_categories AS s.
LEFT JOIN ( SELECT cat.id as id.
FROM gjuhi_categories AS cat JOIN gjuhi_categories AS parent.
ON cat.lft BETWEEN parent.lft.
FROM gjuhi_assets AS a.
LEFT JOIN gjuhi_assets AS b.
AND b.rgt > = a.rgt 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid.
FROM gjuhi_modules AS m.
LEFT JOIN gjuhi_modules_menu AS mm.
LEFT JOIN gjuhi_extensions AS e.
AND e.client_id = m.client_id 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias, ROUND (v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count.
FROM gjuhi_content AS a.
LEFT JOIN gjuhi_categories AS c.
LEFT JOIN gjuhi_users AS u.
LEFT JOIN ( SELECT contact.user_id, MAX (contact.id) AS id, contact.language.
FROM gjuhi_contact_details AS contact 1 × SELECT `config`
FROM ` gjuhi_virtuemart_configs ` 1 × SELECT DISTINCT a.virtuemart_category_id AS id, a.category_description AS description, a.category_name AS name, f.category_parent_id AS parent, 'cat' AS typ, 0 AS productnum.
FROM gjuhi_virtuemart_categories_ru_ru AS a.
LEFT JOIN gjuhi_virtuemart_category_categories AS f.
ON a.virtuemart_category_id = f.category_child_id.
LEFT JOIN gjuhi_virtuemart_categories AS b.
ON a.virtuemart_category_id = b.virtuemart_category_id 1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias, ROUND (v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published.
FROM gjuhi_content AS a.
LEFT JOIN gjuhi_content_frontpage AS fp.
LEFT JOIN gjuhi_categories AS c.
LEFT JOIN gjuhi_users AS ua.
LEFT JOIN gjuhi_users AS uam.
LEFT JOIN ( SELECT contact.user_id, MAX (contact.id) AS id, contact.language.
FROM gjuhi_contact_details AS contact 1 × SELECT *
FROM gjuhi_languages 1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM gjuhi_jcomments_setting 1 × SELECT folder AS type, element AS name, params.
FROM gjuhi_extensions 1 × SELECT id, rules.
FROM gjuhi_usergroups AS a.
LEFT JOIN gjuhi_usergroups AS b.
FROM ` gjuhi_admintools_storage ` 1 × SELECT a.rules.
FROM ` gjuhi_session ` 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 gjuhi_menu AS m.
LEFT JOIN gjuhi_extensions AS e.
FROM gjuhi_assets 1 × SELECT id, home, template, s.params.
FROM gjuhi_template_styles as s.
LEFT JOIN gjuhi_extensions as e.
SQL-:
1 × SHOW TABLES LIKE "%virtuemart_configs% 1 × UPDATE ` gjuhi_session `
FROM ` gjuhi_assets 1 × INSERT INTO ` gjuhi_session ` (`session_id`, `client_id`, `time`)
3590