SELECT ls.*, COALESCE(agg.upvotes,0) AS upvotes, COALESCE(agg.downvotes,0) AS downvotes, COALESCE(uv.value,0) AS user_vote, (uss.id IS NOT NULL) AS is_saved FROM launched_sites ls LEFT JOIN ( SELECT site_id, SUM(value = 1) AS upvotes, SUM(value = -1) AS downvotes FROM site_votes GROUP BY site_id ) agg ON agg.site_id = ls.id LEFT JOIN site_votes uv ON uv.site_id = ls.id AND uv.user_id = :uid LEFT JOIN user_saved_sites uss ON uss.site_id = ls.id AND uss.user_id = :uid2 WHERE ls.country_iso2 IN (:co0) AND ls.region IN (:re0) AND ls.created_at <= :date_end AND ls.created_at >= :date_start AND ls.l1 != 'Adult & Gambling' ORDER BY ls.created_at DESC LIMIT :limit OFFSET :offset New Website Launches — Today — 07 · MA | Website Launches - Website Launches
Categories
Sensitive Categories
Locations 2
Today Past Week Past Month or Pick a Date
Sort: Newest Most upvoted
1-2 of 2 results for "All Site Categories" in your selected locations today Reset All Filters
  1. 1
    favicon
    tourandhost.com (TourAndHost - Luxury Apartments in Marrakech)
    Real Estate › Rentals & Leasing › Vacation Rentals — MA, 07 · Kettara
    0 0 Sep 23, 2025 10:09 pm | save | | details/discuss
  2. 2
    favicon
    ai4health2026.com (Spring School: Artificial Intelligence & Health)
    Entertainment & Events › Venues & Event Services › Event Planners — MA, 07 · Benguerir Base Militaire
    0 0 Sep 23, 2025 6:54 pm | save | | details/discuss