| 0.0005 |
SELECT `site_id`, `token_auth`
FROM `@site_info`
|
| 0.0006 |
SELECT *
FROM `site_basics`
|
| 0.0002 |
SELECT *
FROM `villages`
|
| 0.0006 |
SELECT `groups`.`group_id`, `groups`.`group_name`, `villages`.`village_name`, `villages`.`village_id`, `groups`.`group_cat`, `villages`.`village_order`, `groups`.`group_order`
FROM `groups`
JOIN `villages` ON `villages`.`village_id` = `groups`.`village_id`
WHERE `group_cat` != "business"
ORDER BY `village_order` ASC, `group_order` ASC
|
| 0.0002 |
SELECT DISTINCT `villages`.`village_name`, `groups`.`group_order`
FROM `groups`
JOIN `villages` ON `villages`.`village_id` = `groups`.`village_id`
WHERE `groups`.`group_id` = '35'
ORDER BY `groups`.`group_order` ASC
|
| 0.0008 |
SELECT *
FROM `group_timetable`
LEFT OUTER JOIN `group_activities` ON `group_activities`.`activity_id` = `group_timetable`.`activity_id`
WHERE `group_timetable`.`group_id` = 35 AND (`start_time` > '2025-04-30 11:18 PM')
AND `group_timetable`.`skip` = 'no'
ORDER BY `start_time` ASC
LIMIT 5
|
| 0.0017 |
SELECT *
FROM `people`
JOIN `group_staff` ON `group_staff`.`person_id` = `people`.`person_id`
WHERE `group_staff`.`group_id` = '35'
ORDER BY `group_staff`.`order` ASC, `people`.`person_rank` ASC, `group_staff`.`role` ASC, `people`.`first_name` ASC
|
| 0.0005 |
SELECT *
FROM `group_activities`
JOIN `people` ON `group_activities`.`activity_leader_id` = `people`.`person_id`
JOIN `groups` ON `group_activities`.`group_id` = `groups`.`group_id`
JOIN `villages` ON `villages`.`village_id` = `groups`.`village_id`
WHERE `group_activities`.`group_id` = '35'
ORDER BY `groups`.`group_order` ASC
|
| 0.0006 |
SELECT *
FROM `history`
WHERE `group_id` = '35'
LIMIT 1
|
| 0.0018 |
SELECT DISTINCT `event_id`, `event_title`, `event_date`, `event_time`, `end_date`, `end_time`, `event_place`, `event_description`, `event_img`, `person_id`, `first_name`, `phone`, `email`, `event_last_updated`
FROM `v_events_details`
WHERE `group_id` = '35'
AND `event_description` != ''
ORDER BY `event_date` ASC, `event_time` ASC
LIMIT 1
|
| 0.0016 |
SELECT DISTINCT `news_id`, `news_title`, `news_last_updated`, `news_description`, `news_img`, `person_id`, `person_img`, `first_name`, `phone`, `email`
FROM `v_news_details`
WHERE `group_id` = '35'
AND `news_last_updated` > '2024-11-01 10:18 PM'
AND ( (archive_date >= now()) OR (`archive_date` IS NULL ))
ORDER BY `news_last_updated` DESC
LIMIT 1
|
| 0.0006 |
SELECT DISTINCT `resources`.*
FROM `resources`
JOIN `resources_cats` ON `resources`.`resource_category` = `resources_cats`.`resource_category`
WHERE `is_archived` = 0
AND `group_id` = '35'
ORDER BY `resources`.`resource_category` ASC, `is_featured` DESC, `resource_date_added` DESC
LIMIT 999
|
| 0.0002 |
SELECT `groups`.`group_id`, `groups`.`group_name`, `villages`.`village_name`, `villages`.`village_id`, `groups`.`group_cat`, `villages`.`village_order`, `groups`.`group_order`
FROM `groups`
JOIN `villages` ON `villages`.`village_id` = `groups`.`village_id`
WHERE `group_cat` != "business"
ORDER BY `village_order` ASC, `group_order` ASC
|
| 0.0002 |
SELECT *
FROM `groups`
JOIN `villages` ON `villages`.`village_id` = `groups`.`village_id`
WHERE `group_id` = '35'
|
