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 New Website Launches — Past Month — Portfolio & Personal › Portfolios — IR | Website Launches - Website Launches
Categories
Sensitive Categories
Locations 1
Today Past Week Past Month or Pick a Date
Sort: Newest Most upvoted
1-4 of 4 results for "Portfolio & Personal › Portfolios" in your selected locations this past month Reset All Filters
  1. 1
    favicon
    shadiabtahi.com (Home | Portfolio)
    Portfolio & Personal › Portfolios › Designers & Artists — IR
    0 0 Sep 23, 2025 3:13 pm | save | | details/discuss
  2. 2
    favicon
    shiva-najafi.com (Shiva Najafi | Artist, Architect and Designer)
    Portfolio & Personal › Portfolios › Designers & Artists — IR
    0 0 Sep 23, 2025 11:20 am | save | | details/discuss
  3. 3
    favicon
    omidhaerii.com (Omid Haeri – High-end Parquet Solutions)
    Portfolio & Personal › Portfolios › Designers & Artists — IR
    0 0 Sep 19, 2025 1:34 pm | save | | details/discuss
  4. 4
    favicon
    behnoushrouzbahani.com (Document)
    Portfolio & Personal › Portfolios › Designers & Artists — IR
    0 0 Sep 14, 2025 8:00 pm | save | | details/discuss