Welcome back to updated ComeUp! You can have a host account to manage events and venues now. We encourage you to check your host pages and update information for better experience. Thank you for being with ComeUp.
selectcount(*) as aggregate from `Event` where `TimeFinish` >'2025-04-06 21:37'and `Status` =1and `AreaId` in (78) and `Pin` !='true'and `Event`.`DeletedAt` isnull
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =9612and `HashTag`.`Target_type` ='event'orderby `HashTagId` asc
select `Venue`.*, (selectcount(*) from `Member` innerjoin `VenueLike` on `Member`.`MemberId` = `VenueLike`.`MemberId` where `Venue`.`VenueId` = `VenueLike`.`VenueId` and `VenueLike`.`CreatedAt` >='2025-03-07 21:37:44') as `people_like_time_day_count` from `Venue` where `Status` =1and `IsReview` =1and `AreaId` in (78) orderby `people_like_time_day_count` desc, `VenueId` desc limit 10offset0
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7972and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7972and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7971and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7971and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7970and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7970and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7969and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7969and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7968and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7968and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7967and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7967and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7966and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7966and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7965and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =7965and `HashTag`.`Target_type` ='venue'orderby `HashTagId` asc
select `Team`.*, (selectcount(*) from `Member` innerjoin `Follow` on `Member`.`MemberId` = `Follow`.`MemberId` where `Team`.`TeamId` = `Follow`.`TeamId` and `Follow`.`CreatedAt` >='2025-03-07 21:37:44') as `people_follows_time_day_count` from `Team` where (`CountryId` =8) and `TeamId` !=''and `Status` =1and `Team`.`DeletedAt` isnullorderby `people_follows_time_day_count` desc, `TeamId` desc limit 12offset0
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2745and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =1711and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =3105and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2967and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2966and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2965and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2728and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2721and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2648and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2647and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2646and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc
select `HashTagCategory`.*, `HashTag`.`TargetId` as `pivot_TargetId`, `HashTag`.`HashTagCategoryId` as `pivot_HashTagCategoryId`, `HashTag`.`Target_type` as `pivot_Target_type` from `HashTagCategory` innerjoin `HashTag` on `HashTagCategory`.`HashTagCategoryId` = `HashTag`.`HashTagCategoryId` where `HashTag`.`TargetId` =2644and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc