This is not a permanent tango venue but it is one of the choosed venues by the River Tango Festival and some other Dancing events
Bishopsgate Institute it is a well known London venue whi...
Every Tuesday Tango @ Blueberry Bar.
OPENING NIGHT!!
This is our new venue for Tango! something different for a week day Milonga, We are adding a brand new night, a bit more laid back,...
Tango Etnia it is an established milonga at the London scene.
Weekly tango practica led by the Argentinian School of Tango and Argentine Folklore. A practica is a chance for dancers of al...
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ e2f3cac1369898e01f068d705a094dcc
c8ccb51c473ba0d6b2fa8b9ba24772cb ⇒ 53
Application 0.000 seconds (+0.000); 1.21 MB (+1.212) - afterLoad
Application 0.171 seconds (+0.171); 10.58 MB (+9.372) - afterInitialise
Application 0.207 seconds (+0.036); 12.87 MB (+2.290) - afterRoute
Application 0.653 seconds (+0.446); 30.07 MB (+17.197) - beforeRenderModule mod_jreviews_geomaps (Venues Google Map)
Application 0.864 seconds (+0.211); 30.72 MB (+0.654) - afterRenderModule mod_jreviews_geomaps (Venues Google Map)
Application 0.942 seconds (+0.079); 30.45 MB (-0.273) - afterDispatch
Application 1.150 seconds (+0.208); 36.60 MB (+6.152) - beforeRenderModule mod_roknavmenu ()
Application 1.200 seconds (+0.049); 38.20 MB (+1.594) - afterRenderModule mod_roknavmenu ()
Application 1.200 seconds (+0.000); 38.17 MB (-0.029) - beforeRenderModule mod_roknavmenu ()
Application 1.218 seconds (+0.018); 38.32 MB (+0.156) - afterRenderModule mod_roknavmenu ()
Application 1.263 seconds (+0.045); 38.38 MB (+0.054) - beforeRenderModule mod_menu (menu footer )
Application 1.276 seconds (+0.013); 38.64 MB (+0.257) - afterRenderModule mod_menu (menu footer )
Application 1.278 seconds (+0.002); 38.59 MB (-0.042) - beforeRenderModule mod_jevents_latest (TODAY'S EVENTS)
Application 1.557 seconds (+0.278); 44.58 MB (+5.987) - afterRenderModule mod_jevents_latest (TODAY'S EVENTS)
Application 1.559 seconds (+0.002); 44.62 MB (+0.040) - beforeRenderModule mod_jreviews_listings (Latest Milongas)
Application 1.611 seconds (+0.052); 46.30 MB (+1.675) - afterRenderModule mod_jreviews_listings (Latest Milongas)
Application 1.613 seconds (+0.002); 46.29 MB (-0.002) - beforeRenderModule mod_jreviews_advsearch (venues adv search module)
Application 1.668 seconds (+0.056); 46.61 MB (+0.319) - afterRenderModule mod_jreviews_advsearch (venues adv search module)
Application 1.671 seconds (+0.002); 46.61 MB (-0.002) - beforeRenderModule mod_search (search)
Application 1.678 seconds (+0.007); 46.64 MB (+0.029) - afterRenderModule mod_search (search)
Application 1.679 seconds (+0.001); 46.59 MB (-0.054) - beforeRenderModule mod_jfjslogin (JF JS Login)
Application 1.692 seconds (+0.013); 46.82 MB (+0.229) - afterRenderModule mod_jfjslogin (JF JS Login)
Application 1.853 seconds (+0.161); 47.04 MB (+0.228) - afterRender
44.71 MB (46,879,264 Bytes)
SELECT `data`
FROM `hyaqv_session`
WHERE `session_id` = '886cvc83ndj7letet0l7ht34m3'
DELETE
FROM `hyaqv_session`
WHERE `time` < '1738173509'
SELECT `session_id`
FROM `hyaqv_session`
WHERE `session_id` = '886cvc83ndj7letet0l7ht34m3'
LIMIT 0, 1
INSERT INTO `hyaqv_session`
(`session_id`, `client_id`, `time`)
VALUES
('886cvc83ndj7letet0l7ht34m3', 0, '1738893509')
SELECT b.id
FROM hyaqv_usergroups AS a
LEFT JOIN hyaqv_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
SELECT id, rules
FROM `hyaqv_viewlevels`
SELECT `value`
FROM `hyaqv_admintools_storage`
WHERE `key` = 'cparams'
SELECT id
FROM hyaqv_menu
WHERE link = 'index.php?option=com_community&view=frontpage'
AND published = 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 hyaqv_menu AS m
LEFT JOIN hyaqv_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 extension_id AS id, element AS "option", params, enabled
FROM hyaqv_extensions
WHERE `type` = 'component'
AND `element` = 'com_jreviews'
SELECT value
FROM hyaqv_jreviews_config
WHERE id = 'debug_overrides_disable'
SELECT *
FROM hyaqv_menu
WHERE id = 115
SET SQL_BIG_SELECTS=1
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
(SELECT
ParentCategory.id AS `Category.cat_id`,
ParentCategory.lft AS `Category.lft`,
ParentCategory.title AS `Category.title`,
ParentCategory.alias AS `Category.slug`,
ParentCategory.level AS `Category.level`,
ParentCategory.published AS `Category.published`,
ParentCategory.access AS `Category.access`,
ParentCategory.params AS `Category.params`,
ParentCategory.parent_id AS `Category.parent_id`,
ParentCategory.metadesc AS `Category.metadesc`,
ParentCategory.metakey AS `Category.metakey`,
ParentCategory.description AS `Category.description`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
JreviewsCategory.dirid AS `Directory.dir_id`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`
FROM
hyaqv_categories AS ParentCategory
INNER JOIN
hyaqv_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN
hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN
hyaqv_jreviews_criteria AS ListingType
ON ListingType.id = JreviewsCategory.criteriaid
WHERE
ParentCategory.id = 18
)
UNION
(SELECT
ParentCategory.id AS `Category.cat_id`,
ParentCategory.lft AS `Category.lft`,
ParentCategory.title AS `Category.title`,
ParentCategory.alias AS `Category.slug`,
ParentCategory.level AS `Category.level`,
ParentCategory.published AS `Category.published`,
ParentCategory.access AS `Category.access`,
ParentCategory.params AS `Category.params`,
ParentCategory.parent_id AS `Category.parent_id`,
ParentCategory.metadesc AS `Category.metadesc`,
ParentCategory.metakey AS `Category.metakey`,
ParentCategory.description AS `Category.description`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
JreviewsCategory.dirid AS `Directory.dir_id`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`
FROM
hyaqv_categories AS Category,
hyaqv_categories AS ParentCategory
INNER JOIN
hyaqv_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN
hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN
hyaqv_jreviews_criteria AS ListingType
ON ListingType.id = JreviewsCategory.criteriaid
WHERE
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 18
AND ParentCategory.parent_id > 0
)
ORDER BY
`Category.lft`
SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.level AS `Category.level`,
Category.params AS `Category.params`,
Category.parent_id AS `Category.parent_id`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`,
COUNT(Listing.id) AS `Category.listing_count`
FROM hyaqv_categories AS Category
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft <= ParentCategory.lft
AND Category.rgt >= ParentCategory.rgt
LEFT JOIN hyaqv_content AS Listing
ON ParentCategory.id = Listing.catid
AND (Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2025-02-07 01:58" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2025-02-07 01:58" ))
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Category.id = JreviewsCategory.id
AND JreviewsCategory.option = "com_content"
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
WHERE 1 = 1
AND (
Category.published = 1
AND ParentCategory.access IN ( 1,5 )
AND Category.extension = "com_content"
AND (Category.id = 18 OR Category.parent_id = 18)
)
GROUP BY Category.id
ORDER BY Directory.desc,Category.lft
SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Category.alias AS `Category.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`,
Criteria.required AS `Criteria.required`,
Criteria.state AS `Criteria.state`,
Criteria.config AS `ListingType.config`,
`Field`.featured AS `Listing.featured`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`,
`Field`.jr_latitude AS `Geomaps.lat`,
`Field`.jr_longitude AS `Geomaps.lon`,
JreviewsCategory.marker_icon AS `Geomaps.icon`
FROM hyaqv_content AS Listing USE KEY (jr_title)
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN hyaqv_users AS User
ON User.id = Listing.created_by
LEFT JOIN hyaqv_jreviews_claims AS Claim
ON Claim.listing_id = Listing.id
AND Claim.user_id = Listing.created_by
AND Claim.approved = 1
WHERE 1 = 1
AND (
ParentCategory.id IN (18)
AND Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2025-02-07 01:58" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2025-02-07 01:58" )
AND Category.access IN ( 1,5)
AND Listing.access IN ( 1,5)
)
ORDER BY Listing.title
LIMIT 5
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM hyaqv_community_users AS Community
WHERE 1 = 1
AND (
userid IN (809)
)
SHOW FULL COLUMNS
FROM `hyaqv_community_config`
SELECT *
FROM hyaqv_community_config
WHERE `name` = 'config'
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , 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 `hyaqv_community_users` as a
LEFT JOIN `hyaqv_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `hyaqv_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'
SHOW FULL COLUMNS
FROM `hyaqv_community_profiles`
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , 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 `hyaqv_community_users` as a
LEFT JOIN `hyaqv_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `hyaqv_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='809'
SELECT
media.media_id,
media.media_type,
media.likes_rank,
media.likes_up,
media.likes_total,
media.created,
media.main_media,
media.listing_id,
media.review_id,
media.user_id,
media.filename,
media.file_extension,
media.rel_path,
media.title,
media.description,
media.media_info,
media.embed,
media.published,
media.approved,
media.access,
media.views,
media.filesize,
media.extension
FROM
hyaqv_jreviews_media AS media
WHERE
listing_id IN (59,91,63,92,55)
AND published = 1
AND approved = 1
AND access IN (1,5)
AND main_media = 1
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`,
Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`,
Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`,
Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`,
Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`,
Field.published As `Field.published`,
`
Group`.groupid AS `
Group.group_id`, `
Group`.title AS `
Group.title`, `
Group`.name AS `
Group.name`, `
Group`.showtitle AS `
Group.showTitle`
FROM hyaqv_jreviews_fields AS Field
INNER JOIN hyaqv_jreviews_groups AS `
Group`
ON (`
Group`.groupid = Field.groupid
AND
`
Group`.groupid IN (2,3,4,5)
AND `
Group`.type = 'content' )
WHERE Field.location = 'content'
AND Field.published = 1
ORDER BY
Group.ordering, Field.ordering
SELECT Listing.contentid AS element_id,jr_price,jr_openingtimes,jr_contactname,jr_country,jr_city,jr_borough,jr_location,jr_address,jr_addressa,jr_postalcode,jr_latitude,jr_longitude,jr_email,jr_website,jr_phone,jr_venueservices
FROM hyaqv_jreviews_content AS Listing
WHERE Listing.contentid IN (59,91,63,92,55)
SELECT
*
FROM
hyaqv_jreviews_fieldoptions
WHERE
fieldid IN ( '2','3','20','22','19')
AND
value IN ( 'united-kingdom','london','camden','camden-town','classes','milonga','wandsworth','balham','westminster','lambeth','vauxhall','practica','hackney','shoreditch')
ORDER
BY ordering ASC ,optionid ASC
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT extension_id AS id, element AS "option", params, enabled
FROM hyaqv_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hyaqv_categories as c
LEFT JOIN hyaqv_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM hyaqv_categories AS cat JOIN hyaqv_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=18
AND badcats.id is null
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
SELECT COUNT(*)
FROM hyaqv_content AS Listing
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
WHERE 1 = 1
AND (
ParentCategory.id IN (18)
AND Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2025-02-07 01:58" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2025-02-07 01:58" )
AND Category.access IN ( 1,5)
AND Listing.access IN ( 1,5)
)
SELECT Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.name`,
Directory.tmpl_suffix AS `Directory.tmpl_suffix`,
Directory.title AS `Directory.slug`
FROM hyaqv_jreviews_directories AS Directory
WHERE 1 = 1
AND (
Directory.id = 1
)
SELECT count(DISTINCT groupid)
FROM hyaqv_jreviews_criteria
WHERE groupid != ''
SELECT criteriaid
FROM hyaqv_jreviews_categories
WHERE `option` = 'com_content'
AND id IN (18)
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access
FROM hyaqv_jreviews_fields AS Field
WHERE Field.location = 'content'
AND Field.listsort = 1
AND Field.groupid IN (2,3,4,5)
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hyaqv_modules AS m
LEFT JOIN hyaqv_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hyaqv_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 <= '2025-02-07 01:58:29')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-07 01:58:29')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 115 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT value
FROM hyaqv_jreviews_config
WHERE id = 'debug_overrides_disable'
SET SQL_BIG_SELECTS=1
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT DISTINCT marker_icon
FROM hyaqv_jreviews_categories
WHERE marker_icon != ''
SELECT Listing.id AS `Listing.listing_id`,
Listing.title AS `Listing.title`,
Listing.alias AS `Listing.slug`,
Listing.state AS `Listing.state`,
Listing.publish_down AS `Listing.publish_down`,
'com_content' AS `Listing.extension`,
Category.id AS `Listing.cat_id`,
Category.alias AS `Category.slug`,
JreviewsCategory.criteriaid AS `Criteria.criteria_id`,
JreviewsCategory.dirid AS `Directory.dir_id`,
JreviewsCategory.marker_icon AS `Geomaps.icon`,
Field.featured AS `Listing.featured`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Field.jr_latitude `Geomaps.lat`,
Field.jr_longitude `Geomaps.lon`,
ListingType.state AS `Criteria.state`,
ListingType.config AS `ListingType.config`,
Totals.media_count AS `Listing.media_count`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`
FROM hyaqv_content AS Listing
LEFT JOIN hyaqv_categories AS Category
ON Listing.catid = Category.id
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS `Field`
ON Field.contentid = Listing.id
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
WHERE 1 = 1
AND (
`Field`.jr_latitude BETWEEN 51.381586834095
AND 51.670721165905
AND `Field`.jr_longitude BETWEEN -0.3564753208474
AND 0.1082533208474
AND Field.jr_latitude <> ''
AND Field.jr_longitude <> ''
AND Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2025-02-07 01:58") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2025-02-07 01:58") )
AND Category.access IN (1,5)
AND Listing.access IN (1,5)
)
LIMIT 100
SELECT
media.media_id,
media.media_type,
media.likes_rank,
media.likes_up,
media.likes_total,
media.created,
media.main_media,
media.listing_id,
media.review_id,
media.user_id,
media.filename,
media.file_extension,
media.rel_path,
media.title,
media.description,
media.media_info,
media.embed,
media.published,
media.approved,
media.access,
media.views,
media.filesize,
media.extension
FROM
hyaqv_jreviews_media AS media
WHERE
listing_id IN (81,76,77,71,41,42,43,44,72,46,47,48,49,50,51,52,53,54,55,56,57,58,59,61,62,63,64,65,69,70,78,79,80,82,83,99,85,86,87,88,89,90,91,92,93,94,95,96,97,98)
AND published = 1
AND approved = 1
AND access IN (1,5)
AND main_media = 1
SELECT ts.template
FROM hyaqv_template_styles AS ts
INNER JOIN hyaqv_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 115
AND m.template_style_id != 0
SELECT template
FROM hyaqv_template_styles
WHERE home = 1
AND client_id = 0
SELECT extension_id AS id, element AS "option", params, enabled
FROM hyaqv_extensions
WHERE `type` = 'component'
AND `element` = 'com_jevents'
SELECT extension_id AS id, element AS "option", params, enabled
FROM hyaqv_extensions
WHERE `type` = 'component'
AND `element` = 'com_rsvppro'
SELECT a.rules
FROM hyaqv_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM hyaqv_assets AS a
LEFT JOIN hyaqv_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_jevents' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SHOW FULL COLUMNS
FROM `hyaqv_jev_users`
SELECT tl.*, ju.name as jname, ju.username
FROM hyaqv_jev_users AS tl
LEFT JOIN hyaqv_users as ju
ON tl.user_id=ju.id
WHERE ju.id IN ( 0 )
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hyaqv_categories as c
LEFT JOIN (SELECT cat.id as id
FROM hyaqv_categories AS cat JOIN hyaqv_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_jevents'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
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
SELECT c.id
FROM hyaqv_categories AS c
WHERE c.access IN (1,1,5)
AND c.published = 1
AND c.language in ('en-GB','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=27
AND c.rgt<=28 ) OR (c.lft>=29
AND c.rgt<=30 ) OR (c.lft>=31
AND c.rgt<=32 ))
ORDER BY c.lft asc
SELECT extension_id AS id, element AS "option", params, enabled
FROM hyaqv_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created ,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg ,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfile1.filename) END as filehref1
, jevfile1.filetitle as filetitle1
,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jevfile1.filename,'" />',jevfile1.filetitle,'</a>') END as filelink1, am.agenda_id, am.minutes_id , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM hyaqv_jevents_repetition as rpt
LEFT JOIN hyaqv_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN hyaqv_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN hyaqv_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN hyaqv_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN hyaqv_jev_attendance as atd
ON ev.ev_id=atd.ev_id
LEFT JOIN hyaqv_jev_invitees as inv
ON inv.at_id=atd.id
LEFT JOIN hyaqv_jev_files as jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN hyaqv_jev_files as jevfile1
ON jevfile1.ev_id = ev.ev_id
AND jevfile1.filetype='file'
AND jevfile1.file_num=1
LEFT JOIN hyaqv_jev_agendaminutes as am
ON am.evdet_id = det.evdet_id
LEFT JOIN
hyaqv_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
hyaqv_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2025-02-07 01:58:30'
AND rpt.startrepeat <= '2025-03-09 23:59:59'
AND (rpt.startrepeat >= '2025-02-07 00:00:00' OR det.multiday=1)
AND ev.state=1
AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1
AND atd.hidenoninvitees=1
AND inv.email_address='FALSE'
AND ((atd.allinvites=1
AND inv.rp_id=0) OR (atd.allinvites=0
AND inv.rp_id=rpt.rp_id))))
AND catmapcat.access IN (1,1,5)
AND catmap.catid IN(-1,13,14,15)
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.rp_id
ORDER BY rpt.startrepeat ASC
LIMIT 7
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created ,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg ,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfile1.filename) END as filehref1
, jevfile1.filetitle as filetitle1
,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jevfile1.filename,'" />',jevfile1.filetitle,'</a>') END as filelink1, am.agenda_id, am.minutes_id , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM hyaqv_jevents_repetition as rpt
LEFT JOIN hyaqv_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN hyaqv_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN hyaqv_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN hyaqv_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN hyaqv_jev_attendance as atd
ON ev.ev_id=atd.ev_id
LEFT JOIN hyaqv_jev_invitees as inv
ON inv.at_id=atd.id
LEFT JOIN hyaqv_jev_files as jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN hyaqv_jev_files as jevfile1
ON jevfile1.ev_id = ev.ev_id
AND jevfile1.filetype='file'
AND jevfile1.file_num=1
LEFT JOIN hyaqv_jev_agendaminutes as am
ON am.evdet_id = det.evdet_id
LEFT JOIN
hyaqv_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
hyaqv_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2025-02-07 00:00:00'
AND rpt.startrepeat <= '2025-02-07 01:58:30'
AND (rpt.startrepeat >= '2025-02-07 00:00:00' OR det.multiday=1)
AND ev.state=1
AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1
AND atd.hidenoninvitees=1
AND inv.email_address='FALSE'
AND ((atd.allinvites=1
AND inv.rp_id=0) OR (atd.allinvites=0
AND inv.rp_id=rpt.rp_id))))
AND catmapcat.access IN (1,1,5)
AND catmap.catid IN(-1,13,14,15)
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.rp_id
ORDER BY rpt.startrepeat desc
LIMIT 7
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created ,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb1
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb
,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg ,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfile1.filename) END as filehref1
, jevfile1.filetitle as filetitle1
,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jevfile1.filename,'" />',jevfile1.filetitle,'</a>') END as filelink1, am.agenda_id, am.minutes_id , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM hyaqv_jevents_repetition as rpt
LEFT JOIN hyaqv_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN hyaqv_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN hyaqv_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN hyaqv_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN hyaqv_jev_attendance as atd
ON ev.ev_id=atd.ev_id
LEFT JOIN hyaqv_jev_invitees as inv
ON inv.at_id=atd.id
LEFT JOIN hyaqv_jev_files as jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN hyaqv_jev_files as jevfile1
ON jevfile1.ev_id = ev.ev_id
AND jevfile1.filetype='file'
AND jevfile1.file_num=1
LEFT JOIN hyaqv_jev_agendaminutes as am
ON am.evdet_id = det.evdet_id
LEFT JOIN
hyaqv_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
hyaqv_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2025-02-07 00:00:00'
AND rpt.startrepeat <= '2025-02-07 01:58:30'
AND (rpt.startrepeat <= '2025-02-07 00:00:00'OR det.multiday=1)
AND ev.state=1
AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1
AND atd.hidenoninvitees=1
AND inv.email_address='FALSE'
AND ((atd.allinvites=1
AND inv.rp_id=0) OR (atd.allinvites=0
AND inv.rp_id=rpt.rp_id))))
AND catmapcat.access IN (1,1,5)
AND catmap.catid IN(-1,13,14,15)
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.rp_id
ORDER BY rpt.startrepeat asc
LIMIT 7
SELECT value
FROM hyaqv_jreviews_config
WHERE id = 'debug_overrides_disable'
SET SQL_BIG_SELECTS=1
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Category.alias AS `Category.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
'com_content' AS `Listing.extension`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`,
Criteria.required AS `Criteria.required`,
Criteria.state AS `Criteria.state`,
Criteria.config AS `ListingType.config`,
`Field`.featured AS `Listing.featured`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`
FROM hyaqv_content AS Listing USE KEY (jr_created)
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN hyaqv_users AS User
ON User.id = Listing.created_by
LEFT JOIN hyaqv_jreviews_claims AS Claim
ON Claim.listing_id = Listing.id
AND Claim.user_id = Listing.created_by
AND Claim.approved = 1
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2025-02-07 01:58") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2025-02-07 01:58") )
AND Category.access IN (1,5)
AND Listing.access IN (1,5)
AND ParentCategory.id IN (18)
)
ORDER BY Listing.created DESC
LIMIT 5
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM hyaqv_community_users AS Community
WHERE 1 = 1
AND (
userid IN (810,809)
)
SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , 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 `hyaqv_community_users` as a
LEFT JOIN `hyaqv_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `hyaqv_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='810'
SELECT
media.media_id,
media.media_type,
media.likes_rank,
media.likes_up,
media.likes_total,
media.created,
media.main_media,
media.listing_id,
media.review_id,
media.user_id,
media.filename,
media.file_extension,
media.rel_path,
media.title,
media.description,
media.media_info,
media.embed,
media.published,
media.approved,
media.access,
media.views,
media.filesize,
media.extension
FROM
hyaqv_jreviews_media AS media
WHERE
listing_id IN (99,98,97,96)
AND published = 1
AND approved = 1
AND access IN (1,5)
AND main_media = 1
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`,
Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`,
Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`,
Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`,
Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`,
Field.published As `Field.published`,
`
Group`.groupid AS `
Group.group_id`, `
Group`.title AS `
Group.title`, `
Group`.name AS `
Group.name`, `
Group`.showtitle AS `
Group.showTitle`
FROM hyaqv_jreviews_fields AS Field
INNER JOIN hyaqv_jreviews_groups AS `
Group`
ON (`
Group`.groupid = Field.groupid
AND
`
Group`.groupid IN (2,3,4,5)
AND `
Group`.type = 'content' )
WHERE Field.location = 'content'
AND Field.published = 1
ORDER BY
Group.ordering, Field.ordering
SELECT Listing.contentid AS element_id,jr_price,jr_openingtimes,jr_contactname,jr_country,jr_city,jr_borough,jr_location,jr_address,jr_addressa,jr_postalcode,jr_latitude,jr_longitude,jr_email,jr_website,jr_phone,jr_venueservices
FROM hyaqv_jreviews_content AS Listing
WHERE Listing.contentid IN (101,99,98,97,96)
SELECT
*
FROM
hyaqv_jreviews_fieldoptions
WHERE
fieldid IN ( '2','3','20','22','19')
AND
value IN ( 'united-kingdom','london','greenwich','classes','milonga','practica','lewisham','new-cross','lambeth','kennington','islington','farringdon','royal-borough-of-kensington-
and-chelsea')
ORDER
BY ordering ASC ,optionid ASC
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM hyaqv_jreviews_groups
WHERE groupid IN (4,2,3,5)
AND type = 'content'
SELECT value
FROM hyaqv_jreviews_config
WHERE id = 'debug_overrides_disable'
SET SQL_BIG_SELECTS=1
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT
id, language
FROM
hyaqv_menu
WHERE
link LIKE "%com_community&view=frontpage"
AND published = 1
AND type = "component"
SELECT Field.fieldid AS `Field.id`, Field.name AS `Field.name`, Field.title AS `Field.title`,
Field.type AS `Field.type`, Field.options AS `Field.params`, Field.required AS `Field.required`,
`
Group`.groupid AS `
Group.group_id`, `
Group`.title AS `
Group.title`
FROM hyaqv_jreviews_fields AS Field
INNER JOIN hyaqv_jreviews_groups AS `
Group`
ON (`
Group`.groupid = Field.groupid
AND
`
Group`.groupid
AND `
Group`.type = 'content' )
WHERE Field.name IN ('categories')
AND Field.location = 'content'
SELECT `id`
FROM `hyaqv_menu`
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SHOW FULL COLUMNS
FROM `hyaqv_template_styles`
SELECT *
FROM hyaqv_template_styles
WHERE `id` = '13'
UPDATE `hyaqv_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1738893509;s:18:\"session.timer.last\";i:1738893509;s:17:\"session.timer.now\";i:1738893509;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\";b:0;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\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}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:\"e2f3cac1369898e01f068d705a094dcc\";}__findCount|a:1:{s:7:\"Listing\";a:1:{s:32:\"c8ccb51c473ba0d6b2fa8b9ba24772cb\";s:2:\"53\";}}'
, `time` = '1738893511'
WHERE `session_id` = '886cvc83ndj7letet0l7ht34m3'
13 × SELECT groupid
FROM hyaqv_jreviews_groups
13 × SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.search AS `Criteria.search`, Criteria.config AS `ListingType.config`, Criteria.groupid
FROM hyaqv_jreviews_criteria AS Criteria
10 × SELECT id, language
FROM hyaqv_menu
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM hyaqv_extensions
4 × SELECT value
FROM hyaqv_jreviews_config
3 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , 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 `hyaqv_community_users` as a
LEFT JOIN `hyaqv_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `hyaqv_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
3 × SELECT media.media_id, media.media_type, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension
FROM hyaqv_jreviews_media AS media
3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg1 ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfil1.filename) END as imageurl ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/',jevfil1.filename,'" />') END as imageimg ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('/images/jevents/thumbnails/thumb_',jevfil1.filename) END as imagethumb ,
CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="/images/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END as thumbimg ,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('/images/jevents/',jevfile1.filename) END as filehref1 , jevfile1.filetitle as filetitle1 ,
CASE WHEN (jevfile1.filename='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jevfile1.filename,'" />',jevfile1.filetitle,'</a>') END as filelink1, am.agenda_id, am.minutes_id , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM hyaqv_jevents_repetition as rpt
LEFT JOIN hyaqv_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN hyaqv_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN hyaqv_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN hyaqv_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN hyaqv_jev_attendance as atd
ON ev.ev_id=atd.ev_id
LEFT JOIN hyaqv_jev_invitees as inv
ON inv.at_id=atd.id
LEFT JOIN hyaqv_jev_files as jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN hyaqv_jev_files as jevfile1
ON jevfile1.ev_id = ev.ev_id
AND jevfile1.filetype='file'
AND jevfile1.file_num=1
LEFT JOIN hyaqv_jev_agendaminutes as am
ON am.evdet_id = det.evdet_id
LEFT JOIN hyaqv_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN hyaqv_categories AS catmapcat
ON catmap.catid = catmapcat.id
2 × SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, `
Group`.groupid AS `
Group.group_id`, `
Group`.title AS `
Group.title`, `
Group`.name AS `
Group.name`, `
Group`.showtitle AS `
Group.showTitle`
FROM hyaqv_jreviews_fields AS Field
INNER JOIN hyaqv_jreviews_groups AS `
Group`
ON (`
Group`.groupid = Field.groupid
AND `
Group`.groupid IN (2,3,4,5)
AND `
Group`.type = 'content' )
2 × SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar`
FROM hyaqv_community_users AS Community
2 × SELECT Listing.contentid AS element_id,jr_price,jr_openingtimes,jr_contactname,jr_country,jr_city,jr_borough,jr_location,jr_address,jr_addressa,jr_postalcode,jr_latitude,jr_longitude,jr_email,jr_website,jr_phone,jr_venueservices
FROM hyaqv_jreviews_content AS Listing
2 × SELECT *
FROM hyaqv_jreviews_fieldoptions
1 × SELECT a.rules
FROM hyaqv_assets AS a
1 × SELECT b.rules
FROM hyaqv_assets AS a
LEFT JOIN hyaqv_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT template
FROM hyaqv_template_styles
1 × SELECT ts.template
FROM hyaqv_template_styles AS ts
INNER JOIN hyaqv_menu AS m
ON ts.id=m.template_style_id
1 × SELECT DISTINCT marker_icon
FROM hyaqv_jreviews_categories
1 × SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.alias AS `Listing.slug`, Listing.state AS `Listing.state`, Listing.publish_down AS `Listing.publish_down`, 'com_content' AS `Listing.extension`, Category.id AS `Listing.cat_id`, Category.alias AS `Category.slug`, JreviewsCategory.criteriaid AS `Criteria.criteria_id`, JreviewsCategory.dirid AS `Directory.dir_id`, JreviewsCategory.marker_icon AS `Geomaps.icon`, Field.featured AS `Listing.featured`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Field.jr_latitude `Geomaps.lat`, Field.jr_longitude `Geomaps.lon`, ListingType.state AS `Criteria.state`, ListingType.config AS `ListingType.config`, Totals.media_count AS `Listing.media_count`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`
FROM hyaqv_content AS Listing
LEFT JOIN hyaqv_categories AS Category
ON Listing.catid = Category.id
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS `Field`
ON Field.contentid = Listing.id
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
1 × SELECT tl.*, ju.name as jname, ju.username
FROM hyaqv_jev_users AS tl
LEFT JOIN hyaqv_users as ju
ON tl.user_id=ju.id
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hyaqv_categories as c
LEFT JOIN (SELECT cat.id as id
FROM hyaqv_categories AS cat JOIN hyaqv_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `id`
FROM `hyaqv_menu`
1 × SELECT *
FROM hyaqv_template_styles
1 × SELECT Field.fieldid AS `Field.id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.options AS `Field.params`, Field.required AS `Field.required`, `
Group`.groupid AS `
Group.group_id`, `
Group`.title AS `
Group.title`
FROM hyaqv_jreviews_fields AS Field
INNER JOIN hyaqv_jreviews_groups AS `
Group`
ON (`
Group`.groupid = Field.groupid
AND `
Group`.groupid
AND `
Group`.type = 'content' )
1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`
FROM hyaqv_content AS Listing USE KEY (jr_created)
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN hyaqv_users AS User
ON User.id = Listing.created_by
LEFT JOIN hyaqv_jreviews_claims AS Claim
ON Claim.listing_id = Listing.id
AND Claim.user_id = Listing.created_by
AND Claim.approved = 1
1 × SELECT c.id
FROM hyaqv_categories AS c
1 × SELECT `session_id`
FROM `hyaqv_session`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hyaqv_modules AS m
LEFT JOIN hyaqv_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hyaqv_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access
FROM hyaqv_jreviews_fields AS Field
1 × SELECT id
FROM hyaqv_menu
1 × SELECT `value`
FROM `hyaqv_admintools_storage`
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 hyaqv_menu AS m
LEFT JOIN hyaqv_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM hyaqv_menu
1 × SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count`
FROM hyaqv_categories AS Category
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft <= ParentCategory.lft
AND Category.rgt >= ParentCategory.rgt
LEFT JOIN hyaqv_content AS Listing
ON ParentCategory.id = Listing.catid
AND (Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2025-02-07 01:58" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2025-02-07 01:58" ))
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Category.id = JreviewsCategory.id
AND JreviewsCategory.option = "com_content"
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
1 × SELECT *
FROM hyaqv_community_config
1 × SELECT id, rules
FROM `hyaqv_viewlevels
1 × SELECT b.id
FROM hyaqv_usergroups AS a
LEFT JOIN hyaqv_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT count(DISTINCT groupid)
FROM hyaqv_jreviews_criteria
1 × SELECT criteriaid
FROM hyaqv_jreviews_categories
1 × SELECT Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.name`, Directory.tmpl_suffix AS `Directory.tmpl_suffix`, Directory.title AS `Directory.slug`
FROM hyaqv_jreviews_directories AS Directory
1 × SELECT COUNT(*)
FROM hyaqv_content AS Listing
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
1 × SELECT `data`
FROM `hyaqv_session`
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hyaqv_categories as c
LEFT JOIN hyaqv_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM hyaqv_categories AS cat JOIN hyaqv_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`, `Field`.jr_latitude AS `Geomaps.lat`, `Field`.jr_longitude AS `Geomaps.lon`, JreviewsCategory.marker_icon AS `Geomaps.icon`
FROM hyaqv_content AS Listing USE KEY (jr_title)
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN hyaqv_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN hyaqv_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN hyaqv_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN hyaqv_users AS User
ON User.id = Listing.created_by
LEFT JOIN hyaqv_jreviews_claims AS Claim
ON Claim.listing_id = Listing.id
AND Claim.user_id = Listing.created_by
AND Claim.approved = 1
4 ×
SET SQL_BIG_SELECTS=
1 × SHOW FULL COLUMNS
FROM `hyaqv_jev_users
1 × SHOW FULL COLUMNS
FROM `hyaqv_template_styles
1 × SHOW FULL COLUMNS
FROM `hyaqv_community_profiles
1 × UPDATE `hyaqv_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1738893509;s:18:\"session.timer.last\";i:1738893509;s:17:\"session.timer.now\";i:1738893509;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\";b:0;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\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}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:\"e2f3cac1369898e01f068d705a094dcc\";}__findCount|a:1:{s:7:\"Listing\";a:1:{s:32:\"c8ccb51c473ba0d6b2fa8b9ba24772cb\";s:2:\"53\";}}' , `time` = '1738893511'
1 × SHOW FULL COLUMNS
FROM `hyaqv_community_config
1 × INSERT INTO `hyaqv_session` (`session_id`, `client_id`, `time`)
VALUES ('886cvc83ndj7letet0l7ht34m3', 0, '1738893509'
1 × (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`
FROM hyaqv_categories AS ParentCategory
INNER JOIN hyaqv_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN hyaqv_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN hyaqv_jreviews_criteria AS ListingType
ON ListingType.id = JreviewsCategory.criteriaid
1 × DELETE
FROM `hyaqv_session`