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 09:07'and `Status` =1and `AreaId` in (64) 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` =9611and `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 09:07:32') as `people_like_time_day_count` from `Venue` where `Status` =1and `IsReview` =1and `AreaId` in (64) 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` =9215and `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` =9215and `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` =8999and `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` =8999and `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` =8985and `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` =8985and `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` =8953and `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` =8953and `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` =8951and `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` =8951and `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` =8949and `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` =8949and `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` =8939and `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` =8939and `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` =8914and `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` =8914and `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` =8913and `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` =8913and `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` =8911and `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` =8911and `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 09:07:32') as `people_follows_time_day_count` from `Team` where (`CountryId` =6) 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` =3104and `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` =3062and `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` =2461and `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` =2424and `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` =2159and `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` =2157and `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` =1971and `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` =1967and `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` =1966and `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` =1965and `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` =1879and `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` =1713and `HashTag`.`Target_type` ='team'orderby `HashTagId` asc